Gce Model Questions Vol1 2021 Computer Studies Question 10

Practice essay / theory question 10 from the 2021 Gce Model Questions Vol1 Computer Studies examination. This question covers Spreadsheet formulas, Chart creation, Percentage calculations, Mail merge, Macro advantages and disadvantages .

Gce Model Questions Vol1 2021 Computer Studies Essay / Theory
Topics: Spreadsheet formulas Chart creation Percentage calculations Mail merge Macro advantages and disadvantages
Question 10 GCE_MODEL_QUESTIONS_VOL1 • 2021 • COMPUTER_STUDIES • essay

A small business owner uses a spreadsheet to record monthly sales of three product lines (A, B and C) and prepares a written report in a word processor for the quarterly board meeting.

Question Parts

( a )
The sales data for the first six months are given below. Write a formula to calculate the total sales for each product line (summing the six months). Then write a formula that, for the first quarter (January‑March), gives the percentage contribution of each product line to the quarter’s total sales. Show the exact formulas you would enter.
( b )
Explain how to create a dynamic chart that updates automatically when new monthly sales data are added to the worksheet. Include the steps for defining the data range and selecting an appropriate chart type.
( c )
The owner wishes to generate a personalised sales letter for each client using mail merge. Outline the steps required in the word processor, assuming the client details (Name, Company, Email) are stored in a separate spreadsheet.
( d )
Discuss the advantages and disadvantages of using macros in the spreadsheet to automate the quarterly report generation. Provide two specific examples of tasks that could be automated with a macro.

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 2021 Computer Studies Question 10. It is one of the essay questions from the 2021 Gce Model Questions Vol1 Computer Studies examination.

The question covers Spreadsheet formulas, Chart creation, Percentage calculations, Mail merge, Macro advantages and disadvantages .

View More Gce Model Questions Vol1 2021 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