Why statistical functions summarize data in Excel - Test Your Understanding

Practice - 5 Tasks

1fill in blank

easy

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

Excel

=AVERAGE([1])

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

ACOUNT(A1:A5)

BSUM(A1:A5)

CA1+A5

DA1:A5

Attempts:

3 left

💡 Hint

Common Mistakes

Using SUM or COUNT inside AVERAGE instead of a range.

Adding cells instead of using a range.

The AVERAGE function needs a range like A1:A5 to calculate the mean of those cells.

2fill in blank

medium

Complete the formula to find the highest value in cells B2 to B10.

Excel

=MAX([1])

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

AB2-B10

BB2:B10

CMAX(B2:B10)

DB2,B10

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash instead of a colon for the range.

Passing multiple arguments separated by commas incorrectly.

The MAX function requires a range like B2:B10 to find the largest number in those cells.

3fill in blank

hard

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

Excel

=COUNT([1])

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

AC1:C8

BC1-C8

CCOUNT(C1:C8)

DC1,C8

Attempts:

3 left

💡 Hint

Common Mistakes

Using a dash instead of a colon for the range.

Including the COUNT function inside itself.

The COUNT function needs a proper range like C1:C8 to count numeric cells correctly.

4fill in blank

hard

Fill both blanks to create a formula that calculates the median of values in D1 to D12.

Excel

=MEDIAN([1]:[2])

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

AD1

B:

CD12

D,

Attempts:

3 left

💡 Hint

Common Mistakes

Using a comma instead of a colon to separate cells.

Only putting one cell reference without a range.

So, D1, :, and D12 are needed to form the range.

5fill in blank

hard

Fill all four blanks to create a formula that counts how many cells in E1 to E15 are greater than 10.

Excel

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

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

AE1

B:

C">10"

DE15

Attempts:

3 left

💡 Hint

Common Mistakes

Using commas instead of a colon for the range.

Not putting the condition in quotes.

Using the wrong comparison operator.