True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
Wrapping will create a new line of text within a cell.
|
|
|
2.
|
Rotating will move text from the right side of the cell to the left side of the
cell.
|
|
|
3.
|
Text
in a cell may be aligned by clicking toolbar buttons or by choosing the Cells command on the Format
menu.
|
|
|
4.
|
The
color of the text in a cell may not be changed.
|
|
|
5.
|
Borders may be placed on any or all sides of a cell or range.
|
|
|
6.
|
You
can widen a column by using the Column Width dialog box.
|
|
|
7.
|
The
Merge and Center alignment button is commonly used to center a title across the top of a
worksheet.
|
|
|
8.
|
In
order to change a cell’s appearance, you must first select the cell you want to
change.
|
|
|
9.
|
To
paint a format, you must highlight the cell that you want to format.
|
|
|
10.
|
You
can remove the formats you apply to a cell by choosing Clear on the Tools menu.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
11.
|
When
data is wider than the column, Excel will display which of the following symbols in the
cell? a. | ##### | c. | &&&&& | b. | $$$$$ | d. | ***** | | | | |
|
|
|
12.
|
Which
tab in the Format Cells dialog box contains the options for wrapping and rotating
text? a. | Wrapping | c. | Orientation | b. | Alignment | d. | Position | | | | |
|
|
|
13.
|
The
____ button on the Formatting toolbar is represented by a bucket of paint. a. | Format
Painter | c. | Fill
Color | b. | Drawing | d. | Font Color | | | | |
|
|
|
14.
|
Which
of the following occurs when a format is painted in a cell or range? a. | The data, but
not the format, of the source cell is copied to the destination cell. | b. | The format, but
not the data, of the source cell is copied to the destination cell. | c. | The format and
data of the source cell is copied to the destination cell. | d. | Color is added
to all cells that have been selected. | | |
|
|
|
15.
|
Which
of the following would you use to copy a cell’s format to another cell? a. | Format
Painter | c. | Format
Copier | b. | Conditional formatting | d. | Cell Painter | | | | |
|
|
|
16.
|
What
are formats that have already been created within Excel called? a. | TextFormats | c. | GeneralFormats | b. | NumberFormats | d. | AutoFormats | | | | |
|
|
|
17.
|
Which
of the following is not a choice for aligning cell contents in Excel? a. | align
left | c. | middle | b. | align right | d. | merge and center | | | | |
|
Completion
Complete each sentence or
statement.
|
|
|
18.
|
The
AutoFormat Selection option is found on the Column submenu of the ____________________
menu.
|
|
|
19.
|
Excel
automatically ____________________-aligns a text entry in a cell.
|
|
|
20.
|
Arial
and Times New Roman are examples of ____________________.
|
|
|
21.
|
The
____________________ format displays data in a format designed by the user.
|
|
|
22.
|
A
paintbrush icon identifies the ____________________ button on the toolbar.
|
|
|
23.
|
Bolding, italicizing, and underlining are the most common of the features known as
font ____________________.
|
|
|
24.
|
____________________ affects the way data is shown in a cell.
|
|
|
25.
|
A(n)
____________________ is a combination of formatting characteristics such as alignment, font, border,
or pattern.
|
Matching
|
|
|
Match the format name that follows with the display description
below. a. | General | d. | Number | b. | Scientific | e. | Special | c. | Text | | | | |
|
|
|
26.
|
Displays numerical data that will not be used for calculation
|
|
|
27.
|
Displays either text or numerical data as keyed
|
|
|
28.
|
Displays numerical data that requires a specific format
|
|
|
29.
|
Displays numerical data with a fixed number of places to the right of the decimal
point
|
|
|
30.
|
Displays numerical data in exponential notation
|