Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
1.
|
The Insert Function dialog box allows you to
a. | get help on how to use a function. | b. | select a function from a drop-down
list. | c. | search for a function. | d. | All of these |
|
|
|
2.
|
When writing your own formulas, you must begin each formula with
a. | a space. | b. | a colon (:). | c. | an equals (=)
sign. | d. | an asterisk (*). |
|
|
|
3.
|
When creating a formula by pointing to cell references instead of typing them,
what happens to the cell to which you are pointing?
a. | A temporary moving border is placed around the cell. | b. | The cell is shaded
yellow. | c. | The cell contents are displayed in a bold font. | d. | b and
c |
|
|
|
4.
|
 In this illustration, the border
around cell B2 indicates that the formula in cell D2 is being a. | copied by dragging the fill handle. | b. | modified by using the Trace Error
button. | c. | written with the AutoSum button. | d. | written by pointing to cell
references. |
|
|
|
5.
|
Functions require inputs upon which to operate. The inputs, which can be numbers
or cell references, are called
a. | arguments. | b. | results. | c. | nests. | d. | quarrels. |
|
|
|
6.
|
What does the COUNT function count?
a. | the number of numeric values in a range | b. | the number of text
values in a range | c. | the number of worksheets in a
workbook | d. | the number of non-blank cells in a range |
|
|
|
7.
|
What does it mean for a formula to have a mixed cell reference?
a. | It has an error in the cell reference. | b. | It has a cell reference in which one component
(row or column) is relative, while the other is absolute. | c. | It has a cell
reference that comes from a worksheet other than the active worksheet. | d. | It has cell
references that come from more than one worksheet. |
|
|
|
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.
|
Which of the following formulas shows an example of a mixed cell
reference?
a. | =$A$3 | b. | =$A$3+B3 | c. | =A3+B3 | d. | =$A$3+B$3 |
|
|
|
11.
|
If you enter the formula =SUM(A2:C2) in cell D2, what will happen if you copy it
to cell D3?
a. | The formula will change to =SUM(A3:C3). | b. | The formula will
change to =SUM(B2:D2). | c. | The formula will change to
=SUM(B3:D3). | d. | The formula will not change. |
|
|
|
12.
|
The function that returns the arithmetic mean of the arguments is called
a. | SUM. | b. | MAX. | c. | COUNT. | d. | AVERAGE. |
|
|
|
13.
|
If you have a range of cells containing employee salaries, what function would
you use to return the highest value in the range?
a. | MIN | b. | AVERAGE | c. | MAX | d. | COUNT |
|
|
|
14.
|
An absolute cell reference __________ change when copied to another cell.
a. | will always | b. | does | c. | does
not | d. | can sometimes |
|
|
|
15.
|
A built-in formula, such as =SUM, is called a(n)
a. | argument. | b. | operator. | c. | function. | d. | constant. |
|
|
|
16.
|
What happens to formulas with relative cell references when they are copied
using the fill handle?
a. | An error occurs. | b. | The formula is copied into the selected
cell(s), but with absolute rather than relative references. | c. | The value in the
active cell, rather than the formula, is copied into the selected cell(s). | d. | A relative version
of the formula is copied into the selected cell(s). |
|
|
|
17.
|
In terms of an Excel formula, what is a constant?
a. | a relative cell reference entered into a formula | b. | an absolute cell
reference entered into a formula | c. | a value entered directly into a
formula | d. | text that is entered into a formula |
|
|
|
18.
|
When a function is included in an argument within a function, it is referred to
as a __________ function.
a. | circular | b. | nested | c. | combination | d. | double |
|
|
|
19.
|
The process of calculating a formula and inserting the value in a cell is
referred to as
a. | layering. | b. | nesting. | c. | returning the
result. | d. | a what-if scenario. |
|
|
|
20.
|
Which of the following is not one of the categories of functions offered
by Excel?
a. | Statistical | b. | Logical | c. | Financial | d. | Geographical |
|
|
|
21.
|
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. |
|
|
|
22.
|
An IF function has __________ parts.
|
|
|
23.
|
Which of the following is not a part of an IF function?
a. | value if true | b. | value if false | c. | condition | d. | result |
|
|
|
24.
|
What does the MIN function return?
a. | the highest value in a range | b. | the lowest value in a range | c. | the value in a range
with the fewest number of characters | d. | the first negative number in a
range |
|
|
|
25.
|
Indicate what the following formula will do: =B2/C2
a. | It will divide the contents of cell B2 by the contents of cell
C2. | b. | It will multiply the contents of cell B2 by the contents of cell
C2. | c. | It will divide the contents of cell C2 by the contents of cell
B2. | d. | It will display the text “B2/C2” in the active
cell. |
|
|
|
26.
|
 What button is displayed next to the
word “Hours” in row 46? a. | Show Formulas | b. | AutoSum | c. | Trace Error
| d. | Find and Select |
|
|
|
27.
|
 This illustration shows an example of
