Question 1

In which of the following tabs will you change the Table Name field in the Properties group while adding a table to a internal Data Model?

Accepted Answer

A)  Inquire 
B)  Design 
C)  Power Pivot 
D)  Developer 
A)  Inquire 
B)  Design 
C)  Power Pivot 
D)  Developer

Question 2

To open the Manage Relationships dialog box in a Power View report,click the Design tab in the Power Pivot window,then click Manage Relationships in the Relationships group.

Accepted Answer

A) True 
 B)False

Question 3

Finley wants to create a 3-D map scene in a tour.To do this,she selects a range of cells containing her data in an Excel table.She then clicks on Insert tab > X > 3D Maps > Open 3D Maps.What is X in the procedure?

Accepted Answer

A)  Tours group 
B)  Scene group 
C)  Tables group 
D)  Sparklines group 
A)  Tours group 
B)  Scene group 
C)  Tables group 
D)  Sparklines group

Question 4

Which of the following panes in the Power Map window contains a 3-D globe on which the data is mapped?

Accepted Answer

A)  Layer Pane 
B)  Editor Pane 
C)  Center Pane 
D)  Tour Editor Pane 
A)  Layer Pane 
B)  Editor Pane 
C)  Center Pane 
D)  Tour Editor Pane

Question 5

In which of the following groups on the Database Tools tab will you click Relationships while creating a relationship between two queries?

Accepted Answer

A)  Macro 
B)  Analyze 
C)  Move Data 
D)  Relationships 
A)  Macro 
B)  Analyze 
C)  Move Data 
D)  Relationships

In which of the following tabs will you change the Table Name field in the Properties group while adding a table to a internal Data Model?

To open the Manage Relationships dialog box in a Power View report,click the Design tab in the Power Pivot window,then click Manage Relationships in the Relationships group.

Finley wants to create a 3-D map scene in a tour.To do this,she selects a range of cells containing her data in an Excel table.She then clicks on Insert tab > X > 3D Maps > Open 3D Maps.What is X in the procedure?

Which of the following panes in the Power Map window contains a 3-D globe on which the data is mapped?

In which of the following groups on the Database Tools tab will you click Relationships while creating a relationship between two queries?

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Exploring Pivottable Design

Developing an Excel Application

Customizing Your Workspace Text and Graphics.(Digital Only).

Introducing Power BI (Digital Only).

Collaborating with Your Team.(Digital Only).

Filters

Exam 10: Analyzing Data With Business Intelligence Tools

In which of the following tabs will you change the Table Name field in the Properties group while adding a table to a internal Data Model?

To open the Manage Relationships dialog box in a Power View report,click the Design tab in the Power Pivot window,then click Manage Relationships in the Relationships group.

Finley wants to create a 3-D map scene in a tour.To do this,she selects a range of cells containing her data in an Excel table.She then clicks on Insert tab > X > 3D Maps > Open 3D Maps.What is X in the procedure?

Which of the following panes in the Power Map window contains a 3-D globe on which the data is mapped?

In which of the following groups on the Database Tools tab will you click Relationships while creating a relationship between two queries?

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Exploring Pivottable Design

Developing an Excel Application

Customizing Your Workspace Text and Graphics.(Digital Only).

Introducing Power BI (Digital Only).

Collaborating with Your Team.(Digital Only).

Filters