What does the formula =SUM(A1:A10) do in MS Excel? MCQ with Answer and Explanation

Question

Share Report Error

What does the formula =SUM(A1:A10) do in MS Excel?

A. Finds the average of numbers in A1:A10

B. Counts the number of cells with numbers in A1:A10

C. Adds all numbers in cells A1 through A10

D. Returns the maximum value in the range

Answer: Option C

Solution (By JKSSB Mock Tests)

The SUM function adds all numeric values in the specified range. It does not count, average, or find max.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1

In MS Word, what does pressing the 'Ctrl + W' shortcut key combination do?

A. Saves the current document and opens a blank document

B. Closes the currently active document window

C. Applies a bold style format to the active word block

D. Launches the web browser lookup helper

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Ctrl + W closes the active document or file window in most MS Office suites without exiting the core parent software program altogether.

This question belongs to: Computer Microsoft Office

Question #2

In Excel, which function is used to calculate the payment for a loan based on constant payments and interest rate, but for a given number of periods?

A. RATE

B. PV

C. PMT

D. NPER

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
PMT calculates the periodic payment. NPER calculates number of periods, PV present value, RATE interest rate.

This question belongs to: Computer Microsoft Office

Question #3

In PowerPoint, the 'Arrange' group under the Home tab contains:

A. Bring Forward, Send Backward, Align, Group, Rotate

B. Slide layout

C. Font formatting

D. Animations and transitions

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Arrange group is for object ordering.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs