Why formulas automate calculations in Excel - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to add values in cells A1 and B1.

Excel

=A1 [1] B1

Drag options to blanks, or click blank then click option'

A-

B+

C*

D/

Attempts:

3 left

💡 Hint

Common Mistakes

Using - instead of +

Using * or / which multiply or divide

The plus sign (+) adds the values in A1 and B1.

2fill in blank

medium

Complete the formula to calculate the average of cells A1 to A5.

Excel

=AVERAGE([1])

Drag options to blanks, or click blank then click option'

AA1+A5

BA1-B5

CA1:A5

DA1*5

Attempts:

3 left

💡 Hint

Common Mistakes

Using minus or plus signs instead of colon

Using multiplication which is not a range

The range A1:A5 selects all cells from A1 to A5 for averaging.

3fill in blank

hard

Fix the error in the formula to multiply cell A1 by 10.

Excel

=A1 [1] 10

Drag options to blanks, or click blank then click option'

A+

B/

C-

D*

Attempts:

3 left

💡 Hint

Common Mistakes

Using + or - which add or subtract

Using / which divides

The asterisk (*) is the correct operator for multiplication in Excel formulas.

4fill in blank

hard

Fill both blanks to create a formula that sums cells B1 to B5 and then divides by 5.

Excel

=[1]([2])/5

Drag options to blanks, or click blank then click option'

ASUM

BAVERAGE

CB1:B5

DA1:A5

Attempts:

3 left

💡 Hint

Common Mistakes

Using AVERAGE function instead of SUM

Using wrong cell ranges

SUM(B1:B5) adds all values in B1 to B5. Dividing by 5 calculates the average manually.

5fill in blank

hard

Fill all three blanks to create a formula that counts how many cells in C1:C10 are greater than 50.

Excel

=COUNTIF([1], "[2][3]")

Drag options to blanks, or click blank then click option'

AC1:C10

B>

C50

DB1:B10

Attempts:

3 left

💡 Hint

Common Mistakes

Using wrong cell range

Using < instead of >

Forgetting quotes around >50 in actual Excel

COUNTIF(C1:C10, ">50") counts cells in C1:C10 with values greater than 50.