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's cable bill varies from month to month due to special sporting events he purchases.He wants to calculate the total cable expenses for one year.He wants to see all of the arguments associated with the SUM function so he clicks the ____.
A) Math & Trig button in the Formula group,then clicks SUM to open the Function Arguments dialog box
B) Math & Trig button in the Function Library group,then clicks SUM to open the Function Arguments dialog box
C) AutoSum button in the Function Library group,then clicks SUM to open the Function Arguments dialog box
D) Financial button in the Function Library group,then clicks SUM to open the Function Arguments dialog box
Correct Answer:

Verified
Correct Answer:
Verified
Q49: Absolute references are marked with a _.<br>A)<<br>B):<br>C)$<br>D)!
Q54: The numbers,text,or cell references used by the
Q58: A(n)_ reference contains both relative and absolute
Q67: FUNCTION(argument1,argument2,...)is _.<br>A)the syntax of writing optional arguments<br>B)an
Q76: PMT (rate, nper, <span class="ql-formula"
Q79: For more complex patterns,you can use the
Q80: AutoFill can recognize some patterns if you
Q83: The _ is most often used with
Q86: Every function has to follow _.<br>A) a
Q96: _ arguments may provide more control over