1)You build a line total based on the Order Details table of OrderID, UnitPrice, and Qty. If you add your Customer List table, can you run a query for the top 50 customer orders?

Select an answer:

• Yes, because OrderID bridges the join line gap.
• No, because there is no join line between the two tables.
• Yes, if the two tables cover the same time period.

2)After you append data for missing orders to your invoices table, you notice 136 orders that were not invoiced. What is the most likely reason?

Select an answer:

• They are recent orders that have not yet been invoiced.
• You did not construct your Append query properly.
• The invoice data in your database is incomplete.

3)Why is it often beneficial to unpivot data?

Select an answer:

• to create new pivot tables
• to have easy-to-read data visualizations
• to reduce the amount of space a visual requires

4)You applied conditional formatting to Customer Order by Amount. After you did this, a colleague changed the sort to Alphabetical. What will happen?

Select an answer:

• Your conditional formatting will not be affected.
• Your conditional formatting will disappear.
• Your conditional formatting will need to be refreshed.

5)You suspect fewer customers are sending purchase orders to your company, although the dollar amount of the POs you receive has not changed. Which chart type can best visualize your hunch?

Select an answer:

• a line/pie combo chart
• a pie chart with distinct colors for each slice
• a clustered column/line combo chart

6)What is an example of an ad hoc report?

Select an answer:

• a request from Sales for how many customer purchase orders are in the system
• a request from Accounting for the number of customer orders that have not been invoiced
• a request from Marketing for the top-selling products by dollar amount

7)You are going to present year-end sales information in a company-wide meeting. What must you consider when deciding how to present the data?

Select an answer:

• Your audience likely knows the data as well as you do, so keep your presentation formal.
• You are there to present financial data, so limit your presentation to numbers.
• You know the data better than your audience, so present to the level of their understanding.

8)You are working with ABC Corp. on its data analytics. The company asks you to compile a ranking of its top-performing products over the past five years. What two questions must you ask?

Select an answer:

• "Where is the data on all products?" and "How should price changes over the year be considered?"
• "Where is the data on all products?" and "What is your definition of top-performing?"
• "Where is the data on all products?" and "What should be done about orders where products were returned?"

9)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?

Select an answer:

• a video playback file showing each of the steps you took
• a Word document explaining each of the steps you took
• a series of screenshots with each screenshot showing a step you took

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

Select an answer:

• You can create 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.