Question 1

How can one filter a PivotTable using a report filter?

Accepted Answer

A)  Click on the drop down arrow for a Report Filter in the pivot table and Click (All). 
B)  Click the Report Filter's drop-down arrow,then click on an item to select an item in the list and click OK. 
C)  Right-click a cell in the pivot table,and click Pivot Table Options,then set the 'Display Fields in Report Filter Area' to 'Down,Then Over' On the Layout & Format tab. 
D)  Right-click a cell in the pivot table,and click Pivot Table Options,then set the 'Display Fields in Report Filter Area' to Over,Then Down' On the Layout & Format tab. 
A)  Click on the drop down arrow for a Report Filter in the pivot table and Click (All). 
B)  Click the Report Filter's drop-down arrow,then click on an item to select an item in the list and click OK. 
C)  Right-click a cell in the pivot table,and click Pivot Table Options,then set the 'Display Fields in Report Filter Area' to 'Down,Then Over' On the Layout & Format tab. 
D)  Right-click a cell in the pivot table,and click Pivot Table Options,then set the 'Display Fields in Report Filter Area' to Over,Then Down' On the Layout & Format tab. B

Question 2

Grace wants to connect a slicer to two PivotCharts.In which of these dialog boxes can she select the pivot tables she wants to link to the slicer and click OK?

Accepted Answer

A)  Insert Slicers 
B)  Remove "Product" 
C)  Report Connections 
D)  Multi-select "Product" 
A)  Insert Slicers 
B)  Remove "Product" 
C)  Report Connections 
D)  Multi-select "Product" C

Question 3

Luca wants to insert a pivot table.He clicks on a single cell inside the data set,then proceeds to step X,and finally clicks OK in the dialog box that appears after step 2.What can step 2 be?

Accepted Answer

A)  Select a pivot table under Pivot Chart & Pivot Tables in the Charts group on the Charts tab. 
B)  Click PivotTable on the Insert tab,in the Tables group. 
C)  Click Recommended PivotTables on the Insert tab,in the Tables group. 
D)  Select a pivot table under Pivot Chart in the Charts group on the Charts tab. 
A)  Select a pivot table under Pivot Chart & Pivot Tables in the Charts group on the Charts tab. 
B)  Click PivotTable on the Insert tab,in the Tables group. 
C)  Click Recommended PivotTables on the Insert tab,in the Tables group. 
D)  Select a pivot table under Pivot Chart in the Charts group on the Charts tab. B

Question 4

To insert a Scatter chart for a data set,we can click on the following series: Range of cells > Insert tab > Charts group > Insert Scatter (X,Y)or Bubble Charts > Scatter > Chart of choice > OK.

Accepted Answer

A) True 
 B)False

Question 5

To hide the PivotTable Field list,right click on any cell of the pivot table,and select Hide Field List option from the context menu.

Accepted Answer

A) True 
 B)False

Question 6

Xan wants to change the number format in a PivotTable as well a PivotChart.To do so,she can right-click on a cell in the value field in the pivot table,then click Value Field Settings,and then the Number Format button in the popup menu,then select the formatting that she wants in the Format Cells dialog box and finally click OK.

Accepted Answer

A) True 
 B)False

Question 7

Melanie wants to change the default PivotTable Style for a workbook.She selects a cell in a Pivot Table,then clicks a certain tab on the Ribbon,under the PivotTable Tools tab.Then she right-clicks the style she wants to set as the default In the PivotTable Style gallery and finally clicks on Set As Default in the context menu.What is the tab Melanie clicks during this procedure?

Accepted Answer

A)  Data tab 
B)  Home tab 
C)  Insert tab 
D)  Design tab 
A)  Data tab 
B)  Home tab 
C)  Insert tab 
D)  Design tab

Question 8

To select the Row Labels in a PivotChart,point to the bottom border of a Row Label heading and click to select the row labels for that field when the pointer changes to a thick black arrow.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following keys will you press after clicking on a chart to remove it from an Excel sheet but keep the data intact?

