Computer Aptitude - Microsoft Office (Basics + Functions)
Which MS Excel function is used to add all the numeric values present in cells B1 to B10?
Which MS Excel function is used to add all the numeric values present in cells B1 to B10?
easy Q11 of 15
Step-by-Step Solution
Step 1: Identify the requirement
The task is to add all numeric values in the given range.Step 2: Recall Excel functions
SUM() is used to calculate the total of values.Final Answer:
SUM(B1:B10) → Option A.Quick Check:
SUM adds all values in the selected cells automatically ✅
Quick Trick: Total of numbers always means SUM().
Common Mistakes:
- Choosing AVERAGE instead of calculating total.
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