Neco 2018 Computer Studies Question 32

Practice objective / multiple choice question 32 from the 2018 Neco Computer Studies examination.

Neco 2018 Computer Studies Objective / Multiple Choice Hard Difficulty
Question 32 NECO • 2018 • COMPUTER_STUDIES • objective

In a spreadsheet, cells A2:A5 contain the numbers 2, 5, 8 and 11 respectively. Cell B2 contains the formula \(=SUMPRODUCT(A2:A5, {1,2,3,4})\). The user copies B2 down to B5 using the fill handle, so that B3, B4 and B5 contain relative formulas. What value appears in cell B4 after the copy operation?

Answer Options

Correct Answer A. 30
B. 36
C. 34
D. 28
Correct Answer
A
Correct Option:
30

About This Question

This is Neco 2018 Computer Studies Question 32. It is one of the objective questions from the 2018 Neco Computer Studies examination.

Difficulty level: Hard .

View More Neco 2018 Computer Studies Questions More Neco Practice Questions Back to Questions

Master the Exam!

You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.

Unlock Full Access Available for Android & Windows
Chat with Support