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

QA range of cells from A1 to A5 is written as:

ID: #25649 MCQ Quiz - Chapter Summary - Class 8 - Spreadsheet 6 views
Question Info
#25649Q 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:A5 ✔ ✖
  • B A1-A5 ✔ ✖
  • C A1+A5 ✔ ✖
  • D A1,A5 ✔ ✖
Correct Answer

Explanation

Correct Answer Explanation:

A range in Excel is written using a colon (:) between the first and last cell. So A1 to A5 becomes A1:A5, which includes A1, A2, A3, A4, and A5.

Why the other options are incorrect:

  • Option B: A dash (-) is not Excel's range separator; Excel would interpret it as subtraction.
  • Option C: A plus (+) is the addition operator, not a range separator.
  • Option D: A comma (,) separates individual cells (A1, A5 means only A1 and A5, not A2-A4).
 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? Which key is held to select non-adjacent cells? Cell A5 refers to: Reference $A1 means: Every formula in Excel starts with: Mixed references are useful when: Which key toggles reference types in Excel? Which is a relative reference?