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 is expecting to get a 3% raise next year. She enters .03 in cell D2 so that she can predict her monthly income for the next year. What function key will make D2 an absolute reference?
A) F2
B) F4
C) F6
D) F1

Question

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 is expecting to get a 3% raise next year.  She enters .03 in cell D2 so that she can predict her monthly income for the next year. What function key will make D2 an absolute reference?
A) F2
B) F4
C) F6
D) F1

Quizplus · Accepted Answer

Pressing F4 will make the cell reference absolute by adding a dollar sign ($) before the column letter and row number (e.g. $D$2). This means that when the formula is copied across or down, the cell reference will not change.

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