Good Essays
566 Words
Grammar
Plagiarism
Writing
Score
Inventory Summary

Project Description:
In this Mastery project, you will edit a worksheet that summarizes the inventory status at the Petaluma production facility.
Instructions:
For the purpose of grading the project you are required to perform the following tasks: Step | Instructions | Points Possible | 1 | Start Excel. Open the downloaded Excel workbook named GO_e02_Grader_EOC.xlsx. | 0 | 2 | Rename the Sheet1 worksheet tab to Condiments and then display the Toppings worksheet. | 4 | 3 | On the Toppings worksheet, in cell B4, insert a function that will total the Quantity in Stock data (A15:A29). | 5 | 4 | On the Toppings worksheet, in cell B5, insert a function that will calculate the average retail price of the available toppings (D15:D29). | 5 | 5 | On the Toppings worksheet, in cell B6, insert a function that will calculate the median retail price of the available toppings (D15:D29). | 5 | 6 | On the Toppings worksheet, in cell B7, insert a function that will calculate the lowest retail price of the available toppings (D15:D29). | 5 | 7 | On the Toppings worksheet, in cell B8, insert a function that will calculate the highest retail price of the available toppings (D15:D29). | 5 | 8 | On the Toppings worksheet, in cell B10, insert a function that will count the total number of salsa products available. | 5 | 9 | On the Toppings worksheet, in cell G15, insert a function that will display the text Order if the value in the Quantity in Stock column is less than 50. Otherwise, the function will display the text OK. Copy the function in cell G15 to the range G16:G29. | 8 | 10 | On the Toppings worksheet, apply conditional formatting to the range G15:G29 so that cells containing the text Order are formatted as Bold Italic, with a font color of Aqua, Accent 1 (under Theme Colors). | 8 | 11 | On the Toppings worksheet, display orange data bars with a gradient fill in all cells in the range A15:A29. | 8 | 12 | On the Toppings

## You May Also Find These Documents Helpful

• Good Essays

3. Compare cost per square inch of pizza with customer-chosen toppings versus store established combinations of toppings.…

• 1753 Words
• 8 Pages
Good Essays
• Satisfactory Essays

1,008 revenue 1,008 meals at \$5.77-\$5,816.16 for total cost per meal 1,008 at \$3.971.44 for a total profit of \$5,816.16-\$3961.44=\$1854.72…

• 123 Words
• 1 Page
Satisfactory Essays
• Satisfactory Essays

For the purpose of grading the project you are required to perform the following tasks:…

• 639 Words
• 3 Pages
Satisfactory Essays
• Satisfactory Essays

(Table) Using the information in the table, assume the consumer has a weekly budget of \$2.50, the price of a root beer is \$0.50, and the price of a candy bar is \$1. If the consumer maximizes utility, total utility is:…

• 1278 Words
• 6 Pages
Satisfactory Essays
• Satisfactory Essays

| |* Illustrate on an Excel pie chart showing amounts and percentages for each slice. |…

• 648 Words
• 3 Pages
Satisfactory Essays
• Good Essays

A husband is having difficulties with his Microsoft® Excel® spreadsheet. He has been trying to track his monthly grocery spending to find the daily average he spends on food. The spreadsheet is organized by day, and for the days in which no groceries were purchased, he enters zero. He is seeking assistance to calculate the correct monthly…

• 918 Words
• 4 Pages
Good Essays
• Satisfactory Essays

A customer in a store is purchasing five items. Design a program that asks for the price of each item, and then displays the subtotal of the sale, the amount of sales tax, and the total. Assume the sales tax is 6 percent.…

• 320 Words
• 3 Pages
Satisfactory Essays
• Satisfactory Essays

Based on the menu prices you listed on your menu in Part Two of this assignment, identify the average check for each meal service in your menu program.…

• 512 Words
• 3 Pages
Satisfactory Essays
• Satisfactory Essays

For the purpose of grading the project you are required to perform the following tasks:…

• 829 Words
• 4 Pages
Satisfactory Essays
• Good Essays

5. In the Summary worksheet, in the range B5:F8, delete the existing values and insert formulas that add…

• 369 Words
• 2 Pages
Good Essays
• Satisfactory Essays

Billy 's Gut Busting Buffet - Billy is opening a new buffet restaurant and wants to use Excel to build a weekly budget forecast and estimate his profit. He has inputs and assumptions for revenue and expenses in the spreadsheet. Now he needs to set up his weekly budget forecast to show the profit he can expect based on the input he has provided. Research conducted has indicated that the number of customers Billy can expect in a week is directly tied to the price of an individual buffet meal (see "Buffet Price and associated number of customers" data in Inputs and Assumptions section of start file spreadsheet). All customers will be charged the same meal price, Billy must determine what price to charge for a meal (\$12, \$15, \$18).…

• 837 Words
• 3 Pages
Satisfactory Essays
• Good Essays

The program Pizza.java creates a class Pizza and defines methods to get and set variables in the class…

• 436 Words
• 2 Pages
Good Essays
• Satisfactory Essays

Sl.no 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 Sales 81 23 18 8 16 4 29 22 15 6 45 11 20 60 5 Boys 15 10 7 2 4 1 4 7 5 3 13 2 5 12 1 Adcosts 20 12 11 6 10 5 14 12 10 5 17 9 12 18 5 Outlets 35 10 14 9 11 6 15 16 18 8 20 10 15 30 6 Varieties 17 13 14 13 12 12 15 16 15 13 14 12 12 15 12 Competitor 4 4 3 3 4 5 2 3 4 2 2 3 3 4 5 Custmer 70 43 31 10 17 8 39 40 30 16 30 20 25 50 20…

• 454 Words
• 2 Pages
Satisfactory Essays
• Good Essays

W H AT I S A F R E Q U E N C Y P O LY G O N…

• 727 Words
• 11 Pages
Good Essays
• Satisfactory Essays

Dim sizepizza, crust, drinks, tops1, tops2, tops3, tops4, tops5, tops6, pricepizza, pricetops, pricedrink, totprice As Single…

• 511 Words
• 3 Pages
Satisfactory Essays