PRACTICAL EXERCISE 1
Marklist
1. Enter the following details in a workbook
Roll No, Name, Marks of 4 subjects
2. calculate Total Mark,Average and Result(50% mark is needed to pass)
3. Also Find Grade and Rank. (Grade A+: >=90%, A: >=80%, B+: >=70%, B: >=60%,
C+:>=55%, C: >=50%, F: <50%)
PRACTICAL EXERCISE 2
Payroll
1. Enter the following
A B C D E F G H
1 Name Hours
Worked
Hourly
Rate
Basic
Pay
Allowances Gross
Pay
Tax
Deductions
Net
Pay
2 John 8 200
3 Peter 12 450
4 Sam 22 300
5 Njogu 30 286
6 Mary 16 220
7 Sally 45 468
8 Jane 15 150
9 Tina 3 280
2. Calculate the following
Basic Pay = Hours Worked * Hourly Rate.
Allowances are allocated at 10% of the Basic Pay.
Gross Pay = Basic Pay + Allowances.
Tax Deduction is calculated at 20% of the Gross Pay.
Net Pay = Gross Pay – Tax Deductions.
PRACTICAL EXERCISE 3
Electricity Billing
1. Enter the following
Consumer No., Consumer Name, Unit Consumed
2. Calculate Bill Amount. (if Unit consumed is <=30, then amount charge is Rs.200, if
unit consumed >30 and <=80 amount charged is Rs. 450, for every unit above 80,
Rs. 10 is charged)
