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

QWhich is a relative reference?

ID: #25652 MCQ Quiz - Chapter Summary - Class 8 - Spreadsheet 5 views
Question Info
#25652Q 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 A1 ✔ ✖
  • B $A$1 ✔ ✖
  • C $A1 ✔ ✖
  • D A$1 ✔ ✖
Correct Answer

Explanation

Correct Answer Explanation:

A1 without any $ signs is a relative reference. It will adjust automatically when copied to a new cell.

Why the other options are incorrect:

  • Option B: $A$1 has $ before both column and row — it's an Absolute reference.
  • Option C: $A1 has $ before column only — it's a Mixed reference (column absolute).
  • Option D: A$1 has $ before row only — it's a Mixed reference (row absolute).
 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? To select the entire worksheet, click on: What is a spreadsheet?