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. 18

C. 20

D. 26

Answer: Option C

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 MS PowerPoint, which option is used to add a background image to all slides?

A. Format Background > Apply to All

B. Both A and C

C. Insert > Picture > Background

D. Design > Background Styles > Format Background

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
You can set a background picture via Format Background and then click 'Apply to All'. Also under Design > Background Styles > Format Background opens the same pane. So both A and C are correct. Thus answer D.

This question belongs to: Computer Microsoft Office