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?
Which MS Excel function is most appropriate to assign grades like A, B, or C based on marks ranges?
hard Q9 of 15
Step-by-Step Solution
Step 1: Identify multi-output requirement
The output depends on marks range.Step 2: Match with conditional output function
IF() is used for assigning results based on conditions.Final Answer:
IF() → Option A.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 QuestionsMore Computer Aptitude Quizzes