Spreadsheet - Functions and Charts › MCQ Quiz - Chapter Summary - Class 8 - Spreadsheet › Question #25659
Single Choice Moderate

QWhich key toggles reference types in Excel?

ID: #25659 MCQ Quiz - Chapter Summary - Class 8 - Spreadsheet 6 views
Question Info
#25659Q ID
ModerateDifficulty
MCQ Quiz - Chapter Summary - Class 8 - SpreadsheetTopic
Start Quiz on This Topic
 Your Answer

Choose the Best Option

Click any option to instantly check if you're correct.

  • A F2 ✔ ✖
  • B F4 ✔ ✖
  • C F5 ✔ ✖
  • D F9 ✔ ✖
Correct Answer

Explanation

Correct Answer Explanation:

Pressing F4 while editing a formula cycles the selected reference through Relative → Absolute → Mixed (row locked) → Mixed (column locked) → Relative, saving you from typing $ signs manually.

Why the other options are incorrect:

  • Option A: F2 enters edit mode for the selected cell — it doesn't toggle reference types.
  • Option C: F5 opens the Go To dialog — it doesn't toggle references.
  • Option D: F9 recalculates formulas — it doesn't toggle reference types.
 Continue Practice
Previous Question Next Question
 Share

Share This Question

Challenge a friend or share with your study group.

 More from This Topic

Related MCQ Questions

Which is a spreadsheet program? COUNT function ignores: Which operator gives the remainder? A range of cells from A1 to A5 is written as: Which key is held to select non-adjacent cells? Cell A5 refers to: Reference $A1 means: Every formula in Excel starts with: Toggle F4 twice from A1 gives: Mixed references are useful when: