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 active in the row below
where the new row is to be inserted. Click the down-pointing arrow next to the Insert button, click
Insert Cells, click __________, and then click OK.
a. | Shift cells down | b. | Entire row | c. | Entire
column | d. | Shift cell right |
|
|
|
14.
|
 Where will the newly inserted rows go
in this illustration? a. | at the top of the worksheet | b. | below the selected rows | c. | above the selected
rows | d. | They will replace the selected rows |
|
|
|
15.
|
 What is the user doing in this
illustration? a. | copying formats from one cell to another | b. | copying data from
one cell to another | c. | changing a column width | d. | changing a row
height |
|
|
|
16.
|
Using the Delete key to delete cells
a. | deletes the cell data and formatting. | b. | deletes the entire cell from the
worksheet. | c. | only deletes the cell formatting. | d. | only deletes the cell
data. |
|
|
|
17.
|
How is clearing cell contents different from deleting cells?
a. | Clearing cells only removes entered data; it does not remove
formulas. | b. | Clearing cell contents gives you the option of removing both data and formatting from
a cell. | c. | Clearing cells is only temporary; the cell contents and formatting are restored when
the workbook is saved. | d. | Clearing cells must be done on an entire row or
column, not on individual cells. |
|
|
|
18.
|
You can add a border to a selected cell or cells by clicking the Borders button
in the
a. | Page Layout tab, Themes group. | b. | Page Layout tab, Page Setup
group. | c. | Home tab, Font group. | d. | Home tab, Styles
group. |
|
|
|
19.
|
What does the Merge and Center button in the Home tab, Alignment group
do?
a. | It merges the selected cells and centers the data within the merged
cells. | b. | It merges Excel data into a Word document and centers the text. | c. | It merges an entire
column of cells and centers the data inside the first row. | d. | It merges an entire
row of cells and centers the data inside the first column. |
|
|
|
20.
|
You can insert cell borders
a. | on all sides of one cell at a time. | b. | on any or all sides of one or more selected
cells. | c. | on the top or left of any selected cells. | d. | on the bottom or
right of any selected cells. |
|
|
|
21.
|
Which of these formatting options can not be found in the Home tab, Font
group?
a. | font size | b. | center | c. | bold | d. | underline |
|
|
|
22.
|
You can change the formatting of one cell by double-clicking it, selecting the
data, and hovering the mouse pointer over the
a. | Format Painter. | b. | Home tab, Alignment group. | c. | Mini
toolbar. | d. | Format Cells dialog box. |
|
|
|
23.
|
When text is too long to fit in a cell, it normally overlaps into the next cell
to the right. If you want it to be contained in the cell but continue on another line, select the
__________ option in the Format Cells dialog box.
a. | Shrink to Fit | b. | Merge Cells | c. | Wrap
Text | d. | Text Direction |
|
|
|
24.
|
Font characteristics for data in a cell can be changed with the Font and Font
Size buttons in the
a. | Home tab, Font group. | b. | Mini toolbar. | c. | a and
b | d. | Home tab, Alignment group. |
|
|
|
25.
|
You can change print margins while in Print Preview mode by clicking the Show
Margins check box and
a. | entering the margin dimensions in inches. | b. | entering the margin
dimensions in millimeters. | c. | clicking the Show Margins check box and
dragging the margin borders to the desired location. | d. | All of these |
|
|
|
26.
|
In Print Preview mode you can increase the size of the display by using the
__________ button.
a. | Zoom | b. | Supersize | c. | Expand | d. | Magnify |
|
|
|
27.
|
Which of these methods can be used to change the size of the worksheet display
in Normal view?
a. | the Zoom slider | b. | the Zoom In button | c. | the Zoom Out
button | d. | All of these |
|
|
|
28.
|
How are gridlines that display in a worksheet different from cell
borders?
a. | Cell borders are part of the cell formatting; gridlines are not. | b. | The attributes of
cell borders can be modified (made thicker or thinner, etc.); gridlines cannot. | c. | By default,
gridlines do not print. | d. | All of these |
|
|
|
29.
|
In Print Preview mode a worksheet is displayed
a. | as it will appear when printed. | b. | in Page Break Preview mode. | c. | with a Zoom setting
set to 100%. | d. | b and c |
|
|
|
30.
|
 In this illustration, the user
