Excel 2013 - Lesson 5 Vocabulary - Using Functions

argument

The parameters of a function.

AutoSum

A formula that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function.

AVERAGE function

A function that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function in its formula.

COUNT function

A function that determines how many cells in a range contain a number.

COUNTA function

A function that returns the number of cells in the selected range that contain text or values, but not blank cells.

function

A predefined formula that performs a calculation.

MAX function

A function that returns the largest value in a set of values.

merged cells

Two or more cells combined into a single cell.

MIN function

A function that determines the minimum value in a range of cells.

NOW function

A function that returns today's date and the current time, in the default format of mm/dd/yyyy hh:mm.

PMT function

A function that requires a series of inputs regarding interest rate, loan amount (principal), and loan duration, and then calculates the resulting loan payment.

SUBTOTAL function

A function that returns a subtotal for a list.

SUM function

A function that totals all of the cells in a range.

TODAY function

A function that returns the current date in a worksheet.

trace arrow

An arrow that shows the relationship between formulas and the cells they refer to in order to resolve a formula error.

argument

The parameters of a function.

AutoSum

A formula that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function.

AVERAGE function

A function that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function in its formula.

COUNT function

A function that determines how many cells in a range contain a number.

COUNTA function

A function that returns the number of cells in the selected range that contain text or values, but not blank cells.

function

A predefined formula that performs a calculation.

MAX function

A function that returns the largest value in a set of values.

merged cells

Two or more cells combined into a single cell.

MIN function

A function that determines the minimum value in a range of cells.

NOW function

A function that returns today's date and the current time, in the default format of mm/dd/yyyy hh:mm.

PMT function

A function that requires a series of inputs regarding interest rate, loan amount (principal), and loan duration, and then calculates the resulting loan payment.

SUBTOTAL function

A function that returns a subtotal for a list.

SUM function

A function that totals all of the cells in a range.

TODAY function

A function that returns the current date in a worksheet.

trace arrow

An arrow that shows the relationship between formulas and the cells they refer to in order to resolve a formula error.