iCheck Express Series - Microsoft Excel 2003

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/0078690358/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/0078690358/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