ExamGecko
Question list
Search
Search

List of questions

Search

Question 28 - Desktop Certified Associate discussion

Report
Export

Connect to the 'Global Superstore' data source and use the Orders table. Find out in which year the furniture sales were more than the average sales of that year?

A.
2012
Answers
A.
2012
B.
2013
Answers
B.
2013
C.
2014
Answers
C.
2014
D.
2015
Answers
D.
2015
Suggested answer: A

Explanation:

Drop Order Date to columns, Category to Rows, and Sales to Text.

Go to Analysis -> Totals -> Show Columns Grand Total

Update Total All Using to Average:

In the year 2012, the furniture sales were more than the average sales of that year.

asked 23/09/2024
Ahsan Ilyas
32 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first