True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
Formatting changes both the appearance of a worksheet and the data stored in its
cells.
|
|
|
2.
|
You
can use the Copy and Paste commands to copy a format.
|
|
|
3.
|
If
you want to fit text inside a cell, your only option is to wrap the text.
|
|
|
4.
|
The
gridlines that appear in the worksheet window are displayed on the printed page by
default.
|
|
|
5.
|
The
background image does not affect the format or content of any cell in the worksheet.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
6.
|
What
does the General number format do when a cell is not wide enough to show an entire
number? a. | It aligns
numbers at the right side of the cell. | b. | It rounds numbers that contain
decimals. | c. | It uses scientific notation for large
numbers. | d. | Either B or C | | |
|
|
|
7.
|
The
____ tab in the Format Cells dialog box offers the option to center text within a
cell. a. | Text | b. | Alignment | c. | Patterns | d. | Font | | |
|
|
|
8.
|
A set
of letters, numbers, punctuation marks, and symbols with a specific design and size is called a
____. a. | format | b. | template | c. | design
style | d. | font | | |
|
|
|
9.
|
To
open the Page Setup dialog box, click the Setup button on the ____ toolbar. a. | Orientation | b. | Page Setup | c. | Print
Preview | d. | Options | | |
|
|
|
10.
|
To
select a nonadjacent range, select the first range, press and hold the ____ key, and then select the
next range.
|
|
|
11.
|
Which
of the following number format category might be used for recording engineering
data? a. | Accounting | b. | Currency | c. | Scientific | d. | Decimal | | |
|
|
|
12.
|
The
____ number format is the default format. a. | General | b. | Number | c. | Currency | d. | Accounting | | |
|
Short Answer
|
|
|
13.
|
BONUS:
1. How Long is a
String?
2. List all states that
begin with the letter ‘M’
|