wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Google Sheets Basics

Total questions: 32

Worksheet time: 32mins

Name
Class
Date
1.
What is the name of a vertical section of a spreadsheet as selected in the image?
a)
row
b)
cell
c)
column
d)
format
2.

What is the name of this cell?

a)

B10

b)

5B

c)

B5

d)

B6

3.
All formulas in Google Sheets begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
4.

B1 is a?

a)

row address

b)

column address

c)

cell address

d)

sheet address

5.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
6.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
7.
The correct formula to add cell B1 and B2 is
a)
AddB1+C1
b)
=sum(B1+C1)
c)
 =B1+B2
d)
=sum(B1-B2)
8.

Google Sheets is a program that allows a user to _____.

a)

create electronic slide shows

b)

browse sites on the internet

c)

write letters

d)

calculate numerical information

9.

What is the name of a horizontal section of a spreadsheet as selected in the image?

a)

row

b)

cell

c)

column

d)

format

10.
What number should be in E1 (based on the formula)?
a)
1
b)
2
c)
5
d)
9
11.
=A1*B1
a)
2
b)
3
c)
4
d)
Error
12.
Select ______________ from the functions drop-down menu to add a set of numbers. 
a)
average
b)
count
c)
max
d)
sum
13.
It is possible to insert images in Google Sheets
a)
True
b)
False
14.

What is the sign for adding values in a cell?

a)

*

b)

-

c)

/

d)

+

15.

What is the sign used for subtracting values in a cell?

a)

-

b)

+

c)

*

d)

/

16.

What is the sign for multiplying values in a cell?

a)

*

b)

+

c)

-

d)

/

17.

What is the value for dividing values in a cell?

a)

+

b)

/

c)

-

d)

*

18.
What value would you get if you put in the formula: =B1+C1
a)
2
b)
3
c)
4
d)
Error
19.
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)
20.
You can have multiple sheets within the same Google Sheet document.
a)
True
b)
False
21.
It is possible to change the color of a cell border.
a)
True
b)
False
22.
In a Google Spreadsheet, you can format a column by clicking on the $ sign in the toolbar to format it as ___________.
a)
Numbers
b)
Automatic
c)
Decimals
d)
Currency (money)
23.
Double-clicking between two columns will ____________ the column.
a)
delete
b)
copy
c)
resize or expand
d)
fill
24.

What is the purpose of the following formula: SUM(B2:B6)?

a)

To subtract the values of cells B2:B6

b)

To multiply the values of cells B2:B6

c)

To add the values of cells B2:B6

25.

What is this icon used for?

a)

Skyscrapers

b)

Arrangemnet

c)

Alignment

d)

Audio/Video Adjustment

26.

What is this icon used for?

a)

Inserting capital a "B"

b)

Playing The Bee Movie

c)

Being Beautiful

d)

Making selected text Bold

27.

What is this icon used for?

a)

Adjusting the Border Style of Selected Cells

b)

Connect Four

c)

4 Square

d)

Rubic's Cube

28.

What is this icon used for?

a)

Putting lines through all your "S's"

b)

Getting rich quickly

c)

Sizzling snakes swiftly

d)

Changing the content of a cell to a certain kind of money

29.

What is this icon used for?

a)

Moving your zeros

b)

Changing direction

c)

Adding or taking away decimal places

d)

Adding 10ths and 100ths

30.

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.

31.

You can not adjust a row height or column width.

a)

True

b)

False

32.

A cell's name is based on its column letter and row number. What do you call a cell name?

a)

cell bar

b)

cell address

c)

cell location