wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Google Sheets Quiz

Total questions: 36

Worksheet time: 28mins

Name
Class
Date
1.

A cell you are currently working on

a)

Active Cell

b)

Auto Sum

c)

Cell Reference

d)

Column

2.

The column and row letter of a cell

a)

Active Cell

b)

Auto Sum

c)

Cell Reference

d)

Column

3.

The vertical reference on the spreadsheet

a)

Active Cell

b)

Auto Sum

c)

Cell Reference

d)

Column

4.

To fill a cellwith color using the paint bucket tool

a)

Fill

b)

Fill Handle

c)

Filter

d)

Formula

5.

The dot at the bottom of each cell while it is active

a)

Fill

b)

Fill Handle

c)

Filter

d)

Formula

6.

The procedure to select certain information in a spreadsheet

a)

Fill

b)

Fill Handle

c)

Filter

d)

Formula

7.

What always start with an = sign

a)

Fill

b)

Fill Handle

c)

Filter

d)

Formula

8.

The horizontal and vertical lines on the spreadsheet

a)

Graph

b)

Grid Lines

c)

Row

d)

Selecting

9.

The horizontal reference on the spreadsheet

a)

Graph

b)

Grid Lines

c)

Row

d)

Selecting

10.

A grid that organizes data

a)

Sheet Tabs

b)

Spreadsheets

c)

Value

d)

Workbook

e)

Worksheet

11.

A number that can be entered into a cell

a)

Sheet Tabs

b)

Spreadsheets

c)

Value

d)

Workbook

e)

Worksheet

12.

One page of a spreadsheet

a)

Sheet Tabs

b)

Spreadsheets

c)

Value

d)

Workbook

e)

Worksheet

13.

A collection of worksheets

a)

Sheet Tabs

b)

Spreadsheets

c)

Value

d)

Workbook

e)

Worksheet

14.

If I wanted to collect data and create a graph for my science fair data, I should use

a)

Google Docs

b)

Google Sheets

c)

Google Slides

d)

Google Forms

15.
Columns run _______________.
a)
vertically
b)
diagonally
c)
horizontally
d)
really, really fast
16.
Rows run ____________.
a)
horizontally
b)
diagonally
c)
vertically
d)
much faster than columns
17.
Which of the following is a correctly named cell?
a)
8B
b)
B8
c)
8-B
d)
BB-8
18.
The little triangle in the top right corner of a cell means there is a ________ with that cell.
a)
formula
b)
number
c)
letter
d)
note
19.
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
20.
Select ______________ from the functions drop-down menu to add a set of numbers. 
a)
average
b)
count
c)
max
d)
sum
21.
Text wrapping in Sheets means the text will be on more than 1 line within the cell.
a)
True
b)
False
22.

Which of the following can you do in a spreadsheet?

a)

Sort in alphabetical order

b)

Sort in number order

c)

Sort in reverse alphabetical order

d)

Sort in reverse number order

e)

All of these can be done using spreadsheets

23.

The structure of a Google spreadsheet consists of vertical _______________ and horizontal _________________.

a)

Columns; rows

b)

Charts; images

c)

Forms; equations

d)

Formulas; links

24.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
25.

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

26.

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

27.

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

28.

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

29.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
30.
Which of the following is NOT a spreadsheet?
a)
Google Sheets
b)
Microsoft Excel
c)
Google Docs
d)
none of the above
31.
What is this icon?
a)
sheets
b)
slides
c)
docs
d)
classroom
32.
What is this icon?
a)
sheets
b)
docs
c)
classroom
d)
youtube
33.
What is this icon?
a)
classroom
b)
docs
c)
slides
d)
mail
34.
What is this icon?
a)
docs
b)
classroom
c)
youtube
d)
mail
35.
What is this icon?
a)
slides
b)
chrome
c)
drive
d)
classroom
36.

Looking at the picture, what number do you give yourself?

4 lines