Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
By default, when inserting a column in worksheet, the new column is
placed
a. | one column to the left of the last column of the worksheet that contains
data. | b. | immediately to the left of the column containing the active cell. | c. | immediately to the
right of the column containing the active cell. | d. | at the far left of the
worksheet. |
|
|
|
2.
|
If you have accidentally pressed the Delete key while writing a complex formula
in your worksheet, you will be happy to know that there is a(n) __________ button on the Quick Access
toolbar.
a. | Search | b. | Replace | c. | Undo | d. | Redo |
|
|
|
3.
|
Which of these is the SUM function button?
|
|
|
4.
|
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. | Home tab, Styles group. | c. | Page Layout tab,
Page Setup group. | d. | Home tab, Font
group. |
|
|
|
5.
|
What symbol is used to indicate an absolute cell reference?
a. | dollar sign ($) | b. | asterisk (*) | c. | pound or number sign
(#) | d. | exclamation point (!) |
|
|
|
6.
|
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. |
|
|
|
7.
|
To make rows and columns of data easier to identify when they spread across
several pages, you should
a. | create appropriate footers. | b. | click the Page Layout tab, then the Print
Titles button in the Page Setup group, and check Row and column headings in the Print
section. | c. | create appropriate headers. | d. | click the Page Layout tab, then the Print
Titles button in the Page Setup group, and enter row and column ranges in the Print titles
section. |
|
|
|
8.
|
The function that returns the arithmetic mean of the arguments is called
a. | AVERAGE. | b. | SUM. | c. | COUNT. | d. | MAX. |
|
|
|
9.
|
 Where will the newly inserted rows go in
this illustration? a. | above the selected rows | b. | below the selected rows | c. | They will replace
the selected rows | d. | at the top of the
worksheet |
|
|
|
10.
|
What does it mean for a formula to have relative cell references?
a. | The formula only references cells that are adjacent to the active
cell. | b. | The cell references do not change when the formula is copied to a new
cell. | c. | The cell references change when the formula is copied to a new
cell. | d. | The formula contains only actual numbers, not cell
addresses. |
|
|
|
11.
|
Page breaks display as a broken __________ line in a worksheet.
a. | vertical and/or horizontal | b. | yellow | c. | vertical | d. | horizontal |
|
|
|
12.
|
A question that can be answered with true or false is considered a(n)
a. | nested function. | b. | logical test. | c. | argument. | d. | binary
variable. |
|
|
|
13.
|
An Excel workbook consists of multiple “pages” represented by tabs
at the bottom of the Excel window. These are called
a. | ranges. | b. | cells. | c. | tables. | d. | worksheets, or
sheets. |
|
|
|
14.
|
If the value in cell E2 were 67, indicate the value that would be returned by
this function:
=IF(E2>89,”A”,IF(E2>79,”B”,IF(E2>69,”C”,IF(E2>59,”D”))))
|
|
|
15.
|
When writing your own formulas, you must begin each formula with
a. | a space. | b. | a colon (:). | c. | an equals (=)
sign. | d. | an asterisk (*). |
|
|
|
16.
|
To enter data in a cell, the cell must be
a. | active. | b. | in the upper left corner of the worksheet
area. | c. | empty. | d. | all of these. |
|
|
|
17.
|
If you want to customize a print job you can display the Print dialog box
by
a. | clicking Print on the Page Layout tab. | b. | clicking the Office button, then clicking
Print. | c. | pressing Ctrl + P. | d. | b or c |
|
|
|
18.
|
 The icon in cell H2 in this illustration
indicates that the user is using the __________ feature in Excel. a. | AutoComplete | b. | Help | c. | AutoFill | d. | AutoCorrect |
|
|
|
19.
|
Using the Delete key to delete cells
a. | only deletes the cell data. | b. | deletes the cell data and
formatting. | c. | only deletes the cell formatting. | d. | deletes the entire cell from the
worksheet. |
|
|
|
20.
|
The area of the worksheet that contains tabs and commands divided into groups is
called the
a. | sheet tab. | b. | ribbon. | c. | menu bar.
| d. | toolbar. |
|
|
|
21.
|
What does the Merge and Center button in the Home tab, Alignment group
do?
a. | It merges an entire column of cells and centers the data inside the first
row. | b. | It merges an entire row of cells and centers the data inside the first
column. | c. | It merges Excel data into a Word document and centers the text. | d. | It merges the
selected cells and centers the data within the merged cells. |
|
|
|
22.
|
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. | clicking the right mouse button. | b. | double-clicking the right mouse
button. | c. | double-clicking the left mouse button. | d. | clicking the left mouse
button. |
|
|
|
23.
|
You can use the Undo button to reverse
a. | a deletion of cell data. | b. | formatting changes to a
cell. | c. | changes made to cell data. | d. | All of these |
|
|
|
24.
|
Which of the following is not a part of an IF function?
a. | condition | b. | result | c. | value if
true | d. | value if false |
|
|
|
25.
|
If numeric data in a number is too long to display in the cell, what does Excel
do?
a. | It truncates the number. | b. | It displays number symbols (###) to indicate
that the numeric value is too long to display. | c. | It displays asterisks (***) to indicate
that the numeric value is too long to display. | d. | It rounds the
number. |
|