Question 1

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)> <New Data Source> 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.

Accepted Answer

The given steps are correct and will allow Rachel to use Microsoft Query to retrieve data from her corporate databases and files.

Question 2

Which of the following scene effects move in a repetitive circular motion?
A) Figure 8
B) Dolly
C) Rotate Globe
D) Push In

Accepted Answer

A

Question 3

Which of the following will you click on in the Workbook Queries pane to check the "Add the data to the Data Model" box while adding a query to a Data Model?
A) Load To…
B) Duplicate
C) Reference
D) Move to Group

Accepted Answer

The "Load To…" option allows you to specify how you want to load the query results into the Excel workbook. By selecting this option, you will see a window where you can check the "Add the data to the Data Model" box, allowing you to load the query results directly into the Data Model.

Question 4

Avery wants to transform data from data sources in order to analyze it.To do this,she can click Data > Get Data > Navigator window > Select table (or tables)to use in the query > Edit > OK.

Accepted Answer

The correct sequence is to click Data > Get Data > Navigator window > Select table (or tables) to use in the query > Load or Transform Data, not Edit > OK.

Question 5

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.

Accepted Answer

Get & Transform (Power Query) feature in Excel allows the creation of dynamic connections to data sources such as Excel tables, which can be easily refreshed to reflect any changes made to the data source.

Question 6

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?
A) X-Consolidate,Y-Consolidate
B) X-What-If Analysis,Y-Goal Seek
C) X-What-If Analysis,Y-Scenario Manager
D) X-Data Validation,Y-Data Validation

Accepted Answer

The X in the series should be "What-If Analysis" and the Y should be "Scenario Manager" as they are the options needed to select and create a scenario PivotTable report. Option A and D do not have any relevance to creating a scenario PivotTable report. Option B has "What-If Analysis" as X but "Goal Seek" as Y, which is not applicable to creating a scenario PivotTable report.

Question 7

What is the default value (in seconds)for a transition between scenes in a tour?
A) 1
B) 3
C) 10
D) 12

Accepted Answer

The default value for a transition between scenes in a tour is 3 seconds. This gives enough time for viewers to fully appreciate the scene before moving onto the next one, without making the tour feel slow or dragging on for too long.

Question 8

How can you rename a column in Excel?
A) Double-click on the column in the Query Editor and enter a new name.
B) Right-click on the column in the Query Editor and enter a new name.
C) Left-click on the column in the Query Editor and enter a new name.
D) Right-click on the column in the Query Editor,select Edit enter a new name.

Accepted Answer

The answer of How can you rename a column in...

Question 9

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.

Accepted Answer

By selecting the columns with errors and choosing Remove Errors option, Chris can remove the rows with errors in a query.

Question 10

In which of the following groups on the Database Tools tab will you click Relationships while creating a relationship between two queries?
A) Macro
B) Analyze
C) Move Data
D) Relationships

Accepted Answer

The Relationships group on the Database Tools tab contains the tools for creating and managing table relationships in Access. Therefore, you would click on Relationships to create a relationship between two queries.

Question 11

Which of these will you click select as X in this series of clicks/entries/selections to edit relationships between Pivot tables: Power Pivot window > Design tab > Manage Relationships command > Manage Relationships dialog box > Relationship > Edit > X > Use the drop-down and list box controls on this form to select the appropriate table and field names?
A) Warning Dialog box
B) Format Cells dialog box
C) Create Relationship Dialog box
D) Edit Relationship Dialog box

Accepted Answer

The prompt mentions "edit" and the options include a "Edit Relationship Dialog box." Therefore, the best choice would be D.

Question 12

To create a forecast sheet,enter two data series corresponding to each other in a worksheet,select both the data series,then click on the following: Data tab > Forecast group > Forecast Sheet > Create Forecast Worksheet box > Select Line Chart or Column Chart > Pick an end date in Forecast End box > Create.

Accepted Answer

This is the correct process to create a forecast sheet in Excel.

Question 13

Willa wants to insert a 3-D Map to explore data.Which of the following options should she click in Custom Maps Options box to get the best fit?
A) AutoFit
B) Pixel Space
C) Swap the X and Y axis
D) Lock current coordinate values

Accepted Answer

AutoFit will automatically adjust the size and position of the 3-D map to fit well within the space allotted on the slide, ensuring the best fit.

Question 14

Vasalicki wants to create a query linked to a table.In which row should she enter field criteria in the query design grid?
A) Criteria row
B) Show row
C) Field row
D) Sort row

Accepted Answer

The criteria row in the query design grid is where field criteria should be entered. This allows the query to return specific data based on the criteria specified. The show row is used to select which fields should be displayed in the query results, the field row is used to select the table fields to include in the query, and the sort row is used to specify the order in which the query results should be sorted.

Question 15

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.

Accepted Answer

This is a correct method to remove columns in Query Editor.

Question 16

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?
A) Tours group
B) Scene group
C) Tables group
D) Sparklines group

Accepted Answer

The correct option is A) Tours group. In Excel, to create a 3-D map scene in a tour, you would navigate through the Insert tab, then to the Tours group, where you can find the option for 3D Maps to open and create your 3D map scene.

Question 17

Edward wants to edit a relationship between two tables.To do this,he places the cursor pointing to the relationship line and then clicks the line to select it.Then,he clicks on tab "X" > Group "Y" > Edit Relationships.What are X and Y in the procedure?
A) A-Design tab,B-Tools group
B) A-Developer tab,B-Code group
C) A-Format tab,B-Arrange group
D) A-Design tab,B-Relationships group

Accepted Answer

DIn database management systems like Microsoft Access, editing a relationship between two tables is typically done under the "Design" tab, within the "Relationships" group. This is where users can manage and modify how tables relate to each other.

Question 18

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) Power Pivot
D) Developer

Accepted Answer

The Table Name field in the Properties group can be changed in the Design tab while adding a table to an internal Data Model. The Inquire tab is used for analyzing and understanding the data, the Power Pivot tab is used for advanced data modeling and calculations, and the Developer tab is used for creating and editing macros and VBA code.

Question 19

Which of the following panes in the Power Map window contains a 3-D globe on which the data is mapped?
A) Layer Pane
B) Editor Pane
C) Center Pane
D) Tour Editor Pane

Accepted Answer

The Center Pane is where the 3-D globe can be found in the Power Map window. The Layer Pane is where data layers and visuals can be added, the Editor Pane allows for customization of specific data points, and the Tour Editor Pane is for creating guided tours of the map.

Question 20

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

This is the correct method to open the Manage Relationships dialog box in a Power View report.

Quiz 10: Analyzing Data With Business Intelligence Tools

Which of the following scene effects move in a repetitive circular motion?

Which of the following will you click on in the Workbook Queries pane to check the "Add the data to the Data Model" box while adding a query to a Data Model?

Avery wants to transform data from data sources in order to analyze it.To do this,she can click Data > Get Data > Navigator window > Select table (or tables)to use in the query > Edit > OK.

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.

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?

What is the default value (in seconds) for a transition between scenes in a tour?

How can you rename a column in Excel?

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.

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

Willa wants to insert a 3-D Map to explore data.Which of the following options should she click in Custom Maps Options box to get the best fit?

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

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.

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?

Edward wants to edit a relationship between two tables.To do this,he places the cursor pointing to the relationship line and then clicks the line to select it.Then,he clicks on tab "X" > Group "Y" > Edit Relationships.What are X and Y in the procedure?

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?

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

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.