MS Excel Functions

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

• SUM

• AVERAGE

• MIN

• MAX

CS or Class Standing is the ___________ of Q1%, Q2% and EXER

• sum

• min

• max

• average

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

Counts the number of cells that contain numbers

• Sum

• Counta

• Count

• Argument

Count the number of cells based on one criteria

• Sumif

• Productif

• Averageif

• Countif

Symbol used to multiply

• $

• &

• .

• *

A_________ is a built in mathematical formula included in excel.

• Function
• Cell
• Formula

Formulas in a cell start with a _______.

• :
• =
• (