Learning Data Analytics: Extending & Applying
Core Knowledge- Questions and Answers
You used the Steps Recorder in Windows to document the steps in changing a sort order. When
colleagues use your recording, what will they see? a series of screenshots with each
screenshot showing a step you took
How can you use PowerPoint to make your presentations even more powerful? You can
create a step-by-step tutorial for users to explore the data on their own
Your company decides to share dashboards with contracted salespeople via SharePoint. What
must your company first determine before making this move? whether all the contractors
have the appropriate license
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?
After sorting, use the Above Average conditional formatting rule and select a highlighting
color.
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? so the user's attention is drawn to
certain areas you want to focus on
What is considered the "magic" of pivots? You can determine what the X column and the
Y row headings are.
, What is one benefit of pivot tables when it comes to exploring inside your data? Pivot
tools do not change the underlying data.
You are reviewing customers by yearly purchase amount over the last three years. Why would
you add sparklines to your pivot table? Sparklines show you trends over the three years of
customers' purchases.
2020 sales for Product A are piquing your curiosity. How can pivots enable you to gain more
insight into the data? Pivots let you drill-down into the underlying data.
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? so users can
look at particular months that interest them
Where is noise found? in a data set
If you are building a dashboard for sales management, how will artifacts be involved?
They are the important visuals you will place on the dashboard.
When you are building a dashboard, why should you do the intricate sizing and formatting at the
very end of the process? Objects will shift a lot during the process of setting up a
dashboard.
Core Knowledge- Questions and Answers
You used the Steps Recorder in Windows to document the steps in changing a sort order. When
colleagues use your recording, what will they see? a series of screenshots with each
screenshot showing a step you took
How can you use PowerPoint to make your presentations even more powerful? You can
create a step-by-step tutorial for users to explore the data on their own
Your company decides to share dashboards with contracted salespeople via SharePoint. What
must your company first determine before making this move? whether all the contractors
have the appropriate license
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?
After sorting, use the Above Average conditional formatting rule and select a highlighting
color.
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? so the user's attention is drawn to
certain areas you want to focus on
What is considered the "magic" of pivots? You can determine what the X column and the
Y row headings are.
, What is one benefit of pivot tables when it comes to exploring inside your data? Pivot
tools do not change the underlying data.
You are reviewing customers by yearly purchase amount over the last three years. Why would
you add sparklines to your pivot table? Sparklines show you trends over the three years of
customers' purchases.
2020 sales for Product A are piquing your curiosity. How can pivots enable you to gain more
insight into the data? Pivots let you drill-down into the underlying data.
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? so users can
look at particular months that interest them
Where is noise found? in a data set
If you are building a dashboard for sales management, how will artifacts be involved?
They are the important visuals you will place on the dashboard.
When you are building a dashboard, why should you do the intricate sizing and formatting at the
very end of the process? Objects will shift a lot during the process of setting up a
dashboard.
