NEW
Font size
S
M
L
XL
WorksheetsGoogle Sheets (Homework 2)
Total questions: 11
Worksheet time: 18mins
Name
Class
Date
1.
The correct formula to add cell B1 and B2 is
a)
AddB1+C1
b)
=add(b1:b2)
c)
=B1+B2
d)
=total(B1-B2)
2.
B1 is a?
a)
row
b)
column
c)
cell
d)
sheet
3.
What value would you get if you put in the formula: =A1*B1
a)
2
b)
3
c)
4
d)
Error
4.
All formulas in Google Sheets begin with the following symbol:
a)
+
b)
-
c)
=
d)
%
5.
What number should be in E1 (based on the formula shown)?
a)
1
b)
3
c)
5
d)
9
6.
Which is the correct formula to add cells A1 thru A5?
a)
=SUM(A1+A5)
b)
=SUM(A1:A5)
c)
=A1+A5
d)
=SUM(A1:A4)
7.
The function formula to find the smallest value in a group is
a)
max
b)
min
c)
sum
d)
average
8.
You are able to change the colors shown in a chart.
a)
True
b)
False
9.
What is the name of a vertical section of a spreadsheet as selected in the image?
a)
row
b)
cell
c)
column
d)
format
10.
Which method is best for selecting the cells highlighted in red?
a)
Press the Shift key and click on the cells.
b)
Click and drag the mouse to select the cells.
c)
Press the Ctrl key and click on the cells.
d)
Press the Alt key and click on the cells.
11.
What function should be entered into B7 to calculate the total budget?
a)
=SUM(B3:B6)
b)
=CALCULATE(B3:B6
c)
=SUM(B3-B6)
d)
=AVERAGE(B3:B6)
Reset
