excel terms

______that allows the user to check for multiple conditions and returns true if all conditions are met and false if any of the conditions are not met.

• conditional formatting

• ADD function

• data validation

• countif function

A feature that creates rows and columns based on values in the selected cells.

• cell style

• avg if function

• data validation

• auto fill

A function that returns the average in a range of cells based on one specified criterion.

• average

• IF

• avg if

• none

Provides an option to autofill data across a row or column using a user-established pattern.

• goal seek

• fill series

• if series

• adding series

A function that allows the user to make a comparison between two values and then returns a true or false result.

• AVG IF FUNCTION

• IF FUNCTION

• COMPARE FUNCTION

• RESULT FUNCTION

A list of commands that are recorded or coded with the purpose of executing the commands using a single command.

• Micro function

• recorder function

• coding function

• macro

This option allows a user to set protection settings on a worksheet with a password.

• workbook protection

• worksheet protection

• saving protection

• excel savings protection

A function that returns the current date.

• Month function

• day function

• Today function

• current function

A function that adds up all of the numbers in a range of cells based on a criterion that the user specifies.

• sum function

• sumif functions

• sumifs function

• adding function

A tool that allows a user to establish the format of data that is entered into cells.

• User function

• ENTER function

• format function

• data validation