easyFPSCNTSCSSPPSCMS Office & Productivity
Answer explanation
Explanation included
Practice quiz ready
Question

What is the function of the SUM function in Excel?

ATo add up a range of cells
BTo find the average of a range of cells
CTo count the number of cells in a range
DTo find the maximum value in a range of cells

Choose an option to check yourself, or reveal the answer and explanation instantly.

Continue practising this MCQ topic

Use these links to review the full topic, start a timed quiz, or open the exam hub connected with this question.

Related MS Office & Productivity MCQs

View all

Test Yourself

Take a full quiz on MS Office & Productivity

Start Quiz

Exam Coverage

Trust

Answer is visible after reveal
Explanation helps learning
Free topic quiz available

Subject

MS Office & Productivity

Save your progress

Create a free account to bookmark MCQs and track weak areas.

Register Free
Start QuizMore MCQs
Answer and explanation

Correct Answer: A: To add up a range of cells

Explanation: The correct answer is A: To add up a range of cells. The SUM function adds all numeric values within a specified range, making it the most frequently used function in Excel. Keyboard shortcut Alt+= automatically inserts the SUM function for adjacent cells.

Continue practice

More MS Office & Productivity MCQs with answers

Use these links to review related questions, practise the full topic, or open the exam preparation pages connected with this MCQ.

Related questions

Topic and exam paths