Excel Formulas and Function Quiz

A function that returns the largest values in a set of values

• MAX function
• AVERAGE function
• MIN function
• SUM function

A function that determines the minimum value in a range of cells

• MIN function
•  MAX function
•  SUM function
• AVERAGE function

A predefined formula that performs a calculation

• Function
• AutoSum
• Value
• Variable

A function that totals all of the cells in a range

• SUM function
• MIN function
• MAX function 
• AVERAGE function

Write a FORMULA or FUNCTION for the following:

Add cells A1 and B1

• A1 + B1

• =A1 + B1

• =SUM(A1+B1)

• SUM(A1+B1)

Write a FORMULA or FUNCTION for the following:

Add a range of cells C4 to C15

• =SUM(C4:C15)

• SUM(C4:C15)

• =SUM C4:C15

• =ADD(C4:C15)

Write a FORMULA or FUNCTION for the following:

Multiply cells A1 and B1

• A1 * B1

• =A1 * B1

• MULTIPLY(A1:B1)

• =A1 x B1

Write a FORMULA or FUNCTION for the following:

Find the average of the range of cells C1 through C20

• AVERAGE(C1:C20)

• =AVG C1:C15

• =AVERAGE C1:C15

• =AVERAGE(C1:C20)

Write a FORMULA or FUNCTION for the following:

Find the smallest number in the range of cells C1 through C20

• MAX(C1:C20)

• =LARGEST(C1:C15)

• =MAX C1:C15

• =MIN(C1:C20)

Write a FORMULA or FUNCTION for the following:

Subtract 12 from the sum of the range of cells A2 to A10

• =SUM(A2:A10) - 12

• SUM(A2:A10) - 12

• =12 - SUM(A2:A10)

• =SUM(A2:A10)