Question

1. Do you think that formatting cells is important? Explain why you think formatting cells is,...

1. Do you think that formatting cells is important? Explain why you think formatting cells is, or is not important. Give specific examples.


2. What is Conditional Formatting? Give a specific example.


Homework Answers

Answer #1

1. Yes, formatting cells is important as it helps us to enhance the data in many ways. Formatting the cells helps in representing the data in them correctly. It also helps the user to make important data stand out.

For example: Formatting the cell to the DATE format, like MM-DD-YYYY helps to avoid errors in data entry. It also helps in correctly identifying the meaning and representation of data.

2. Conditional Formatting is a tool in Excel with the help of which you can apply conditions to the format of the cell selected. It can be used to apply simple IF-ELSE conditions as well as conditional formulas.

Example:
1. Select cells you want to format.
2. Select formula option from condition formatting menu
3. Enter a formula that may return TRUE or a FALSE value.
Like: ISEVEN() and ISODD() functions can be used to format the cell differently when the number entered is EVEN or ODD.

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Why do we use conditional formatting? List one example of conditional formatting.
Why do we use conditional formatting? List one example of conditional formatting.
Why do you think it is important for an engineer to measure variability? For Biomedical Engineering....
Why do you think it is important for an engineer to measure variability? For Biomedical Engineering. Give examples.
Explain why you think that learning a foreign language is important, especially if you have been...
Explain why you think that learning a foreign language is important, especially if you have been given an overseas assignment. What advantages does it give you in life, in your career, and with your specific overseas assignment.
Do you think that voluntariness is morally important in euthanasia decisions? How important do you think...
Do you think that voluntariness is morally important in euthanasia decisions? How important do you think that it is? For example, do you think that it is so important that whatever a person requests ought to be done? Explain. Does your conclusion regard the morality or also the legality of euthanasia?
Cells can confine proteins to specific domains within a membrane. Explain why is this important using...
Cells can confine proteins to specific domains within a membrane. Explain why is this important using an example from our lectures.
Explain why you think that it is important for an organisation to understand its external environment....
Explain why you think that it is important for an organisation to understand its external environment. Using examples, explain what are the external elements that the company needs to analyze. Elaborate more please and provide insightful analysis
Why do you think it is difficult to estimate a demand curve in reality? Explain. Give...
Why do you think it is difficult to estimate a demand curve in reality? Explain. Give three examples of goods or services that you believe may have high levels of consumer surplus. Explain the logic for each.
It is so important that nurses understand why pharmacologic principles are important to understand, why and...
It is so important that nurses understand why pharmacologic principles are important to understand, why and how medications are dosed, and, is it safe to administer? If it is not safe, what do you as a nurse need to do? THINK about it. In this question: please list and explain with 2 examples of each type of order, the time allowed for the nurse to administer the order based on the type of order it is. For example, for a...
Do you think FV is important to managers? Why or why not?
Do you think FV is important to managers? Why or why not?
Do you think empathy is important in leadership? Why or Why not?
Do you think empathy is important in leadership? Why or Why not?
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT