Exam 11: Excel Lesson 5: Using Functions

The monthly interest rate is determined by dividing the annual interest rate by 12 ____________________.

You can enter a formula with the AVERAGE, COUNT, MAX, or MIN function in a selected cell by clicking the Sum button arrow in the ____ group on the Home tab, clicking the function name, selecting the appropriate range, and then pressing the Enter key.

The ____________________(logical) function returns a value of TRUE if the argument is false, and FALSE if the argument is true;

Date and time functions can be used to convert serial numbers to a ____.

In the IF function, the second argument determines the value that appears in the cell if the logical test is ____.

An example of the function that returns the number of cells in a range of cells that contain data is ____.

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

FIGURE EX 5-1 In Figure EX 5-1 above, the Pmt figure is -250. The negative number means ____.

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

The primary financial functions are future value, present value, and payment .

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

=ROUND(142.3433,-2) returns 142.34 .

The IFERROR function is written as ____.

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 keyboard shortcut is a shorthand way to write an equation that performs a calculation.

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

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

When you type =s , all functions that begin with the letter s appear in the list box, such as SEARCH, SECON, and SERISSUM.

FIGURE EX 5-1 In Figure EX 5-1 above, the annual interest rate is ____.