Neco 2022 Computer Studies Question 31

Practice objective / multiple choice question 31 from the 2022 Neco Computer Studies examination.

Neco 2022 Computer Studies Objective / Multiple Choice Hard Difficulty
Question 31 NECO • 2022 • COMPUTER_STUDIES • objective

In a spreadsheet, cells C2:C7 contain the units sold: 45, 60, 55, 70, 65, 80 respectively. In cell D2 the formula \( =IF(C2>50, C2\\times1.2, C2\\times1.1) \) is copied down to D7. Cell D8 contains the formula \( =SUM(D2:D7) \). What value is displayed in D8?

Answer Options

A. 450.0
B. 396.0
Correct Answer C. 445.5
D. 412.5
Correct Answer
C
Correct Option:
445.5

About This Question

This is Neco 2022 Computer Studies Question 31. It is one of the objective questions from the 2022 Neco Computer Studies examination.

Difficulty level: Hard .

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