wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Google Sheets Quiz

Total questions: 30

Worksheet time: 15mins

Name
Class
Date
1.
In a Google Spreadsheet, the letters across the top represent __________.
a)
Rows
b)
Numbers
c)
Columns
d)
Functions
2.
In a Google Spreadsheet, the numbers down the left side represent __________.
a)
Rows
b)
 Columns
c)
Headers
d)
Functions
3.
In a Google Spreadsheet, you can widen an entire column anywhere in the sheet.
a)
True
b)
False
4.
In a Google Spreadsheet, where a column and row intersect is called a ________.
a)
Rectangle
b)
Square
c)
Cell
d)
Intersection
5.
In a Google Spreadsheet, selecting the SUM function from the toolbar will perform what mathematical option?
a)
Subtraction
b)
Multiplication
c)
Division
d)
Addition
6.
Columns run _______________.
a)
vertically
b)
diagonally
c)
horizontally
d)
really, really fast
7.
Rows run ____________.
a)
horizontally
b)
diagonally
c)
vertically
d)
much faster than columns
8.
Which of the following is a correctly named cell?
a)
8B
b)
B8
c)
8-B
d)
BB-8
9.

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

10.

Which of the following is NOT a spreadsheet software?

a)

Google Sheets

b)

Google Docs

c)

Microsoft Excel

d)

File Explorer

11.

Google Sheets saves your changes automatically.

a)

True

b)

False

12.

Rows are labeled by _____.

a)

symbols

b)

letters

c)

numbers

d)

colors

13.

Columns are labeled by _____.

a)

symbols

b)

letters

c)

numbers

d)

colors

14.

A spreadsheet is made up of all the following EXCEPT

a)

rows

b)

pictures

c)

columns

d)

cells

15.

Which function would you use to add the values of several cells?

a)

TOTAL

b)

AVERAGE

c)

MAX

d)

SUM

16.

What is the name of this cell?

a)

B10

b)

5B

c)

B5

d)

you cannot know the name from this picture

17.
In a Google Spreadsheet, selecting the SUM function from the toolbar will perform what mathematical option?
a)
Subtraction
b)
Multiplication
c)
Division
d)
Addition
18.

Google Sheets is used to? (Select ALL that apply?)

a)

Add numbers.

b)

Make charts (graphs).

c)

Put information in columns and rows.

d)

Collect Data

19.

Double-clicking between two columns will ____________ the column.

a)

Delete

b)

Copy

c)

Resize

d)

Fill

20.

A Sheets document is called a?

a)

Work page

b)

Work paper

c)

Spreadsheet

d)

Slide

21.

Which column is this?

a)

A

b)

B

c)

C

d)

D

22.

Which row is this?

a)

1

b)

2

c)

3

d)

4

23.

Which row is this?

a)

1

b)

2

c)

3

d)

4

24.

Which cell address is in blue?

a)

A1

b)

B1

c)

A2

d)

B2

25.

Which cell address is in blue?

a)

B2

b)

A5

c)

C4

d)

C5

26.

B1 is called

a)

Row

b)

Cell

c)

Column

d)

Sheet

27.

A cell you are currently working on

a)

Active Cell

b)

Auto Sum

c)

Cell Reference

d)

Column

28.

Google Sheets is made by...

a)

Mid-evil pirates

b)

Google

c)

Chrysler Corp.

d)

Sony Games

29.

Why would you want to change the column width?

a)

To make sure all of the numbers are visible

b)

To make sure the title is visible

c)

To make sure all of the headings are visible

d)

All of the above

30.

What is this icon used for?

a)

Bold

b)

Brighten

c)

Beware

d)

Buffer