True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
Formatting
affects how information appears in cells and does not alter the data in any way.
|
|
|
2.
|
Formatting
alters the data in cells.
|
|
|
3.
|
The Increase
Decimal button automatically adds dollar signs and two decimal places to your data.
|
|
|
4.
|
Bold,
italics, and underlining are examples of Format Painter.
|
|
|
5.
|
Format
Painter allows you to copy only the format of a cell.
|
|
|
6.
|
The Format
Painter button allows you to change only the color of the specified cells.
|
|
|
7.
|
If you
change the font size of a single cell, Excel will automatically adjust the font size of all the cells
in the worksheet.
|
|
|
8.
|
Point size
is the name given to a collection of characters with a specific design.
|
|
|
9.
|
The physical
size of text is measured in inches.
|
|
|
10.
|
The default
font in Excel is 10 point Arial.
|
|
|
11.
|
Excel
provides 16 preset formats, called AutoFormats, which allow instant formatting of large amounts of
data.
|
|
|
|
|
|
12.
|
The default
column width is a little less that one inch or 8.43 characters wide.
|
|
|
13.
|
The AutoFit
Selection command automatically resizes a worksheet column to fit the widest entry in that
column.
|
|
|
14.
|
Row height
is calculated in units of measure called points.
|
|
|
15.
|
In order for
text to be legible, row height must exceed font size.
|
|
|
16.
|
You might
need to adjust column widths to make a worksheet more useable.
|
|
|
17.
|
You can
adjust both the width of columns and height of rows in an Excel worksheet.
|
|
|
18.
|
If you
choose the Standard Width command from the Format menu, your columns are reset to 1.5
inches.
|
|
|
19.
|
If you
select the Hide command, it will hide all labels in a worksheet.
|
|
|
20.
|
When you
delete a row or column within a range used in a formula you must change the formula.
|
|
|
21.
|
Excel does
NOT automatically adjust formulas when a column or a row is inserted within a range used in a
formula.
|
|
|
22.
|
Borders can
be applied to selected cells in a worksheet.
|
|
|
23.
|
In the
Format Cells dialog box, you can see what your text will look like in the Sample box.
|
|
|
24.
|
Automatically applying formatting attributes based on cell values is called
conditional formatting.
|
|
|
25.
|
Any words
you've added to the dictionary using Word, PowerPoint, and Access are also available in Excel's spell
checker.
|
|
|
26.
|
It is not
necessary to check for spelling errors after formatting.
|
|
|
|
|
|
27.
|
In the
figure above, item 2 displays the currently selected font.
|
|
|
28.
|
In the
figure above, item 3 shows a sample of the selected font which is 10 point Arial, Excel's default
font.
|
|
|
29.
|
The figure
above illustrates the Format Cells dialog box with the Font tab selected.
|
|
|
30.
|
In the
figure above, item 1 points to the available fonts.
|
|
|
31.
|
In the
figure above, item 2 indicates line length in picas.
|
|
|
32.
|
In the
figure above, item 1 points to pattern attribute options.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
33.
|
Formatting
affects how information appears in ____. a. | Boxes | b. | Cells | c. | Formulas | d. | None of the above | | |
|
|
|
34.
|
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 | | |
|
|
|
35.
|
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 | | |
|
|
|
36.
|
A font is
the name given to a collection of ____. a. | Letters | b. | Numerals | c. | Symbols and punctuation marks | d. | All the
above | | |
|
|
|
37.
|
Which
toolbar is used to change fonts and sizes? a. | Standard | b. | Formatting | c. | Both a and b | d. | None of the
above | | |
|
|
|
38.
|
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 | | |
|
|
|
39.
|
Attributes
are font styling features, such as ____. a. | Bold | b. | Italics | c. | Underlining | d. | All of the above | | |
|
|
|
40.
|
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 | | |
|
|
|
41.
|
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 | | |
|
|
|
42.
|
To reset
columns to the default width, select the range of cells, then ____. a. | Position the pointer on
the column line, and double-click the left mouse button | b. | Use the Column Standard
Width command on the Format menu | c. | Both a and b | d. | None of the
above | | |
|
|
|
43.
|
The default
column width is ____. a. | One-half inch | b. | A little less than one
inch | c. | One and one-half
inches. | d. | Two inches | | |
|
|
|
44.
|
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 | | |
|
|
|
45.
|
Row height
must exceed ____. a. | Column
width | b. | Font size | c. | Standard width | d. | Standard
height | | |
|
|
|
46.
|
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 | | |
|
|
|
47.
|
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 | | |
|
|
|
48.
|
Which menu
is used to add a comment to a cell? a. | File | b. | Edit | c. | Insert | d. | Tools | | |
|
|
|
49.
|
Which menu
is used to see all the comments in a worksheet? a. | File | b. | View | c. | Insert | d. | Tools | | |
|
|
|
50.
|
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 | | |
|
|
|
51.
|
Which of the
following CANNOT be accomplished from the Insert dialog box? a. | Shifting cells
down | b. | Shifting cells
left | c. | Inserting a
row | d. | Inserting a
column | | |
|
|
|
52.
|
You can
apply colors, patterns, and borders to a worksheet using the ____. a. | Patterns tab in the
Format Cells dialog box | b. | Borders and Fill Color buttons on the Formatting
toolbar | c. | Both a and b | d. | None of the
above | | |
|
|
|
53.
|
To enhance
the appearance of a worksheet use ____. a. | Colors | b. | Patterns | c. | Borders | d. | All the above | | |
|
|
|
54.
|
Single
underline, double underline, and outline are examples of ____ buttons. a. | Border | b. | Attribute | c. | Pattern | d. | Font | | |
|
|
|
55.
|
To apply
conditional formatting, select Conditional Formatting on the ____ menu. a. | Format | b. | Edit | c. | Insert | d. | None of the above | | |
|
|
|
56.
|
Which
menu is used to send a workbook as an attachment? a. | File | b. | Edit | c. | Insert | d. | Tools | | |
|
|
|
|
|
|
57.
|
In the
figure above, item 2 points to the ____ button. a. | Attribute | b. | Border | c. | Box | d. | Bold | | |
|
|
|
58.
|
In the
figure above, item 4 points to a(n) ____. a. | Attribute button | b. | Alignment
button | c. | Both a and b | d. | None of the
above | | |
|
|
|
59.
|
In the
figure above, item 3 indicates the Fill Color button, which is used to ____. a. | Copy a cell
format | b. | Copy cell contents | c. | Select a cell for
formatting | d. | Apply a color to a cell's background | | |
|
|
|
60.
|
In the
figure above, item 5 points to a(n) ____. a. | Attribute button | b. | Alignment
button | c. | Both a and b | d. | None of the
above | | |
|
|
|
61.
|
In the
figure above, item 1 indicates the application of which formatting attribute? a. | Merging and
centering | b. | Italics | c. | Underlining | d. | Left-align | | |
|
|
|
|
|
|
62.
|
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 | | |
|
|
|
63.
|
In the
figure above, item 3 points to the Percent style button, which can be used to format cells
____. a. | Before data is
entered | b. | After data is entered | c. | In % of total
columns | d. | Both a and b | | |
|
|
|
64.
|
In the
figure above, item 1 points to the ____. a. | Formatting toolbar | b. | Menu
bar | c. | Status
bar | d. | None of the
above | | |
|
|
|
65.
|
In the
figure above, item 2 points to the ____ button. a. | Add Formula | b. | Currency Style | c. | Dollar
Sign | d. | Money
Format | | |
|
|
|
66.
|
In the
figure above, you would use the button labeled ____ to increase the number of decimal places in
selected cells.
|
|
|
67.
|
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 | | |
|
Completion
Complete each sentence or
statement.
|
|
|
68.
|
The Percent
Style button is located on the ____________________ toolbar.
|
|
|
69.
|
The
____________________ Style button adds dollar signs and two decimal places to your
data.
|
|
|
70.
|
____________________ determines how information appears in cells.
|
|
|
71.
|
To format a
cell, you ____________________ it, then apply the formatting you want.
|
|
|
72.
|
____________________ Painter allows you to copy the format of a cell.
|
|
|
73.
|
____________________ is the name given to a collection of characters with a specific
design.
|
|
|
74.
|
The physical
size of text is measured in ____________________.
|
|
|
75.
|
10 pt Arial
is the ____________________ font in Excel.
|
|
|
76.
|
The
____________________ and Center button on the Formatting toolbar centers data across
columns.
|
|
|
77.
|
Data in
cells can be left-, right-, and center-____________________.
|
|
|
78.
|
Data in a
cell can be moved to the left, right, or center of the cell by clicking the appropriate
____________________ button on the Formatting toolbar.
|
|
|
79.
|
Bold,
italics, and underline are examples of font styling features called
____________________.
|
|
|
80.
|
____________________ allows instant formatting of data.
|
|
|
81.
|
Excel
provides 16 preset formats called ____________________.
|
|
|
82.
|
Row height
must exceed ____________________ size.
|
|
|
83.
|
Row height
is calculated in ____________________.
|
|
|
84.
|
The
____________________ feature automatically resizes a column to fit the widest entry.
|
|
|
85.
|
The Column
____________________ Width command resets a column to the default width.
|
|
|
86.
|
One use of
the ____________________ command on the Edit menu is to remove a selected row or
column.
|
|
|
87.
|
You can add
a new column to a worksheet by clicking ____________________ on the menu bar.
|
|
|
88.
|
To delete a
row in a worksheet, click ____________________ on the menu bar, then click Delete.
|
|
|
89.
|
In the
____________________ dialog box, you can choose to add a column or row, or shift data in the active
cells right or down.
|
|
|
90.
|
Share ideas
with teammates by adding ____________________ in selected worksheet cells.
|
|
|
91.
|
To add color
to the background of a cell, click the ____________________ Color list arrow on the Formatting
Toolbar.
|
|
|
92.
|
To add a
diagonal crosshatch pattern to a cell, use the ____________________ tab in the Format Cells dialog
box.
|
|
|
93.
|
You can use
the ____________________ tab in the Format Cells dialog box to add a single underline to a
cell.
|
|
|
94.
|
You can add
patterns and colors to a worksheet using the ____________________ tab in the Format Cells dialog
box.
|
|
|
95.
|
Automatically applying formatting attributes based on cell values is called
____________________ formatting.
|
|
|
96.
|
The Spelling
button is on the ____________________ toolbar.
|
|
|
97.
|
A(n)
____________________ is an individual media file, such as art, sound, animation, or a
movie.
|