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.
|
A document created in Excel is referred to as a
a. | workbook. | b. | cell. | c. | table. | d. | database. |
|
|
|
3.
|
You can make a cell active by left-clicking in it, or you can use
a. | the vertical scroll bar. | b. | the title bar. | c. | the Go To
feature. | d. | the horizontal scroll bar. |
|
|
|
4.
|
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. |
|
|
|
5.
|
In the worksheet area, the cell containing the insertion point is surrounded by
a thick, black border and is known as the __________ cell.
a. | active | b. | main | c. | title | d. | working |
|
|
|
6.
|
 As shown here, the name box
displays a. | the name of the active worksheet. | b. | the cell address of the active cell.
| c. | the name of the active workbook. | d. | the cell address of the upper left cell of the
display. |
|
|
|
7.
|
Which of the following is not a valid name for an Excel workbook?
a. | MyBudget.xls | b. | mybudget_version2.xls | c. | MyBudget*.xls
| d. | mybudget2.xls |
|
|
|
8.
|
The horizontal and vertical scroll bars
a. | shift the values stored in the cells. | b. | change the active cell, but do not change which
cells are displayed on the screen. | c. | shift the display of cells and change the
active cell. | d. | shift the display of cells, but do not change the active
cell. |
|
|
|
9.
|
What happens if you enter text into a cell and it is too long to fit in the
cell?
a. | The text is truncated; that is, the extra characters are chopped
off. | b. | The extra text is stored in the next cell to the right. | c. | No text is stored in
the cell until you make the cell wider. | d. | The text overlaps into the cell to the right,
but it is not stored in that cell. |
|
|
|
10.
|
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. |
|
|
|
11.
|
There are several ways to save an Excel workbook. Which of the following
is not one of them?
a. | pressing Alt + S | b. | clicking the Save button on the Quick Access
toolbar | c. | pressing Ctrl + S | d. | clicking the Office button and then
Save |
|
|
|
12.
|
If you have an Excel workbook named BudgetAnalysis.xls, which of the following
names could not be used for another workbook in the same location (folder)?
a. | budgetanalysis.xls | b. | budgetanalysis2.xls | c. | BudgetAnalysis_2.xls | d. | BudgetAnalysis2.xls |
|
|
|
13.
|
When you have finished editing the data in a cell, you must get out of Edit
mode. Which of the following will not accomplish this?
a. | pressing Shift + Tab | b. | pressing Tab | c. | pressing
Enter | d. | pressing Home |
|
|
|
14.
|
The AutoCorrect feature in Excel automatically corrects
a. | errors in formulas. | b. | common typing errors. | c. | every
misspelling. | d. | errors in cell formatting. |
|
|
|
15.
|
Which of the following methods will close the current workbook, but not
exit Excel?
a. | double-clicking the Office button at the left side of the menu
bar | b. | clicking the Close button on the title bar (the upper-most Close button in the upper
right corner of the screen) | c. | clicking the Save button on the Quick Access
toolbar | d. | clicking the Office button and then Close |
|
|
|
16.
|
 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 |
|
|
|
17.
|
The AutoFill feature in Excel works with a series of
a. | sequential even numbers (2, 4, 6, 8). | b. | days of the week (Monday, Tuesday,
Wednesday). | c. | sequential numbers (1, 2, 3,4). | d. | All of these |
|
|
|
18.
|
 In this illustration, what happens
when the fill handle is dragged to the right (into column F)? a. | The values for cells B2 through F2 are erased. | b. | Cell F2 becomes the
active cell, but no data is entered into it. | c. | A value of 101 is entered into cell
F2. | d. | A value of 100 is entered into cell F2. |
|
|
|
19.
|
An Excel workbook can be opened by clicking the Open button on the Quick Access
toolbar, or by pressing
a. | Alt + W. | b. | Ctrl + O. | c. | Ctrl +
F. | d. | Alt + O. |
|
|
|
20.
|
When would you want to select groups of cells in a worksheet?
a. | to change the alignment of data in the cells | b. | to change the cell
formatting | c. | a or b | d. | None of these |
|
|
|
21.
|
Using the keyboard, you can select an entire column of cells by pressing
a. | Alt + Home. | b. | Shift + Home. | c. | Ctrl + spacebar in
the desired column. | d. | Ctrl + Shift + spacebar in the desired
column. |
|
|
|
22.
|
You can select adjacent cells with your mouse by
a. | clicking and dragging over the desired cells. | b. | right-clicking each
desired cell in turn. | c. | left-clicking each desired cell in
turn. | d. | all of these. |
|
|
|
23.
|
You can select non-adjacent cells with your mouse by
a. | right-clicking each desired cell in turn. | b. | holding down the
Shift key while clicking the desired cells. | c. | holding down the Ctrl key while clicking the
desired cells. | d. | clicking and dragging across each desired cell. |
|
|
|
24.
|
To select all cells from the active cell to the beginning of the row, you
press
a. | Shift + Ctrl + End. | b. | Shift + spacebar. | c. | Shift +
Home. | d. | Ctrl + spacebar. |
|
|
|
25.
|
The quickest way to select all cells in a worksheet with your mouse is to
click
a. | each row header in turn. | b. | each column header in turn. | c. | and drag over all
cells in the worksheet. | d. | the Select All button in the upper left corner
of the worksheet area. |
|
|
|
26.
|
How do you select specific characters within a cell (rather than the whole
cell)?
a. | Press the Tab key to navigate to the desired cell. | b. | Double-click in the
desired cell. | c. | Right-click in the desired cell. | d. | Click in the desired
cell. |
|
|
|
27.
|
If you want to edit only a portion of the data in a cell, first __________ the
cell to make the cell active and move the insertion point inside the cell.
a. | double-click | b. | right-click | c. | double-right-click | d. | left-click |
|
|
|
28.
|
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. |
|
|
|
29.
|
Which of these is not a valid method for printing a worksheet in Excel
2007?
a. | Click the Quick Print button on the Quick Access toolbar. | b. | Click the Office
button, point to the Print option and click Quick Print. | c. | Click Ctrl + P, then
OK. | d. | Click File, then Print, then OK. |
|
|
|
30.
|
 To modify the AutoCorrect options
