Snick's Board Shop is located in La Jolla, California, and specializes in complete and longboard skateboards and equipment. Owner Casey "Snick" Miller is curious to see how Excel might help him manage the business and account for its inventory. His girlfriend Caitlin handles the financial aspects of the business but hasn't had much experience with Excel. They have hired you to help him construct several worksheets to help the business better understand the financial and managerial aspects of the company.

To being, you decide to create a worksheet of Snick's inventory. Start with worksheet ch2-07 and make the following changes:

1. Format the company name and worksheet title bold and italics.

2. Format the title of each column (located in row 5) bold with a bottom border.

3. Format all values for the column Price as Accounting Number Format.

4. If necessary, resize all columns and rows so that data does not wrap.

5. Add one column (titled Quantity) to the right of column Product # and then type 10 as the quantity for all items. Add an additional column (titled Retail Value) to the right of column Quantity. Format both column titles as all other column titles.

6. Insert a formula to calculate the retail value as quantity times price in cell I6, ten fill down this formula for all cells in the table.

7. Inset a text label "Total" in cell G19 and a formula to calculate the total retail value of all products in cell H19.

8. Format cell H19 with a top and bottom double border.

9, Insert two additional rows after row 9.

10. Add two products in rows 10 and 11 as follows.

category	Ramp	Ramp
Manufacturer	Element	Mojo
Product Name	element Launch Ramp	Mojo Wedge Ramp
Price	209.99	215.99
Style	Black/Red	Black/Blue
Product#	65-01837	65-00011
Quantity	5	8

11. Change the name of Sheet1 to "Retail Value"

12. Create a copy of this worksheet and place it before Sheet2, then change the name of this sheet to "Cost".

13. add a label at cell E2 of the Cost sheet called "Cost %" in Bold, Italics.

14. Type 40% as the cost percentage in cell F2 of the Cost sheet. Change the name of the column "Retail Value" to "Cost". Center the Cost title.

15. Create a new formula in cell H6 to calculate the cost as Price time Cost % times Quantity. (Be sure to use absolute or relative references where appropriate.) Fill the formula in cell H^ down to all items.

Category	Manufacturer	Product Name	Price	Style	Product #
Complete	Krooked	Krooked Eyes Complete	95.99	Pink/Blue	65-01400
Complete	Element	Element Section Complete	89.99	Black/Red	65-00358
Complete	Almost	Almost Mullen OC Impact V4 Complete	119.99	Orange/Teal	65-00335
Complete	Almost	Almost Mullen Premium Day Glow Complete	119.99	Black/Yellow	65-00981
Longboards	Sector 9	Sector 9 Sand Wedge Complete	189.99	Black/White	65-01967
Longboards	Goldcoast	Goldcoast Venice Complete	149.99	Green/Yellow	65-01970
Longboards	Santa Cruz	Santa Cruz Landshark Complete	99.99	Blue/White	65-01783
Longboards	Santa Cruz	Santa Cruz Tiger Shark Complete	129.99	Orange/Black	65-01786
Protective Gear	Bern	Bern Macon Helmet	59.99	White	65-01135
Protective Gear	Triple Eight	Triple Eight Little Tricky Helmet	34.99	Black	65-23174
Rails	Element	Element Flat Bar Grind Rail	109.99	Black	61-16758
Rails	Zero	Zero 6 Foot Flat Bar Grind Rail	99.99	Red	61-36447
Rails	Zero	Zero Switchblade Rail	119.99	Silver	61-23116