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

QRelative references are useful for:

ID: #25655 MCQ Quiz - Chapter Summary - Class 8 - Spreadsheet 5 views
Question Info
#25655Q 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 Applying same formula to a range ✔ ✖
  • B Locking a value ✔ ✖
  • C Deleting rows ✔ ✖
  • D Formatting cells ✔ ✖
Correct Answer

Explanation

Correct Answer Explanation:

Relative references are useful for applying the same formula pattern to a range. For example, in a totals column, you can write =A1+B1 in row 1 and copy down — each row calculates its own total.

Why the other options are incorrect:

  • Option B: Locking a value requires absolute references, not relative.
  • Option C: Relative references have nothing to do with deleting rows.
  • Option D: Formatting cells uses styles and Ribbon commands, not 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? 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? Cell A5 refers to: A spreadsheet consists of: