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

QWhich key toggles between reference types?

ID: #25697 MCQ Quiz - Chapter Summary - Class 8 - Spreadsheet 4 views
Question Info
#25697Q 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 F1 ✔ ✖
  • B F4 ✔ ✖
  • C F7 ✔ ✖
  • D F10 ✔ ✖
Correct Answer

Explanation

Correct Answer Explanation:

F4 toggles between relative, absolute, and mixed references while editing a formula. It cycles: A1 → $A$1 → A$1 → $A1 → back to A1.

Why the other options are incorrect:

  • Option A: F1 opens Help in Excel.
  • Option C: F7 opens spell check.
  • Option D: F10 activates the menu bar, doesn't affect references.
 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? Cell A5 refers to: Reference $A1 means: Which key toggles reference types in Excel? A range of cells from A1 to A5 is written as: Which key is held to select non-adjacent cells? What is a spreadsheet? A spreadsheet consists of: