Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Google Sheets

Total questions: 11

Worksheet time: 8mins

Name
Class
Date
1.
Which symbol tells the computer you want to create an equation or formula?
a)
$
b)
+
c)
=
d)
-
2.
What number should be in E1 (based on the formula)?
a)
1
b)
2
c)
5
d)
9
3.

B1 is called

a)

Row

b)

Cell

c)

Column

d)

Sheet

4.

Which item is FALSE regarding charts in Google Sheets?

a)

You can create pie and line charts.

b)

Charts can't be inserted on their own sheet.

c)

You can change the chart title.

d)

You can put a background color on your chart.

5.

You can not adjust a row height or column width.

a)

True

b)

False

6.
Which is the correct formula to add cells A1 to A5?
a)
=SUM(A1+A5)
b)
=SUM(A1:A5)
c)
=A1+A2+A3
d)
=SUM(A1:A4)
7.

In Google Sheets, rows are identified by

a)

Letters

b)

Numbers

8.

In Google Sheets, columns are identified by

a)

Letters

b)

Numbers

9.

I forgot to add a column. Which menu should I use?

a)

File

b)

Edit

c)

Format

d)

Insert

10.

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.

a)

Sum

b)

Average

c)

Count

d)

Max

e)

Min

11.

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