Gce Model Questions Vol1 2023 Computer Studies Question 10

Practice essay / theory question 10 from the 2023 Gce Model Questions Vol1 Computer Studies examination. This question covers Spreadsheet Functions, Formulas and Conditional Formatting, Data Validation and Protection, Word Processing – Mail Merge .

Gce Model Questions Vol1 2023 Computer Studies Essay / Theory

Topics: Spreadsheet Functions Formulas and Conditional Formatting Data Validation and Protection Word Processing – Mail Merge

Question 10 GCE_MODEL_QUESTIONS_VOL1 • 2023 • COMPUTER_STUDIES • essay

A retail company uses a spreadsheet to record its monthly sales for each of its five product lines (A‑E) across the twelve months of a year. The spreadsheet contains the following columns: - Month (January … December) - Sales_A, Sales_B, Sales_C, Sales_D, Sales_E (numeric values in ₦) - Total_Sales (to be calculated) - Commission (to be calculated) The company also prepares a standard letter in a word‑processing document that is sent to each regional manager. The letter contains placeholders for the manager’s name, region, and the total sales figure for the manager’s region, which is extracted from the spreadsheet. Answer the following questions:

Question Parts

( a )

Using spreadsheet formulas, describe how to calculate: i. The total sales for each month (column Total_Sales). ii. The average monthly sales for each product line over the year. iii. Apply conditional formatting to highlight any month where Total_Sales falls below ₦500,000 in red.

( b )

The company pays commission on total annual sales according to the following tiered structure: • Up to ₦2,000,000 – 2% of sales • ₦2,000,001 to ₦5,000,000 – 3% of sales • Above ₦5,000,000 – 5% of sales Write a single spreadsheet formula (using IF or nested IF) that calculates the commission based on the value in Total_Sales for a given month and places the result in the Commission column.

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

The question covers Spreadsheet Functions, Formulas and Conditional Formatting, Data Validation and Protection, Word Processing – Mail Merge .

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