NEW
Font size
S
M
L
XL
WorksheetsGoogle Sheets
Total questions: 20
Worksheet time: 20mins
Name
Class
Date
1.
What number should be in E1 (based on the formula)?
a)
1
b)
2
c)
5
d)
9
2.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
3.
=A1*B1
a)
2
b)
3
c)
4
d)
Error
4.
All formulas in Google sheets begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
5.
Spreadsheets work much like the game ________________.
a)
Monopoly
b)
Minecraft
c)
Battleship
d)
Yahtzee
6.
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
7.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
8.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
9.
Which of the following is a correctly named cell?
a)
8B
b)
B8
c)
8-B
d)
BB-8
10.
A ____________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
11.
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
12.
Which symbol tells the computer you want to create an equation or formula?
a)
$
b)
+
c)
=
d)
-
13.
Select ______________ from the functions drop-down menu to add a set of numbers.
a)
average
b)
count
c)
max
d)
sum
14.
Select ___________________ from the functions menu to find the smallest value in a group.
a)
max
b)
min
c)
sum
d)
average
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.
You can not give an exact size for a row height or column width.
a)
True
b)
False
18.
It is possible to insert images in Google Sheets
a)
True
b)
False
19.
What is a vertical section of a spreadsheet?
a)
row
b)
cell
c)
column
d)
format
20.
What is a vertical section of a spreadsheet?
a)
row
b)
cell
c)
column
d)
format
Reset
