Spreadsheets Exercise 6

Spreadsheets – Exercise 6

  1. Create the following table in a new spreadsheet.

The Sweet Shop
Weekly Sales
Day of the Week / Bounty / Kit-Kat / LionBar / MarsBar / Picnic / TOTAL
Mon / 30 / 52 / 38 / 10 / 13 / formula
Tue / 40 / 55 / 33 / 34 / 40 / formula
Wed / 29 / 29 / 54 / 48 / 29 / formula
Thur / 35 / 40 / 51 / 50 / 32 / formula
Fri / 52 / 33 / 53 / 44 / 44 / formula
Sat / 31 / 45 / 32 / 21 / 12 / formula
TOTAL / formula / formula / formula / formula / formula / formula

2.  Change the font of the heading “The Sweet Shop” to Arial size 18.

  1. Embolden the heading.
  1. Embolden and Italicise the Sub-heading “Weekly Sales”
  1. Embolden all column titles (e.g. Day of the Week, Bounty, etc).
  1. Embolden all the days and the TOTAL
  1. Enter a formula to calculate the TOTAL for all items for each day.
  1. Enter a formula to calculate the TOTAL for each item for all days.
  1. Put borders around the whole table and between each cell.
  1. Insert a new sheet before the sheet you are currently working on and call it page 1.
  1. Copy all text and figures from the old sheet to the new sheet starting at cell B8 of page 1.
  1. Return to the old sheet and create a Bar Chart on that sheet based on the weekly sales for all the types of sweets (the data contained in cells A5 to F11).
  1. Use “Weekly Sales of Sweets” as the title for the chart.
  1. Use “Name of chocolate product” for the Category axis.
  1. Use “Amount Sold” for the Value axis.
  1. Insert your name in the Footer.
  1. Save the spreadsheet as EX6COMPLETE in the your working area within a Spreadsheet folder.

W:\I.T\_KS3 MATERIALS\Year 9 04\Spreadsheets\Spreadsheets Exercise 6r.doc