WorksheetsGOOGLE SHEET BEGINNER
Total questions: 25
Worksheet time: 33mins
Name
Class
Date
1.
B1 is a?
a)
row
b)
column
c)
cell
d)
sheet
2.
What number is in D1?
a)
1
b)
2
c)
blank
d)
4
3.
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)
4.
Select ______________ from the functions drop-down menu to add a set of numbers together.
a)
average
b)
count
c)
max
d)
sum
5.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
6.
Columns are labeled by ______________.
a)
numbers
b)
letters
c)
symbols
d)
colors
7.
Rows are labeled by __________.
a)
numbers
b)
letters
c)
symbols
d)
colors
8.
What is the name of this button?
a)
Function button
b)
the backwards 3 button
9.
What do these buttons do?
a)
Back space and move forward
b)
Look back before moving forward
c)
Undo or Redo
d)
Get Out the Way
10.
Which letter on the image is a Row?
a)
A
b)
B
c)
C
d)
D
11.
If I want to add a Chart, one way is to select the ____________ tab.
a)
Home
b)
Insert
c)
Page Layout
d)
Data
12.
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)
13.
In a Google Spreadsheet, selecting the SUM function from the toolbar will perform what mathematical option?
a)
Subtraction
b)
Multiplication
c)
Division
d)
Addition
14.
In a Google Spreadsheet, the first thing you should type in a cell where you want to insert a formula/function to get an answer is a(n) ____________.
a)
Plus sign
b)
Minus sign
c)
Equal sign
d)
Multiplication sign
15.
What is this icon?
a)
sheets
b)
slides
c)
docs
d)
classroom
16.
What is this icon?
a)
sheets
b)
docs
c)
classroom
d)
youtube
17.
What is this icon?
a)
classroom
b)
docs
c)
slides
d)
mail
18.
What is this icon?
a)
docs
b)
classroom
c)
youtube
d)
mail
19.
What is this icon?
a)
slides
b)
chrome
c)
drive
d)
classroom
20.
What is this icon?
a)
drive
b)
slides
c)
sheets
d)
classroom
21.
What does it mean to merge cells?
a)
apply a border around a set of cells
b)
center the text content in the center of the cell
c)
combine cells into a single cell
d)
split a single cell into multiple cells
22.
What function should be entered into B7 to calculate the total budget?
a)
=MAX(B3:B6)
b)
=AVERAGE(B3:B6)
c)
=SUM(B3:B6)
d)
=SUM(B3-B6)
23.
I forgot to add a column. Which menu should I use?
a)
File
b)
Edit
c)
Format
d)
Insert
24.
What is this?
a)
Pie chart
b)
Column chart
25.
What is this?
a)
Pie Chart
b)
Column Chart
100 %
