Wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Google Sheets

Total questions: 35

Worksheet time: 29mins

Name
Class
Date
1.

B1 is a?

a)

row

b)

column

c)

cell

d)

sheet

2.
What number is in D1?
a)
1
b)
2
c)
blank
d)
4
3.
All formulas in Google Sheets begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
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 have multiple sheets within the same Google Sheet document.
a)
True
b)
False
6.

You can adjust the size of columns in Sheets.

a)

True

b)

False

7.

You are able to change the colors shown in a chart.

a)

True

b)

False

8.
What is the name of a vertical section of a spreadsheet as selected in the image?
a)
row
b)
cell
c)
column
d)
format
9.

What is the name of the selected cell?

a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
10.

You can only apply a border to the bottom of cells in Google Sheets

a)

True

b)

False

11.

Which letter on the image is a column?

a)

A

b)

B

c)

C

d)

D

12.

Which letter on the image is a Cell?

a)

A

b)

B

c)

C

d)

D

13.

Which method is best for selecting the cells highlighted in red?

a)

Press the Shift key and click on the cells.

b)

Click and drag the mouse to select the cells.

c)

Press the Ctrl key and click on the cells.

d)

Press the Alt key and click on the cells.

14.

Which sequence of keyboard shortcuts would you use to COPY information from one cell to another?

a)

Ctrl+X then Ctrl+Z

b)

Ctrl+C then Ctrl+V

c)

Ctrl+V then Ctrl+Z

d)

Ctrl+X then Ctrl+V

15.

What function should be entered into B7 to calculate the total budget?

a)

=SUM(B3:B6)

b)

=CALCULATE(B3:B6

c)

=SUM(B3-B6)

d)

=AVERAGE(B3:B6)

16.

Where is the formula bar?

a)

A

b)

B

c)

C

d)

D

17.
Columns run _______________.
a)
vertically
b)
diagonally
c)
horizontally
d)
really, really fast
18.
Rows run ____________.
a)
horizontally
b)
diagonally
c)
vertically
d)
much faster than columns
19.
A spreadsheet is made up of all of the following EXCEPT
a)
Rows
b)
Cells
c)
Pictures
d)
Columns
20.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
21.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
22.
The little triangle in the top right corner of a cell means there is a ________ with that cell.
a)
formula
b)
number
c)
letter
d)
note
23.
Spreadsheets work much like the game ________________.
a)
Monopoly
b)
Minecraft
c)
Battleship
d)
Yahtzee
24.
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
25.
Which cursor would you use to auto fit content in a column?
a)
vertical line with arrows pointing left and right
b)
plus sign
c)
hand
d)
white arrow
26.
Which of the following is NOT a spreadsheet?
a)
Google Sheets
b)
Microsoft Excel
c)
Google Docs
d)
none of the above
27.

Which picture represents Google Sheets?

a)
b)
c)
d)
28.

What are the rectangles used to hold data in a spreadsheet called?

a)

Cells

b)

Data Holders

c)

Grids

d)

Data Locators

29.

What is the title of this Google Spreadsheet Document?

a)

Hurricanes vs. Year

b)

Hurricanes

c)

Year

d)

Unnamed

30.

What is the name of the spreadsheet?

a)

Hurricanes

b)

Sheet 1

c)

Unnamed

d)

Hurricanes vs. Year

31.

How would you format a large amount of text to fit in a single cell?

a)

Overflow

b)

Wrap

c)

Clip

d)

It's not possible.

32.

Oops, you forgot to add a row to the top of your spreadsheet, you should click on ...?

a)

Edit then delete row

b)

File then Save As

c)

Insert then Row Above

d)

Insert then Row Below

33.

Oops, you need to delete an entire row, you should select the row then ...?

a)

Press backspace

b)

Press delete

c)

Press "ctrl" and "x" at the same time

d)

Right click, then select "delete row"

34.

To create a simple chart, you would click on Insert, then...?

a)

Chart

b)

Image

c)

Drawing

d)

Form

35.

If I want to add a Chart, one way is to select the ____________ tab.

a)

Home

b)

Insert

c)

Page

d)

Data