NEW
Font size
S
M
L
XL
WorksheetsSpreadsheet Formulas and Functions
Total questions: 20
Worksheet time: 10mins
Name
Class
Date
1.
sum
a)
=SUM(B2:B12)
b)
=A2*A3
c)
add all the numbers in a range of cells
d)
=SUM(B8:B20)*SUM(C28:C40)
2.
average
a)
=AVERAGE(A2:Q2)
b)
=B8-N9
c)
=MIN(B1:G10)
d)
return the average of its arguments
3.
max
a)
=MIN(B1:G10)
b)
=SUM(C1:W1)
c)
=SUM(B8:B20)*SUM(C28:C40)
d)
return the largest value in a set of values
4.
min
a)
=MAX(B1:B31)
b)
=B2/SUM(B10:B21)
c)
return the largest value in a set of values
d)
return the smallest value in a set of values
5.
count
a)
=SUM(C1:W1)
b)
=B8-N9
c)
=A6*SUM(C1:G10)/A2
d)
count the number of cells in a range that contains numbers
6.
vlookup
a)
add all the numbers in a range of cells
b)
looks up a value from the leftmost column of a table,and returns a value in the same row from a column you specify
c)
=SUM(A1:C10)-B8
d)
=B8-N9
7.
Formula: Add a range of numbers in cells B2:B12
a)
=SUM(C1:W1)
b)
=B8-N9
c)
return the smallest value in a set of values
d)
=SUM(B2:B12)
8.
Formula: Find the largest number in cell C14 through Z14
a)
=B2/SUM(B10:B21)
b)
=AVERAGE(A2:Q2)
c)
=A2*A3
d)
=MAX(C14:Z14)
9.
Write a formula (function) to add the range of cells C1:W1.
a)
return the largest value in a set of values
b)
=SUM(C1:W1)
c)
=MAX(B1:B31)
d)
=AVERAGE(A2:Q2)
10.
Divide B2 by the sum of the range of cells in B10 through B21
a)
=SUM(C1:W1)
b)
=AVERAGE(A2:Q2)
c)
=A6*SUM(C1:G10)/A2
d)
=B2/SUM(B10:B21)
11.
Write a formula to find the highest number in the cell range B1:B31.
a)
=B2/SUM(B10:B21)
b)
=B8-N9
c)
=MAX(B1:B31)
d)
=SUM(B8:B20)*SUM(C28:C40)
12.
Write a formula to subtract B8 from the sum of cells A1 through C10
a)
=SUM(A1:C10)-B8
b)
return the average of its arguments
c)
=SUM(S1:S10)-C10
d)
=SUM(C1:W1)
13.
Write a formula that multiplies A6 by the sum of cells C1 through G10, then divide the result by A2.
a)
=A2*A3
b)
=AVERAGE(C1:C10)
c)
=A6*SUM(C1:G10)/A2
d)
return the smallest value in a set of values
14.
Write a formula that will average the cells A2 through Q2.
a)
=SUM(A1:C10)-B8
b)
=AVERAGE(A2:Q2)
c)
=AVERAGE(C1:C10)
d)
=A6*SUM(C1:G10)/A2
15.
Write a formula to find the lowest number in the cell range B1:G10
a)
=MIN(B1:G10)
b)
=A2*A3
c)
=AVERAGE(C1:C10)
d)
=SUM(C1:W1)
16.
Write a formula to calculate the average of cells C1:C10
a)
looks up a value from the leftmost column of a table,and returns a value in the same row from a column you specify
b)
=AVERAGE(C1:C10)
c)
=A2*A3
d)
add all the numbers in a range of cells
17.
Write a formula to multiply the sum of cells B8 through B20 by the sum of C28 through C40
a)
return the largest value in a set of values
b)
=AVERAGE(A2:Q2)
c)
=SUM(A1:C10)-B8
d)
=SUM(B8:B20)*SUM(C28:C40)
18.
Write a formula to subtract C10 from the sum of the cells in the range S1 through S10.
a)
=A6*SUM(C1:G10)/A2
b)
=SUM(S1:S10)-C10
c)
=MAX(C14:Z14)
d)
looks up a value from the leftmost column of a table,and returns a value in the same row from a column you specify
19.
Write a formula that will subtract N9 from B8
a)
=SUM(C1:W1)
b)
return the average of its arguments
c)
=A6*SUM(C1:G10)/A2
d)
=B8-N9
20.
Write a formula that will calculate the cost of of 4 bags of potato chips is the cost was in A2 and the amount was in A3.
a)
=B2/SUM(B10:B21)
b)
return the largest value in a set of values
c)
=A2*A3
d)
=SUM(C1:W1)
Reset
