In Excel, which function key toggles between relative and absolute cell referencing when editing a formula?
A) F1
B) F2
C) F3
D) F4
E) F5

Question

Quizplus · Accepted Answer

The function key F4 toggles between relative and absolute cell referencing when editing a formula. Pressing F4 repeatedly will cycle through each type of reference (absolute row and column, absolute row only, absolute column only, and relative).

In Excel, Which Function Key Toggles Between Relative and Absolute