Learning Notes
📘 Day 1 – Step-by-Step Practice Guide
🔹 Step 1: Open the file
- Open Excel
- Open the downloaded file
🔹 Step 2: Understand structure
You will see 3 columns:
- Student Name
- Age
- Marks
👉 This is your basic table
🔹 Step 3: Practice basic editing
Do these tasks:
- Add 5 more students below
- Change marks of any 3 students
- Add one new column:
- Column name: Class
- Fill values like: A, B, C
🔹 Step 4: Formatting practice
- Make headers bold
- Add borders to table
- Change header color (any color)
- Align text center
🔹 Step 5: Simple understanding task
Answer these manually (no formula yet):
- Who has highest marks?
- Who has lowest marks?
🔥 Long Task (Important)
Create your own new sheet in same file:
👉 Sheet Name: My Class Data
Create from scratch:
- 20 students (your choice names)
- Columns:
- Name
- Age
- Marks
🎯 Goal of Day 1
After today, you should:
- Understand Excel screen
- Enter data confidently
- Format a simple table
📊 Day 1 Data Table
| Student Name | Age | Marks |
|---|---|---|
| Rahul | 18 | 75 |
| Amit | 19 | 82 |
| Neha | 18 | 90 |
| Priya | 17 | 65 |
| Rohit | 18 | 70 |
| Anjali | 19 | 88 |
| Karan | 18 | 72 |
| Pooja | 17 | 91 |
| Vikas | 19 | 60 |
| Sneha | 18 | 85 |
| Arjun | 19 | 78 |
| Simran | 17 | 92 |
| Deepak | 18 | 66 |
| Riya | 19 | 89 |
| Manish | 18 | 74 |
| Kavita | 17 | 81 |
| Suresh | 19 | 68 |
| Meena | 18 | 87 |
| Ajay | 17 | 73 |
| Nisha | 18 | 84 |