Gce Model Questions Vol1 2022 Computer Studies Question 10

Practice essay / theory question 10 from the 2022 Gce Model Questions Vol1 Computer Studies examination. This question covers Spreadsheet formulas, Conditional formatting, Moving averages, VBA macros, Linking Office applications .

Gce Model Questions Vol1 2022 Computer Studies Essay / Theory

Topics: Spreadsheet formulas Conditional formatting Moving averages VBA macros Linking Office applications

Question 10 GCE_MODEL_QUESTIONS_VOL1 • 2022 • COMPUTER_STUDIES • essay

A company uses Microsoft Excel to maintain its monthly sales data and Microsoft Word to produce a formatted sales report that is sent to management.

Question Parts

( a )

The sales data for three products (A, B, C) for the months January to June are entered in a worksheet as shown below. Describe the formulas required to calculate (i) the total sales for each product over the six months, (ii) the moving average of the total sales for the last three months, and (iii) how to apply conditional formatting to highlight any month where total sales fall below 5 000 units.

Detailed Solution & Marking Scheme

Get the step-by-step solution, key points required by examiners and detailed marking guidance through the Edcrib AI Tutor.

Reveal Answer

About This Question

This is Gce Model Questions Vol1 2022 Computer Studies Question 10. It is one of the essay questions from the 2022 Gce Model Questions Vol1 Computer Studies examination.

The question covers Spreadsheet formulas, Conditional formatting, Moving averages, VBA macros, Linking Office applications .

View More Gce Model Questions Vol1 2022 Computer Studies Questions More Gce Model Questions Vol1 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