Ch02: More in Excel 2019

CHAPTER 2 - More in Excel 2019

📘 Introduction to Excel 2019

Microsoft Excel is a spreadsheet program used to:

• Store data in rows and columns
• Perform calculations
• Create charts and graphs
• Sort and filter data
• Analyze large amounts of information

Excel is widely used in schools, offices, banks, and businesses.

1️⃣ SUM() Function

Meaning: Used to add numbers quickly.

Syntax:

=SUM(number1, number2, ...)

=SUM(A1:A5)

Example:

A
10
20
30

=SUM(A1:A3)

Result = 60

Steps:

1. Select any cell
2. Type =SUM(A1:A3)
3. Press Enter

2️⃣ IF() Function

Meaning: Checks condition and gives different results.

Syntax:

=IF(condition, true_result, false_result)

Example:

Formula: =IF(A1>=40,"Pass","Fail")

If marks are 50 → Pass

If marks are 30 → Fail

Marks	Result
50	Pass
30	Fail

Uses:

1. Result sheet
2. Salary bonus
3. Attendance check

3️⃣ LCM() Function

Finds Least Common Multiple.

Gives smallest common multiple of numbers.

=LCM(4,6)

Result = 12

4️⃣ GCD() Function

Finds Greatest Common Divisor.

Formula: =GCD(12,18)

Answer: 6

5️⃣ Data Sorting

Meaning: Arranging data in order.

• Ascending Order (A-Z / Small-Large)
• Descending Order (Z-A / Large-Small)

Example:

Before Sorting: Ram, Aman, Riya

After Sorting: Aman, Ram, Riya

Steps:

1. Select data
2. Click Data Tab
3. Choose Sort A-Z or Z-A

6️⃣ Custom Sorting

Meaning: Sorting by multiple columns.

Example: Sort by Class, Name, Marks

1. Select table
2. Click Data Tab
3. Click Sort
4. Add levels

7️⃣ Filtering Data

Meaning: Show only selected records.

Example: Students above 80 marks.

1. Select heading row
2. Data Tab
3. Click Filter

Dropdown arrows appear.

8️⃣ Custom Filters

Meaning: Used for special conditions.

• Greater than 50
• Less than 100
• Begins with A

Example: Marks > 70

9️⃣ Removing Filters

Meaning: Show all data again.

1. Go to Data Tab
2. Click Filter again
3. Choose Clear Filter

🔟 Conditional Formatting

Meaning: Highlight cells automatically.

• Red color for low marks
• Green for high marks
• Duplicate values highlight

Steps:

1. Select cells
2. Home Tab
3. Conditional Formatting
4. Choose rule

Example: Marks below 40 become red.

Chalo ab formative and summative Questions Banaya jaye ........:)