iCheck™ Series Microsoft® Office 2007 Real World Applications

Lesson 5: Advanced Data Management

Self Checks

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

1
You can ____ data from a text file to an Excel worksheet.
A)consolidate
B)import
C)export
D)delimit
2
The ____ tab contains a command that lets you create a Web query.
A)Home
B)Insert
C)Formulas
D)Data
3
A Web query creates a ____ to a Web site
A)query
B)delimiter
C)macro
D)link
4
____ data are separated by tabs, commas, or other special characters.
A)Delimited
B)Exported
C)Imported
D)Macro
5
Use the ____ to make certain that a document does not contain any hidden or personal data, such as names or revisions.
A)Compatibility Checker
B)Web query
C)Document Inspector
D)Document Information Panel
6
Which tab would you click if you wanted to insert the author's name into this Properties dialog box?

<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/596822/Ex_U2L5Q6.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"> (55.0K)</a>
A)A
B)B
C)C
D)D
7
Which of the following is not a text box contained in the Document Information Panel?
A)Author
B)Format
C)Subject
D)Keywords
8
A(n) ____ template is one you create on your own.
A)user-defined
B)delimited
C)PDF
D)XPS
9
Which of these buttons would you click to record a macro?
A)<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/596822/Ex_U2L5Q9a.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"> (19.0K)</a>
B)<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/596822/Ex_U2L5Q9b.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"> (19.0K)</a>
C)<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/596822/Ex_U2L5Q9c.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>
D)<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078786051/596822/Ex_U2L5Q9d.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>
10
A summary worksheet is used to ____ data from multiple worksheets.
A)import
B)export
C)consolidate
D)query
Glencoe Online Learning CenterComputer Education HomeProduct InfoSite MapContact Us

The McGraw-Hill CompaniesGlencoe