Excel Lesson 16 Quiz

Using this function category you can add a hyperlink to a cell (HYPERLINK)

A function has an argument

This function category check arguments for a value or condition. Example: if someone spends over $300, they get $20 off

This function category works in arguments to perform tasks, like converting text to lowercase or replacing text

This allows you to search for a specific function using key words...

This Function Category calculates things like determining a payment (PMT) or interest rate for a loan (RATE).

The "more function" command has all of the following categories EXCEPT

All of the following are under the AutoSum dropdown menu but this

A formula has an argument

Which function is used to find the highest cell value

A function is all of the following EXCEPT

The Average Function is located under the AutoSum Function

This function category will return results like the current date and time (NOW) or the seconds (SECOND).

Under this command you can find additional function categories

The "more function" command has all of the following categories EXCEPT

An example of making a formula with cell references looks like this

This function category includes functions for numerical arguments. 

The COUNT Function counts the number of cells with numerical data in the argument.

An example of a formula using just operations looks like this

Every function has an argument.

Another example of using a formula using cell references is this

A function has commas separating multiple arguments

If you have 5 cells in a column with numbers and one cell with words, how many cells will the COUNT function count

This function category is used for calculations for determining a payment (PMT) or interest rate for a loan (RATE).

You can find Functions under this Tab