(Solved): wpc 300 Assignment 2: Advanced Excel for FoodEmporium score 100%...

Assignment 2: Advanced Excel

Quiz Instructions

• Read the Assignment Instructions: Assign2_Instruc_FoodEmporium.pdf

Question 1    2.5 pts

What are the five worst selling products based on quantity sold?

Group of answer choices

• Alice Mutton, Aniseed Syrup, Boston Crab Meat, Camembert Pierrot, Carnarvon Tigers
• Zaanse koeken, Wimmers gute Semmelknödel, Vegie-spread, Valkoinen suklaa, Uncle Bob's Organic Dried Pears
• Mishi Kobe Niku, Genen Shouyu, Gravad lax, Chocolade, Laughing Lumberjack Lager
• Camembert Pierrot, Raclette Courdavault, Gorgonzola Telino, Gnocchi di nonna Alice, Pavlova,

Question 2        2.5 pts

Which order ID has the largest order total (extended price)

Group of answer choices

• 10865
• 10691
• None of the answers are correct
• 16388

 Question 3        2.5 pts

Provide a screenshot showing the total of extended price by month.

Upload 

 Question 4        2.5 pts

Which month had the largest count of records (rows)?

Group of answer choices

• June
• December
• November
• July

 Question 5        2.5 pts

What are the five most heavily discounted products when compared using "Sum of Total Discount"?

Group of answer choices

• Camembert Pierrot, Gorgonzola Telino, Gnocchi di nonna Alice, Chai
• Côte de Blaye, Thüringer Rostbratwurst, Raclette Courdavault, Camembert Pierrot, Manjimup Dried Apples
• Alice Mutton, Aniseed Syrup, Boston Crab Meat, Camembert Pierrot, Carnarvon Tigers
• None of the answer selections are correct

 Question 6        2.5 pts

Who are our five best customers based on total sales (i.e., Extended Price)?

Group of answer choices                                                                              

• Allan Laubach, Allan Lorentzen, Allan Strate, Alton Nicolay, Alton Wareing
• None of the answer selections are correct
• Cathrine Ecton, Shayla Mcbath, Ellie Sittig, Kurt Bissonette, Alvina Bollig
• Neva Burgoyne, Shayla Mcbath, Preston Mczeal, Malcolm Potthoff, Clinton Goewey

Question 7        2.5 pts

What are the 5 most popular (quantity sold) products among our five best customers? (HINT: Apply a filter to include only the five best customers as obtained from previous question)

Group of answer choices

• Gnocchi di nonna Alice, Côte de Blaye, Chartreuse verte, Guaraná Fantástica, Camembert Pierrot
• Gnocchi di nonna Alice, Côte de Blaye, Tofu, Chia, Filo Mix
• Gnocchi di nonna Alice, Côte de Blaye, Chartreuse verte, Perth Pasties, Alice Mutton
• Guaraná Fantástica, Camembert Pierrot, Chang, Konbu, Chai

Question 8        2.5 pts

Create a pie chart to demonstrate the average of "Discount (%)" enjoyed by each customer status. Submit a screenshot. 

Upload 

Question 9        2.5 pts

Use a column chart to show the total sales (by extended price) for each State (Customer State) from the highest to the lowest.  Submit a screenshot.

Upload 

Question 10      2.5 pts

Upload the excel file with all the sheets that you created to answer the above questions. Don't forget to add your name to the filename.

Upload