NEW
Font size
S
M
L
XL
WorksheetsBasic Spreadsheets: Google Sheets
Total questions: 22
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.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
5.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
6.
Spreadsheets work much like the game ________________.
a)
Monopoly
b)
Minecraft
c)
Battleship
d)
Yahtzee
7.
Which symbol tells the computer you want to create an equation or formula?
a)
$
b)
+
c)
=
d)
-
8.
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
9.
Which cursor allows you to drag and fill a series?
a)
Skinny Plus Sign
b)
Fat Plus Sign
c)
Hand
d)
Arrow
10.
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
11.
What number should be in E1 (based on the formula)?
a)
1
b)
2
c)
5
d)
9
12.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
13.
=A1*B1
a)
2
b)
3
c)
4
d)
Error
14.
Select ______________ from the functions drop-down menu to add a set of numbers.
a)
average
b)
count
c)
max
d)
sum
15.
Text wrapping in Sheets means the text will be on more than 1 line within the cell.
a)
True
b)
False
16.
You can have multiple sheets within the same Google Sheet document.
a)
True
b)
False
17.
It is possible to insert images in Google Sheets
a)
True
b)
False
18.
What is a vertical section of a spreadsheet?
a)
row
b)
cell
c)
column
d)
format
19.
What is the name of the yellow highlighted area?
a)
Task bar
b)
Formula bar
c)
Tool bar
d)
Functions
20.
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
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 manually type the function/formula in a cell if the operation is not available in the function drop-down list.
a)
True
b)
False
Reset
