iCheck™ Series Microsoft® Office 2007 Real World Applications

Lesson 2: Advanced Data Analysis

Self Checks

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

1
A ____ is based on the data contained in a PivotTable.
A)database function
B)What-If Analysis
C)LOOKUP table
D)PivotChart
2
To replace every occurrence of the word "First" with the word "Last," use the ____ function.
A)SUBSTITUTE
B)What-If Analysis
C)PROPER
D)LOOKUP
3
What is a scenario?
A)A formula that acts on only those items that meet certain specifications.
B)A version of a worksheet designed to test one of a number of possible outcomes.
C)A word or words that represent one cell or a range of cells.
D)A limit that is set.
4
If you want to modify text so that only the first letter is capitalized, use the ____ function.
A)UPPER
B)LOWER
C)PROPER
D)SUBSTITUTE
5
Given the following dialog box, how will the Solver find a solution?

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/596822/Ex_U2L2Q5.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"> (49.0K)</a>
A)By increasing the value in cell F9.
B)By decreasing the value in cell F9.
C)By multiply A9 by F9.
D)By altering the value in cell A9.
6
When using ____, a statement is either true or false.
A)conditional logic
B)a database function
C)a What-If Analysis
D)a LOOKUP function
7
In which of the situations listed here would the following test be true? =AND(B3>=0.8, C3 = 1)
A)B3 = 0.8; C3 = 2
B)B3 = 0.7; C3 = 0
C)B3 = 0.7; C3 = 1
D)B3 = 0.9; C3 = 1
8
To create a PivotChart, choose ____.
A)Data>Data Tools>PivotChart
B)Options>>Tools>PivotChart
C)Insert>Tables>PivotChart
D)Insert>Charts>PivotChart
9
If you want to determine how many times column M contains a value of zero and column N contains a positive number, use the ____ function.
A)SUMIF
B)SUMIFS
C)COUNTIF
D)COUNTIFS
10
The following worksheet contains a ____.

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/596822/Ex_U2L2Q10.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"> (40.0K)</a>
A)PivotTable
B)scenario
C)LOOKUP table
D)database function
Glencoe Online Learning CenterComputer Education HomeProduct InfoSite MapContact Us

The McGraw-Hill CompaniesGlencoe