WorksheetsUsing functions in Excel
Total questions: 10
Worksheet time: 6mins
Name
Class
Date
1.
Any function in Excel begins with...
a)
=
b)
@
c)
DO
d)
#
2.
Match each function with what it does
a)
SUM
1.
Finds the total of the values
b)
AVERAGE
2.
Finds the mean of the values
c)
MAX
3.
Finds the highest value
d)
MIN
4.
Finds the lowest value
e)
ROUND
5.
Rounds the value (to decimal places)
3.
What is the result of
= SUM(A1 : A3)
4.
What is the result of
= AVERAGE(A1 : A3)
5.
What is the result of
= MAX(B1 : B4)
6.
What is the result of
= MIN(B1 : C4)
7.
What is the result of
= ROUND(C3,1)
8.
What is the result of
= ROUND(C4,2)
9.
What is the result of
= ROUND(C1,0)
10.
What is the result of
= SQRT(B1 + B2)
100 %
