Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
1.
|
Formatting
affects how information appears in ____. a. | Boxes | b. | Cells | c. | Formulas | d. | None of the above | | |
|
|
|
2.
|
Cells and
ranges in a worksheet can be formatted ____. a. | Before data is entered | b. | After data is
entered | c. | Before or after data is entered | d. | At the same time data
is entered | | |
|
|
|
3.
|
A cell's
format can be "copied" into other cells using the ____. a. | Clipboard | b. | Format Painter button | c. | Paste Function
button | d. | None of the above | | |
|
|
|
4.
|
A font is
the name given to a collection of ____. a. | Letters | b. | Numerals | c. | Symbols and punctuation marks | d. | All the
above | | |
|
|
|
5.
|
Which
toolbar is used to change fonts and sizes? a. | Standard | b. | Formatting | c. | Both a and b | d. | None of the
above | | |
|
|
|
6.
|
If you want
to see a sample of a selected font, open the ____ dialog box. a. | Format
Cells | b. | Auto Format | c. | Auto Fit | d. | None of the above | | |
|
|
|
7.
|
Attributes
are font styling features, such as ____. a. | Bold | b. | Italics | c. | Underlining | d. | All of the above | | |
|
|
|
8.
|
To adjust
the width of a column to fit the widest entry, use the ____ command. a. | AutoFit | b. | Standard Width | c. | Format
Column | d. | None of the above | | |
|
|
|
9.
|
Selecting
the Format menu, then column, and then width ____. a. | Resets the column to
the default width | b. | Fits the widest entry in the column | c. | Allows you to set the
column width to a specific number of characters | d. | All the
above | | |
|
|
|
10.
|
To change
the width of column A using the mouse, be sure to position the mouse pointer ____. a. | In the center of column
A | b. | So that column A is
highlighted | c. | On the border between column headings A and
B | d. | In the lower left
corner of column A | | |
|
|
|
11.
|
Row height
must exceed ____. a. | Column
width | b. | Font size | c. | Standard width | d. | Standard
height | | |
|
|
|
12.
|
To delete a
row from a worksheet, click the row selector button, click Edit on the ____ bar, then click
Delete. a. | Edit | b. | Menu | c. | Status | d. | Tool | | |
|
|
|
13.
|
Which of the
following can you insert into or delete from your worksheet? a. | Rows | b. | Columns | c. | Both a and b | d. | None of the
above | | |
|
|
|
14.
|
When you add
or delete a row or column within a range used in a formula, ____. a. | You must re-enter the
formula | b. | You must change to a new formula | c. | Excel automatically
adjusts the formula | d. | None of the above | | |
|
|
|
15.
|
To enhance
the appearance of a worksheet use ____. a. | Colors | b. | Patterns | c. | Borders | d. | All the above | | |
|
|
|
16.
|
Single
underline, double underline, and outline are examples of ____ buttons. a. | Border | b. | Attribute | c. | Pattern | d. | Font | | |
|
|
|
|
|
|
17.
|
In the
figure above, item 4 points to the Comma Style button, which can be used to format
____. a. | Values | b. | Labels | c. | Text copy | d. | None of the above | | |
|
|
|
18.
|
In the
figure above, item 2 points to the ____ button. a. | Add Formula | b. | Currency Style | c. | Dollar
Sign | d. | Money
Format | | |
|
|
|
19.
|
In the
figure above, you would use the button labeled ____ to increase the number of decimal places in
selected cells.
|
|
|
20.
|
In the
figure above, item 6 points to the ____. a. | Increase decimal button | b. | Fill Color
button | c. | Currency Style button | d. | none of the
above | | |
|