Case 3-1
Ellen is a recent college graduate. She has decided to open a T-Shirt business and would like to create budget worksheet using Microsoft Excel 2016. She need to keep track of her expenses and income for the year.
-Ellen has entered all of her monthly expenses. She needs to create a formula that will deduct her monthly expenses from her monthly income. Since her monthly income is the same amount each month, she 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

Ellen needs to use an absolute reference to identify the cell containing the income value because it will always be the same amount each month and she does not want that cell reference to change when she copies the formula to other cells.

Case 3-1 Ellen Is a Recent College Graduate. She Has Decided to Decided