In Excel, the formula =SUMPRODUCT(A1:A3, B1:B3) multiplies corresponding components and returns the sum. If A1=2,A2=3,A3=4 and B1=1,B2=2,B3=3, result is: MCQ with Answer and Explanation

Question

In Excel, the formula =SUMPRODUCT(A1:A3, B1:B3) multiplies corresponding components and returns the sum. If A1=2,A2=3,A3=4 and B1=1,B2=2,B3=3, result is:

A. 24

B. 26

C. 18

D. 20

Answer: Option D

Solution (By JKSSB Mock Tests)

2*1 + 3*2 + 4*3 = 2+6+12=20.

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

Share Report

In Excel, which function counts the number of blank cells in a range?

A. COUNTBLANK()

B. COUNTIF()

C. ISBLANK()

D. COUNTA()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
COUNTBLANK(range) returns count of empty cells.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Access, which object can contain other objects like buttons, text boxes, and subforms?

A. Form

B. Query

C. Macro

D. Table

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Forms serve as containers for controls.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In Excel, the error '#DIV/0!' occurs when:

A. Name not recognized

B. A formula divides by zero or an empty cell

C. Invalid reference

D. Value not available

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
#DIV/0! division by zero.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs