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 | | |
|