In Excel, what is the result of the formula =SUM(A1:A3, B1:B3) if A1=5, A2=3, A3=2, B1=1, B2=4, B3=2? MCQ with Answer and Explanation

Question

Share Report Error

In Excel, what is the result of the formula =SUM(A1:A3, B1:B3) if A1=5, A2=3, A3=2, B1=1, B2=4, B3=2?

A. 15

B. 17

C. 12

D. 19

Answer: Option B

Solution (By JKSSB Mock Tests)

SUM(A1:A3) = 5+3+2 = 10, SUM(B1:B3) = 1+4+2 = 7, total 17.

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 Access, the 'Report Wizard' allows you to:

A. Create macros for reporting

B. Design a table

C. Create a report quickly by selecting fields, grouping, and layout

D. Write SQL for a report

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Report Wizard steps through report creation.

This question belongs to: Computer Microsoft Office

Question #2

In PowerPoint, which feature automatically adjusts the size of text to fit within a placeholder?

A. Both A and B

B. AutoFit

C. Shrink text on overflow

D. Text Scaling

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
AutoFit options: Shrink text on overflow, Resize shape to fit text.

This question belongs to: Computer Microsoft Office

Question #3

In MS Word, what is the maximum zoom level?

A. 1000%

B. 500%

C. 400%

D. 200%

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Maximum zoom in Word is 500%.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs