Notes

MS-EXCEL
=============================================================

Q1. From the given table below calculate –
DA as 20% of basic salary
HRA as 35% of basic salary if basic salary >= 30,000, else, HRA as 20% of basic salary
Total salary as Basic salary + DA + HRA

Employee Number Basic Salary DA HRA Total Salary
101 35000
102 20000
103 28000
104 33000
105 22000
--------------------------------------------------------------
Q2. From the given table below calculate –
Income tax as per the table –

Taxable income Rate
First 1,00,000 Nil
Next 60,000 10%
Excess 20%

Surcharge as 3% of income tax
Total tax as Income tax + surcharge

Employee Number Taxable Income Income Tax Surcharge Total Tax
101 35000
102 20000
103 28000
104 33000
105 22000
--------------------------------------------------------------
Q3. From the table given below filter –
1. All students who have scored more than 55 in economics and less than 65 in finance
2. Plot subject-wise pie chart for roll number 5

Roll Number Economics Marketing Finance Computer
1 63 68 72 74
2 54 56 74 55
3 61 59 55 82
4 52 55 66 76
5 52 69 53 86
6 52 66 73 82
7 64 50 74 85
8 53 68 58 73
9 52 59 68 53
10 56 58 77 89
--------------------------------------------------------------
Q4. In the given table allocate bonus to all employees using lookup functions –

Employee Number Sales Bonus
101 53000
102 120000
103 250000
104 460000
105 230000

Sales Bonus
50000 2500
100000 3500
200000 4500
300000 6000
400000 7500
--------------------------------------------------------------
Q5. In the given table calculate the total units that can be produced if total cost cannot exceed 54,000. Use Goal seek to solve the problem –

Total Units Produced 2000
Cost per Unit 30
Total Cost
Total Cost = Total units produced X Cost per unit
--------------------------------------------------------------
Q6. From the given table below calculate –
DA as 24% of basic salary
HRA as 36% of basic salary if basic salary >= 35,000, else, HRA as 25% of basic salary
Total salary as Basic salary + DA + HRA

Employee Number Basic Salary DA HRA Total Salary
101 45000
102 30000
103 28000
104 33000
105 22000
--------------------------------------------------------------
Q7. From the given table below calculate –
Income tax as per the table –

Taxable income Rate
First 2,00,000 Nil
Next 80,000 12%
Excess 22%

Surcharge as 4% of income tax
Total tax as Income tax + surcharge

Employee Number Taxable Income Income Tax Surcharge Total Tax
101 350000
102 200000
103 280000
104 330000
105 220000
--------------------------------------------------------------
Q8. In the given table calculate the total units that can be produced if total cost cannot exceed 72,000. Use Goal seek to solve the problem –

Total Units Produced 2000
Cost per Unit 54
Total Cost
Total Cost = Total units produced X Cost per unit
--------------------------------------------------------------
Q9. From the table given below filter –
1. Plot subject-wise bar chart for all students
2. All students who have scored more than average marks in computer

Roll Number Economics Marketing Finance Computer
1 63 68 72 74
2 54 56 74 55
3 61 59 55 82
4 52 55 66 76
5 52 69 53 86
6 52 66 73 82
7 64 50 74 85
8 53 68 58 73
9 52 59 68 53
10 56 58 77 89
--------------------------------------------------------------
VISUAL BASICS
================================================================
Q1. Develop a VB project to design suitable form to Subtract two numbers and display the result

Q2. Develop a VB project to design suitable form to enter total price and calculate and display GST as 18% of the price

Q3. Develop a VB project to design suitable form to accept radius of a circle and calculate and display the circumference of circle [circumference = 2 X 3.14 X radius]

Q4. Develop a VB project to design suitable form to accept length of a square and calculate and display the perimeter of square [Perimeter = 4 X length]

Q5. Develop a VB project to design suitable form to enter basic salary and calculate and display HRA as 20% of basic salary, and total salary as basic salary + HRA

Q6. Develop a VB project to design suitable form to multiply and divide two numbers and display the result

Q7. Develop a VB project to design suitable form to enter sales and calculate and display bonus as 15% of sales

Q8. Develop a VB project to design suitable form to accept length and breadth of rectangle and calculate and display the perimeter of rectangle [perimeter = 2 X (length + Breadth)]

Q9. Develop a VB project to design suitable form to accept radius of a circle and calculate and display the area of circle [Area = 3.14 X radius X radius]

Q10. Develop a VB project to design suitable form to enter basic salary and calculate and display HRA as 20% of basic salary, PF as 8% of basic salary and Net salary as basic salary + HRA - PF