Single Choice Moderate

QThe reference A1:B3 refers to:

ID: #25650 MCQ Quiz - Chapter Summary - Class 8 - Spreadsheet 5 views
Question Info
#25650Q ID
ModerateDifficulty
MCQ Quiz - Chapter Summary - Class 8 - SpreadsheetTopic

Choose the Best Option

Click any option to instantly check if you're correct.

  • A 6 cells
  • B 3 cells
  • C 9 cells
  • D 2 cells
Correct Answer

Explanation

Correct Answer Explanation:

A1:B3 covers 2 columns (A and B) and 3 rows (1, 2, 3), giving 2 × 3 = 6 cells: A1, A2, A3, B1, B2, B3.

Why the other options are incorrect:

  • Option B: 3 cells would only cover one column or one row, not this 2-column × 3-row range.
  • Option C: 9 cells would be 3 × 3 (like A1:C3), but this range is 2 × 3 = 6.
  • Option D: 2 cells would be just A1 and B3 — but a colon includes all cells in between too.

Share This Question

Challenge a friend or share with your study group.