Using functions in Excel

Any function in Excel begins with...

• =

• @

• DO

• #

Match each function with what it does

• Finds the highest value

• AVERAGE

• Finds the mean of the values

• SUM

• Finds the total of the values

• MAX

• Finds the lowest value

• MIN

• Rounds the value (to decimal places)

• ROUND

What is the result of

= SUM(A1 : A3)

Mathematical Equivalence

ON

What is the result of

= AVERAGE(A1 : A3)

Mathematical Equivalence

ON

What is the result of

= MAX(B1 : B4)

Mathematical Equivalence

ON

What is the result of

= MIN(B1 : C4)

Mathematical Equivalence

ON

What is the result of

= ROUND(C3,1)

Mathematical Equivalence

ON

What is the result of

= ROUND(C4,2)

Mathematical Equivalence

ON

What is the result of

= ROUND(C1,0)

Mathematical Equivalence

ON

What is the result of

= SQRT(B1 + B2)

Mathematical Equivalence

ON