City Guilds Model Questions Vol1 2019 Information Technology Question 4

A small retail shop records its daily sales (in Naira) for three products – A, B and C – over a seven‑day period. The data are entered in a spreadsheet as shown below (the first column is the day of the week): | Day | Product A | Product B | Product C | |-----|-----------|-----------|-----------| | Mon | 12,500 | 9,800 | 4,200 | | Tue | 13,400 | 10,500 | 4,750 | | Wed | 11,900 | 9,300 | 5,100 | | Thu | 14,200 | 11,600 | 4,950 | | Fri | 15,800 | 12,300 | 5,400 | | Sat | 18,600 | 13,900 | 6,250 | | Sun | 16,700 | 12,800 | 5,800 | Using spreadsheet functions, complete the following tasks: a) Write the formula that will calculate the total weekly sales for each product and the overall total sales for the week. State the cell reference where each total should be placed. b) Determine which product achieved the highest average daily sales and show the formula you used to obtain the average. c) Create a column chart that compares the daily sales of the three products. Outline the steps required to insert the chart and to modify its title to “Weekly Sales Comparison” and label the horizontal axis as “Day” and the vertical axis as “Sales (₦)”. d) Identify one possible source of error that could arise when entering the sales figures and suggest a spreadsheet feature that can be used to minimise this error.