ExamGecko
Question list
Search
Search

List of questions

Search

Question 19 - Desktop Certified Associate discussion

Report
Export

Connect to the 'Global Superstore' data source and use the Orders table. Create a view using Profit and Sales. Find out which sub-category is above the profit median but below the sales median value?

A.
Appliances
Answers
A.
Appliances
B.
Binders
Answers
B.
Binders
C.
Storage
Answers
C.
Storage
D.
Tables
Answers
D.
Tables
Suggested answer: B

Explanation:

Drop Sales to columns and profit to rows, and Sub-Category to details.

Add two reference lines, one on the sales axis:

Add similarly on profit axis as well.

Out of the following options, only the Binders sub-category is above the profit median but below the sales median value.

asked 23/09/2024
Shahir Kazmi
42 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first