a. | a nested IF condition. | b. | the Trace Error button. | c. | the AutoSum
button. | d. | the Insert Function dialog box. |
|
|
|
28.
|
The Trace Error button allows you to __________ the potential error in your
formula.
a. | ignore | b. | get help on | c. | edit | d. | All of these |
|
|
|
29.
|
The Trace Error button is a type of
a. | wizard. | b. | tool tip. | c. | smart
tag. | d. | task pane. |
|
|
|
30.
|
To copy data or formulas using the fill handle, first position the mouse pointer
on the desired fill handle until it turns into a
a. | hand. | b. | double-headed arrow pointing left and
right. | c. | thin, black plus sign. | d. | smiley face. |
|
|
|
31.
|
 The Function Arguments palette shown
here displays as part of the __________ feature. a. | AutoSum | b. | Insert Function | c. | Task
pane | d. | Ask a Question |
|
|
|
32.
|
When typing a formula into a cell, by default what happens when the formula is
complete and you exit the cell?
a. | You are prompted to confirm the syntax of the formula. | b. | The formula displays
in the cell. | c. | The results of the formula display in the cell. | d. | A border is
automatically placed around the cell. |
|
|
|
33.
|
Excel uses the same order of operations used in
a. | calculus. | b. | geometry. | c. | trigonometry. | d. | algebra. |
|
|
|
34.
|
 In this illustration, the first cell
reference in the formula in cell B3 ($A3) is an example of a(n) a. | mixed cell reference. | b. | nested IF condition. | c. | relative cell
reference. | d. | absolute cell reference. |
|
|
|
35.
|
 What function is being inserted in
this illustration?
|
|
|
36.
|
To find the future value of a series of equal payments (to an investment
account, for example), you would use the __________ function.
|
|
|
37.
|
How is it possible for Excel to perform calculations on date values?
a. | Dates are represented as serial numbers. | b. | Excel cannot perform
calculations on date values. | c. | Each date component (month, day, year) is
treated as an individual numeric value. | d. | Dates are converted to the Julian
calendar. |
|
|
|
38.
|
Which of the following is an example of a nested IF condition?
a. | =IF(SUM(A2:C2)>5, “High”,”Low) | b. | =IF(E2>89,”A”,IF(E2>79,”B”,IF(E2>69,”C”,IF(E2>59,”D”)))) | c. | =IF(E2>89,B2,C2) | d. | =IF(E2>89,SUM(B2:C2),COUNT(C2:D2)) |
|
|
|
39.
|
 This illustration shows an example of
a a. | financial function. | b. | nested IF condition. | c. | single IF
condition. | d. | statistical function. |
|
|
|
40.
|
 In the Insert Function dialog box
shown here, what happens if you choose the PMT function in the Select a function list box ,
and then click OK? a. | The function will be inserted into the active cell. | b. | The Function
Arguments dialog box will display. | c. | An error will occur because the PMT function
requires arguments. | d. | Default values will be chosen for the required
arguments, and the function will be inserted into the active cell. |
|
|
|
41.
|
Because the IF function makes a logical test and then performs a particular
action if the answer is true and another action if the answer is false, it is referred to as a
__________ function.
a. | testing | b. | nested | c. | circular | d. | conditional |
|
|
|
42.
|
Which of the following is not one of the arguments needed by the PMT
function?
a. | Present value (Pv) | b. | Number of payments (Nper) | c. | Payment
(Pmt) | d. | Interest rate (Rate) |
|
|
|
43.
|
The PMT function is one of Excel’s financial functions. What
does it return?
a. | the periodic payment for a loan based on constant payments and a constant interest
rate | b. | the amount of interest paid on a loan | c. | the number of months needed to pay off a
loan | d. | the amount of principal paid on a loan |
|
|
|
44.
|
If one of the cells in a range of cells you use as an argument for an AVERAGE
function contains text instead of numbers, what will Excel do?
a. | return an error message | b. | convert the text to a number and calculate the
average | c. | ignore the text and calculate the average | d. | replace the text
with a zero (0) |
|
|
|
45.
|
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”))))
|
|
|
46.
|
 In this illustration, what is the
“B3:M3” entry in the Number1 text box? a. | the range of cells into which the AVERAGE function will be
inserted | b. | the cell boundaries of the active worksheet | c. | the range of cells
upon which the AVERAGE function will be calculated | d. | the address of the active
cell |
|
|
|
47.
|
When you type a formula into a cell in your worksheet, the formula appears in
the cell and in the
a. | Menu bar. | b. | Name box. | c. | Formula
bar. | d. | Status bar. |
|
|
|
48.
|
Instead of typing dollar signs ($), which function key can you press repeatedly
to change a cell reference to absolute, relative, or mixed?
|
|
|
49.
|
What will happen if you press Ctrl + ` (grave accent)?
a. | The worksheet will display formulas instead of results. | b. | The active worksheet
will be sent to the printer immediately. | c. | The current date and time will be inserted into
the active cell. | d. | All formulas will be recalculated. |
|
|
|
50.
|
Excel 2007 treats date values as serial numbers, counting the number of days
since
a. | January 1, 0000. | b. | January 1, 1000. | c. | January 1,
1900. | d. | January 1, 2000. |
|