Exam 10: Data Analysis With Power Tools and Creating Macros

Portia wants to create a calculated measure in Excel.To do this,she creates a PivotChart report using the data stored in an Analysis Services cube.Next,she clicks on a tab "A" and then in group "B," she chooses OLAP Tools > MDX Calculated Measure to open the New Calculated Measure dialog box.What can A and B be in the procedure?

(Multiple Choice)

4.9/5

(32)

Question 21

Which of the following series of clicks will you follow after clicking on a column to create a measure in the Power Pivot Window using AutoSum?

(Multiple Choice)

4.9/5

(34)

Question 22

Nathan wants to create multiple charts for a table Power View,beginning with a pie chart.What should he select as X in the series of clicks to do this: Design tab > X > Other Charts > Pie Chart?

(Multiple Choice)

4.9/5

(34)

Question 23

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

(True/False)

4.8/5

(40)

Question 24

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

(True/False)

4.8/5

(31)

Question 25

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)

4.8/5

(35)

Question 26

To update the data associated with external links,close all workbooks and open the one that contains the links.Then click Options on the Trust Bar and then click Enable this Content.

(True/False)

4.9/5

(30)

Question 27

Esperanza wants to record a macro to automate a repetitive task.Which of the following combinations of keys should she press to open the Macro name box?

(Multiple Choice)

4.7/5

(34)

Question 28

Which of the following combinations of keys will you press to open the VBA window and run a macro code?

(Multiple Choice)

4.9/5

(37)

Question 29

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?

(Multiple Choice)

4.8/5

(41)

Question 30

There are two Card Styles for Card visualization: Card and Callout.

(True/False)

4.7/5

(36)

Question 31

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?

(Multiple Choice)

4.8/5

(32)

Question 32

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?

(Multiple Choice)

4.8/5

(32)

Question 33

Which of the following will you select in Excel Options under File tab add the Insert Power View Report button to the ribbon?

(Multiple Choice)

4.8/5

(27)

Question 34

Which of these will you select as X in the following series of clicks to insert a hyperlink to a webpage: Select text or picture to display as hyperlink > Insert tab > Hyperlink > Insert Hyperlink box > X > Type or paste link?

(Multiple Choice)

4.9/5

(30)

Question 35

To add a title to a Power View report,one should click on the placeholder "Click here to add a title" at the top of the Power View.

(True/False)

4.8/5

(40)

Question 36

In which of the following boxes under Define target value will you type a numerical value while creating a key performance indicator (KPI)?

(Multiple Choice)

4.9/5

(33)

Question 37

If Power View is enabled,one can create a new Power View report page by clicking Insert tab > Power View button.

(True/False)

4.9/5

(42)

Question 38

Joyce wants to stop recording the steps of a task as a macro.She clicks on the following series: View > Macros > X > Stop Macro > Type a file name in the dialog box > Save.Which of the following can X be in the given steps?

(Multiple Choice)

4.8/5

(31)

Question 39

Which of these series of clicks would you select to remove hyperlink from a cell?

(Multiple Choice)

4.7/5

(38)

Question 40

Showing 21 - 40 of 60

Which of the following series of clicks will you follow after clicking on a column to create a measure in the Power Pivot Window using AutoSum?

Nathan wants to create multiple charts for a table Power View,beginning with a pie chart.What should he select as X in the series of clicks to do this: Design tab > X > Other Charts > Pie Chart?

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

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

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.

To update the data associated with external links,close all workbooks and open the one that contains the links.Then click Options on the Trust Bar and then click Enable this Content.

Esperanza wants to record a macro to automate a repetitive task.Which of the following combinations of keys should she press to open the Macro name box?

Which of the following combinations of keys will you press to open the VBA window and run a macro code?

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?

There are two Card Styles for Card visualization: Card and Callout.

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?

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 will you select in Excel Options under File tab add the Insert Power View Report button to the ribbon?

Which of these will you select as X in the following series of clicks to insert a hyperlink to a webpage: Select text or picture to display as hyperlink > Insert tab > Hyperlink > Insert Hyperlink box > X > Type or paste link?

To add a title to a Power View report,one should click on the placeholder "Click here to add a title" at the top of the Power View.

In which of the following boxes under Define target value will you type a numerical value while creating a key performance indicator (KPI)?

If Power View is enabled,one can create a new Power View report page by clicking Insert tab > Power View button.

Joyce wants to stop recording the steps of a task as a macro.She clicks on the following series: View > Macros > X > Stop Macro > Type a file name in the dialog box > Save.Which of the following can X be in the given steps?

Which of these series of clicks would you select to remove hyperlink from a cell?

Creating a Worksheet and a Chart

Formulas,functions,and Formatting

Working With Large Worksheets, charting, and What-If Analysis

Financial Functions, data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, sorting, and Querying a Table

Creating Templates, importing Data, and Working With Smartart, images, and Screenshots

Working With Trendlines, pivot Table Reports, pivotchart Reports, and Slicers

Formula Auditing, data Validation, and Complex Problem Solving

User Interfaces, visual Basic for Applications Vba, and Collaboration Features in Excel

Filters