🎬 Video Lecture 📊 Presentation Slides 📝 Practice Quiz 📁 Unit 4 Hub
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
📊 Slide Deck 📝 Take Quiz
⬅️ Previous Episode 🏠 Unit Overview Next Episode ➡️

✍️ 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) returns 2 (only 50 and 80 are numbers).
  • =COUNTA(A1:A5) returns 4 (4 cells contain data).
  • =COUNTBLANK(A1:A5) returns 1 (only 1 cell is empty).