74.
If you wanted to see a list of every student who scored greater than 85
percent on a test, you would use the Custom AutoFilter function.
75.
If you wanted to see a list that displays all customers that have spent less
than $20, or more than $100, in the past six months, you would use the
Custom AutoFilter function.
76.
Entries in a list meeting some specific criteria can be identified using the
Filter function or the conditional formatting function in Excel.
77.
Conditional formatting highlights the information in a cell that does not
meet the criteria you specified.
78.
Conditional formatting only works for textual data.
79.
Conditional formatting from a list can be removed only from selected cells.
80.
A pivot table enables you to group and summarize information.
81.
A pivot table can be created for information obtained from a Word or Access
table.
82.
The default location of a pivot table is to place it in the same worksheet as
that of the list.
83.
Dragging a label from the PivotTable Field List to the area in the lower-right
portion of the screen marked “Values” makes it three dimensional.
84.
A pivot table can be two-or three-dimensional.
85.
By creating a two-dimensional pivot table in Excel, using rows and columns,
you can build a data warehouse.
86.
Goal Seek works backward from an objective to compute an unknown
value.
87.
To use Goal Seek, one has to create a worksheet that includes an objective
based on some unknown value in a cell.
88.
In using Goal Seek to compute an unknown value, the first step is to click
on the “Value Fields” setting, then click on “Summarize Values By”, and
then select “Goal Seek”.
Fill in the Blank Questions
89.
_____ is Microsoft’s spreadsheet software that allows you to work with and
analyze information.
90.
A(n) _____ is the intersection of a row and column.
91.
A(n) _____ is a spreadsheet function that summarizes information by
category.
92.
The first _____ in a list contains column headings or labels.
93.
A(n) _____ is a collection of information arranged in columns and rows in
which each column displays one particular type of information.
94.
A list is a collection of information arranged in _____ and _____ in which
each column displays one particular type of information.
95.
In a list, each column has only _____ type(s) of information.