EXCELPART3

MS Excel Lecture Part 3

Sorting Example

Scores: 45, 70, 30, 90

Step 1: Highlight cells
Step 2: Click Data → Sort Smallest to Largest

Result: 30, 45, 70, 90

Conditional Formatting Example

Goal: Highlight scores below 50

Step 1: Select score column
Step 2: Click Conditional Formatting
Step 3: Choose Highlight Cell Rules → Less Than → 50

All values below 50 will turn red.

Creating a Chart

Step 1: Select sales data
Step 2: Click Insert
Step 3: Choose Column Chart

Excel automatically generates a visual graph.