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

QA relative reference changes when the formula is:

ID: #25651 MCQ Quiz - Chapter Summary - Class 8 - Spreadsheet 4 views
Question Info
#25651Q 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 Copied to another cell ✔ ✖
  • B Deleted ✔ ✖
  • C Printed ✔ ✖
  • D Saved ✔ ✖
Correct Answer

Explanation

Correct Answer Explanation:

A relative reference (like A1) automatically adjusts when the formula is copied to another cell. If you copy =A1 from B1 to B2, it becomes =A2 — it 'moves' with the formula.

Why the other options are incorrect:

  • Option B: Deleting a formula doesn't change references — it just removes the formula.
  • Option C: Printing has no effect on cell references — it just prints what's on screen.
  • Option D: Saving preserves the workbook as-is; it doesn't change 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? Which operator gives the remainder? COUNT function ignores: 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? Cell A5 refers to: A spreadsheet consists of: What is a cell reference? What is a formula?