basic excel skills test

Q.No.1: Prepare the following bill and calculate the bill amount for the customers. Also create a suitable chart.

Cust. No.	Name	Current Meter Reading	Previous Meter Reading	Consumed Unit	Bill Amount
A1001	RajKumar Sharma	1250	1130
A1002	Hari Shankar	1320	1305
A1003	Anita K.C.	768	599
A1003	Sarita Thapa	1380	1125

Condition: Minimum Charge upto 20 units is Rs.80, the charge for 21 to 250 units is Rs.7.30 per unit and the charge for more than 250 units is Rs.11.50 per unit.

Q.No. 2: Calculate the wages for the following workers.

S.N.	Name	Working Days	Absent Days	Wages
1.	Sanjaya Neupane	20	10
2.	Sarita Ghimire	24	6
3.	Hari Sharma	28	2
4.	Raju Acharya	29	1

Conditions: Rs. 450 is given for working days and 4 days holiday is announced per month. 50% amount is deducted for absent days except holidays and 50% extra wages is given for working on holidays.

Q.No.3: Prepare the following salary sheet and calculate the income tax, social tax and net salary.

EmpCode	Name	Address	Monthly Salary	IncomeTax	SocialTax	Net Salary
A001	Hari Sharma	Banepa	22500
A002	Ramita Gurung	Kathmandu	27000
A003	Anjana Giri	Bhaktapur	30000
A004	Sarita Ghimire	Sanga	20000

-Social Tax is 1% of salary. Income tax is not charged upto annual income of Rs.250000, 15% tax is charged for annual salary above 250000. 20% income tax is charged for annual salary above 350000.

Q.No.4. Enter following data in Sheet 1 and perform as asked. (10)

S.N.	Name	Quantity (kg)	Rate	Amount	Discount (10%)	Net amount
1	Apple	20	150
2	Lemon	30	120
3	Grapes	50	230

Calculate Amount discount and net amount with suitable formula.

Create a pie chart of Rate

Q.No. 5. Enter following data in Sheet 1 and perform as asked. (10)

SN	Item Name	Item price	Quantity no.	Total
1	Tube light	10	100
2	Tourch Light	20	50
3	LCD Monitor	1400	100
4	CD	20	20000

Do following calculation.

Total =?, Insert "Depawali offer as 20% Discount" calculate value and insert bar chart of total & item name.