(Solved): WPC 300 : Lab 2: Advanced Excel Jan updates...

Lab 2: Advanced Excel

Quiz Instructions

• Start with datafile: Sample-Superstore.xlsx
• Review what we did in the lab.
• Answer the following multiple-choice questions. 
• Note: When you are asked to submit a screen capture, you need to make sure that your name is part of the capture.

Question 1 2 pts

How many records (rows) are there in the “Corporate” segment? 

Group of answer choices

• 5191
• 3020
• 1783
• 1593

Question 2 2 pts

Submit a screenshot of a pie-chart that demonstrates the total sales per segment.

Upload 

Choose a File

Question 32 pts

How many records (rows) are there in the “Home Office” segment that belong to central region of the market?

Group of answer choices

• 673
• 438
• 272
• 1212

Question 4 2 pts

What is the total sale from customers in the Western region that bought product in ‘Furniture’ category?

Group of answer choices

• $208291
• $163797
• $117299
• $252613

Question 5 2 pts

Provide a screenshot of a bar chart of Sales in different regions by market segment.

Upload 

Choose a File

Question 6 2 pts

What is the total 4^th quarter profit in the year 2013?

Group of answer choices

• $38042
• $21724
• $23309
• $27449

Question 7 2 pts

Show a visual display (bar chart) of total quantity sold, total sales and total profit for different subcategories of products sold by the store. Submit a screenshot.

Upload 

Choose a File

Question 82 pts

Which of the following subcategories of products experienced the largest total loss?

Group of answer choices

• Bookcases
• Paper
• Tables
• Supplies

Question 9 2 pts

Which State experienced the largest profit for products in the ‘Technology’ category.   

Group of answer choices

• California
• Texas
• New York
• Washington

Question 10 2 pts

Create two slicers to filter data by regions and categories. Show how the sum of sales and sum profit change in an individual year using these filters. Upload your Excel file that demonstrates this feature in pivot table.

Upload 

Choose a File