Question

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.

Answer 1

Absolute reference

Step-by-step explanation:

An absolute reference in excel indicates a reference that is locked such that rows and columns do not alter when copied to another cell in the excel sheet.

It points to an actual fixed location in excel and absolute referencing is simply by adding a dollar sign before the row and column.

In other words ,Ellen will absolutely reference her income ,as the income is the same month-on-month.