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

Question

Quizplus · Accepted Answer

An absolute reference is used when referring to a cell that will not change even when copied to other cells. In this case, Charles' monthly income is a fixed amount and will not change, so he should use an absolute reference for this cell when deducting his monthly expenses from his income.