Question 1

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 2

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 contains the tools necessary for creating and managing relationships between tables or queries in Access. Therefore, while creating a relationship between two queries, we will click on the Relationships option in the Database Tools tab.

Question 3

In which of the following boxes under Define target value will you type a numerical value while creating a key performance indicator (KPI)?
A) Absolute value
B) Select icon style
C) Define target value
D) Define status thresholds

Accepted Answer

Absolute value is where you would type a numerical value when setting a target for a KPI, as it directly specifies the goal or target number you aim to achieve.

Question 4

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.

Accepted Answer

Clicking on the "Click here to add a title" placeholder at the top of the Power View allows you to add a title to the report.

Question 5

To change the size of text to a particular percentage of the original text size in a Power View report,click on Power View tab > Themes group > Text Size.

Accepted Answer

This is the correct process to change the size of text in a Power View report.

Question 6

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

Accepted Answer

This is the correct method for creating a new Power View report page in Microsoft Excel.

Question 7

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

Accepted Answer

The answer of To open the Power Pivot window,one should...

Question 8

The buttons on the Design tab within the Switch Visualizations button group allows us to change the type of data visualization.

Accepted Answer

The buttons on the Design tab within the Switch Visualizations button group do allow us to change the type of data visualization.

Question 9

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

To check the "Add the data to the Data Model" box while adding a query to a Data Model, you should click on the "Load To…" button in the Workbook Queries pane. This will open a dropdown menu where you can choose to add the data to the worksheet, the data model, or both. Select the option to add the data to the data model, and the checkbox for "Add the data to the Data Model" will automatically be selected.

Question 10

From how many theme options can you choose to change the theme of a Power View report?
A) 12
B) 20
C) 39
D) 56

Accepted Answer

According to Microsoft documentation, there are 39 theme options available to choose from when changing the theme of a Power View report.

Question 11

To load the Analysis ToolPak and select Anova: Single Factor for statistical analysis in Excel,one should click on the following series: File tab > Options > Add-Ins category > Manage box > Excel Add-ins > Go .select Analysis ToolPak option on the appearing dialog box > OK > Data > Analysis > Data Analysis dialog box > Anova: Single Factor > OK.

Accepted Answer

The steps mentioned in the statement are correct for loading Analysis ToolPak and selecting Anova: Single Factor for statistical analysis in Excel.

Question 12

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 way to open the Manage Relationships dialog box in a Power View report.

Question 13

On which of the following tabs of the Power Pivot window will you select Refresh All under Refresh command to refresh all Power Pivot tables?
A) Home
B) Insert
C) Formulas
D) Developer

Accepted Answer

Refresh All option can be found under the Refresh command on the Home tab of the Power Pivot window.

Question 14

To change the background colors in a Power View report,click the POWERVIEW tab > Themes group > Background > Select a color.

Accepted Answer

This is the correct procedure for changing the background colors in a Power View report.

Question 15

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?
A) A-Design tab,B-Data group
B) A-Developer tab,B-Code group
C) A-Analyze tab,B-Calculations group
D) A-Design tab,B-Table Style Options group

Accepted Answer

The "Analyse" tab is where PivotChart reports can be created, and the "Calculations" group is where MDX Calculated Measure can be found in Excel. The other options are not relevant to creating a calculated measure in Excel using data stored in an Analysis Services cube.

Question 16

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?
A) Tiles
B) Options
C) Other Chart
D) Switch Visualization

Accepted Answer

To create multiple charts for a table in Power View, starting with a pie chart, Nathan should navigate through the Design tab, then select "Switch Visualization," and finally choose "Other Charts > Pie Chart." This sequence allows changing the current visualization to a different type, such as a pie chart.

Question 17

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.

Accepted Answer

This is the correct step to create a relationship between two tables in Microsoft Access.

Question 18

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

Accepted Answer

The answer of To create a video with High-definition video...

Question 19

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

Accepted Answer

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

Question 20

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 can be changed in the Design tab while adding a table to an internal Data Model.

Quiz 10: Data Analysis With Power Tools and Creating Macros

How can you rename a column in Excel?

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

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

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.

To change the size of text to a particular percentage of the original text size in a Power View report,click on Power View tab > Themes group > Text Size.

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

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

The buttons on the Design tab within the Switch Visualizations button group allows us to change the type of data visualization.

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?

From how many theme options can you choose to change the theme of a Power View report?

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.

On which of the following tabs of the Power Pivot window will you select Refresh All under Refresh command to refresh all Power Pivot tables?

To change the background colors in a Power View report,click the POWERVIEW tab > Themes group > Background > Select a color.

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 create a relationship between two tables,the first step would be to click on Relationships in the Relationships group on the Database Tools tab.

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

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

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?