City Guilds Model Questions Vol1 2021 Information Technology Question 4

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

City Guilds Model Questions Vol1 2021 Information Technology Practical

Topic: Spreadsheets

Question 4 CITY_GUILDS_MODEL_QUESTIONS_VOL1 • 2021 • INFORMATION_TECHNOLOGY • practical

A small retail shop records the monthly sales (in Naira) of three products over the first six months of the year as shown below: | Month | Product A | Product B | Product C | |-------|-----------|-----------|-----------| | Jan | 12,500 | 9,300 | 4,200 | | Feb | 13,800 | 10,150 | 4,750 | | Mar | 15,200 | 11,400 | 5,300 | | Apr | 14,600 | 10,900 | 5,050 | | May | 16,050 | 12,300 | 5,800 | | Jun | 17,400 | 13,250 | 6,150 | Using a spreadsheet application, the student must analyse the data and present the findings.

Question Parts

( a )

Create a summary table that shows the total sales for each product over the six‑month period. State the formulas used.

( b )

Identify the month with the highest combined sales of all three products. Use a single formula (do not calculate manually) and give the month name as the answer.

( c )

Add three new columns that show, for each month, the percentage contribution of each product to that month’s total sales. Round each percentage to the nearest whole number.

( d )

Insert a line chart that compares the monthly sales trends of the three products. Briefly describe how to set the data range, assign series, label the axes and add a legend.

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

The question covers Spreadsheets .

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