Test 2 B

Question 1

Filtering

Answer 1

The process of displaying a subset of rows in an excel table that meets the criteria you specify.

Question 2

Pane

Answer 2

Separate areas of a worksheet when they are on the screen at the same time.

Question 3

Split Bar

Answer 3

The division between the panes.

Question 4

Criteria Filters

Answer 4

Enable you to specify various conditions in addition to those that were based on an “equals” criterion.

Question 5

Category Fields

Answer 5

The fields that group the values in a PivotTable.

Question 6

PivotTable

Answer 6

An interactive table used to group and summarize either a range of data or an Excel table into a concise, tabular format for easier reporting and analysis.

Question 7

Value Fields

Answer 7

Fields that contain summary data in a PivotTable.

Question 8

PivotChart

Answer 8

A graphical representation of the data in a PivotTable.

Question 9

Slicer

Answer 9

An object used to filter a PivotTable or PivotChart.

Question 10

Refresh

Answer 10

Updating a PivotTable to reflect the updated data.