Microsoft Excel - Formulae

The function that lets you add up a range of cells or values

• SUM

• AVERAGE

• MIN

• MAX

What function was used to find the lowest grade?

• average

• sum

• min

• max

What function was used to find the highest grade?

• average

• min

• sum

• max

The Count column found on the Grade Count table, can be computed by this function.

• counta

• countif

• count

• countblank

SUM, AVERAGE, IF, MIN and MAX are examples of _______.

• user-defined functions

• online functions

• table functions

• predefined functions

All formulas used within the table are seen on the __________

• cells

• cell reference

• name box

• formula bar

The function COUNT is specific for ___________

• counting cells

• counting numbers

• counting text

• counting tables

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

• 
• 
• 
• 

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

• if

• count

• average

• sum

In the picture, why is D2 through D5 placed in ( paranthesis/Brackets )?

• So Excel knows to total the cells before performing the next operation.

• So the total of the cells can be multiplied rather than added.