WorksheetsGoogle Sheets 5°
Total questions: 20
Worksheet time: 10hrs 0mins
Name
Class
Date
1.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
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.
A ____________ is where a row and column meet.
a)
sheet
b)
formula
c)
blank
d)
cell
6.
Select ______________ from the functions drop-down menu to add a set of numbers.
a)
average
b)
count
c)
max
d)
sum
7.
What is a vertical section of a spreadsheet?
a)
row
b)
cell
c)
column
d)
format
8.
In a Google Spreadsheet, selecting the SUM function from the toolbar will perform what mathematical option?
a)
Subtraction
b)
Multiplication
c)
Division
d)
Addition
9.
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
10.
In a Google Spreadsheet, you can format a column by clicking on the $ sign in the toolbar to format it as ___________.
a)
Numbers
b)
Automatic
c)
Decimals
d)
Currency (money)
11.
Columns on a spreadsheet run _______________.
a)
vertically
b)
diagonally
c)
horizontally
d)
really, really fast
12.
Rows on a spreadsheet run ____________.
a)
horizontally
b)
diagonally
c)
vertically
d)
much faster than columns
13.
What does this icon represent?
a)
sheets
b)
slides
c)
docs
d)
classroom
14.
What number should be in cell E1 (based on the formula)?
a)
1
b)
2
c)
5
d)
9
15.
=A1*B1
a)
2
b)
3
c)
4
d)
Error
16.
What is the formula to find the average(PROMEDIO)?
a)
b)
c)
d)
17.
What is the formula to find the maximum?
a)
b)
c)
d)
18.
What is the formula to find the minimum?
a)
b)
c)
d)
19.
How to change the currency from Euro to Peso?
a)
Format + Number + Settings + Save
b)
Insert + Chart + Settings + Save
c)
File + Settings + Country + Accept
d)
“The currency cannot be changed.”
20.
"In which of these icons can you find the formulas?"
a)
b)
c)
d)
100 %
