NEW
Font size
S
M
L
XL
WorksheetsGoogle sheets
Total questions: 14
Worksheet time: 12mins
Name
Class
Date
1.
What number should be in E1 (based on the formula)?
a)
1
b)
2
c)
5
d)
9
2.
All formulas in Google sheets begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
3.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
4.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
5.
Which of the following is a correctly named cell?
a)
8B
b)
B8
c)
8-B
d)
BB-8
6.
Which symbol tells the computer you want to create an equation or formula?
a)
$
b)
+
c)
=
d)
-
7.
Select ______________ from the functions drop-down menu to add a set of numbers.
a)
average
b)
count
c)
max
d)
sum
8.
Select ___________________ from the functions menu to find the smallest value in a group.
a)
max
b)
min
c)
sum
d)
average
9.
What is a vertical section of a spreadsheet?
a)
row
b)
cell
c)
column
d)
format
10.
What is a vertical section of a spreadsheet?
a)
row
b)
cell
c)
column
d)
format
11.
A group of cells is called a ________.
a)
Chart
b)
Cell range
c)
Cell cluster
d)
Multicell
12.
Google Sheets uses standard operators for formulas, for multiplication is:
a)
asterisk
b)
minus
c)
caret
d)
forward slash
13.
Google Sheets uses standard operators for formulas, for division is:
a)
asterisk
b)
minus
c)
caret
d)
forward slash
14.
Google Sheets uses standard operators for formulas, for addition is:
a)
asterisk
b)
minus
c)
plus sign
d)
forward slash
Reset
