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: