Case-Based Critical Thinking Questions
Case 3-1
Charles is a recent college graduate.He is paying rent for the first time,as well as utility bills,such as cable,electric,and telephone.He also has some hefty school loan payments.Charles has a good paying job and knows that even though he has lots of expenses,it is critical for him to save money each month,too.He decides to create a budget for himself in Excel 2010.
-Charles wants to add color only to those cells with a negative balance.He would accomplish this by using ___ formatting.
A) compact
B) conditional
C) simple
D) complex

Question

Quizplus · Accepted Answer

Charles wants to add color only to those cells with a negative balance. This can be achieved by using conditional formatting in Excel 2010, where he can set up a rule to format cells with a negative balance in a particular color. Therefore, the best choice is B) conditional formatting. A) Compact formatting refers to a setting where cells are formatted to take up less space on the worksheet. C) Simple and D) complex formatting options are not applicable in this case.