Excel Practice Example Sums
1. Find the SUM of: 120, 250, 300, 450.
2. Find the AVERAGE of: 45, 60, 75, 90.
3. Find the MAX and MIN values from: 12, 78, 45, 99, 23.
4. Calculate 18% GST on ■5,000.
5. Employee Salary = ■25,000, HRA = 20%, DA = 10%. Find Gross Salary.
6. Sales: Jan=15000, Feb=18000, Mar=22000. Find Total Sales.
7. Use IF formula: If marks >= 35, Result='Pass', otherwise 'Fail'.
8. Count how many numbers are in: 10, 20, 30, 40, 50.
9. Calculate discount amount for ■2,000 at 10%.
10. Create a simple monthly expense sheet and find total expenses.