WorksheetsGoogle Sheets
Total questions: 15
Worksheet time: 8mins
Name
Class
Date
1.
The correct formula to add cell B1 and B2 is
a)
AddB1+C1
b)
=sum(B1+C1)
c)
=B1+B2
d)
=sum(B1-B2)
2.
B1 is a?
a)
row
b)
column
c)
cell
d)
sheet
3.
What number is in D1?
a)
1
b)
2
c)
blank
d)
4
4.
What value would you get if you put in the formula: =A1*B1
a)
2
b)
3
c)
4
d)
Error
5.
All formulas in Google Sheets begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
6.
What value would you get if you put in the formula: =B1+C1
a)
2
b)
3
c)
4
d)
Error
7.
What number should be in E1 (based on the formula shown)?
a)
1
b)
3
c)
5
d)
9
8.
Which is the correct formula to add cells A1 to A5?
a)
=SUM(A1+A5)
b)
=SUM(A1:A5)
c)
=A1+A2+A3
d)
=SUM(A1:A4)
9.
It is possible to insert images in Google Sheets
a)
True
b)
False
10.
What is the name of a vertical section of a spreadsheet as selected in the image?
a)
row
b)
cell
c)
column
d)
format
11.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
12.
It is possible to change the color of a cell border.
a)
True
b)
False
13.
The only colors you can change your sheet tabs to are red, blue, green, or yellow.
a)
True
b)
False
14.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
15.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
100 %
