Font size
WorksheetsGoogle Sheets
Total questions: 21
Worksheet time: 11mins
The correct formula to add cell B1 and B2 is
AddB1+C1
=add(b1:b2)
=B1+B2
=total(B1-B2)
The formula to calculate the average of cells A1, A2, and A3 is
=average(A1:A3)
=mean(A1,A2,A3)
=A1+A2+A3/3
=sum(A1+A2+A3)/3
To find the maximum value in cells C1 to C5, you would use the formula
=C1>C2>C3>C4>C5
=C1+C2+C3+C4+C5
=highest(C1,C2,C3,C4,C5)
=max(C1:C5)
The correct formula to subtract cell D2 from D1 is
=D1/D2
=subtract(D1,D2)
=D1-D2
=D1+D2
The formula to multiply cell E1 by E2 is
=E1-E2
=E1+E2
=multiply(E1,E2)
=E1*E2
The formula to find the minimum value in cells G1 to G5 is
=G1+G2+G3+G4+G5
=lowest(G1,G2,G3,G4,G5)
=G1
=min(G1:G5)
What is the purpose of the Autosave feature in Google Sheets?
To use math to find the answer to a problem
To automatically save your work
To change the way data looks in a spreadsheet
To study and understand information in a spreadsheet
Using cell references, select the correct formula for calculating the initial cost of goldfish.
=b9*c9
b9*c9
.25*6
=.25*6
What will the following do when typed into a cell?
=(B5 + C5)
The values in B5 and C5 will be multiplied
The value in B5 will be divided by C5
The values in B5 and C5 will be added
The values in B5 and C5 will be subtracted
Google Sheets is used to?
Add numbers.
Make charts (graphs).
Put information in columns and rows.
Collect Data
