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 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

Quizplus · Accepted Answer

The function key F4 will make a cell reference absolute. In this case, Ellen wants to make cell D2 an absolute reference when she copies the formula to other cells. By pressing F4 after selecting cell D2, it will add dollar signs before the column and row (i.e., $D$2) to make it an absolute reference.

Ellen Is a Recent College Graduate