True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
You
must enter an ampersand (&) as the first character in a function formula so that Excel will
recognize it as a formula.
|
|
|
2.
|
The
ROUND function is used to round up, or sum, the values in a selected range.
|
|
|
3.
|
To
calculate the standard deviation of the number contained in the range of the argument, you would use
the STDEV function.
|
|
|
4.
|
You
would use the GHK function to calculate the payment for a loan based on constant payments and a
constant interest rate.
|
|
|
5.
|
You
can use the DATE function to display dates in many different formats.
|
|
|
6.
|
Logical functions may be used to display text or values if certain conditions
exist.
|
|
|
7.
|
Function formulas are special formulas that do not use operators to calculate a
result.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
8.
|
Which
of the following functions determines the payment needed each period to repay a
loan?
|
|
|
9.
|
Which
of the following functions determines the current value of an investment that will return a series of
equal payments in the future?
|
|
|
10.
|
Which
of the following functions will display today's date in a worksheet? a. | DATE | c. | NOW | b. | DAY | d. | PRESENT | | | | |
|
|
|
11.
|
Which
of the following functions will display the current time in a worksheet? a. | CLOCK | c. | NOW | b. | DATE | d. | PRESENT | | | | |
|
|
|
12.
|
What
is the purpose of the COUNT function? a. | It determines the number of cells in a
range. | b. | It determines the number of empty cells in a
range. | c. | It determines the number of filled cells in a
range. | d. | It determines the number of columns in a
range. | | |
|
|
|
13.
|
Which
of the following is not a part of a function formula? a. | equal
sign | c. | function
name | b. | Formula
Palette | d. | argument | | | | |
|
|
|
14.
|
Which
of the following functions shows the square root of the number identified in the
argument?
|
|
|
15.
|
The
____ function displays the number of cells with numerical values in the argument
range. a. | VAR | c. | MAX | b. | AVERAGE | d. | COUNT | | | | |
|
|
|
16.
|
Which
function displays the future value of a series of equal payments?
|
|
|
17.
|
Which
of the following functions displays the date or time based on the computer’s
clock?
|
Completion
Complete each sentence or
statement.
|
|
|
18.
|
The
____________________ is a value, cell reference, range, or text that acts as an operand in a function
formula.
|
|
|
19.
|
The
AutoSum feature actually applies the ____________________ function.
|
|
|
20.
|
The
____________________ function displays the largest value contained in a range.
|
|
|
21.
|
If
you want to find the present value of an investment you should choose the ____________________
financial function.
|
|
|
22.
|
____________________ and reference functions may be used to find cell contents and use
them as data in another part of the worksheet.
|
|
|
23.
|
____________________ functions and _____________________ functions manipulate
quantitative data in a worksheet.
|
|
|
24.
|
The
function _____________________ displays the square root of the number identified in the
argument.
|
|
|
25.
|
______________________ functions are used to describe large quantities of
data.
|
Matching
|
|
|
Assume C3 contains the value of 5, C4 the value of 7, and C5 the value of 9. Match
the following functions with the value the function would display below. a. | =SUM(C3:C5) | d. | =MIN(C3:C5) | b. | =COUNT(C3:C5) | e. | =AVERAGE(C3:C5) | c. | =MAX(C3:C5) | | | | |
|
|
|
26.
|
9
|
|
|
27.
|
21
|
|
|
28.
|
3
|
|
|
29.
|
7
|
|
|
30.
|
5
|