Name:     ID: 
 
Email: 

Microsoft Excel Lesson 5

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 non-adjacent 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 5-1

nar001-1.jpg
 

 21. 

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

 22. 

In Figure EX 5-1 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 5-1
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 right-clicking on the active cell
d.
None of the above
 
 
Case EX 5-2
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.
 



 
         Start Over