Formula-based rules in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to check if cell A1 is greater than 10.

Excel

=IF(A1 [1] 10, "Yes", "No")

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

A<

B>

C=

D<=

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>'

Using '=' which checks for equality, not greater than

The formula uses the greater than operator (>) to check if A1 is more than 10.

2fill in blank

medium

Complete the formula to sum the values in cells B1 to B5.

Excel

=SUM([1])

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

AB1:B6

BC1:C5

CA1:A5

DB1:B5

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting the wrong column range

Including an extra cell like B6

The SUM function adds all numbers in the range B1 to B5.

3fill in blank

hard

Fix the error in the formula to calculate the average of cells C1 to C4.

Excel

=AVERAGE([1])

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

AC1:C4

BC1-C4

CC1;C4

DC1.C4

Attempts:

3 left

💡 Hint

Common Mistakes

Using dash '-' instead of colon ':'

Using semicolon ';' or dot '.' which are invalid

The correct range syntax uses a colon ':' between start and end cells, like C1:C4.

4fill in blank

hard

Fill both blanks to create a formula that counts how many cells in D1:D10 are equal to 5.

Excel

=COUNTIF([1], [2])

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

AD1:D10

BE1:E10

C"=5"

D"5"

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong range like E1:E10

Using "=5" instead of "5" as criteria

The COUNTIF function needs the range D1:D10 and the criteria "5" to count cells equal to 5.

5fill in blank

hard

Fill all three blanks to create a formula that returns the maximum value in F1:F8 if it is greater than 50, otherwise returns "Low".

Excel

=IF(MAX([1]) [2] 50, MAX([3]), "Low")

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

AF1:F8

B>

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' in the condition

Using different ranges in MAX functions

The formula checks if the max value in F1:F8 is greater than 50. If yes, it returns that max value; otherwise, it returns "Low".