Question 1

PivotTable rows are drawn from columns in the worksheet data._________________________

Accepted Answer

A) True 
 B)False

Question 2

You can change the height of a slicer by clicking the Height text box in the Buttons group on the ____ tab and then entering the desired height.

Accepted Answer

A)  SLICER TOOLS FORMAT 
B)  SLICER TOOLS LAYOUT 
C)  SLICER TOOLS OPTIONS 
D)  SLICER TOOLS DESIGN 
A)  SLICER TOOLS FORMAT 
B)  SLICER TOOLS LAYOUT 
C)  SLICER TOOLS OPTIONS 
D)  SLICER TOOLS DESIGN

Question 3

Changes in the view of a PivotChart report are automatically reflected in the PivotTable report.

Accepted Answer

A) True 
 B)False

Question 4

____ reports are visual representations of PivotTables.

Accepted Answer

A)  PivotChart 
B)  Slicer 
C)  Data Marker 
D)  Calculated field 
A)  PivotChart 
B)  Slicer 
C)  Data Marker 
D)  Calculated field

Question 5

Which of the following is the path to the Report Layout button?

Accepted Answer

A)  (PIVOTTABLE TOOLS LAYOUT tab | Design group) 
B)  (PIVOTTABLE TOOLS DESIGN tab | Layout group) 
C)  (PIVOTTABLE TOOLS FORMAT tab | Layout group) 
D)  (PIVOTTABLE TOOLS DESIGN tab | Theme group) 
A)  (PIVOTTABLE TOOLS LAYOUT tab | Design group) 
B)  (PIVOTTABLE TOOLS DESIGN tab | Layout group) 
C)  (PIVOTTABLE TOOLS FORMAT tab | Layout group) 
D)  (PIVOTTABLE TOOLS DESIGN tab | Theme group)

Question 6

PivotTables automatically update when you change the underlying data for the PivotTable report.

Accepted Answer

A) True 
 B)False

Question 7

You can remove a report filter from a PivotTable report by dragging the field outside of the PivotTable Fields task pane.

Accepted Answer

A) True 
 B)False

Question 8

Excel includes a number of preset PivotTable styles that function in similar fashion to Excel's table styles.

Accepted Answer

A) True 
 B)False

Question 9

With which of the following are any selected subgroups immediately identifiable,and able to be changed with the click of a button or buttons?

Accepted Answer

A)  autofilters 
B)  slicers 
C)  filters 
D)  pivots 
A)  autofilters 
B)  slicers 
C)  filters 
D)  pivots

Question 10

Which of the following is the path to the PivotTable Styles gallery More button?

Accepted Answer

A)  (INSERT tab | Table Styles group) 
B)  (PIVOTTABLE TOOLS DESIGN tab | PivotTable Styles group) 
C)  (HOME tab | Paint Styles group) 
D)  (PIVOTTABLE TOOLS LAYOUT tab | PivotTable Layout group) 
A)  (INSERT tab | Table Styles group) 
B)  (PIVOTTABLE TOOLS DESIGN tab | PivotTable Styles group) 
C)  (HOME tab | Paint Styles group) 
D)  (PIVOTTABLE TOOLS LAYOUT tab | PivotTable Layout group)

Question 11

When analyzing a chart that contains a trendline,always check the axes to be sure that the differences shown in the chart are not being visually overstated._________________________

Accepted Answer

A) True 
 B)False

Question 12

A ____ is an interactive view of worksheet data.

Accepted Answer

A)  PivotChart report 
B)  trendline 
C)  PivotTable report 
D)  2-D column chart 
A)  PivotChart report 
B)  trendline 
C)  PivotTable report 
D)  2-D column chart

Question 13

The + / - buttons ____ a field across categories.

Accepted Answer

A)  add and subtract 
B)  expand and collapse 
C)  multiply and divide 
D)  none of the above 
A)  add and subtract 
B)  expand and collapse 
C)  multiply and divide 
D)  none of the above

Question 14

PivotChart reports often are used to represent changes in one set of data over time._________________________

Accepted Answer

A) True 
 B)False

Question 15

Excel needs the blank rows above a PivotTable to remain blank,for any filters added in the PivotTable Fields task pane.

Accepted Answer

A) True 
 B)False

Question 16

You can connect ____ to more than one PivotTable to filter the data.

Accepted Answer

A)  PivotCharts 
B)  slicers 
C)  field lists 
D)  row headings 
A)  PivotCharts 
B)  slicers 
C)  field lists 
D)  row headings

Question 17

Which of the following is the path to the Field Buttons button?

Accepted Answer

