RANK function in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the formula to rank the value in cell A2 among the range A2:A10.

Excel

=RANK([1], A2:A10)

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

AB2

BA1

CA11

DA2

Attempts:

3 left

💡 Hint

Common Mistakes

Using a cell outside the range to rank.

Using a cell from a different column.

The RANK function needs the cell value to rank as the first argument. Here, it is A2.

2fill in blank

medium

Complete the formula to rank the value in B3 among the range B2:B10 in ascending order.

Excel

=RANK([1], B2:B10, 1)

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

AB2

BB3

CA3

DB10

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong cell reference for the value.

Confusing the range with the value cell.

The first argument should be the value you want to rank, which is in cell B3.

3fill in blank

hard

Fix the error in the formula to rank the value in C4 among C2:C10 in descending order.

Excel

=RANK(C4, [1], 0)

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

AC1:C9

BC4:C10

CC2:C10

DB2:B10

Attempts:

3 left

💡 Hint

Common Mistakes

Using a range that excludes some data.

Using a range from a different column.

The range to rank against must include all values, here C2:C10. Using C4:C10 excludes some values.

4fill in blank

hard

Fill both blanks to rank the value in D5 among D2:D10 in ascending order.

Excel

=RANK([1], [2], 1)

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

AD5

BD2:D10

CD3:D9

DD1:D10

Attempts:

3 left

💡 Hint

Common Mistakes

Using a partial range that misses some values.

Using the wrong cell for the value.

The first blank is the value to rank (D5). The second blank is the full range (D2:D10).

5fill in blank

hard

Fill all three blanks to rank the value in E6 among E2:E12 in descending order.

Excel

=RANK([1], [2], [3])

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

AE6

BE2:E12

C0

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using 1 instead of 0 for descending order.

Using an incomplete range.

The first blank is the value cell (E6), the second is the range (E2:E12), and the third is 0 for descending order.