Excel

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

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 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?

• So Excel knows to total the cells before performing the next operation.
• So the total of the cells can be multiplied rather than added.

By default, all cell references are _________ references. 

• Absolute
• Relative

In order to create a single formula to copy to the other rows, use ______ references so the formula calculates the total for each item correctly.

• relative
• relational