excel

sushil7
Module_2_Microsoft_Excel_Practice2.zip
Home>Computer Science homework help>excel

Microsoft Excel Practice Exercise_Working With Data.docx

MICROSOFT EXCEL PRACTICE EXERCISE: WORKING WITH DATA

 

Use the Raw Concessions.xls workbook provided to complete the following tasks:

1. Create a column in the Basketball Game Sales worksheet that calculates the Actual Profit for each item by multiplying price by profit percentage.

2. Use the AVERAGE function to find the average sales price.

3. Create a chart to visualize calories by item.

4. Use the VLOOKUP to add Calories to the Basketball Game Sales worksheet.

5. Create a Pivot Table in another worksheet and find the total revenue by item.

6. Create a filter for the table so you can view total revenue by item for each category.

Microsoft Excel Practice Exercise_Working_with_Data_Raw Concessions Workbook.xlsx

Basketball Game Sales

Item Category Price Profit
Beer Beverages $ 4.00 50%
Hamburger Hot Food $ 3.00 67%
Popcorn Hot Food $ 5.00 80%
Pizza Hot Food $ 2.00 25%
Bottled Water Beverages $ 3.00 83%
Hot Dog Hot Food $ 1.50 67%
Chocolate Dipped Cone Frozen Treats $ 3.00 50%
Soda Beverages $ 2.50 80%
Chocolate Bar Candy $ 2.00 75%
Hamburger Hot Food $ 3.00 67%
Beer Beverages $ 4.00 50%
Hot Dog Hot Food $ 1.50 67%
Licorice Rope Candy $ 2.00 50%
Chocolate Dipped Cone Frozen Treats $ 3.00 50%
Nachos Hot Food $ 3.00 50%
Pizza Hot Food $ 2.00 25%
Beer Beverages $ 4.00 50%
Soda Beverages $ 2.50 80%
Beer Beverages $ 4.00 50%
Hamburger Hot Food $ 3.00 67%
Gummy Bears Candy $ 2.00 50%
Popcorn Hot Food $ 5.00 80%
Hamburger Hot Food $ 3.00 67%
Nachos Hot Food $ 3.00 50%
Nachos Hot Food $ 3.00 50%
Chocolate Dipped Cone Frozen Treats $ 3.00 50%
Chocolate Bar Candy $ 2.00 75%
Hamburger Hot Food $ 3.00 67%
Beer Beverages $ 4.00 50%
Chocolate Dipped Cone Frozen Treats $ 3.00 50%
Soda Beverages $ 2.50 80%
Gummy Bears Candy $ 2.00 50%
Chocolate Dipped Cone Frozen Treats $ 3.00 50%
Licorice Rope Candy $ 2.00 50%
Nachos Hot Food $ 3.00 50%
Bottled Water Beverages $ 3.00 83%
Bottled Water Beverages $ 3.00 83%
Popcorn Hot Food $ 5.00 80%
Chocolate Bar Candy $ 2.00 75%
Chocolate Dipped Cone Frozen Treats $ 3.00 50%
Licorice Rope Candy $ 2.00 50%
Beer Beverages $ 4.00 50%
Hot Dog Hot Food $ 1.50 67%
Chocolate Bar Candy $ 2.00 75%
Pizza Hot Food $ 2.00 25%
Hamburger Hot Food $ 3.00 67%
Chocolate Dipped Cone Frozen Treats $ 3.00 50%
Licorice Rope Candy $ 2.00 50%
Nachos Hot Food $ 3.00 50%
Popcorn Hot Food $ 5.00 80%
Chocolate Bar Candy $ 2.00 75%
Hot Dog Hot Food $ 1.50 67%
Popcorn Hot Food $ 5.00 80%
Beer Beverages $ 4.00 50%
Chocolate Dipped Cone Frozen Treats $ 3.00 50%
Gummy Bears Candy $ 2.00 50%
Licorice Rope Candy $ 2.00 50%
Beer Beverages $ 4.00 50%
Licorice Rope Candy $ 2.00 50%
Beer Beverages $ 4.00 50%
Soda Beverages $ 2.50 80%
Hot Dog Hot Food $ 1.50 67%
Pizza Hot Food $ 2.00 25%
Soda Beverages $ 2.50 80%
Gummy Bears Candy $ 2.00 50%
Chocolate Dipped Cone Frozen Treats $ 3.00 50%
Soda Beverages $ 2.50 80%
Chocolate Bar Candy $ 2.00 75%
Beer Beverages $ 4.00 50%
Chocolate Dipped Cone Frozen Treats $ 3.00 50%
Beer Beverages $ 4.00 50%
Nachos Hot Food $ 3.00 50%
Nachos Hot Food $ 3.00 50%
Nachos Hot Food $ 3.00 50%
Gummy Bears Candy $ 2.00 50%
Hot Dog Hot Food $ 1.50 67%
Pizza Hot Food $ 2.00 25%
Bottled Water Beverages $ 3.00 83%
Hamburger Hot Food $ 3.00 67%
Chocolate Dipped Cone Frozen Treats $ 3.00 50%
Popcorn Hot Food $ 5.00 80%
Hot Dog Hot Food $ 1.50 67%
Ice Cream Sandwich Frozen Treats $ 3.00 67%
Chocolate Bar Candy $ 2.00 75%
Licorice Rope Candy $ 2.00 50%
Beer Beverages $ 4.00 50%
Hot Dog Hot Food $ 1.50 67%
Ice Cream Sandwich Frozen Treats $ 3.00 67%
Hot Dog Hot Food $ 1.50 67%
Ice Cream Sandwich Frozen Treats $ 3.00 67%
Soda Beverages $ 2.50 80%
Chocolate Bar Candy $ 2.00 75%
Gummy Bears Candy $ 2.00 50%
Pizza Hot Food $ 2.00 25%
Hot Dog Hot Food $ 1.50 67%
Gummy Bears Candy $ 2.00 50%
Ice Cream Sandwich Frozen Treats $ 3.00 67%
Licorice Rope Candy $ 2.00 50%
Beer Beverages $ 4.00 50%
Hamburger Hot Food $ 3.00 67%
Beer Beverages $ 4.00 50%
Ice Cream Sandwich Frozen Treats $ 3.00 67%
Gummy Bears Candy $ 2.00 50%
Hamburger Hot Food $ 3.00 67%
Licorice Rope Candy $ 2.00 50%
Hamburger Hot Food $ 3.00 67%
Soda Beverages $ 2.50 80%
Bottled Water Beverages $ 3.00 83%
Hamburger Hot Food $ 3.00 67%
Ice Cream Sandwich Frozen Treats $ 3.00 67%
Gummy Bears Candy $ 2.00 50%
Bottled Water Beverages $ 3.00 83%
Hot Dog Hot Food $ 1.50 67%
Soda Beverages $ 2.50 80%
Pizza Hot Food $ 2.00 25%
Popcorn Hot Food $ 5.00 80%
Popcorn Hot Food $ 5.00 80%
Ice Cream Sandwich Frozen Treats $ 3.00 67%
Popcorn Hot Food $ 5.00 80%
Bottled Water Beverages $ 3.00 83%
Licorice Rope Candy $ 2.00 50%
Bottled Water Beverages $ 3.00 83%
Ice Cream Sandwich Frozen Treats $ 3.00 67%
Pizza Hot Food $ 2.00 25%
Pizza Hot Food $ 2.00 25%
Ice Cream Sandwich Frozen Treats $ 3.00 67%
Pizza Hot Food $ 2.00 25%
Gummy Bears Candy $ 2.00 50%
Chocolate Bar Candy $ 2.00 75%
Beer Beverages $ 4.00 50%
Ice Cream Sandwich Frozen Treats $ 3.00 67%
Nachos Hot Food $ 3.00 50%
Bottled Water Beverages $ 3.00 83%
Beer Beverages $ 4.00 50%
Hamburger Hot Food $ 3.00 67%
Chocolate Bar Candy $ 2.00 75%
Popcorn Hot Food $ 5.00 80%
Hamburger Hot Food $ 3.00 67%
Soda Beverages $ 2.50 80%
Pizza Hot Food $ 2.00 25%
Hot Dog Hot Food $ 1.50 67%
Hot Dog Hot Food $ 1.50 67%
Nachos Hot Food $ 3.00 50%
Hamburger Hot Food $ 3.00 67%
Nachos Hot Food $ 3.00 50%
Hamburger Hot Food $ 3.00 67%
Hot Dog Hot Food $ 1.50 67%
Nachos Hot Food $ 3.00 50%
Popsicle Frozen Treats $ 3.00 83%
Popcorn Hot Food $ 5.00 80%
Popcorn Hot Food $ 5.00 80%
Bottled Water Beverages $ 3.00 83%
Hamburger Hot Food $ 3.00 67%
Pizza Hot Food $ 2.00 25%
Popsicle Frozen Treats $ 3.00 83%
Pizza Hot Food $ 2.00 25%
Popcorn Hot Food $ 5.00 80%
Soda Beverages $ 2.50 80%
Nachos Hot Food $ 3.00 50%
Gummy Bears Candy $ 2.00 50%
Nachos Hot Food $ 3.00 50%
Licorice Rope Candy $ 2.00 50%
Popsicle Frozen Treats $ 3.00 83%
Popcorn Hot Food $ 5.00 80%
Popsicle Frozen Treats $ 3.00 83%
Soda Beverages $ 2.50 80%
Chocolate Bar Candy $ 2.00 75%
Popsicle Frozen Treats $ 3.00 83%
Gummy Bears Candy $ 2.00 50%
Chocolate Bar Candy $ 2.00 75%
Nachos Hot Food $ 3.00 50%
Licorice Rope Candy $ 2.00 50%
Beer Beverages $ 4.00 50%
Popsicle Frozen Treats $ 3.00 83%
Popsicle Frozen Treats $ 3.00 83%
Popsicle Frozen Treats $ 3.00 83%
Beer Beverages $ 4.00 50%
Popsicle Frozen Treats $ 3.00 83%
Gummy Bears Candy $ 2.00 50%
Pizza Hot Food $ 2.00 25%
Beer Beverages $ 4.00 50%
Popcorn Hot Food $ 5.00 80%
Popsicle Frozen Treats $ 3.00 83%
Hot Dog Hot Food $ 1.50 67%
Soda Beverages $ 2.50 80%
Licorice Rope Candy $ 2.00 50%
Bottled Water Beverages $ 3.00 83%
Pizza Hot Food $ 2.00 25%
Popsicle Frozen Treats $ 3.00 83%
Gummy Bears Candy $ 2.00 50%
Pizza Hot Food $ 2.00 25%
Bottled Water Beverages $ 3.00 83%
Popcorn Hot Food $ 5.00 80%
Beer Beverages $ 4.00 50%
Pizza Hot Food $ 2.00 25%
Popsicle Frozen Treats $ 3.00 83%
Chocolate Bar Candy $ 2.00 75%
Bottled Water Beverages $ 3.00 83%
Popsicle Frozen Treats $ 3.00 83%

Calories

Item Calories
Beer 200
Bottled Water 0
Chocolate Bar 255
Chocolate Dipped Cone 300
Gummy Bears 300
Hamburger 320
Hot Dog 265
Ice Cream Sandwich 240
Licorice Rope 280
Nachos 560
Pizza 480
Popcorn 500
Popsicle 150
Soda 120

Fee Schedule

Item Beer Bottled Water Chocolate Bar Chocolate Dipped Cone Gummy Bears Hamburger Hot Dog Ice Cream Sandwich Licorice Rope Nachos Pizza Popcorn Popsicle Soda
Percent 15% 5% 15% 15% 15% 5% 5% 15% 15% 5% 5% 5% 15% 15%

Calories-Solver

Item Calories
Beer 200
Bottled Water 0
Chocolate Bar 255
Chocolate Dipped Cone 300
Gummy Bears 300
Hamburger 320
Hot Dog 265
Ice Cream Sandwich 240
Licorice Rope 280
Nachos 560
Pizza 480
Popcorn 500
Popsicle 150
Soda 120
Total Items:
Total Calories: