FINAL LAB EXERCISE

Since this is a final exercise, step-by-step directions will not be given as they were in the other exercises.  It is up to you to remember how to do these things.  If you do not, you can always refresh your memory by returning to the web page.

 

 

  1. Open up an Excel spreadsheet
  2. In cell A1, type in ‘School Store Price List for 2000 and 2001’
  3. Merge cells A1 through E1 – this will automatically center your text
  4. Change the text size to 12 and make it bold
  5. In cell A2, type in ‘2000’, and in cell D2, type in ‘2001’
  6. Center these two numbers
  7. In cell A3, type in ‘Product’, and in cell B3, type in ‘Price’
  8. Make these words centered and bold
  9. In cells A4 through A9, type in the following school supplies:  ‘pencils’, ‘pens’, ‘rulers’, ‘notebooks’, ‘erasers’, and ‘folders’, respectively – remember that the column may need to be widened to accommodate all text
  10. In cells B4 through B9, type in ‘1.2’, ‘1.5’, ‘2’, ‘3.25’, ‘.75’, and ‘2.5’, respectively
  11. Now, format the numbers in the price column to currency
  12. Copy ‘Product’ and ‘Price’ and paste them under the ‘2001’ heading
  13. Copy the school supplies and paste them under the product heading – remember that the column may need to be widened
  14. Give the school supplies the following prices:  ‘1.25’, ‘1.5’, ‘2.1’, ‘3’, ‘.9’, and ‘2.5’, respectively
  15. Format the numbers in the price column to currency
  16. In cells A11 and D11, type in ‘Average Price’ – the column may need to be widened
  17. In cell B11, use the Excel formula to get the average price (your formula will look like this: =AVERAGE(B4:B9)
  18. Copy this formula into cell D11 to get the 2001 average price
  19. But borders around the 2000 information (cells A2 through B11) and the 2001 information (cells D2 though D11)
  20. Make the words ‘Average Price’ red (don’t forget – it’s written twice)
  21. Give the cells containing ‘Product’ and ‘Price’ a green background on the 2000 side, and a blue background on the 2001 side
  22. Change the font size of ‘2000’ and ‘2001’ to size 12 – change them at the same time
  23. Change the font of all the school supplies to the ‘Century’ font – change them at the same time
  24. Center all of the prices on both sides
  25. Insert a hyperlink to the office supply store “Staples” in cell A13 – the web page name should be ‘http://www.staples.com/’, but the text to display is ‘Staples Website’ – This hyperlink will run over the cell, but that’s okay – leave it the way it is

 

Your final worksheet should look like this: