SECTION C

The following data represents yearly sales made by GoEasy Enterprise from 2013 -2017. You are to create a professional report to analyze the information by performing the following tasks in a spreadsheet.

SUMMER SALES ITEM 2013 2015 2016 2017 TOTAL Fruits 600.54 500 744.50 680 Vegetables 420.45 705 525 188 Fish 1100.25 230 525 164 Bottled Water 700.90 650 120.55 725 Dairy 690.75 1130 655 499 Drinks 225.99 325 119 431

a) Enter the data above, leaving the TOTAL column blank. b) Center the spreadsheet heading SUMMER SALES across the spreadsheet. c) Create a formula to display the total for each item. d) Apply borders and shading (colour) as shown in the table above. Feel free to use your own colour scheme. e) Add the year 2014 with the following details: Fruits 600, Vegetables 330, Fish, 250, Bottled water 720, Dairy 408 and Drinks 2275 f) Use conditional formatting to highlight in a red text all sales below 500 g) Update your spreadsheet and create a formula to calculate the total sales for all items in an appropriate cell. Format the result to the nearest whole number. h) Generate an appropriate graph to display the total of each item from 2013 to 2017 i) Create a column with heading Increment. If the total sale for an item exceeds 2000 display Approved otherwise Denied j) Insert your index number at the center of the footer.