True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
Formatting can change the actual data of a cell.
|
|
|
2.
|
The Increase Decimal button automatically adds dollar signs and two decimal
places to your data.
|
|
|
3.
|
You can apply formatting before or after you enter data in a cell or
range.
|
|
|
4.
|
You can change the font and font size of any cell or range using the Mini
toolbar.
|
|
|
5.
|
The Format Painter button copies both the cell’s content and
formatting.
|
|
|
6.
|
With Excel, you can adjust the width of one or more columns by using the
Ribbon.
|
|
|
7.
|
When you insert a new column, the contents of the worksheet shift to the left
from the point of the new column.
|
|
|
8.
|
You must apply borders to all the cells in a worksheet; you cannot apply them
only to selected cells.
|
|
|
9.
|
To check the spelling in more than one sheet of a multiple-sheet workbook, you
need to display each sheet and run the spelling checker again.
|
|
|
10.
|
You can add words to the dictionary of the spelling checker.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
11.
|
The ____ of a cell determines how the labels and values look.
a. | value | c. | label | b. | formula | d. | format |
|
|
|
|
|
|
12.
|
As shown in the figure above, item 1 is the ____ list arrow.
a. | Number Format | c. | Commands in Number | b. | Accounting Format | d. | Decimal Number |
|
|
|
|
|
|
13.
|
As shown in the figure above, item 2 points to the ____ button in the Styles
group on the Home tab of the Ribbon.
a. | Format as Table | c. | Format Painter | b. | Cell Styles | d. | Conditional
Formatting |
|
|
|
14.
|
As shown in the figure above, item 3 points to the ____ button in the Styles
group on the Home tab of the Ribbon.
a. | Format as Table | c. | Format Painter | b. | Cell Styles | d. | Conditional
Formatting |
|
|
|
|
|
|
15.
|
The dialog box shown in the figure above is opened by right-clicking a cell and
then clicking ____ on the shortcut menu.
a. | Format | c. | Cells | b. | Format Cells | d. | Fonts |
|
|
|
16.
|
As shown in the figure above, the currently selected font is ____.
a. | Regular | c. | Times New Roman | b. | Calibri | d. | font 11 |
|
|
|
17.
|
The arrow shown in the figure above indicates the ____.
a. | effects size in points | c. | line length in picas | b. | currently selected font | d. | currently selected font
size |
|
|
|
18.
|
A ____ is an individual media file, such as art, sound, animation, or a
movie.
a. | point | c. | clip | b. | cell style | d. | template |
|
|
|
19.
|
____ are styling formats such as bold, italic, and underlining that you can
apply to affect the way text and numbers look in a worksheet.
a. | Attributes | c. | Fonts | b. | Formats | d. | Clip arts |
|
|
|
20.
|
The Format Painter button is found in the ____ group on the Home tab of the
Ribbon.
a. | Alignment | c. | Clipboard | b. | Styles | d. | Font |
|
|
|
21.
|
You can apply attributes and alignment options using the ____ tab of the
Ribbon.
a. | Insert | c. | Page Layout | b. | Home | d. | View |
|
|
|
22.
|
You can apply attributes and alignment options using the ____ dialog box.
a. | Format Cells | c. | Conditional Formatting | b. | Insert | d. | AutoCorrect |
|
|
|
|
|
|
23.
|
As shown in the figure above, item ____ points to the button that italicizes
text.
|
|
|
24.
|
As shown in the figure above, item ____ points to the Center button.
|
|
|
25.
|
You insert a comment in a worksheet by using the ____ tab on the Ribbon.
a. | Home | c. | Insert | b. | Review | d. | View |
|
|
|
26.
|
A small, ____ triangle appears in the upper-right corner of a cell containing a
comment.
a. | red | c. | green | b. | blue | d. | yellow |
|
|
|
27.
|
You can change colors, patterns, and borders of cells by using the Fill tab and
the Border tab in the ____ dialog box.
a. | Page Setup | c. | Insert | b. | AutoCorrect | d. | Format Cells |
|
|
|
28.
|
The formatting due to ____ formatting is automatically updated if you change
data in the worksheet.
a. | conditional | c. | dynamic | b. | spatial | d. | data |
|
|
|
29.
|
The Spelling button is found in the Proofing group on the ____ tab on the
Ribbon.
a. | Home | c. | Review | b. | Page Layout | d. | Data |
|
|
|
30.
|
The Find & Select button is found in the Editing group on the ____ tab on
the Ribbon.
a. | Home | c. | Review | b. | Page Layout | d. | Data |
|
Matching
|
|
|
Identify the letter of the choice that best matches the phrase or
definition. a. | data bar | d. | point | b. | column
width | e. | theme | c. | font |
|
|
|
31.
|
The name for a collection of characters (letters, numerals, symbols, and
punctuation marks) with a similar, specific design.
|
|
|
32.
|
Equal to 1/72 of an inch.
|
|
|
33.
|
A type of conditional formatting that visually illustrates differences among
values.
|
|
|
34.
|
A predefined set of attributes that gives your Excel worksheet a professional
look.
|
|
|
35.
|
Has a default value of 8.43 characters, a little less than one inch.
|