A)  (PIVOTCHART TOOLS LAYOUT tab | Show / Hide group) 
B)  (PIVOTCHART TOOLS DESIGN tab | Show / Hide group) 
C)  (PIVOTCHART TOOLS OPTIONS tab | Show / Hide group) 
D)  (PIVOTCHART TOOLS ANALYZE tab | Show / Hide group) 
A)  (PIVOTCHART TOOLS LAYOUT tab | Show / Hide group) 
B)  (PIVOTCHART TOOLS DESIGN tab | Show / Hide group) 
C)  (PIVOTCHART TOOLS OPTIONS tab | Show / Hide group) 
D)  (PIVOTCHART TOOLS ANALYZE tab | Show / Hide group)

Question 18

The summary function that calculates the number of data values in a PivotTable report is ____.

Accepted Answer

A)  Count 
B)  Product 
C)  Var 
D)  Count Nums 
A)  Count 
B)  Product 
C)  Var 
D)  Count Nums

Question 19

To change the summary functions in a PivotTable,right-click a cell,point to ____,and click a command on the submenu.

Accepted Answer

A)  Subtotal Values By 
B)  Summarize Values By 
C)  Total Values By 
D)  Calculate Values By 
A)  Subtotal Values By 
B)  Summarize Values By 
C)  Total Values By 
D)  Calculate Values By

Question 20

Click the Options button in the ____ group on the PIVOTTABLE TOOLS ANALYZE tab to display the PivotTable Options dialog box.

Accepted Answer

A)  Options 
B)  Columns 
C)  Fields 
D)  PivotTable 
A)  Options 
B)  Columns 
C)  Fields 
D)  PivotTable

PivotTable rows are drawn from columns in the worksheet data._________________________

You can change the height of a slicer by clicking the Height text box in the Buttons group on the ____ tab and then entering the desired height.

Changes in the view of a PivotChart report are automatically reflected in the PivotTable report.

____ reports are visual representations of PivotTables.

Which of the following is the path to the Report Layout button?

PivotTables automatically update when you change the underlying data for the PivotTable report.

You can remove a report filter from a PivotTable report by dragging the field outside of the PivotTable Fields task pane.

Excel includes a number of preset PivotTable styles that function in similar fashion to Excel's table styles.

With which of the following are any selected subgroups immediately identifiable,and able to be changed with the click of a button or buttons?

Which of the following is the path to the PivotTable Styles gallery More button?

When analyzing a chart that contains a trendline,always check the axes to be sure that the differences shown in the chart are not being visually overstated._________________________

A ____ is an interactive view of worksheet data.

The + / - buttons ____ a field across categories.

PivotChart reports often are used to represent changes in one set of data over time._________________________

Excel needs the blank rows above a PivotTable to remain blank,for any filters added in the PivotTable Fields task pane.

You can connect ____ to more than one PivotTable to filter the data.

Which of the following is the path to the Field Buttons button?

The summary function that calculates the number of data values in a PivotTable report is ____.

To change the summary functions in a PivotTable,right-click a cell,point to ____,and click a command on the submenu.

Click the Options button in the ____ group on the PIVOTTABLE TOOLS ANALYZE tab to display the PivotTable Options dialog box.

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

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters

Exam 8: Working With Trendlines, Pivot Table Reports, Pivotchart Reports, and Slicers

PivotTable rows are drawn from columns in the worksheet data._________________________

You can change the height of a slicer by clicking the Height text box in the Buttons group on the ____ tab and then entering the desired height.

Changes in the view of a PivotChart report are automatically reflected in the PivotTable report.

____ reports are visual representations of PivotTables.

Which of the following is the path to the Report Layout button?

PivotTables automatically update when you change the underlying data for the PivotTable report.

You can remove a report filter from a PivotTable report by dragging the field outside of the PivotTable Fields task pane.

Excel includes a number of preset PivotTable styles that function in similar fashion to Excel's table styles.

With which of the following are any selected subgroups immediately identifiable,and able to be changed with the click of a button or buttons?

Which of the following is the path to the PivotTable Styles gallery More button?

When analyzing a chart that contains a trendline,always check the axes to be sure that the differences shown in the chart are not being visually overstated._________________________

A ____ is an interactive view of worksheet data.

The + / - buttons ____ a field across categories.

PivotChart reports often are used to represent changes in one set of data over time._________________________

Excel needs the blank rows above a PivotTable to remain blank,for any filters added in the PivotTable Fields task pane.

You can connect ____ to more than one PivotTable to filter the data.

Which of the following is the path to the Field Buttons button?

The summary function that calculates the number of data values in a PivotTable report is ____.

To change the summary functions in a PivotTable,right-click a cell,point to ____,and click a command on the submenu.

Click the Options button in the ____ group on the PIVOTTABLE TOOLS ANALYZE tab to display the PivotTable Options dialog box.

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

Using Macros and Visual Basic for Applications Vba With Excel

Collaboration Features for Workbooks

Essential Concepts and Skills

Productivity App: Productivity Apps for School and Work

Filters