0
0
Excelspreadsheet~10 mins

Subtotals 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 calculate the subtotal of the range A1 to A10.

Excel
=SUBTOTAL([1], A1:A10)
Drag options to blanks, or click blank then click option'
A101
B9
C109
D1
Attempts:
3 left
💡 Hint
Common Mistakes
Using 1 instead of 109 sums all cells including hidden ones.
Using 9 sums all cells including hidden ones.
2fill in blank
medium

Complete the formula to calculate the average of visible cells in B2:B20.

Excel
=SUBTOTAL([1], B2:B20)
Drag options to blanks, or click blank then click option'
A109
B101
C9
D1
Attempts:
3 left
💡 Hint
Common Mistakes
Using 1 calculates average including hidden rows.
Using 9 or 109 calculates sum, not average.
3fill in blank
hard

Fix the error in the formula to count visible numeric cells in C3:C15.

Excel
=SUBTOTAL([1], C3:C15)
Drag options to blanks, or click blank then click option'
A102
B3
C2
D103
Attempts:
3 left
💡 Hint
Common Mistakes
Using 2 counts all numeric cells including hidden ones.
Using 3 or 103 counts non-numeric cells.
4fill in blank
hard

Fill both blanks to calculate the maximum of visible cells in D5:D25, ignoring hidden rows.

Excel
=SUBTOTAL([1], [2])
Drag options to blanks, or click blank then click option'
A104
BD5:D25
C105
DD1:D20
Attempts:
3 left
💡 Hint
Common Mistakes
Using 105 calculates minimum instead of maximum.
Using wrong range like D1:D20.
5fill in blank
hard

Fill both blanks to calculate the count of visible non-empty cells in E10:E30.

Excel
=SUBTOTAL([1], [2])
Drag options to blanks, or click blank then click option'
ACOUNTA
BE10:E30
C103
D102
Attempts:
3 left
💡 Hint
Common Mistakes
Using 102 counts only numeric cells.
Using function name 'COUNTA' instead of function number.