iCheck™ Series Microsoft® Office 2007 Real World Applications

Lesson 4: Analyze 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/0078786051/574822/U2L4Q1.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"> (212.0K)</a>
A)AutoFilter is turned on
B)the columns have been sorted
C)the IF function is turned on
D)the NOW function is turned on
2
A formula must always begin with the ____ sign.
A)=
B)*
C)+
D)-
3
How can you edit a formula?
A)Choose Data>Data Tools>Edit.
B)Key changes in the formula bar.
C)Use the AutoSum function.
D)Choose Home>Editing>Sort & Filter.
4
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/0078786051/574822/U2L4Q4.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"> (228.0K)</a>
A)A
B)B
C)C
D)D
5
A(n) ____ does not change when you copy a formula to a new location.
A)AutoFilter
B)mixed reference
C)relative reference
D)absolute reference
6
The formula in this formula bar contains ____.
<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/574822/U2L4Q6.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"> (57.0K)</a>
A)only absolute references
B)only relative references
C)mixed references
D)no references
7
To add a label to a chart's horizontal axis, choose ____.
A)Insert>Charts>Column
B)Insert>Charts>Labels
C)Layout>Labels>Axis Titles
D)Layout>Titles>Axis
8
The ____ tab in the Chart Tools lets you change a chart's type.
A)Layout
B)Format
C)Data
D)Design
9
The ____ function checks to see if a specific condition is true.
A)IF
B)NOW
C)PMT
D)COUNT
10
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
Glencoe Online Learning CenterComputer Education HomeProduct InfoSite MapContact Us

The McGraw-Hill CompaniesGlencoe

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