Practice - 5 Tasks
Answer the questions below
1fill in blank
easyComplete the formula to add the value in cell A1 to the value in cell B1.
Google Sheets
=A1[1]B1 Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using minus (-) instead of plus (+).
Using multiplication (*) or division (/) by mistake.
✗ Incorrect
The plus sign + adds the values of two cells.
2fill in blank
mediumComplete the formula to multiply the value in cell C2 by 10.
Google Sheets
=C2[1]10
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using plus (+) instead of multiplication (*).
Using division (/) or minus (-) by mistake.
✗ Incorrect
The asterisk * multiplies numbers in formulas.
3fill in blank
hardFix the error in the formula to subtract B3 from A3.
Google Sheets
=A3[1]B3 Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using plus (+) instead of minus (-).
Using multiplication (*) or division (/) by mistake.
✗ Incorrect
The minus sign - subtracts one cell's value from another.
4fill in blank
hardFill both blanks to create a formula that divides the value in D4 by the value in E4.
Google Sheets
=D4[1]E4[2]2
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using plus (+) or minus (-) instead of division (/).
Mixing up multiplication and division order.
✗ Incorrect
The slash / divides numbers. Multiplying by 2 after division doubles the result.
5fill in blank
hardFill all three blanks to create a formula that adds A5 and B5, then multiplies the sum by C5.
Google Sheets
=(A5[1]B5)[2]C5[3]1
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Mixing up the order of operations.
Using division (/) instead of subtraction (-) at the end.
✗ Incorrect
First add A5 and B5 with +. Then multiply the sum by C5 with *. The last blank uses minus - with 1 to subtract 1 from the result.