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 has entered all of his monthly expenses.He needs to create a formula that will deduct his monthly expenses from his monthly income.Since his monthly income is the same amount each month,he uses a(n) ____ to identify the cell containing the income value.
A) relative reference
B) absolute reference
C) mixed reference
D) fixed reference
Correct Answer:

Verified
Correct Answer:
Verified
Q34: When you enter a formula into a
Q35: Most Recently Used is a _.<br>A) group
Q36: The _ category of Excel functions retrieves
Q42: The OR function is a logical function
Q44: AutoFill,which copies content and formats from a
Q47: Not all functions have arguments,and some functions
Q75: Another name for the middle value is
Q85: A mixed reference "locks" one part of
Q87: MATCHING<br>Identify the letter of the choice that
Q89: Why is it that the TODAY and