wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Google Sheets Functions Review

Total questions: 10

Worksheet time: 12mins

Name
Class
Date
1.
Select ______________ from the functions drop-down menu to add a set of numbers together. 
a)
average
b)
count
c)
max
d)
sum
2.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
3.

Mr. Esker wanted to see how the class did as a whole on the most recent test. Using spreadsheets he used the ______________ function to calculate the classes score as a whole.

a)

Sum

b)

Average

c)

Count

d)

Max

e)

Min

4.

Mr. Tone wanted to see which student received the highest score on the last Quizizz. In his spread sheet he used the ______________ function to identify the highest score.Mi

a)

Sum

b)

Average

c)

Count

d)

Max

e)

Min

5.

Betty has a spreadsheet of sales for her bakery for a month. In one column she lists the amount of donuts sold each day. If she wanted to find out what day she sold the LEAST amount of donuts she would use the _________________ function.

a)

Sum

b)

Average

c)

Count

d)

Max

e)

Min

6.

Mr. Esker is looking over his quiz data again in his spreadsheet. He wanted to know how many students received an 80% on his latest quiz. In his spreadsheet he would use the ___________________ function.

a)

Sum

b)

Average

c)

Count

d)

Max

e)

Min

7.

Mr. Tone's favorite baseball team is...

a)

Chicago White Sox

b)

Chicago Cubs

c)

Chicago Bears

d)

Iowa Hawkeyes

8.
Which of the following is a correctly named cell?
a)
8B
b)
B8
c)
8-B
d)
BB-8
9.
This cursor allows you to click and hold the mouse to move the contents of that cell anywhere. 
a)
Skinny Plus Sign
b)
Hand
c)
Arrow
d)
Fat Plus Sign
10.
Select ___________________ from the functions menu to find the smallest value in a group.
a)
max
b)
min
c)
sum
d)
average