Basic Excel functions

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

• SUM

• AVERAGE

• 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

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

An absolute reference is designated in a formula by the addition of a _______ sign before and after the cell reference letter.

• %

• $

• &

• #

When using VLookUp, use _______________ if you want to look for approximate matches rather than an exact match.

• True
• False

What function was used to find the lowest grade?

• average

• sum

• min

• max

Which symbol must all formula begin with?

• =
• +
• (
• @