Learn Excel with AI | Part - 4

 Learn Excel with Copilot A.I.

Basic Functions in Excel

Excel provides several built-in functions that help with calculations and data analysis. In this section, we'll cover four fundamental functions:

1. SUM Function

Purpose: Adds numbers in a range of cells.

Syntax:

=SUM(number1, number2, ...)

or

=SUM(range)

Example:

• =SUM(A1:A5) → Adds values from cells A1 to A5.
• =SUM(10, 20, 30) → Returns 60.

---

2. AVERAGE Function

Purpose: Calculates the average (arithmetic mean) of a group of numbers.

Syntax:

=AVERAGE(number1, number2, ...)

or

=AVERAGE(range)

Example:

• =AVERAGE(A1:A5) → Finds the average of numbers in A1 to A5.
• =AVERAGE(10, 20, 30) → Returns 20.

---

3. COUNT Function

Purpose: Counts the number of numeric values in a range.

Syntax:

=COUNT(range)

Example:

• =COUNT(A1:A10) → Counts how many numeric values exist in A1 to A10.
• =COUNT(10, 20, "text") → Returns 2 (ignores text).

---

4. MIN and MAX Functions

• MIN Function: Returns the smallest value in a range.
• MAX Function: Returns the largest value in a range.

Syntax:

=MIN(range)
=MAX(range)

Example:

• =MIN(A1:A5) → Returns the smallest number in A1 to A5.
• =MAX(A1:A5) → Returns the largest number in A1 to A5.
• =MIN(5, 10, 3, 7) → Returns 3.
• =MAX(5, 10, 3, 7) → Returns 10.

---

Practice Exercise:

Try these in an Excel sheet:

1. Enter numbers in A1 to A5 and apply SUM, AVERAGE, COUNT, MIN, and MAX.
2. Use SUM(A1:A10) to total values from A1 to A10.
3. Check COUNT(A1:A10) when some cells have numbers and some have text.

Let me know if you need further clarification! 🚀