Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
An Excel workbook consists of multiple “pages” represented by tabs
at the bottom of the Excel window. These are called
a. | ranges. | b. | worksheets, or sheets. | c. | tables. | d. | cells. |
|
|
|
2.
|
To enter data in a cell, the cell must be
a. | in the upper left corner of the worksheet area. | b. | active. | c. | empty. | d. | all of
these. |
|
|
|
3.
|
If numeric data in a number is too long to display in the cell, what does Excel
do?
a. | It rounds the number. | b. | It displays number symbols (###) to indicate
that the numeric value is too long to display. | c. | It truncates the number. | d. | It displays
asterisks (***) to indicate that the numeric value is too long to
display. |
|
|
|
4.
|
 The icon in cell H2 in this
illustration indicates that the user is using the __________ feature in Excel. a. | Help | b. | AutoComplete | c. | AutoFill | d. | AutoCorrect |
|
|
|
5.
|
The area of the worksheet that contains tabs and commands divided into groups is
called the
a. | menu bar. | b. | toolbar. | c. | ribbon. | d. | sheet tab. |
|
|
|
6.
|
Which of these is the SUM function button?
|
|
|
7.
|
When writing your own formulas, you must begin each formula with
a. | a space. | b. | a colon (:). | c. | an equals (=)
sign. | d. | an asterisk (*). |
|
|
|
8.
|
What symbol is used to indicate an absolute cell reference?
a. | exclamation point (!) | b. | asterisk (*) | c. | pound or number sign
(#) | d. | dollar sign ($) |
|
|
|
9.
|
What does it mean for a formula to have relative cell references?
a. | The cell references change when the formula is copied to a new
cell. | b. | The formula only references cells that are adjacent to the active
cell. | c. | The formula contains only actual numbers, not cell
addresses. | d. | The cell references do not change when the formula is copied to a new
cell. |
|
|
|
10.
|
The function that returns the arithmetic mean of the arguments is called
a. | SUM. | b. | MAX. | c. | COUNT. | d. | AVERAGE. |
|
|
|
11.
|
A question that can be answered with true or false is considered a(n)
a. | nested function. | b. | argument. | c. | binary
variable. | d. | logical test. |
|
|
|
12.
|
Which of the following is not a part of an IF function?
a. | value if true | b. | value if false | c. | condition | d. | result |
|
|
|
13.
|
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”))))
|
|
|
14.
|
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. |
|
|
|
15.
|
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. |
|
|
|
16.
|
 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 |
|
|
|
17.
|
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. |
|
|
|
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.
|
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. |
|
|
|
21.
|
Page breaks display as a broken __________ line in a worksheet.
a. | vertical and/or horizontal | b. | horizontal | c. | yellow | d. | vertical |
|
|
|
22.
|
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 |
|
|
|
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.
|
To make rows and columns of data easier to identify when they spread across
several pages, you should
a. | create appropriate headers. | b. | create appropriate footers. | c. | 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. | d. | 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. |
|
|
|
25.
|
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. | Undo | c. | Replace | d. | Redo |
|