Harry, a bank employee, is using Excel to carry out loan payment calculations. He wishes to change the column containing interest rates to an absolute reference. Which of the following keys should Harry use to change the reference to an absolute reference for a selected cell or range?
A)Alt+R
B)F4
C)Shift+PgDn
D)F1

Question

Harry, a bank employee, is using Excel to carry out loan payment calculations. He wishes to change the column containing interest rates to an absolute reference. Which of the following keys should Harry use to change the reference to an absolute reference for a selected cell or range? ​
A)Alt+R
B)F4
C)Shift+PgDn
D)F1

Quizplus · Accepted Answer

The F4 key is used in Excel to cycle through different reference types, including changing a cell reference to an absolute reference.

Harry, a Bank Employee, Is Using Excel to Carry Out