Question

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.

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.