0
0
Excelspreadsheet~10 mins

LARGE and SMALL in Excel - Interactive Code Practice

Choose your learning style9 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash
Practice - 5 Tasks
Answer the questions below
1fill in blank
easy

Complete the formula to find the 3rd largest number in the range A1:A10.

Excel
=LARGE(A1:A10, [1])
Drag options to blanks, or click blank then click option'
A1
B10
C5
D3
Attempts:
3 left
💡 Hint
Common Mistakes
Using 1 instead of 3 returns the largest number, not the 3rd largest.
Using 10 might cause an error if there are fewer than 10 numbers.
2fill in blank
medium

Complete the formula to find the smallest value in the range B2:B20.

Excel
=SMALL(B2:B20, [1])
Drag options to blanks, or click blank then click option'
A1
B0
C2
D20
Attempts:
3 left
💡 Hint
Common Mistakes
Using 0 is invalid because the position must be 1 or greater.
Using 20 returns the 20th smallest, which might not exist.
3fill in blank
hard

Fix the error in the formula to find the 2nd smallest number in C1:C15.

Excel
=SMALL(C1:C15, [1])
Drag options to blanks, or click blank then click option'
A0
B-1
C2
D15
Attempts:
3 left
💡 Hint
Common Mistakes
Using 0 or negative numbers causes errors.
Using 15 returns the 15th smallest, which might be out of range.
4fill in blank
hard

Fill both blanks to create a formula that finds the 4th largest number in D1:D30.

Excel
=LARGE([1], [2])
Drag options to blanks, or click blank then click option'
AD1:D30
BD1:D20
C4
D3
Attempts:
3 left
💡 Hint
Common Mistakes
Using a smaller range than needed.
Using the wrong position number.
5fill in blank
hard

Fill both blanks to create a formula that finds the 5th smallest number in E5:E50.

Excel
=SMALL([1], [2])
Drag options to blanks, or click blank then click option'
AE5:E50
B5
C4
DE1:E50
Attempts:
3 left
💡 Hint
Common Mistakes
Using the wrong range.
Using the wrong position number.