is a. | changing the zoom display for a worksheet. | b. | determining the size
of the print display. | c. | modifying formatting to display
percentages. | d. | selecting Print Preview mode. |
|
|
|
31.
|
To give your presentation a professional look, you can apply a predefined set of
colors, fonts, lines and fill effects by
a. | applying a background. | b. | applying a theme. | c. | using the Mini
toolbar. | d. | using the Format Painter. |
|
|
|
32.
|
You can see how a theme will affect your worksheet before you apply it by using
the __________ feature.
a. | Format Painter | b. | Mini toolbar | c. | Zoom
slider | d. | live preview |
|
|
|
33.
|
The Themes button can be found on the __________ tab.
a. | Home | b. | Insert | c. | Page
Layout | d. | View |
|
|
|
34.
|
By default, numbers typed in a cell are formatted to
a. | left-align, with one decimal place and commas for the thousand
separator. | b. | right-align, with no decimals or commas unless they are typed in the
cell. | c. | right-align, with two decimal places and no commas. | d. | left-align, with no
decimals or commas unless they are typed in the cell. |
|
|
|
35.
|
If you enter the value $45.50 into a cell with default formatting, Excel
automatically
a. | rounds the value to a whole number (45). | b. | removes the dollar
sign. | c. | removes the dollar sign and rounds the value up (46). | d. | applies Currency
formatting to the number. |
|
|
|
36.
|
You can specify the formatting for numbers in a cell
a. | only before any data is entered into the worksheet. | b. | either before or
after the number is entered into the cell. | c. | only after the number is entered into the
cell. | d. | only before the number is entered into the cell. |
|
|
|
37.
|
 In this illustration, what will happen
when the Increase Decimal button is clicked? a. | The values in the selected cells will increase by one each time the button is
clicked. | b. | The number of decimal places displayed in the selected cells will increase by one
each time the button is clicked. | c. | The decimal point will move to the left within
the selected values each time the button is clicked. | d. | The decimal point will move to the right within
the selected values each time the button is clicked. |
|
|
|
38.
|
Which of the following number formatting categories can be found in the Format
Cells dialog box?
a. | Accounting | b. | Date | c. | Text | d. | All of these |
|
|
|
39.
|
In which number category can you specify the formatting for Zip codes?
a. | Number | b. | General | c. | Special | d. | Text |
|
|
|
40.
|
The Increase Indent and Decrease Indent buttons in the Home tab, Alignment group
move text
a. | into the cell to the left or right of the selected cell. | b. | into the next or
previous worksheet. | c. | within the selected
cell(s). | d. | into the cell above or below the selected cell. |
|
|
|
41.
|
To reduce the size of the text font so that all selected data fits within a
column, click the __________ option on the Alignment tab in the Format Cells dialog box.
a. | Wrap text | b. | Shrink to fit | c. | Decrease
indent | d. | Merge cells |
|
|
|
42.
|
If you want to enter data on more than one line in a cell, you can enter the
data on the first line and then move the insertion point to the next line in the cell by
a. | clicking the Increase Indent button. | b. | double-clicking the Align Text Right
button. | c. | pressing Ctrl + Enter. | d. | pressing Alt +
Enter. |
|
|
|
43.
|
Which of the following changes in text format can you not make on the
Font tab in the Format Cells dialog box?
a. | color | b. | size | c. | style | d. | orientation |
|
|
|
44.
|
 On which tab of the Format Cells
dialog box can you choose the effect shown here? a. | Alignment | b. | Font | c. | Border | d. | Fill |
|
|
|
45.
|
 In this illustration, the user is
changing a. | a font color. | b. | a border color. | c. | the font
size. | d. | a fill color. |
|
|
|
46.
|
To add a background color to a selected cell, use the __________ button in the
Home tab, Font group.
a. | Borders | b. | Fill Color | c. | Font
Color | d. | Bold |
|
|
|
47.
|
 To achieve the shading shown behind
the text in this illustration, select __________ in the Format Cells dialog box. a. | Fill Effects on the Fill tab | b. | Background Shading on the Font
tab | c. | Color Effects on the Font tab | d. | Shading on the Fill
tab |
|
|
|
48.
|
The Home tab, Clipboard group contains a button called __________ that can be
used to copy formatting to different locations in the worksheet.
a. | Paste | b. | Redo | c. | Drawing | d. | Format Painter |
|
|
|
49.
|
If you want to apply the formatting you have just done to one cell to other
cells in your worksheet, you can use the Repeat command, which is executed by pressing
a. | the Tab key. | b. | F4. | c. | Ctrl +
Y. | d. | b or c |
|
|
|
50.
|
Select the rows or columns you do not want to display on the screen and
click Hide & Unhide
a. | on the Format button in the Cells group on the Home tab. | b. | on the Protection
tab in the Format Cells dialog box. | c. | on the Alignment tab in the Format Cells dialog
box. | d. | in the Window group on the View tab. |
|