INSTRUCTIONS FOR Excel practice sheet
Download an excel worksheet by right clicking this link  and choosing "save target as".


1 Change the "description" column to make the text wrap.
2 Make the "Vendor" column wide enough to show all the vendor names.
3 Put $ on all sales figures 
4 Total the sales for The first quarter. Put the total right below the last sales figure.
5 Put a double bar before the total figure.
6 Add a column to show the % that each sale is of the total sales figure.
7 In the heading, write your name.
8 In the footing, write a page number.
9 Bold the "The Computer Source" and make it size 20.
10 Sort all rows except the headings in description order.
11 set up the headings (Item #, Category, Description, Vendor, QTR 1) to print at the top of each page
12 set up those same headings to stay put as you scroll
13
14
Tell excel to only print landscape and only one page wide
Print preview to see the headings and to see that it is just one page wide.

Here are some helps for completing this sheet. Don't use the helps unless you are stuck. If you find you need them, be sure to return to try the exercise without any helps to ensure you are ready for the test.