Reference no: EM132832735

Learning Objective 1: Employ spreadsheet functions to analyze information and solve problems.

Interpret data using visual representation.

Assignment

Your new bakery business is getting off the ground and you need to inventory your ingredients. You are also interested in determining how much money you have invested and which ingredients are the most costly. You will open the W2 Bakery spreadsheet and complete the steps below to organize your data:

1. Center the data in the Measurement Unit column.

2. Apply the COUNTIF formula to calculate the number of ingredients measured in cups and tbsp. Include the total for cups (C) in Cell B26 and for the tbsp (T) in Cell B27.

3. Sort your Ingredient data by Measurement Unit and then by ingredient name.

4. Convert the Cost per Unit into pounds in the Conversion column. Note: 1 lb = 60.50 tbspand 1 lb = 2 cups

5. Calculate the cost of the total lbs on hand for each ingredient in the Cost column and add the ROUND function. Example: =ROUND(SUM(F3:F22),0)

6. Use the AutoSum function to total up the Costs of ingredients.

7. Calculate the, mean, median, and standard deviation for the Costs using the Excel Formulas. Place the calculations in Cells F24, F25, and F26.

8. Create a Pie chart of the costs for your ingredient inventory. HINT: Copy the entire table to the sheet entitled "Costs Chart", and hide all columns except for the Ingredient and Cost columns. To do this, select Columns B, C, D, and E. Right click and choose "Hide". Create you're a 3D pie chart using these two columns. Enlarge the chart to see all ingredients. Using the Chart Layouts, add a title and include names and percentages on the chart.

9. Select the table with the exception of the title. (A2 through F23) Go to the "Home" tab and use "Format as Table" to choose and apply a style to your table. Investigate the arrows on the column headings to see what filters can do.

10. Save your file as "W2 Bakery Your Initials" and submit.

Attachment:- Spreadsheet functions.rar