Multiple Choice
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
Correct Answer:

Verified
Correct Answer:
Verified
Q68: The FV function stands for _.<br>A)function value<br>B)future
Q88: >= is a(n)_ operator.<br>A) absolute<br>B) comparison<br>C) mathematical<br>D)
Q89: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB5278/.jpg" alt=" -Referring to the
Q91: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB5278/.jpg" alt=" -Referring to the
Q92: The PMT function is a(n)_ function.<br>A) date<br>B)
Q94: =INT(AVERAGE(A1:A100))is an example of a(n)_ function.<br>A) complex<br>B)
Q95: _ can also be used to create
Q96: If you wanted to find the correct
Q97: The Function Library is a group on
Q98: Case-Based Critical Thinking Questions<br>Case 3-2<br>Pamela is getting