Font size
S
M
L
XL
Worksheets04 | Calculating/Modelling (H/W 2)
Total questions: 10
Worksheet time: 6mins
Name
Class
Date
1.
What is the cell reference for David's seat?
a)
A3
b)
B3
c)
C5
d)
D4
2.
Where was Nancy's seat?
a)
A3
b)
B3
c)
C5
d)
D4
3.
What is the purpose of using formulas in Google Sheets?
a)
To calculate mathematical operations
b)
To format cells and apply conditional formatting
c)
To create charts and graphs
d)
To import and export data
4.
What is the formula to calculate the sum of cells A1 and B1 in Google Sheets?
a)
=A1*B1
b)
=SUM(A1,B1)
c)
=A1+B1
d)
=A1-B1
5.
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
6.
In a Google Spreadsheet, selecting the SUM function from the toolbar will perform what mathematical option?
a)
Subtraction
b)
Multiplication
c)
Division
d)
Addition
7.
Which is the correct formula to multiply?
a)
=B6*C6
b)
B6*C6
c)
B6C6*
d)
*B6C6
8.
Which is the correct formula to divide?
a)
B6/C6
b)
=B6/C6
c)
/B6C6
d)
B6C6/
9.
What function do you use to find the lowest number?
a)
SUM
b)
MAX
c)
MIN
d)
AVERAGE
10.
What function can be used to find the largest number in a range of numbers?
a)
=MIN
b)
=MAX
c)
=AVERAGE
d)
=SUM
Reset
