iCheck Series Office 2003: Real World Applications-Advanced

Lesson 4: Managing Data and Workbooks

Self Checks

1.
What kind of file is shown in the figure?
<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078687101/282013/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"> (78.0K)</a>
A)Template
B)Web page
C)XML file
D)Text file
2.
You can _____ data from Excel to another application.
A)consolidate
B)import
C)export
D)delimit
3.
Which menu do you use to create a Web query?
A)the Edit menu
B)the Insert menu
C)the Tools menu
D)the Data menu
4.
A(n) _____ template is one that you create on your own.
A)user-defined
B)delimited
C)XML
D)consolidated
5.
Which of the following is NOT included under the Summary tab of the Properties dialog box?
A)Subject
B)Author
C)Keywords
D)Date Created
6.
What are the items indicated in the task pane?
<a onClick="window.open('/olcweb/cgi/pluginpop.cgi?it=jpg::::/sites/dl/free/0078687101/282013/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"> (70.0K)</a>
A)Mapped XML elements
B)Undefined XML elements
C)Cells with XML errors
D)Available XML schemas
7.
A summary worksheet is used to ____ data from multiple worksheets.
A)import
B)consolidate
C)publish
D)concatenate
8.
The Data menu allows you to ____ XML data.
A)consolidate
B)create your own
C)refresh
D)modify
9.
____ data are separated by a tab, comma, or other character.
A)Exported
B)Imported
C)Consolidated
D)Delimited
10.
What does XML stand for?
A)eXtra Math List
B)eXtensible Markup Language
C)X-factor Manipulation Location
D)Exerting Manual Labor
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.