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 2013. 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 should use an absolute reference to identify the cell containing her monthly income value, as this will ensure that the formula always subtracts her expenses from the same cell (i.e. the cell containing her income). A relative reference would adjust the cell reference based on the location of the formula when it is copied to other cells, which could result in errors if Ellen accidentally copies or moves the formula. A mixed reference combines absolute and relative references, which is not necessary in this case, and a fixed reference is not a valid reference type in Excel.

Ellen Is a Recent College Graduate