wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Google Sheets Basic

Total questions: 23

Worksheet time: 18mins

Name
Class
Date
1.
Google Sheets is used to?
a)
Add numbers.
b)
Make charts (graphs).
c)
Put information in columns and rows.
d)
All of the above.
2.

Double-clicking between two columns will ____________ the column.

a)

delete

b)

copy

c)

resize

d)

fill

3.
If I want to add a Chart, one way is to select the ____________ tab.
a)
Home
b)
Insert
c)
Page Layout
d)
Data
4.
If I want to make a cell a particular color, which button would I click on?
a)
Format tab
b)
Font style
c)
Text color
d)
Fill color
5.
Identify this cell (highlighted)
a)
A3
b)
C3
c)
C1
d)
C U L8R
6.
If you want to calculate something in a cell, the first symbol you must enter in that cell is?
a)
Plus sign
b)
Open parenthesis
c)
Equal sign
d)
Divide sign
7.

This is a web-based spreadsheet application that allows you to store and organize different types of information, much like Microsoft Excel.

a)
b)
c)
d)
8.
A ____________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
9.

Rows are labeled by __________.

a)

numbers

b)

letters

c)

symbols

d)

colors

10.

Columns are labeled by ______________.

a)

numbers

b)

letters

c)

symbols

d)

colors

11.

You can have multiple tabs within the same Google Sheet document.

a)

True

b)

False

12.

What number is in D1?

a)

1

b)

2

c)

4

13.

What is this area in red called?

a)

Search Bar

b)

Omni Box

c)

Formula Bar

d)

Tool Bar

14.

This is the area where you can find options to edit and modify (change) your spreadsheet in many ways.


What is this area called?

a)

Formula Bar

b)

Toolbar Menu

c)

Help Bar

15.

The area in red tells me that sheets

a)

Saved Changes

b)

Found Nemo

c)

Shared my work

16.

Collaboration options allow you to do this to your spreadsheet: (Pick 2)

a)

Comment

b)

Share

c)

Save

d)

Delete

17.

These display what worksheet a user is currently editing. By clicking these, a user can switch between worksheets in a workbook.

a)

Sheets sticker

b)

Sheets Tab

c)

Sheets menu

18.
=A1*B1
a)
2
b)
3
c)
4
d)
Error
19.
Select ______________ from the functions drop-down menu to add a set of numbers. 
a)
average
b)
count
c)
max
d)
sum
20.

Select the correct formula for calculating the initial cost of goldfish.

a)

=b9*c9

b)

b9*c9

c)

.25*6

d)

=.25*6

21.

Which of the following options will allow all text to fit into one cell without spilling into the next column?

a)

Overflow

b)

Text wrapping

c)

Clip

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.
Which of the following is a correctly named cell?
a)
8B
b)
B8
c)
8-B
d)
BB-8