iCheck Microsoft Office 2003 Introductory

Lesson 4: Analyzing Data

Self Checks

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

1
The arrows in the first row of the worksheet indicate that ____.

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078659493/290732/U2_L4_1.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"> (93.0K)</a>
A)AutoFilter is turned on.
B)AutoFilter is turned on.
C)the IF function is turned on.
D)the NOW function is turned on.
2
The ____ function calculates payments for a loan based on interest rate, number of payments, and the amount of the loan.
A)IF
B)NOW
C)PMT
D)Count
3
A keyed formula must always begin with the ____ sign.
A)=
B)*
C)+
D)–
4
How do you edit a formula?
A)Open the Edit menu.
B)Key changes in the formula bar.
C)Use the AutoSum function.
D)Open the Format menu.
5
A(n) ____ does not change when you copy a formula to a new location.
A)absolute reference
B)cell range
C)relative reference
D)AutoFilter
6
Identify the button that you would click to organize the selected column in ascending order.

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078659493/290729/U2_L4_2.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"> (199.0K)</a>
A)A
B)B
C)C
D)D
7
What is a range?
A)A cell reference that does not change when a formula is copied to a new location.
B)A function that counts the number of cells.
C)One cell within a series of cells.
D)A group of cells.
8
Which Excel feature allows you to see only the data you need?
A)Sort
B)Filter
C)Count
D)Function
9
Clustered column is a type of ____.
A)chart
B)graph
C)diagram
D)worksheet
10
You can access the Count function by using the drop-down arrow next to the ____ button.
A)Sort Ascending
B)Sort Descending
C)AutoSum
D)Undo
Glencoe Online Learning CenterComputer Education HomeProduct InfoSite MapContact Us

The McGraw-Hill CompaniesGlencoe

Please read our Terms of Use and Privacy Policy before you explore our Web site. To report a technical problem with this Web site, please contact the Web Producer.