EXCEL FUNCTIONS

What function was used to find the lowest grade?

• average

• sum

• min

• max

To display the Letter Grade Equivalent, we can use the ___ function.

• if

• count

• average

• sum

To sort names in a worksheet, we can use this button.

• 
• 
• 
• 

A _________ is a prewritten formula that is built into EXCEL.

• function

• problem

• equation

• equal sign

Formulas can be copied to adjacent cells with the ____________.

• Fill handle

• PgDn Key

• Function key F4

• None of the above

to count any fields containing numbers we use:

• countIF function

• counta function

• count function

• countIFs function

A company needs to highlight with red the salaries more than 8000

• it should use the bucket filler

• it should use the highlighter

• it should use the conditional formatting

• it uses the (A) button on top of the home tab

the structure of countif is:

• contif(criteria,range of cells)

• countif(range of cells, criteria, range of cells)

• countif(range of cells, criteria)

the structure of sumif is:

• sumif(range of cells to be sdded,criteria, range of cells to be tested)

• sumif(criteria,range of cells to be tested)

• sumif(range of cells to be tested,criteria,range of cells to be added)

if statement structure is:

• if(value-if-true,logical-test,value-if-false)

• if(logical-test,value-if-false-value-if-true)

• if(logical-test,value-if-true,value-if-false)