0% found this document useful (0 votes)
4 views1 page

Excel Practice Examples

Uploaded by

anbudeepa06
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
4 views1 page

Excel Practice Examples

Uploaded by

anbudeepa06
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

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.

You might also like