96.
A list does not contain any _____ rows.
97.
A(n) _____ is a description of a list by column.
98.
The _____ quickly creates smaller lists out of a much larger list.
99.
From a list of customers living in the North, the South, the East, and the
West, in order to get specific information to create a list of all customers
living in the North, the _____ function must be used.
100.
The purpose of the AutoFilter function is to help you quickly focus on only
the information that is important by _____ the information that is not.
101.
When using the Filter function, you are not limited to working with just one
____.
102.
The basic AutoFilter function allows you to create sublists using _____
match criteria.
103.
The basic AutoFilter function creates _____ based on exact match criteria.
104.
The _____ allows you to view rows in a list that meet a range of criterion
that you specify.
105.
The Custom Filter function allows you to hide all the rows in a list except
those that match criteria, besides “_____,” you specify.
106.
_____ highlights the information in a cell that meets some criteria you
specify.
107.
The Filter function _____ the information you want to see by hiding the
information you do not want to see.
108.
Conditional formatting maintains the view of the _____ list of information
but highlights key pieces of information that you are looking for.
109.
A(n) _____ takes the most steps to create, but yields highly valuable
summary information.
110.
You need to have a(n) _____ before you can use a pivot table.
111.
The default aggregation or summarization in a pivot table is by ____.
112.
In the _____ area of a summary of a pivot table, you drop the fields of
information that you want in the interior of the pivot table.
113.
The PivotTable _____ is the list of fields in the original table that you can
work with.
114.
In a pivot table, the _____ area is where you will drop a field of information
to create pages or layers.
115.
A two-dimensional pivot table with another layer giving it more depth is a
_____ pivot table.
116.
A three-dimensional pivot table has rows, columns, and ____.
117.
Goal Seek works backward from an objective to compute a(n) _____ value.