Why built-in tools accelerate analysis in Excel - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to sum values in cells A1 to A5.

Excel

=SUM([1])

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

AA1+A5

BA1:A5

CA1-A5

DA1*A5

Attempts:

3 left

💡 Hint

Common Mistakes

Using plus signs instead of a range

Using multiplication instead of sum

The SUM function adds all numbers in the range A1 to A5.

2fill in blank

medium

Complete the formula to find the average of cells B1 to B10.

Excel

=AVERAGE([1])

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

AB1+B10

BB1*B10

CB1:B10

DB1-B10

Attempts:

3 left

💡 Hint

Common Mistakes

Using addition or multiplication instead of a range

Forgetting the colon between cell references

The AVERAGE function calculates the mean of the numbers in the range B1 to B10.

3fill in blank

hard

Fix the error in the formula to count how many cells in C1:C20 contain numbers.

Excel

=COUNT([1])

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

AC1-C20

BC1*C20

CC1+C20

DC1:C20

Attempts:

3 left

💡 Hint

Common Mistakes

Using minus or plus instead of colon

Multiplying cell references inside COUNT

The COUNT function requires a range like C1:C20 to count numeric cells.

4fill in blank

hard

Fill both blanks to create a formula that returns the maximum value in D1:D15 if it is greater than 50.

Excel

=IF(MAX([1]) [2] 50, MAX(D1:D15), "No")

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

AD1:D15

B>

C<

DD1+D15

Attempts:

3 left

💡 Hint

Common Mistakes

Using addition instead of range

Using less than symbol instead of greater than

MAX(D1:D15) finds the highest value in the range. The IF checks if it is greater than 50.

5fill in blank

hard

Fill all three blanks to create a formula that counts how many cells in E1:E20 are less than 100.

Excel

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

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

AE1:E20

B<

C100

DE1+E20

Attempts:

3 left

💡 Hint

Common Mistakes

Using addition instead of range

Not using quotes around the criteria

Separating operator and number incorrectly

COUNTIF counts cells in E1:E20 where the value is less than 100 using the criteria "<100".