NP Excel 2016
Module 05
Quick Check Answers
Session 5.1
2. A field is a single piece of data that is entered in a column. A record is a group of related
fields that appears in a row.
3. The Freeze Panes button enables you to keep, or freeze, rows and columns so that they
5. Use the Remove Duplicates dialog box to locate and delete duplicate records from an
Excel table.
7. Sort by year of graduation and then by student last name.
Session 5.2
1. Filtering temporarily hides any records that do not meet the specified criteria.
2. Click the Major filter button, and then check only the Economics check box. Click the
4. A slicer is an object used to filter data in an Excel table. It includes a button for each
5. Click the Gender filter button and check only the Female check box. Insert the Total row,
6. You must first sort the data for which you want to calculate subtotals because subtotals
are inserted whenever the value in the specified field changes.
7. The Outline buttons show or hide details from the subtotal report. Each level adds or
removes another level of detail. Level 1 displays the least amount of detail.
Session 5.3
2. After you create the blank PivotTable, you use the PivotTable Fields pane to drag fields
into different areas to build the PivotTable.
4. values
6. FILTERS area
8. A PivotChart is a graphical representation of the data in a PivotTable.