Which of the following panes in the Power Map window contains a 3-D globe on which the data is mapped?
a. Center Pane
b. Tour Editor Pane
c. Layer Pane
d. Editor Pane

Chris wants to remove the rows with data errors in a query. To do so, he can right-click on the selected columns from where he wants to remove the rows containing the errors and select Remove Errors.

True
False

Rachel wants to use Microsoft Query to retrieve data from her corporate databases and files so that she doesn't have to retype the data that she wants to analyze in Excel. To do so, she can click and/or enter the following information in the following series of clicks: Data tab > Get External Data group > From Other Sources > From Microsoft Query > Databases tab (To specify a data source for a database, text file, or Excel workbook) > OK > Create New Data Source dialog box > Type a name to identify the data source > Click a driver for the type of database for use as data source > Connect (Provide the information needed to connect to the data source) > OK.
True
False

One can use Get & Transform (Power Query) feature of Excel to create a dynamic connection to an existing Excel table and refresh the connection when the data in table changes.

True
False

To create a relationship between two tables, the first step would be to click on Relationships in the Relationships group on the Database Tools tab.

True
False

How can you rename a column in Excel?
a. Left-click on the column in the Query Editor and enter a new name.
b. Right-click on the column in the Query Editor, select Edit enter a new name.
c. Double-click on the column in the Query Editor and enter a new name.
d. Right-click on the column in the Query Editor and enter a new name.

Which of the following can X be in the series of clicks to create a scenario PivotTable report: Data tab > Data Tools > X > Y > Summary button > Scenario Summary dialog box > Report type > Scenario PivotTable report > Enter cell name in Results cells box > OK?

Vasalicki wants to create a query linked to a table. In which row should she enter field criteria in the query design grid?

a. Show row
b. Field row
c. Criteria row
d. Sort row

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?

a. Inquire
b. Design
c. Developer
d. Power Pivot

Derek wants to remove columns from Query he doesn't need. To do so, he can select the columns he wants to remove with Ctrl+Click. Then he can select Remove Columns > Remove Columns in the Query Editor ribbon.

True
False