Accepted Answer

A)  Ctrl + Q 
B)  Alt + F 
C)  Esc 
D)  Delete 
A)  Ctrl + Q 
B)  Alt + F 
C)  Esc 
D)  Delete

Question 10

In which of these boxes will you enter the name of the new row or column that you want to show the calculated field in a PivotChart?

Accepted Answer

A)  Name text box 
B)  Fields lists box 
C)  Formula text box 
D)  Calculated Field dialog box 
A)  Name text box 
B)  Fields lists box 
C)  Formula text box 
D)  Calculated Field dialog box

Question 11

Right-click the pivot item,then click Expand to expand a field in a PivotTable.

Accepted Answer

A) True 
 B)False

Question 12

How many items in a Pivot table can you drill down at a time?

Accepted Answer

A)  1 
B)  2 
C)  5 
D)  8 
A)  1 
B)  2 
C)  5 
D)  8

Question 13

To insert a trendline that forecasts future trends into a chart,we need to follow this series: Chart > Data series > Chart > Add Trendline > Options tab > Forecast section > Up arrow in the Forecast box.

Accepted Answer

A) True 
 B)False

Question 14

To remove a field,in the PivotTable Field List clear the check box of the field you want to remove In the Choose fields to add to report box.

Accepted Answer

A) True 
 B)False

Question 15

After drilling down,Esteban wants to drill up to analyze summary data.To do so,he follows the following steps: 1.Select the item to drill up on in the PivotTable hierarchy you have drilled into.2.Click the Quick Explore button that appears in the lower-right corner of the selection.3.Use the Quick Explore button to reach the data you want.Which step did he miss while following this procedure?

Accepted Answer

A)  Step 3: Select the item you want to explore in the Explore box and then click Drill Down. 
B)  Step 3: Select the item you want to explore in the Explore box and then click Drill Up. 
C)  Step 2: Select the item you want to drill up on and then click Drill Up. 
D)  Step 4: Click OK to complete the procedure. 
A)  Step 3: Select the item you want to explore in the Explore box and then click Drill Down. 
B)  Step 3: Select the item you want to explore in the Explore box and then click Drill Up. 
C)  Step 2: Select the item you want to drill up on and then click Drill Up. 
D)  Step 4: Click OK to complete the procedure.

Question 16

Which option will you click after selecting a chart and clicking on + at its top to add a trendline to a chart?

Accepted Answer

A)  Axes 
B)  Legend 
C)  Gridlines 
D)  Trendline 
A)  Axes 
B)  Legend 
C)  Gridlines 
D)  Trendline

Question 17

What will you select as X in the following series of clicks/entries to insert a Histogram chart: Range of cells > Insert tab > Charts group > X > Histogram group > Histogram chart icon > OK?

Accepted Answer

A)  Insert Bar Chart 
B)  Insert line Chart 
C)  Insert Area Chart 
D)  Insert Static Chart 
A)  Insert Bar Chart 
B)  Insert line Chart 
C)  Insert Area Chart 
D)  Insert Static Chart

Question 18

To filter data in a PivotTable,follow the series of selections: A cell in the PivotTable > Analyze > Insert Slicer > Select the fields you want to create slicers for > OK > Select the items you want to show in the PivotTable.

Accepted Answer

A) True 
 B)False

Question 19

Which of these is the default layout for a newly created Pivot table?

Accepted Answer

A)  Compact Form 
B)  Outline Form 
C)  Tabular Form 
D)  Chart Form 
A)  Compact Form 
B)  Outline Form 
C)  Tabular Form 
D)  Chart Form

Question 20

Right-click the pivot item,then click Collapse to collapse a field in a PivotTable.

Accepted Answer

A) True 
 B)False

How can one filter a PivotTable using a report filter?

Grace wants to connect a slicer to two PivotCharts.In which of these dialog boxes can she select the pivot tables she wants to link to the slicer and click OK?

