Bird
0
0

Which MS Excel function is most appropriate to assign grades like A, B, or C based on marks ranges?

hard Q9 of 15
Computer Aptitude - Microsoft Office (Basics + Functions)
Which MS Excel function is most appropriate to assign grades like A, B, or C based on marks ranges?
AIF()
BCOUNTIF()
CAND()
DSUMIF()
Step-by-Step Solution
  1. Step 1: Identify multi-output requirement

    The output depends on marks range.
  2. Step 2: Match with conditional output function

    IF() is used for assigning results based on conditions.
  3. Final Answer:

    IF() → Option A.
  4. Quick Check:

    Nested IF() can handle multiple grade conditions ✅
Quick Trick: Result labels based on marks = IF().
Common Mistakes:
MISTAKES
  • Trying to use COUNTIF() for result assignment.
Master "Microsoft Office (Basics + Functions)" in Computer Aptitude

Start learning the concept with an interactive lesson.

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Computer Aptitude Quizzes