Getting Started with Functions

____ is a Math & Trig function that uses a condition to add a certain data.

Using a function as an argument within another function.

• logical function

• Nesting

• expression

The logical test is a condition or expression whose result is either true or false.

• True

• False

The box at the far-left end of the formula bar that you can use to create and navigate to named ranges.

• range name

• name box

If functions may use comparison operators to state condition of greater than or equal to.

• ><

• >=

• <=

• =>

The _______ is the range of cells you want to review.

= ROUND is used to find the lowest value in a range.

• True

• False

_____ is a statistical function that uses criteria to count the number of items in a range.

• sumif

• countif

• averageif

• if

The values and other inputs that a function uses to calculate the result.

• nest

• function

• argument

______finds the highest value in a range of cells.

• =MIN

• =ROUND

• =MAX

• =SUM