True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
The
sorting buttons on the toolbar are identified by an icon of the letters “AZ” and an up or
down arrow.
|
|
|
2.
|
To
insert a picture from the Microsoft Clip Gallery, select Picture on the Edit menu and then select
Clip Art from the submenu.
|
|
|
3.
|
Pictures may be resized to fit within a specific area of the worksheet.
|
|
|
4.
|
Format painting will insert a picture in a worksheet.
|
|
|
5.
|
The
Drawing toolbar is used to create lines and objects in a worksheet.
|
|
|
6.
|
A
spreadsheet may be saved in HTML format.
|
|
|
7.
|
The
Drawing button is on the Standard toolbar.
|
|
|
8.
|
Excel
can open spreadsheets that are created in other programs, such as Lotus 1-2-3.
|
|
|
9.
|
You
may insert a hyperlink into a worksheet.
|
|
|
10.
|
To
sort in descending order is to sort in alphabetic order and with numbers from lowest to
highest.
|
|
|
11.
|
Templates are files that automate tasks by creating a worksheet format that may be
used more than once.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
12.
|
Which
of the following is not an order by which a range of data may be sorted? a. | alphabetically | c. | by cell
size | b. | ascending
numeric order | d. | descending
numeric order | | | | |
|
|
|
13.
|
To
prevent Excel from including the column headings in the sort, select the ____ button in the Sort
dialog box. a. | Header
row | c. | Skip
header | b. | No header row | d. | Data only | | | | |
|
|
|
14.
|
To
move a picture, you must a. | drag it to the desired position. | b. | click the
Restore button on the Picture toolbar. | c. | click the Increase Contrast or Decrease Contrast button on the
Picture toolbar. | d. | drag the sizing handles on the sides of the
picture. | | |
|
|
|
15.
|
What
action temporarily removes a row or column from the workbook screen? a. | deleting | c. | concealing | b. | hiding | d. | freezing | | | | |
|
|
|
16.
|
What
operation displays a subset of the data in a worksheet that meet certain criteria? a. | AutoFilter | c. | AutoSum | b. | AutoSort | d. | Sort | | | | |
|
|
|
17.
|
To
refer a worksheet user to a data source on the Internet, what operation are you most likely to
perform? a. | Save the file as
a template. | c. | Perform an
AutoFilter. | b. | Insert a hyperlink. | d. | Sort data. | | | | |
|
|
|
18.
|
Which
worksheet operation is used to display the 10 largest items in a worksheet column? a. | Sort | c. | AutoFilter | b. | Hide | d. | Big 10 | | | | |
|
|
|
19.
|
The
Drawing toolbar usually appears near the ____ of the screen. a. | bottom | c. | right | b. | top | d. | left | | | | |
|
Completion
Complete each sentence or
statement.
|
|
|
20.
|
To
access the Sort dialog box you must open the ____________________ menu.
|
|
|
21.
|
Worksheets saved in HTML format will probably be used on the
____________________.
|
|
|
22.
|
One
way to delete a line or object you have created in an Excel worksheet, is to click on the object or
line and press the ____________________ key on the keyboard.
|
|
|
23.
|
To
resize a picture, you must select it and then drag one of its sizing
____________________.
|
|
|
24.
|
The
____________________ is a collection of clip art that may be placed on your hard disk when Office is
installed.
|
|
|
25.
|
____________________ automate tasks performed in Excel by creating a worksheet format
that may be used more than once.
|
|
|
26.
|
____________________ may be placed in a worksheet to show other files or Web pages on
the screen.
|
|
|
27.
|
____________________ organizes data in an order that is meaningful and more
useful.
|
|
|
28.
|
The
____________________ command displays a subset of the data in a worksheet that meets certain
criteria.
|
|
|
29.
|
To
insert a picture from the media clips, select ____________________ on the Insert menu, and then
select Clip Art on the submenu.
|
|
|
30.
|
The
icons for Excel template files can be recognized by the _____________________ strip across the top of
the icon.
|