NEW
Font size
S
M
L
XL
WorksheetsGoogle Sheets ReViEw
Total questions: 18
Worksheet time: 13mins
Name
Class
Date
1.
What is a vertical section of a spreadsheet
a)
row
b)
addition
c)
column
d)
format
2.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
3.
The correct formula to add cell B1 and B2 is
a)
AddB1+C1
b)
=sum(B1+C1)
c)
=B1+B2
4.
B1 is a?
a)
row
b)
column
c)
cell
d)
sheet
5.
What number is in D1?
a)
1
b)
2
c)
blank
d)
4
6.
=A1*B1
a)
2
b)
3
c)
4
d)
Error
7.
=B1+C1
a)
2
b)
3
c)
4
d)
Error
8.
Opening a new file in this app is called a
a)
row
b)
column
c)
cell
d)
sheet
9.
D1-C1
a)
2
b)
3
c)
4
d)
Error
10.
Which is the correct formula to add cells A1 to A5?
a)
=SUM(A2+A5)
b)
=SUM(A1:A5)
c)
=A1+A2+A3
d)
=SUM(A1:A4)
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 Row?
a)
A
b)
B
c)
C
d)
D
13.
If I want to make a cell a particular color, which button would I click on?
a)
orange arrow
b)
red arrow
c)
blue arrow
d)
green arrow
14.
Name this Google icon?
a)
Drive
b)
Doc
c)
Sheets
d)
Word
15.
Select ______________ from the functions drop-down menu to add a set of numbers.
a)
average
b)
count
c)
max
d)
sum
16.
Select ___________________ from the functions menu to find the smallest value in a group.
a)
max
b)
min
c)
sum
d)
average
17.
SUM, AVERAGE, MAX and MIN are preset formulas on the _______________ menu.
a)
filter
b)
functions
c)
border
d)
fill color
18.
What value will be in the blue shaded cell?
a)
23
b)
17
c)
19
d)
34
Reset
