Question 1

You can limit the display of data to specific information by using ________.

Accepted Answer

A) sorting 
B) filtering 
C) reporting 
D) charting 
A) sorting 
B) filtering 
C) reporting 
D) charting

Question 2

A PivotTable is an interactive Excel report that summarizes large amounts of data,allowing you to more easily analyze it.

Accepted Answer

A) True 
 B)False

Question 3

A ________ chart is used to illustrate the relationship of each part to a whole.

Accepted Answer

The answer of A ________ chart is used to illustrate...

Question 4

Match the following terms and elements with their descriptions:
i.Clear Filter
II.Filter
III.filtering button
IV.slicer header
v.slicers

Accepted Answer

A) The button on a slicer that you use to select the item by which to filter. 
B) Indicates the category of the slicer items. 
C) Easy-to-use filtering controls to drill down through large amounts of data in an interactive way. 
D) Limits the display of data to only specific information. 
E) A command that removes a filter. 
A) The button on a slicer that you use to select the item by which to filter. 
B) Indicates the category of the slicer items. 
C) Easy-to-use filtering controls to drill down through large amounts of data in an interactive way. 
D) Limits the display of data to only specific information. 
E) A command that removes a filter.

Question 5

By default,when a non-numeric field is added to a PivotTable,it is placed in the ________ area.

Accepted Answer

A) COLUMNS Area 
B) VALUES Area 
C) FILTER Area 
D) ROWS Area 
A) COLUMNS Area 
B) VALUES Area 
C) FILTER Area 
D) ROWS Area

Question 6

An area to position fields that you want to display as columns in the PivotTable is called ________.

Accepted Answer

A) COLUMNS Areas 
B) COLUMNS Headers 
C) COLUMNS Texts 
D) COLUMNS Filters 
A) COLUMNS Areas 
B) COLUMNS Headers 
C) COLUMNS Texts 
D) COLUMNS Filters

Question 7

Match the following PivotTable screen elements with their description:
i.FILTERS area
II.COLUMNS area
III.ROWS area
IV.VALUES area
v.PivotTable Fields pane

Accepted Answer

A) A window that lists at the top,all of the fields and column titles. 
B) An area to position fields that you want to display as columns in the PivotTable. 
C) An area in the lower portion of the PivotTable Fields pane to position fields. 
D) Numeric of financial in nature and the data is summarized. 
E) The data is grouped by theses row titles. 
A) A window that lists at the top,all of the fields and column titles. 
B) An area to position fields that you want to display as columns in the PivotTable. 
C) An area in the lower portion of the PivotTable Fields pane to position fields. 
D) Numeric of financial in nature and the data is summarized. 
E) The data is grouped by theses row titles.

Question 8

A PivotChart displays ________ that you can click to choose a filter and change the data displayed in the chart.

Accepted Answer

A) cell ranges 
B) named reports 
C) field buttons 
D) name ranges 
A) cell ranges 
B) named reports 
C) field buttons 
D) name ranges

Question 9

The area to rearrange and reposition fields in the PivotTable is called the ________.

Accepted Answer

A) layout section 
B) COLUMNS area 
C) field section 
D) column filters 
A) layout section 
B) COLUMNS area 
C) field section 
D) column filters

Question 10

Match the following terms with their meanings:
i.PivotChart
II.field button
III.associated PivotTable report
IV.refresh

Accepted Answer

A) The PivotTable in a workbook that is graphically represented in a PivotChart. 
B) Command to update a worksheet to reflect new data. 
C) A button on a PivotChart with an arrow to choose a filter. 
D) A graphical representation of the data in a PivotTable. 
A) The PivotTable in a workbook that is graphically represented in a PivotChart. 
B) Command to update a worksheet to reflect new data. 
C) A button on a PivotChart with an arrow to choose a filter. 
D) A graphical representation of the data in a PivotTable.

Question 11

A series of rows that contains related data with column titles in the first row is known as a(n)________.

Accepted Answer

The answer of A series of rows that contains related...

You can limit the display of data to specific information by using ________.

A PivotTable is an interactive Excel report that summarizes large amounts of data,allowing you to more easily analyze it.

A ________ chart is used to illustrate the relationship of each part to a whole.

Match the following terms and elements with their descriptions: i.Clear Filter II.Filter III.filtering button IV.slicer header v.slicers

By default,when a non-numeric field is added to a PivotTable,it is placed in the ________ area.

An area to position fields that you want to display as columns in the PivotTable is called ________.

Match the following PivotTable screen elements with their description: i.FILTERS area II.COLUMNS area III.ROWS area IV.VALUES area v.PivotTable Fields pane

A PivotChart displays ________ that you can click to choose a filter and change the data displayed in the chart.

The area to rearrange and reposition fields in the PivotTable is called the ________.

Match the following terms with their meanings: i.PivotChart II.field button III.associated PivotTable report IV.refresh

A series of rows that contains related data with column titles in the first row is known as a(n)________.

Introduction to Microsoft Office 2016 Features

Excell: Creating a Worksheet and Charting Data

Excell: Using Functions, Creating Tables, and Managing Large Workbooks

Excell: Analyzing Data With Pie Charts, Line Charts, and What-If Analysis Tools

Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering

Excell: Creating Charts, Diagrams, and Templates

Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas

Excell: Using Macros and Visual Basic for Applications

Excell: External Data, Database Functions, and Side-By-Side Tables

Excell: Collaborating With Others and Preparing a Workbook for Distribution

Filters

Exam 7: Excell: Creating Pivottables and Pivotcharts

You can limit the display of data to specific information by using ________.

A PivotTable is an interactive Excel report that summarizes large amounts of data,allowing you to more easily analyze it.

A ________ chart is used to illustrate the relationship of each part to a whole.

Match the following terms and elements with their descriptions: i.Clear Filter II.Filter III.filtering button IV.slicer header v.slicers

By default,when a non-numeric field is added to a PivotTable,it is placed in the ________ area.

An area to position fields that you want to display as columns in the PivotTable is called ________.

Match the following PivotTable screen elements with their description: i.FILTERS area II.COLUMNS area III.ROWS area IV.VALUES area v.PivotTable Fields pane

A PivotChart displays ________ that you can click to choose a filter and change the data displayed in the chart.

The area to rearrange and reposition fields in the PivotTable is called the ________.

Match the following terms with their meanings: i.PivotChart II.field button III.associated PivotTable report IV.refresh

A series of rows that contains related data with column titles in the first row is known as a(n)________.

Introduction to Microsoft Office 2016 Features

Excell: Creating a Worksheet and Charting Data

Excell: Using Functions, Creating Tables, and Managing Large Workbooks

Excell: Analyzing Data With Pie Charts, Line Charts, and What-If Analysis Tools

Excell: Use Financial and Lookup Functions, Define Names, Validate Data, and Audit Worksheets

Excell: Managing Large Workbooks and Using Advanced Sorting and Filtering

Excell: Creating Charts, Diagrams, and Templates

Excell: Using the Data Analysis, Solver, and Scenario Features, and Building Complex Formulas

Excell: Using Macros and Visual Basic for Applications

Excell: External Data, Database Functions, and Side-By-Side Tables

Excell: Collaborating With Others and Preparing a Workbook for Distribution

Filters