1️⃣ Real-Life Office Tasks

Excel ব্যবহার করে অফিসে যেসব কাজ করা হয় তার মধ্যে প্রধান কিছু:

Salary Sheet → বেতন ও Allowance দিয়ে Total Salary হিসাব।
Stock / Inventory Sheet → Opening Stock, Sold, Closing Stock ও Reorder Alert।
Invoice / Bill → Qty × Unit Price এবং Grand Total।
Result Sheet → Subject-wise Marks → Total, Average, Result (Pass/Fail)।
Attendance Record → Total Present + % Attendance।

💡 সব কাজ Formula, Functions এবং Charts ব্যবহার করে করা হয়।

2️⃣ Excel Interview Questions

Excel interview-এ সাধারণ প্রশ্নগুলো:

Sales Report Example:

Month	Product	Quantity	Price	Total Price
Jan	Pen	50	5	`=B2*C2`
Jan	Notebook	20	15	`=B3*C3`
Pivot Table: Product-wise Total
Column Chart: Monthly Sales
Conditional Formatting: High Sale Highlight

#	Project	Key Formula / Task
1	Salary Sheet	`=B2+C2`
2	Attendance Sheet	`=COUNTIF(B2:D2,"P")`
3	Student Result Sheet	`Total=SUM(B2:C2), Average=AVERAGE(B2:C2), Result=IF(D2>=50,"Pass","Fail")`
4	Invoice / Bill	`Total=B2*C2, Grand Total=SUM(D2:D3)`
5	Stock / Inventory	`Closing Stock=B2-C2`
6	Loan / EMI Calculator	`=PMT(C2/12,12,B2)`
7	Budget Sheet	`Variance=B2-C2`
8	Project Timeline	`Duration=C2-B2`
9	Sales Report	`Total Sale=B2*C2, Grand Total=SUM(D2:D3)`
10	Expense Tracker	`Total=SUM(C2:C3)`
11	Commission Calculator	`Commission=B2*C2`
12	Employee Overtime	`Overtime Hours=B2-C2, Pay=D2*Rate`
13	Customer Order Tracker	Filter Pending Orders
14	Attendance % Sheet	`% Attendance=C2/B2*100`
15	Expense Category Analysis	`Total=SUM(B2:D2)`
16	Profit & Loss Statement	`Profit=B2-C2`
17	Stock Reorder Alert	`=IF(B2<C2,"Yes","No")`
18	Employee Bonus	`Bonus=B2*C2`
19	Student Grade Sheet	`=IF(B2>=80,"A",IF(B2>=60,"B","C"))`
20	Project Cost Estimation	`Total=B2*C2, Grand Total=SUM(D2:D4)`

Data: Name, Math, English, Science
Formulas:
- Total: =SUM(B2:D2)
- Average: =AVERAGE(B2:D2)
- Result: =IF(E2>=40,"Pass","Fail")
Conditional Formatting → Fail → Red Highlight