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
|