True/False Indicate whether the
statement is true or false.


1.

If a function contains more than one argument, semicolons separate the
arguments.


2.

Because Excel includes so many functions, the best way to select a function is
from the Excel Help.


3.

You can use the SUM function to total the values stored in up to 255
nonadjacent cells or ranges.


4.

Some mathematical operations, such as addition, subtraction, multiplication, and
division, do not require functions.


5.

Logical functions can determine the average, standard deviation, or variance of
a range of data.


6.

In the IF function, the first argument sets a condition for comparison, called a
relative test.


7.

Date and time functions are used to format and work with cell contents.


8.

A text function can be used to convert text in a cell to all uppercase or
lowercase letters.


9.

You must use double brackets to enclose the text you want the IF function to
return in the second and third arguments.


10.

The rounding operation requires two arguments, which are separated by a
comma.

Multiple Choice Identify the
choice that best completes the statement or answers the question.


11.

You can use the Insert Function dialog box to find a specific function. In the
____ box, type a brief description of what you want to do. Then, click Go.
a.  Directory  c.  Search for a function  b.  Find
what  d.  Go
to 


12.

____ helps you enter a formula with a valid function name and arguments. As you
begin to type the function name, a list of function names appears below the active cell.
a.  Formula Complete  c.  Formula Selector  b.  Formula Now  d.  Formula
AutoComplete 


13.

An example of the function of the natural logarithm of a number written
correctly is ____.
a.  =LOG(50)  c.  =NL(50)  b.  =LN(50)  d.  =(NL,50,2) 


14.

An example of the function that returns the number of cells in a range of cells
that contain data is ____.
a.  =NUMBER(B4)  c.  =NUMBER(B4:B15)  b.  =COUNT(B4)  d.  =COUNT(B4:B15) 


15.

The function ____ returns the estimated variance of the numbers in the
range.
a.  VAR(number1,number2...)  c.  ESTVAR(number1,number2...)  b.  EVAR(number1,number2...)  d.  EV(number1,number2...) 


16.

The present value of a loan based on equal payments is written as ____.
a.  PV(rate,nper,pmt,fv,type)  c.  PV(rate,nper,pmt,term)  b.  PVAL(rate,nper,pmt,fv,type)  d.  PVAL(rate,nper,pmt,term) 


17.

The AND function returns the result of ____ if any or all of the arguments are
false.
a.  TRUE  c.  ERROR  b.  FALSE  d.  none of the
above 


18.

Date and time functions can be used to convert serial numbers to a ____.
a.  month  c.  year  b.  day  d.  all of the
above 


19.

The ____ function returns the current date and time based on the
computer’s date and time settings.
a.  NOW( )  c.  CURRENT( )  b.  WHEN( )  d.  DATE( ) 


20.

The ____ function replaces existing text in a specified cell with new
text.
a.  FIND AND REPLACE  c.  SUBSTITUTE  b.  WRITE OVER  d.  REPLACE 



FIGURE EX 51


21.

In Figure EX 51 above, the annual interest rate is ____.
a.  .015%  c.  1.5%  b.  0.15%  d.  15% 


22.

In Figure EX 51 above, the Pmt figure is 250. The negative number means
____.
a.  the entry is income  c.  there is an error  b.  the entry is a payment  d.  the person is behind on their
payments 



Case EX 51 Cheryl is planning to use Formula AutoComplete to help her
enter some formulas in her new worksheet.


23.

What should Cheryl do to access Formula AutoComplete to help her write her
formulas?
a.  Type the first letters in a cell  b.  Click Formula AutoComplete on the
Ribbon  c.  Open the AutoComplete Wizard by rightclicking on the active cell  d.  None of the
above 



Case EX 52 Sam is using the functions within Excel to complete
questions in a school homework assignment.


24.

Sam needs to find the average of a range of numbers. What would be an example of
a formula written correctly?
a.  =AVG(E4,E9)  c.  =AVG(E4:E9)  b.  =AVERAGE(E4:E9)  d.  +AVERAGE(E4:E9) 


25.

Sam needs to round some figures in a worksheet. The Round function is considered
to be a _____ function.
a.  date and time  c.  mathematical  b.  financial  d.  statistical 

Matching



Identify the letter of the choice that best matches the phrase or
definition.
a.  Mathematical functions  b.  Text
functions  c.  Financial functions  d.  Statistical functions  e.  Date and time
functions 


26.

Functions used to describe large quantities of data.


27.

Functions that are used to insert dates and times in a worksheet.


28.

Functions used to analyze loans and investments.


29.

Functions that are used to format and work with cell contents.


30.

Functions, such as the square root functions, that manipulate quantitative data
in a worksheet.
