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

QSUM can accept:

ID: #25677 MCQ Quiz - Chapter Summary - Class 8 - Spreadsheet 4 views
Question Info
#25677Q 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 Range or individual values ✔ ✖
  • B Only text ✔ ✖
  • C Only booleans ✔ ✖
  • D Only dates ✔ ✖
Correct Answer

Explanation

Correct Answer Explanation:

SUM accepts both individual numeric values (like =SUM(1,2,3)) AND ranges (like =SUM(A1:A10)). You can even mix them: =SUM(A1:A5, 100).

Why the other options are incorrect:

  • Option B: SUM adds numbers; text values are ignored (or cause errors if you're strict).
  • Option C: TRUE/FALSE (booleans) aren't the primary input — SUM works with numbers.
  • Option D: Dates can be summed (they're stored as numbers), but SUM is not limited to dates.
 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? Reference $A1 means: 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?