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

QMIN considers empty cells as:

ID: #25685 MCQ Quiz - Chapter Summary - Class 8 - Spreadsheet 5 views
Question Info
#25685Q 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 Zero ✔ ✖
  • B Ignored ✔ ✖
  • C Text ✔ ✖
  • D Error ✔ ✖
Correct Answer

Explanation

Correct Answer Explanation:

MIN ignores empty cells while calculating. Empty cells are NOT treated as zero — they simply don't count. But if a cell CONTAINS 0, it IS considered.

Why the other options are incorrect:

  • Option A: Empty cells are ignored, not treated as zero.
  • Option C: Empty cells are treated as empty, not as text.
  • Option D: Empty cells cause no error — they're simply skipped.
 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 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: What is a cell reference? Reference $A1 means: MAX works with: