Which key is used in MS Excel to switch a cell reference between relative, absolute, and mixed references?
AF2
BF4
CF7
DF11
Explanation
Pressing F4 while selecting a cell reference in an Excel formula toggles through relative (A1), absolute ($A$1), and mixed (A$1 or $A1) cell references by adding or removing dollar signs ($).
Exam Relevance
- Topic: MS Office
- Subtopic: MS Excel

No Comments