Practice - 5 Tasks
Answer the questions below
1fill in blank
easyComplete the formula to add values in cells A1 and B1.
Excel
=A1[1]B1 Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using minus or multiplication instead of addition.
Forgetting to use an operator.
✗ Incorrect
The plus sign + adds the values of A1 and B1.
2fill in blank
mediumComplete the formula to calculate the average of cells A1 to A5.
Excel
=AVERAGE([1]) Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using a minus sign instead of a colon.
Listing cells separated by commas without parentheses.
✗ Incorrect
The range A1:A5 selects all cells from A1 to A5 for averaging.
3fill in blank
hardFix the error in the formula to multiply cell B2 by 10.
Excel
=B2[1]10
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using plus or minus instead of multiplication.
Using division operator by mistake.
✗ Incorrect
The asterisk * is the multiplication operator in Excel formulas.
4fill in blank
hardFill both blanks to create a formula that sums cells C1 to C5 and then divides by 5.
Excel
=[1](C1:C5)[2]5
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Using plus instead of division after the sum.
Using a function other than SUM.
✗ Incorrect
SUM(C1:C5) adds the values, and /5 divides the total by 5 to find the average.
5fill in blank
hardFill all three blanks to create a formula that counts how many cells in D1 to D10 are greater than 50.
Excel
=COUNTIF([1], [2][3])
Drag options to blanks, or click blank then click option'
Attempts:
3 left
💡 Hint
Common Mistakes
Forgetting the quotes around the condition.
Using the wrong range or condition.
✗ Incorrect
COUNTIF(D1:D10, ">50") counts cells in the range D1 to D10 with values greater than 50. The quotes are needed around the condition.