Roseys Roses is located in Savannah, Georgia, and specializes in the sale of roses. You, as the

Question:

Rosey€™s Roses is located in Savannah, Georgia, and specializes in the sale of roses. You, as the manager of the business, are curious to see how Excel might help you manage the business and account for its inventory. To that end, you have hired a local college student to construct several worksheets to help the business better understand the financial and managerial aspects of the company. To begin, the two of you decide to create a worksheet of Rosey€™s inventory.
Start with worksheet ch2-08 and make the following changes:

1. Format the company name and worksheet title bold and italics.
2. Move the company name and worksheet title from column C to column A.
3. Format the title of each column (located in row 4) bold with a bottom border.
4. Add a column (titled Quantity) to the right of column Description.
5. Format the Quantity title aligned centered, bold with a bottom border.
6. Format the values under the Quantity title as comma style with no decimals.
7. Resize column C to 95 pixels.
8. Add an additional column (titled Cost/Unit) to the right of column Quantity.
9. Format the Cost/Unit title aligned centered, bold with a bottom border.
10. Format the values under the Cost/Unit title as currency.
11. Resize column D to 115 pixels.
12. Add an additional column (titled Cost) to the right of column Cost/Unit.
13. Format the Cost title aligned centered, bold with a bottom border.
14. Format the values under the Cost title as currency.
15. Resize column E to 115 pixels.
16. Enter the following values for Quantity and Cost/unit

Quantity Cost/Unit Type Description Shrub Abraham Darby #5 Be My Baby #5 Deja Blu #5 Koko Loko #7 25 $39.99 Shrub 40 $18

17. Insert a formula to calculate the cost as quantity times cost/unit in cell E5.
18. Format this cell aligned right.
19. Fill down this formula for all cells in the table.

20. Insert a row below the last shrub listed.
21. Add one additional item into your newly added row with a type €˜€˜Shrub,€™€™
description €˜€˜Wing Ding #5,€™€™ quantity €˜€˜20,€™€™ and cost/unit €˜€˜13.99.€™€™
22. Type Total in cell A20.
23. Insert a formula to calculate the total cost of all roses into cell E20.
24. Format cell E20 to align right with a top and double bottom border.
25. Save the file as ch2-08_student_name (replacing student_name with your name).
a. Print the completed worksheet in Value view, with portrait orientation with your name and date printed in the lower left footer and file name in the lower right footer.
b. Print the completed worksheet in Formula view with gridlines and row and column headers, with portrait orientation, with your name and date printed in the lower left footer and the file name in the lower right footer.