Episode 4.8
EXCEL FUNCTIONS
Class 10 (X) • Unit 4: Digital Data Tabulation - Spreadsheet (MS Excel)
💡 Direct Stream: You can also watch directly on YouTube or via local server:
📺 Watch on YouTube.com
Episode code: 4.8
✍️ Episode 4.8 Topic Notes
📌 A. `=SUM(number1, [number2], ...)`
- Adds all numerical values within the specified arguments.
- Key Behavior: Automatically ignores text labels and blank empty cells; if cell B3 contains
"Absent",=SUM(B1:B10)simply ignores B3 and sums the remaining numbers.
📌 B. `=AVERAGE(number1, [number2], ...)`
- Calculates the arithmetic mean of the supplied numerical arguments ($\text{Sum} / \text{Count}$).
- CRITICAL DISTINCTION:
- An empty/blank cell is completely ignored in both the numerator (sum) and denominator (count).
- A cell containing the number
0(zero) IS counted in the denominator!
📌 C. `=MAX(number1, [number2], ...)`
- Scans the range and returns the highest (maximum) numerical value.
📌 D. `=MIN(number1, [number2], ...)`
- Scans the range and returns the lowest (minimum) numerical value.
📌 Practical Counting Example:
=COUNT(A1:A5)returns2(only 50 and 80 are numbers).=COUNTA(A1:A5)returns4(4 cells contain data).=COUNTBLANK(A1:A5)returns1(only 1 cell is empty).