wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Google Sheets Quiz

Total questions: 30

Worksheet time: 23mins

Name
Class
Date
1.
Columns run _______________.
a)
vertically
b)
diagonally
c)
horizontally
d)
really, really fast
2.
Rows run ____________.
a)
horizontally
b)
diagonally
c)
vertically
d)
much faster than columns
3.
A ____________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
4.
A spreadsheet is made up of all of the following EXCEPT
a)
Rows
b)
Cells
c)
Pictures
d)
Columns
5.
Which of the following is a correctly named cell?
a)
8B
b)
B8
c)
8-B
d)
BB-8
6.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
7.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
8.
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
9.
Which symbol tells the computer you want to create an equation or formula?
a)
$
b)
+
c)
=
d)
-
10.
What number should be in E1 (based on the formula)?
a)
1
b)
2
c)
5
d)
9
11.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
12.
=A1*B1
a)
2
b)
3
c)
4
d)
Error
13.
All formulas in Google sheets begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
14.
Select ______________ from the functions drop-down menu to add a set of numbers. 
a)
average
b)
count
c)
max
d)
sum
15.
You can have multiple sheets within the same Google Sheet document.
a)
True
b)
False
16.
It is possible to insert images in Google Sheets
a)
True
b)
False
17.

Which column is this?

a)

A

b)

B

c)

C

d)

D

18.

Which column is this?

a)

A

b)

B

c)

C

d)

D

19.

Which row is this?

a)

1

b)

2

c)

3

d)

4

20.

Which row is this?

a)

1

b)

2

c)

3

d)

4

21.

Which cell address is in blue?

a)

A1

b)

B1

c)

A2

d)

B2

22.

Which cell address is in blue?

a)

B2

b)

A5

c)

C4

d)

C5

23.

Use Google Sheets to create

a)

word documents

b)

presentations

c)

drawings

d)

spreadsheets

24.

Which type of data is this?

a)

numeric

b)

text

c)

numeric and text

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

What is the name of the yellow highlighted area?

a)

Task bar

b)

Formula bar

c)

Tool bar

d)

Functions

27.

Using cell references, select the correct formula for calculating the initial cost of goldfish.

a)

=b9*c9

b)

b9*c9

c)

.25*6

d)

=.25*6

28.

In Google Sheets, a CELL is

a)

a group of cells that run horizontally

b)

each rectangle in a spreadsheet

c)

a group of cells that run vertically

d)

the place to enter and edit data, functions, and formulas for a specific cell

29.

What formula would be used in cell B14 to find the average number of miles the person biked in a month?

a)

=(B2/B10)

b)

=AVERAGE(C2:C10)

c)

=AVERAGE(B2+B10)

d)

=AVERAGE(B2:B10)

30.

Google Sheets saves your changes automatically.

a)

True

b)

False

Similar Resources on Wayground

Parts of a Computer #2 - Cables and Ports

25 questions

Parts of a Computer #2 - Cables and Ports

quiz

Worksheet

•

6th Grade - Professio...

JS Begin

25 questions

JS Begin

quiz

Worksheet

•

6th - 8th Grade

Parts of the Computer 5

26 questions

Parts of the Computer 5

quiz

Worksheet

•

7th - 8th Grade

Lab Safety & School Policies

31 questions

Lab Safety & School Policies

quiz

Worksheet

•

6th - 7th Grade

Introduction - Lego Spike Prime - Review

30 questions

Introduction - Lego Spike Prime - Review

quiz

Worksheet

•

7th Grade

Sensor - ICT IGCSE

35 questions

Sensor - ICT IGCSE

quiz

Worksheet

•

7th Grade

Keyboarding

25 questions

Keyboarding

quiz

Worksheet

•

6th - 8th Grade

ICT 7 - Systems Lifecycle

25 questions

ICT 7 - Systems Lifecycle

quiz

Worksheet

•

7th - 9th Grade