City Guilds Model Questions Vol1 2018 Information Technology Question 4

Practice practical question 4 from the 2018 City Guilds Model Questions Vol1 Information Technology examination. This question covers Spreadsheets .

City Guilds Model Questions Vol1 2018 Information Technology Practical
Topic: Spreadsheets
Question 4 CITY_GUILDS_MODEL_QUESTIONS_VOL1 • 2018 • INFORMATION_TECHNOLOGY • practical

A small business owner records monthly sales of three products (A, B, C) for the first six months of the year in a spreadsheet. The units sold and unit prices are given below. | Month | Product A (units) | Product B (units) | Product C (units) | |-------|-------------------|-------------------|-------------------| | Jan | 120 | 80 | 150 | | Feb | 130 | 95 | 160 | | Mar | 140 | 120 | 170 | | Apr | 150 | 150 | 180 | | May | 160 | 180 | 190 | | Jun | 170 | 210 | 200 | Unit prices: Product A – ₦250 per unit, Product B – ₦400 per unit, Product C – ₦150 per unit. The owner wants to analyse revenue, average sales and growth trends using spreadsheet formulas.

Question Parts

( a )
Write the spreadsheet formula (using cell references) that would calculate the total revenue for a given month, assuming the units for the month are in cells B2:D2 and the unit‑price range is in cells B8:D8.
( b )
Using the data provided, calculate (i) the total revenue for June and (ii) the overall total revenue for the six‑month period.
( c )
Find the average monthly revenue generated by Product C over the six months.
( d )
The units sold of Product B grew from March (120 units) to June (210 units). Assuming a constant percentage increase each month, (i) calculate that monthly growth rate (to two decimal places) and (ii) project the expected units for July.

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 City Guilds Model Questions Vol1 2018 Information Technology Question 4. It is one of the practical questions from the 2018 City Guilds Model Questions Vol1 Information Technology examination.

The question covers Spreadsheets .

View More City Guilds Model Questions Vol1 2018 Information Technology Questions More City Guilds 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