iCheck™ Series Microsoft® Office 2010

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 second row of the worksheet indicate that ____.

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/007661395x/903631/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"> (252.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>Data Validation.
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/007661395x/903631/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"> (269.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/007661395x/903631/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"> (59.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
A ____ is a tiny chart that lets you show data trends within a single cell.
A)clustered column
B)scatter chart
C)slicer
D)sparkline
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.