Excel Chapter 3
Multiple Choice
Identify the choice that best completes the statement or answers the question.
____ 1.
By default, all columns in a worksheet
a.
expand automatically to accommodate longer values.
b.
are different widths.
c.
are hidden.
d.
are the same width.
____ 2.
You can adjust a column width to fit the longest entry in the column by positioning the mouse pointer on the right column boundary and
a.
double-clicking the right mouse button.
b.
double-clicking the left mouse button.
c.
clicking the right mouse button.
d.
clicking the left mouse button.
____ 3.
The column width number in the Column Width dialog box represents
a.
the width of the column measured in inches.
b.
the average number of characters in the standard font that will fit in a cell.
c.
the width of the column measured in the typesetting unit called picas.
d.
the width of the column measured in millimeters.
____ 4.
To increase the width of a column using your mouse, position the mouse pointer on the right boundary line in the column header until the mouse pointer turns into a __________, then drag the boundary to the right.
a.
plus sign (+).
b.
hand.
c.
double-headed arrow pointing up and down.
d.
double-headed arrow pointing left and right.
____ 5.
Which of the following is the correct sequence of steps for displaying the Column Width dialog box?
a.
Click the Format button in the Cells group on the Home tab, click Format Cells, and then click Column Width.
b.
Click the Format button in the Cells group on the Home tab, click Format Cells, and then click Alignment.
c.
Click the Format button in the Cells group on the Home tab and then click Column
Width.
d.
Click the Format button in the Cells group on the Home tab and then click AutoFit
Column Width.
____ 6.
In this illustration, the user is
a.
moving data from one cell to another.
b.
changing a row height.
c.
changing a column width.
d.
using the AutoFill feature.
____ 7.
To insert a new row in a worksheet, select __________, and then click the Insert button.
a.
the row above where the row is to be inserted
b.
the row below where the row is to be inserted
c.
the first row of the worksheet

d. the last row of the worksheet
____ 8.
Which of the following is the correct sequence of steps for changing a row height using the Row Height dialog box?
a.
In the Cells group on the Home tab click the Format button and then click Row Height.
b.
In the Cells group on the Home tab click the Format button and then click AutoFit Row
Height.
c.
In the Cells group on the Home tab click the Format button, click Format Cells, and then click Row Height.
d.
In the Cells group on the Home tab click the Format button, click Format Cells, and then click Line Width.
____ 9.
To change the height of a row using your mouse, position the mouse pointer on the boundary line in the row header until the mouse pointer turns into a __________, then drag the boundary to the desired height.
a.
plus sign (+)
b.
hand
c.
double-headed arrow pointing up and down
d.
double-headed arrow pointing left and right
____ 10.
You can use your mouse to change the height of multiple rows at the same time if the rows are
a.
not adjacent to one another.
b.
all the same height to begin with.
c.
not selected.
d.
adjacent to one another.
____ 11.
When a row height is being changed, the row height number that displays represents a measurement in both pixels and
a.
points.
b.
picas.
c.
inches.
d.
millimeters.
____ 12.
By default, when inserting a column in worksheet, the new column is placed
a.
immediately to the right of the column containing the active cell.
b.
one column to the left of the last column of the worksheet that contains data.
c.
immediately to the left of the column containing the active cell.
d.
at the far left of the worksheet.
____ 13.
You can insert a new row in a worksheet by making a cell