Bird
0
0

Which MS Excel function returns TRUE if at least one of the given conditions is satisfied?

easy Q12 of 15
Computer Aptitude - Microsoft Office (Basics + Functions)
Which MS Excel function returns TRUE if at least one of the given conditions is satisfied?
AAND()
BOR()
CIF()
DSUMIF()
Step-by-Step Solution

  1. Step 1: Understand the condition

    The function should succeed even if one condition is TRUE.

  2. Step 2: Match with logical functions

    OR() returns TRUE when any one condition is TRUE.

  3. Final Answer:

    OR() → Option B.

  4. Quick Check:

    OR(FALSE, TRUE) = TRUE ✅
Quick Trick: Any one true = OR().
Common Mistakes:
MISTAKES
  • Confusing OR() with AND().
Master "Microsoft Office (Basics + Functions)" in Computer Aptitude

Start learning the concept with an interactive lesson.

Learn

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Computer Aptitude Quizzes
Microsoft Office (Basics + Functions) - MS PowerPoint — Design & View Options - Quiz 14medium Microsoft Office (Basics + Functions) - Cross-Application Integration (Office Suite Awareness) - Quiz 2easy Microsoft Office (Basics + Functions) - MS Word — Advanced Features - Quiz 15medium Microsoft Office (Basics + Functions) - MS PowerPoint — Design & View Options - Quiz 7medium Microsoft Office (Basics + Functions) - MS Word — Basic Formatting & Editing Tools - Quiz 14medium Microsoft Office (Basics + Functions) - Cross-Application Integration (Office Suite Awareness) - Quiz 15medium Microsoft Office (Basics + Functions) - MS Excel — Basic Functions & Formulas - Quiz 1easy Microsoft Office (Basics + Functions) - MS Excel — Basic Functions & Formulas - Quiz 2easy Microsoft Office (Basics + Functions) - Common Office File Extensions & Compatibility - Quiz 9hard Microsoft Office (Basics + Functions) - Cross-Application Integration (Office Suite Awareness) - Quiz 13easy