Excel Basics Exercise 7

  1. Open the spreadsheet called which compares sales figures for the company MSI
  2. Create and fill down formulae to perform the calculations required in columns D, E and F
  3. Calculate Average, Maximum and Minimum sales figures for the different regions for each year
  4. Save and print the worksheet
  5. Display formulae and print the worksheet a second time
  6. Create a title sheet for the workbook and name the sheet
  7. Create a centred and bolded heading called Motorcycle Specialities Incorporated
  8. Enter the purpose of the spreadsheet
  9. Enter the date and the creator (your name)
  10. Name another sheet as charts
  11. Create some charts that visually show the sales figures and insert them on the chart worksheet