11)For a presentation, you want to sort customer orders for the quarter from largest to smallest, and also highlight orders that are larger than the average order amount. How will you accomplish it?

Select an answer:

• After sorting, use the Below Average conditional formatting rule to delete orders below average.
• After sorting, use the Above Average conditional formatting rule and select a highlighting color.
• After sorting, use the Top 10% conditional formatting rule and select a highlighting color.

2)You are using PowerPoint to create tutorial on navigating through a dashboard. Why would you apply a shape and highlighting to one part of a visual?

Select an answer:

• so the user's attention is drawn to certain areas you want to focus on
• so the user does not accidentally navigate to the dashboard in Power BI
• so you can hide information you do not want the user to see

3)What is considered the "magic" of pivots?

Select an answer:

• You can determine what the X column and the Y row headings are.
• The X columns and Y rows are predetermined so you cannot make a mistake.
• You can determine what the Y row headings are, and Excel provides the X column headings.

4)Question 24 of 30:

What is one benefit of pivot tables when it comes to exploring inside your data?

Select an answer:

• Pivot tools quickly fix errors in the underlying data.
• Pivot tools do not change the underlying data.
• Pivot tools do not require creating tables of data.

5)You are reviewing customers by yearly purchase amount over the last three years. Why would you add sparklines to your pivot table?

Select an answer:

• Sparklines "spark," as a bold highlight, at the highest level of customer purchases.
• Sparklines show you trends over the three years of customers' purchases.
• Sparklines, and no another visualization, can show percentage changes.

6)2020 sales for Product A are piquing your curiosity. How can pivots enable you to gain more insight into the data?

Select an answer:

• Pivots let you filter your data to display just the data you want.
• Pivots let you drill-down into the underlying data.
• Your data continually refreshes while you are working with pivots.

7)You set up a pivot table for sales by product over the last three years and add an easy-to-read, 100% stacked bar chart. Why would you also include an Order Date slicer?

Select an answer:

• so users can look at particular months that interest them
• so users can perform mathematical calculations in the data
• so users can filter out any products that do not interest them

8)Where is noise found?

Select an answer:

• in a data set
• in queries
• in pieces of data

9)If you are building a dashboard for sales management, how will artifacts be involved?

Select an answer:

• They are the filters you place on the data that will then display on the dashboard.
• They are the important visuals you will place on the dashboard.
• They are the data tables you will place on the dashboard.

10)When you are building a dashboard, why should you do the intricate sizing and formatting at the very end of the process?

Select an answer:

• Sizing and formatting are the most important aspects of building a dashboard.
• The display you select, such as smartphone, will differ from tablet or laptop displays.
• Objects will shift a lot during the process of setting up a dashboard.