Microsoft Excel Functions

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

• SUM

• AVERAGE

• MIN

• MAX

In computing for the % equivalent of Q1 and Q2 the following operators were used ________.

• addition and multiplication

• division and multiplication

• addition and subtraction

• subtraction and division

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

For the highest grade, this remark can be seen __________.

• Superior

• Excellent

• Very Good

• Good

Passing grades are __________.

• 74 and above

• 70 and above

• 69 and above

• 60 and above

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