Exam 10: Analyzing Data With Business Intelligence Tools

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?

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

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.

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.

Jacob wants to import a table from an Access database and put it into a workbook to organize it for a presentation.To do so,he opens a new workbook in Excel,clicks on the Data tab,then clicks on X under Get External Data.He then browses to the location of the database he wants to import and selects the table.He then selects the appearance of the data in the workbook,chooses the cell where he wants it to start,and finally clicks OK.What can X in the series of clicks be?

How can you rename a column in Excel?

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

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?

To create a video with High-definition video display,select 720p from the video quality settings.

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?

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.

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.

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?

To open the Power Pivot window,one should click Power Pivot > Manage.

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.

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.

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.

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 boxes under Home > Scene Options will you insert the name for the scene name of a tour?