5)

How can you use PowerPoint to make your presentations even more powerful?

Select an answer:

• You can create a step-by-step tutorial for users to explore the data on their own.

• You can present the data and visuals at a pace comfortable for your audience.

• You can display more visuals on a screen than you can with just your dashboard on Power BI.

6)

Your company decides to share dashboards with contracted salespeople via SharePoint. What must your company first determine before making this move?

Select an answer:

• whether all the contractors have the appropriate license

• how frequently the dashboards will be shared

• what permission level the contractors will have

7)

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 do this?

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.

8)

You are using PowerPoint to create a 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

9)

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.

10)

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.