Case EX 9-1 Andrea is preparing a spreadsheet showing her earnings and spendings for the last year. Andrea would like to highlight the months where her spending was more than her earnings. She needs to use a ____ formatting formula.
A) theme
B) filter
C) banded
D) conditional

Question

Quizplus · Accepted Answer

Andrea needs to use a conditional formatting formula to highlight the months where her spending was more than her earnings. Conditional formatting allows users to apply formatting based on a set of conditions or criteria. In this case, Andrea can set a condition where the cell with her spending for a particular month is greater than the cell with her earnings for that same month, and then apply a formatting style of her choice to those cells.

Case EX 9-1 Andrea Is Preparing a Spreadsheet Showing Her