Luca wants to insert a pivot table.He clicks on a single cell inside the data set,then proceeds to step X,and finally clicks OK in the dialog box that appears after step 2.What can step 2 be?

To insert a Scatter chart for a data set,we can click on the following series: Range of cells > Insert tab > Charts group > Insert Scatter (X,Y)or Bubble Charts > Scatter > Chart of choice > OK.

To hide the PivotTable Field list,right click on any cell of the pivot table,and select Hide Field List option from the context menu.

To select the Row Labels in a PivotChart,point to the bottom border of a Row Label heading and click to select the row labels for that field when the pointer changes to a thick black arrow.

Which of the following keys will you press after clicking on a chart to remove it from an Excel sheet but keep the data intact?

In which of these boxes will you enter the name of the new row or column that you want to show the calculated field in a PivotChart?

Right-click the pivot item,then click Expand to expand a field in a PivotTable.

How many items in a Pivot table can you drill down at a time?

To insert a trendline that forecasts future trends into a chart,we need to follow this series: Chart > Data series > Chart > Add Trendline > Options tab > Forecast section > Up arrow in the Forecast box.

To remove a field,in the PivotTable Field List clear the check box of the field you want to remove In the Choose fields to add to report box.

Which option will you click after selecting a chart and clicking on + at its top to add a trendline to a chart?

What will you select as X in the following series of clicks/entries to insert a Histogram chart: Range of cells > Insert tab > Charts group > X > Histogram group > Histogram chart icon > OK?

To filter data in a PivotTable,follow the series of selections: A cell in the PivotTable > Analyze > Insert Slicer > Select the fields you want to create slicers for > OK > Select the items you want to show in the PivotTable.

Which of these is the default layout for a newly created Pivot table?

Right-click the pivot item,then click Collapse to collapse a field in a PivotTable.

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

Formula Auditing, data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

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

Filters

Exam 8: Working With Trendlines, pivot Table Reports, pivotchart Reports, and Slicers

How can one filter a PivotTable using a report filter?

Grace wants to connect a slicer to two PivotCharts.In which of these dialog boxes can she select the pivot tables she wants to link to the slicer and click OK?

Luca wants to insert a pivot table.He clicks on a single cell inside the data set,then proceeds to step X,and finally clicks OK in the dialog box that appears after step 2.What can step 2 be?

To insert a Scatter chart for a data set,we can click on the following series: Range of cells > Insert tab > Charts group > Insert Scatter (X,Y)or Bubble Charts > Scatter > Chart of choice > OK.

To hide the PivotTable Field list,right click on any cell of the pivot table,and select Hide Field List option from the context menu.

To select the Row Labels in a PivotChart,point to the bottom border of a Row Label heading and click to select the row labels for that field when the pointer changes to a thick black arrow.

Which of the following keys will you press after clicking on a chart to remove it from an Excel sheet but keep the data intact?

In which of these boxes will you enter the name of the new row or column that you want to show the calculated field in a PivotChart?

Right-click the pivot item,then click Expand to expand a field in a PivotTable.

How many items in a Pivot table can you drill down at a time?

To insert a trendline that forecasts future trends into a chart,we need to follow this series: Chart > Data series > Chart > Add Trendline > Options tab > Forecast section > Up arrow in the Forecast box.

To remove a field,in the PivotTable Field List clear the check box of the field you want to remove In the Choose fields to add to report box.

Which option will you click after selecting a chart and clicking on + at its top to add a trendline to a chart?

What will you select as X in the following series of clicks/entries to insert a Histogram chart: Range of cells > Insert tab > Charts group > X > Histogram group > Histogram chart icon > OK?

To filter data in a PivotTable,follow the series of selections: A cell in the PivotTable > Analyze > Insert Slicer > Select the fields you want to create slicers for > OK > Select the items you want to show in the PivotTable.

Which of these is the default layout for a newly created Pivot table?

Right-click the pivot item,then click Collapse to collapse a field in a PivotTable.

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

Formula Auditing, data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

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

Filters