Module: M1-R5: Information Technology Tools and Network Basics
Chapter: Spreadsheet
Below data tables to help you practice Excel/LibreOffice Calc functions such as sorting, filtering, charts, pivot tables, and conditional formatting. You can use these for analysis, reports, or automation exercises.
| Month | Product | Units Sold | Price (₹) | Region |
|---|---|---|---|---|
| January | Mobile | 120 | 15000 | Delhi |
| February | Laptop | 80 | 55000 | Mumbai |
| March | TV | 60 | 25000 | Kolkata |
| April | Tablet | 45 | 22000 | Chennai |
| Roll No | Name | IT | Web Design | Python | IoT |
|---|---|---|---|---|---|
| 101 | Ravi | 78 | 85 | 88 | 90 |
| 102 | Neha | 82 | 79 | 91 | 86 |
| 103 | Priya | 88 | 75 | 69 | 92 |
| Emp ID | Name | Basic | DA | HRA | PF | Gross |
|---|---|---|---|---|---|---|
| E001 | Rohit | 25000 | 5000 | 4000 | 1500 | 30500 |
| E002 | Meena | 28000 | 5600 | 4500 | 1600 | 34500 |
| E003 | Arjun | 22000 | 4400 | 3500 | 1200 | 28700 |
| Consumer No | Name | Units Used | Rate per Unit (₹) | Month |
|---|---|---|---|---|
| EB001 | Ravi Kumar | 320 | 6.5 | January |
| EB002 | Neha Gupta | 410 | 6.5 | February |
| EB003 | Rajesh Patel | 260 | 6.5 | March |
| Village | Population | Literacy Rate (%) | Households | District |
|---|---|---|---|---|
| Rampur | 3200 | 78 | 670 | Lucknow |
| Bhawanipur | 2500 | 72 | 480 | Patna |
| Kamalpur | 4100 | 84 | 820 | Jaipur |
| Emp ID | Name | Month | Present Days | Leave |
|---|---|---|---|---|
| 101 | Sita | January | 26 | 2 |
| 102 | Rahul | January | 25 | 3 |
| 103 | Vikram | January | 27 | 1 |
| Item Code | Item Name | Category | Quantity | Reorder Level |
|---|---|---|---|---|
| I001 | Notebook | Stationery | 120 | 50 |
| I002 | Printer Cartridge | Office | 40 | 10 |
| I003 | Mouse | Hardware | 75 | 20 |
| Payment ID | Customer | Mode | Amount (₹) | Status |
|---|---|---|---|---|
| P001 | Ravi | UPI | 5000 | Paid |
| P002 | Priya | Cash | 7000 | Pending |
| P003 | Rohit | Card | 6500 | Paid |
| Payment ID | Customer | Mode | Amount (₹) | Status |
|---|---|---|---|---|
| P001 | Ravi Kumar | UPI | 5000 | Paid |
| P002 | Priya Sharma | Cash | 7000 | Pending |
| P003 | Rohit Singh | Card | 6500 | Paid |
| Emp ID | Name | Department | Basic Pay (₹) | Net Salary (₹) |
|---|---|---|---|---|
| E001 | Neha Gupta | Accounts | 28000 | 34500 |
| E002 | Amit Joshi | Sales | 25000 | 31200 |
| E003 | Pooja Das | IT | 32000 | 40000 |
| Invoice No. | Customer | Product | Qty | Amount (₹) |
|---|---|---|---|---|
| S001 | Ravi | Laptop | 2 | 110000 |
| S002 | Priya | Mobile | 3 | 54000 |
| S003 | Arjun | Printer | 1 | 15000 |
| Roll No. | Name | IT | Web Design | Python | IoT |
|---|---|---|---|---|---|
| 101 | Ravi Kumar | 80 | 85 | 78 | 90 |
| 102 | Neha Sharma | 75 | 82 | 65 | 70 |
| 103 | Amit Das | 60 | 58 | 55 | 62 |
| Bill No. | Name | Units | Rate (₹) | Total (₹) |
|---|---|---|---|---|
| B001 | Ravi | 250 | 6 | 1500 |
| B002 | Priya | 180 | 6 | 1080 |
| B003 | Rohit | 320 | 6 | 1920 |
| Bill ID | Name | Month | Usage (Ltr) | Amount (₹) |
|---|---|---|---|---|
| W001 | Neha | January | 1800 | 360 |
| W002 | Amit | January | 2200 | 440 |
| W003 | Pooja | January | 2000 | 400 |
| Bill No. | User | Plan | Speed | Amount (₹) |
|---|---|---|---|---|
| I001 | Ravi | Fiber 100Mbps | 100Mbps | 799 |
| I002 | Priya | Fiber 200Mbps | 200Mbps | 999 |
| I003 | Rohit | Broadband 50Mbps | 50Mbps | 599 |
| Item ID | Product | Quantity | Unit Price (₹) | Total Value (₹) |
|---|---|---|---|---|
| S001 | Mouse | 50 | 400 | 20000 |
| S002 | Keyboard | 40 | 700 | 28000 |
| S003 | Monitor | 20 | 8000 | 160000 |
| Emp ID | Name | Days Present | Leave | Remarks |
|---|---|---|---|---|
| E001 | Ravi | 26 | 2 | Good |
| E002 | Neha | 25 | 3 | Average |
| E003 | Amit | 28 | 0 | Excellent |
| Vehicle No. | Driver | Route | KMs | Fuel (L) |
|---|---|---|---|---|
| OD02B1234 | Ravi | Bhubaneswar–Cuttack | 60 | 8 |
| OD02C5678 | Ajay | Puri–BBSR | 120 | 15 |
| OD02A9087 | Neha | BBSR–Khorda | 40 | 5 |
| Item Code | Item Name | Category | Quantity | Price (₹) |
|---|---|---|---|---|
| IT001 | Pen Drive | Accessories | 30 | 600 |
| IT002 | Hard Disk | Storage | 20 | 3500 |
| IT003 | SSD | Storage | 15 | 5000 |
| Roll No. | Name | Month | Present | Absent |
|---|---|---|---|---|
| 101 | Ravi | January | 25 | 2 |
| 102 | Priya | January | 23 | 4 |
| 103 | Rohit | January | 26 | 1 |
| Expense ID | Item | Category | Cost (₹) | Date |
|---|---|---|---|---|
| EX001 | Stationery | Office | 2500 | 01-Jan-2025 |
| EX002 | Electricity | Utilities | 4800 | 05-Jan-2025 |
| EX003 | Internet | Services | 900 | 10-Jan-2025 |
| PO No. | Supplier | Item | Qty | Amount (₹) |
|---|---|---|---|---|
| PO001 | TechMart | Router | 5 | 25000 |
| PO002 | OfficeNeeds | Paper | 10 | 3500 |
| PO003 | CompuWorld | Printer | 2 | 30000 |
| Book ID | Title | Author | Issued To | Status |
|---|---|---|---|---|
| B001 | HTML Basics | John Doe | Ravi | Issued |
| B002 | Python 101 | Mark Lee | Neha | Returned |
| B003 | IoT Systems | Dr. Ray | Priya | Issued |
| Return ID | Product | Customer | Reason | Status |
|---|---|---|---|---|
| R001 | Mobile | Ravi | Defective | Accepted |
| R002 | Printer | Neha | Wrong Model | Pending |
| R003 | Laptop | Arjun | Screen Issue | Resolved |
| Emp ID | Name | Month | Bonus (₹) | Status |
|---|---|---|---|---|
| E001 | Ravi | Jan | 2000 | Approved |
| E002 | Neha | Jan | 1800 | Pending |
| E003 | Arjun | Jan | 2500 | Approved |
| Vendor ID | Name | Invoice | Amount (₹) | Status |
|---|---|---|---|---|
| V001 | TechnoWorld | INV1201 | 32000 | Paid |
| V002 | OfficePro | INV1202 | 18000 | Pending |
| V003 | SoftLink | INV1203 | 26000 | Paid |
| Village Name | Population | Households | Literacy Rate (%) | Water Source |
|---|---|---|---|---|
| Rampur | 2200 | 400 | 68 | Well |
| Laxmipur | 3100 | 550 | 75 | Borewell |
| Haripur | 1800 | 300 | 60 | River |
| Employee | Date | Task | Hours | Status |
|---|---|---|---|---|
| Ravi | 01-Nov-2025 | Data Entry | 6 | Completed |
| Neha | 01-Nov-2025 | Inventory Check | 7 | Completed |
| Amit | 01-Nov-2025 | Sales Update | 5 | Pending |
Login with Google