shown in the illustration, a. | click the Review tab, then click the AutoCorrect Options button in the Proofing
group. | b. | click the Office button, click Excel Options, click Proofing, then click the
AutoCorrect Options button. | c. | click Ctrl + O, then click the AutoCorrect
Options button in the Proofing group. | d. | None of these |
|
|
|
31.
|
Which of the following methods can be used to add a column of numbers?
a. | Click the Sum button in the Editing group on the Home tab. | b. | Click the Sum button
in the Function Library group on the Formulas tab. | c. | Press Alt + =. | d. | All of
these |
|
|
|
32.
|
Which of these is the SUM function button?
|
|
|
33.
|
Clicking the Quick Print button will print
a. | the active worksheet. | b. | the active cell. | c. | the selected
cells. | d. | all worksheets in the workbook. |
|
|
|
34.
|
 As shown here, what happens when OK is
clicked? a. | The value “C7” is inserted into the active cell. | b. | The contents for
cell C7 are erased. | c. | The insertion point is moved to cell
C7. | d. | All cells from the active cell to cell C7 are
selected. |
|
|
|
35.
|
One of the features Excel offers to help with data entry is the AutoComplete
feature, which automatically
a. | inserts data in a cell that begins the same as a previous entry. | b. | corrects many
typographical errors. | c. | inserts word, numbers, or formulas in a
series. | d. | adds dollar signs to currency data. |
|
|
|
36.
|
When a cell containing data is active, anything you type will
a. | be added to the beginning of the existing data. | b. | be replaced by the
existing data. | c. | be added to the end of the existing data. | d. | take the place of
the existing data. |
|
|
|
37.
|
If you have consecutive cells that will store a sequence of numbers, you can use
the __________ feature to enter data into them quickly.
a. | AutoFill | b. | AutoCorrect | c. | AutoSeries | d. | AutoComplete |
|
|
|
38.
|
The individual cells in the Excel worksheet area are identified by a letter and
number combination, such as A2, known as the
a. | cell name. | b. | formula. | c. | URL. | d. | cell address or cell
reference. |
|
|
|
39.
|
You can copy a formula to other cells quickly by using
a. | the Fill handle. | b. | AutoComplete. | c. | the SUM
button. | d. | the Go To feature. |
|
|
|
40.
|
Excel’s Help feature is
a. | available only in printed manuals. | b. | an on-screen reference manual containing
information about all of Excel’s features and commands. | c. | available on the
Microsoft web site. | d. | b and c |
|
|
|
41.
|
The default typeface format for data in cells is
a. | bold. | b. | 10-point Arial. | c. | underlined. | d. | 11-point
Calibri. |
|
|
|
42.
|
In the default formatting for an Excel worksheet, text is __________-aligned and
numbers are __________-aligned.
a. | left; right | b. | right; left | c. | right;
right | d. | left; left |
|
|
|
43.
|
Which of the following can be used for formatting data in an Excel 2007
worksheet?
a. | Table Styles and Cell Styles | b. | AutoFormat | c. | AutoFormat and Cell
Styles | d. | AutoComplete |
|
|
|
44.
|
Hovering your mouse pointer over a cell style option allows you to
a. | preview how your data will look when formatted for Currency. | b. | compare different
background colors for your data. | c. | see the effect of various
headings. | d. | All of these |
|
|
|
45.
|
Which method can you use if you want to customize Help and search only the Excel
Help resources available offline?
a. | Click the Office button, click Excel Options, click Customize, click Offline
Help. | b. | Click the Home tab, click the down-pointing arrow in the Editing group, click
Content from this computer. | c. | Click the Office Excel Help button, click the
down-pointing arrow next to Search, click Excel Help in the Content from this computer
section. | d. | Click the Offline Help button on the Quick Access
toolbar. |
|
|
|
46.
|
Which of these provides help in Excel 2007?
a. | function key F1 | b. | the question mark in a circle
button | c. | hovering the mouse pointer over a button | d. | All of
these |
|
|
|
47.
|
In addition to its worksheet cell, where else is a data value displayed in
Excel?
a. | Name box | b. | Formula bar | c. | Title
bar | d. | Status bar |
|
|
|
48.
|
Which of the following symbols is permitted in a workbook file name?
a. | question mark (?) | b. | colon (:) | c. | space
(spacebar) | d. | forward slash (/) |
|
|
|
49.
|
An Excel worksheet recalculates all its formulas whenever you change a value.
What is the term commonly used to describe this?
a. | AutoRecalc | b. | “Always
up-to-date” | c. | QuickCalc | d. | “What-if” analysis |
|
|
|
50.
|
What is the name of the area at the bottom of the Excel screen that shows the
Zoom level, the viewing mode, and whether you are in Edit or Ready mode?
a. | Screen tab | b. | Scroll bar | c. | Status
bar | d. | Ribbon |
|