Multiple Choice Identify the
choice that best completes the statement or answers the question.
|
|
1.
|
How do you record the tietle, author, and subject of a workbook?
a. | Save the file as a template | c. | Import the data | b. | Add Workbook
properties | d. | Save the file as
a Web page. |
|
|
2.
|
How do you import data to Excel from a Web page?
a. | Save the file as a Web page | c. | Create a Web
Query | b. | Consolidate the data | d. | Edit the template |
|
|
3.
|
What do you create when you consolidate, or combine, data from multiple
worksheets?
a. | Keyboard shortcut | c. | User-defined template | b. | Summary
Worksheet | d. | Web
query |
|
|
4.
|
What feature allows you to record a series of commands that can be played back
using a single command using shortcut or hot keys?
a. | Web Query | c. | Template | b. | Compatibility Checker | d. | Macro |
|
Matching
|
|
|
a. | Compativility Checker | i. | Summary Worsheet | b. | Delimited | j. | Template | c. | Document Information
Panel | k. | User-Defined
Template | d. | Document Inspector | l. | Web Query | e. | Import | m. | Author | f. | Keyboard
Shortcut | n. | Consolidate | g. | Macro | o. | Perform | h. | Property | p. | Reveal |
|
|
5.
|
A file that is used as a basis for new files of that type.
|
|
6.
|
A feature that can be used to view, add, and edit document properties while you
work on the document.
|
|
7.
|
Source or originator
|
|
8.
|
A workseet created by a user that becomes the basis for new worksheets.
|
|
9.
|
Carry out
|
|
10.
|
A tool that ensures that a document or workbook will be compatible with a
different version of the software without losing any data.
|
|
11.
|
A feature that reviews documents for hidden data ro personal information that
is stored in the document or document properties.
|
|
12.
|
A set of hot keys used to perform an action or command.
|
|
13.
|
Data that is separated by a comma or other character
|
|
14.
|
A piece of information saved as part of a workbook.
|
|
15.
|
Combine
|
|
16.
|
An action that opens a Web page and then imports data from Web page into your
workbook.
|
|
17.
|
A sequence of actions recorded by the user and then played back with a single
command.
|
|
18.
|
Expose
|
|
19.
|
A worksheet that combines data from multiple worksheets.
|
|
20.
|
Bring in
|