Neco 2019 Computer Studies Question 17

Practice objective / multiple choice question 17 from the 2019 Neco Computer Studies examination.

Neco 2019 Computer Studies Objective / Multiple Choice Hard Difficulty
Question 17 NECO • 2019 • COMPUTER_STUDIES • objective

An Excel worksheet records quarterly sales for ten products. For each product, the sales for Q1 to Q4 are entered in columns B to E of rows 2 to 11. Column F should show the total annual sales for that product, and row 12 should show the total sales for each quarter across all products. Provide: 1. The formula to place in cell F2 that can be copied down to compute each product's total. 2. The formula to place in cell B12 that can be copied across to compute each quarter's total. 3. The formula to place in cell G2 that gives the percentage contribution of that product's total to the overall total (which will be in cell G12), and can be copied down.

Answer Options

Correct Answer A. =SUM(B2:E2); =SUM(B$2:B$11); =F2/\$F\$12*100
B. =SUM(B2:E2); =SUM(B$2:B$11); =F2*\$F\$12*100
C. =SUM(B2:D2); =SUM(B$2:B$11); =F2\/\$F\$12/100
D. =SUM(B2:E2); =SUM(B2:B11); =F2\/\$F\$12*100
Correct Answer
A
Correct Option:
=SUM(B2:E2); =SUM(B$2:B$11); =F2/\$F\$12*100

About This Question

This is Neco 2019 Computer Studies Question 17. It is one of the objective questions from the 2019 Neco Computer Studies examination.

Difficulty level: Hard .

View More Neco 2019 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