Have a Question ?

Home / Answered Questions / WPC 300 / wpc-300-lab-2-advanced-excel-score-100-q-932

(Solved): WPC 300 Lab 2: Advanced Excel score 100%...


Lab 2: Advanced Excel

Quiz Instructions

  • Datafile: Sample-Superstore.xlsx

  •  
  • 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 East 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 4th quarter profit in the year 2016?

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

 



We have an Answer from Expert View Expert Answer

Expert Answer


We have an Answer from Expert
Buy This Answer $15

-- OR --

Subscribe To View Unlimited Answers
Subscribe $12 / Month