Project 2B. Inventory Value
In Activities 2.7 through 2.16, you will create a workbook for Bill Peterson, the manager of Desert Park's municipal golf course. The golf course carries a small inventory of golf products and snacks in its pro shop. Mr. Peterson wants to calculate the retail value of the inventory of golf products and, using a pie chart, display how each item's retail value contributes to the total retail value. Your completed worksheet and chart will look similar to Figure 2.20.
Figure 2.20.
|
For Project 2B, you will need the following file: |
|
New blank workbook |
You will save your workbook as
2B_Inventory_Value_Firstname_Lastname
Objective 5 Design a Worksheet
|