iCheck™ Series Microsoft® Office 2007 Real World Applications

Lesson 1: Advanced Data Organization

Self Checks

Self Checks provide you with multiple choice questions you can use to review the main ideas of the lesson.

1
You can use the AutoFilter tool to locate a(n) ____ of data that meets criteria you have specified.
A)outline
B)subtotal
C)named range
D)subset
2
Which of the following is true concerning this custom filter?

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/596822/Ex_U2L1Q2.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (24.0K)</a>
A)It will search for the specified value in all columns of the table.
B)It will show all rows of the table.
C)It will show all rows in which a value greater than 10 or less than 100 is in the third column.
D)It will show all rows in which a value greater than 10 and less than 100 is in the third column.
3
You can use Excel's ____ feature to control the type of data that can be entered into a cell.
A)advanced filter
B)evaluate formula
C)data validation
D)remove duplicate values
4
A(n) ____ is consists of the sum of a group of items within a larger set of items.
A)AutoFilter
B)subtotal
C)named range
D)outline
5
Which of the following is an important reason that you might name a range of cells?
A)To make it easier for Excel to perform calculations on the cells.
B)So that the data in the range can be validated.
C)To simplify referring to the cells in formulas.
D)So that custom filters can be applied to the range.
6
You can use the Evaluate Formula dialog box to ____.
A)see the steps Excel takes in trying to calculate a formula
B)create or modify a named range
C)apply an advanced filter to a range of data
D)specify the amount of detail you want to see in a list of data
7
If you want to change the name of a named range, click the ____ button on the ____ tab.
A)Name Manager; Formulas
B)Create from Selection; Formulas
C)Format; Home
D)Data Validation; Data Tools
8
What button would be useful if you wanted to merge three cells into a single cell?
A)<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/596822/Ex_U2L1Q8a.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (1.0K)</a>
B)<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/596822/Ex_U2L1Q8b.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (18.0K)</a>
C)<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/596822/Ex_U2L1Q8c.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (1.0K)</a>
D)<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/596822/Ex_U2L1Q8d.jpg','popWin', 'width=NaN,height=NaN,resizable,scrollbars');" href="#"><img valign="absmiddle" height="16" width="16" border="0" src="/olcweb/styles/shared/linkicons/image.gif"> (18.0K)</a>
9
To remove any rows that contain the exact same values of another row, choose ____.
A)Formulas>Formula Auditing>Evaluate Formula
B)Data>Data Tools>Remove Duplicates
C)Formulas>Defined Names>Find Duplicates
D)Data>Sort & Filter>Filter
10
When you organize a worksheet so that all of the inventory for each of seven stores is positioned together, you are ____ the data.
A)subtotaling
B)applying a formula to
C)filtering
D)grouping
Glencoe Online Learning CenterComputer Education HomeProduct InfoSite MapContact Us

The McGraw-Hill CompaniesGlencoe