Lesson 5

Question 0

AutoSum

Answer 0

Makes SUM function even easier by calculating the total from the adjacent cell through the first nonnumeric cell, using the SUM function in its formula

Question 1

Argument

Answer 1

The parameters of a function

Question 2

AVERAGE function

Answer 2

Adds a range of cells and then divides by the number of cell entires, determining the mean value of all values in the range

Question 3

COUNT function

Answer 3

Used when you want to determine how many cells in a range contain a number

Question 4

COUNTA function

Answer 4

Returns the number of cells in the selected range that contains text of values, but not blank cells

Question 5

Function

Answer 5

Is a predefined formula that performs a calculation

Question 6

MAX formula

Answer 6

Returns the largest value in a set of values

Question 7

MIN function

Answer 7

Allows you to determine the minimum value in a range of cells

Question 8

NOW function

Answer 8

Returns today’s date and current time, in the default format of mm/dd/yyyy

Question 9

PMT function

Answer 9

Requires a series of inputs regarding interest rates, loan amounts, and loan duration, and then calculates the resulting loan payments

Question 10

SUBTOTAL function

Answer 10

Returns a subtotal for a list

Question 11

SUM function

Answer 11

Totals all of the cells in a range, easily and accurately

Question 12

TODAY function

Answer 12

Returns the current date in a worksheet

Question 13

Trace arrow

Answer 13

Shows the relationship between formulas and the cells they refer to