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

QIf B2 has =A2 and you copy it to B3, it becomes:

ID: #25653 MCQ Quiz - Chapter Summary - Class 8 - Spreadsheet 5 views
Question Info
#25653Q 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 1 ✔ ✖
  • B 2 ✔ ✖
  • C No of Question ✔ ✖
  • D Which is a spreadsheet program? ✔ ✖
Correct Answer

Explanation

Correct Answer Explanation:

Because A2 is a relative reference, copying from B2 down to B3 shifts the reference down by 1 row too — A2 becomes A3.

Why the other options are incorrect:

  • Option A: The reference stays as A2 only for absolute references ($A$2), not relative ones.
  • Option C: A1 would result from copying UP, not down.
  • Option D: The formula pattern is =A(something), not =B(something).
 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: