Question

Molly wants to make some cells in her balance spreadsheet different colors so that she can more quickly find important data. What can she do? A. Use a nested IF statement B. Use the lookup table C. Use cell protection D. Use conditional formatting

Answer 1

Answer:

Use conditional formatting

Explanation:

Answer 2

She can choose to (D) use conditional formatting so that her balance spreadsheet will show different colors according to her needs.

In conditional formatting, which can be found in the Home tab in Microsoft Excel, the user will get the choice of determining both the colors and the type of data that needs to be highlighted.

Molly will need to create a formula or use a predetermined one to highlight her data cells.