Gce Model Questions Vol1 2018 Computer Studies Question 10

Practice essay / theory question 10 from the 2018 Gce Model Questions Vol1 Computer Studies examination. This question covers Spreadsheet functions, Data validation, Pivot tables and charts, Word processing mail‑merge, Report formatting .

Gce Model Questions Vol1 2018 Computer Studies Essay / Theory
Topics: Spreadsheet functions Data validation Pivot tables and charts Word processing mail‑merge Report formatting
Question 10 GCE_MODEL_QUESTIONS_VOL1 • 2018 • COMPUTER_STUDIES • essay

A small retail shop wishes to manage its monthly sales using a spreadsheet and to produce a formatted performance report with a word processor. The shop sells three product categories (A, B and C). Design a solution that meets the following requirements.

Question Parts

( a )
Set up a worksheet to record daily sales with columns: Date, Category, Units Sold, Unit Price. Explain how to apply data validation so that: i) Category can only be A, B or C; ii) Units Sold must be a non‑negative integer.
( b )
Write a formula that calculates the total revenue for each row, and another formula that gives the cumulative monthly revenue up to that row (assume the data are sorted by date).
( c )
Using the same data, describe the steps required to create a pivot table that shows total revenue per category and a line chart that visualises the monthly revenue trend. Include any field settings that are essential.
( d )
Outline how to use the spreadsheet data to generate a printed monthly sales summary in a word processor using mail‑merge. The report must contain a table of total revenue per category and the line chart created in part (c).

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

The question covers Spreadsheet functions, Data validation, Pivot tables and charts, Word processing mail‑merge, Report formatting .

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