Microsoft Excel Exercises
Microsoft Excel ICS Practical PTCB 2025 - 2026
Exercise # 1 - ICS Practical # 9
1. Create the following Work sheet
2. Enter the formula to calculate are of rectangle.
3. Area of Rectangle = Length x Width
2. Enter the formula to calculate are of rectangle.
3. Area of Rectangle = Length x Width
Exercise # 2 - ICS Practical # 10
1. Find Maximum Number in Column A
2. Find Minimum Number in Column A
2. Find Minimum Number in Column A
Exercise # 3 - ICS Practical # 11
1. Create the sheet giving below
2. Find the Square of Numbers
3. Find the cube of Numbers
2. Find the Square of Numbers
3. Find the cube of Numbers
Exercise # 4 - ICS Practical # 12
1. Create the sheet giving below
2. Find the Profit by given formula
3. PROFIT = PRICE - COST
2. Find the Profit by given formula
3. PROFIT = PRICE - COST
Exercise # 5 - ICS Practical # 13
1. Create the Following Sheet
2. Find the Average Marks
2. Find the Average Marks
Exercise # 6 - ICS Practical # 14
1. Create the Following Sheet
2. Calculate the Attendance Percentage by using formula
3. Attendance Percentage = (Lecture Attend / Lecture Delivered) x100
2. Calculate the Attendance Percentage by using formula
3. Attendance Percentage = (Lecture Attend / Lecture Delivered) x100
Exercise # 7 - ICS Practical # 15
1. Create the Following Sheet
2. How many cells have Integer Data in given Range
3. How many cells have any text data or Integer data in given Range
4. How many cells have empty in given Range
2. How many cells have Integer Data in given Range
3. How many cells have any text data or Integer data in given Range
4. How many cells have empty in given Range
Exercise # 8 - ICS Practical # 16
1. Create the Following Sheet
2. Calculate the Medical Allowance which is 30% of Employee Basic Salary
3. Calculate the House Rent which is 45% of Employee Basic Salary
4. Calculate the Conveyance Allowance which is 10% of Employee Basic Salary
5. Calculate the Net Salary which is Net Salary = Basic Salary + House Rent + Conveyance Allowance + Medical Allowance
2. Calculate the Medical Allowance which is 30% of Employee Basic Salary
3. Calculate the House Rent which is 45% of Employee Basic Salary
4. Calculate the Conveyance Allowance which is 10% of Employee Basic Salary
5. Calculate the Net Salary which is Net Salary = Basic Salary + House Rent + Conveyance Allowance + Medical Allowance
Exercise # 9 - ICS Practical # 17
1. Create the Following Sheet
2. Calculate the Grade by using following criteria
Marks >= 900 Grade=A
Marks >= 800 Grade=B
Marks >= 700 Grade=C
Marks >= 600 Grade=D
Marks < 600 Grade=F
2. Calculate the Grade by using following criteria
Marks >= 900 Grade=A
Marks >= 800 Grade=B
Marks >= 700 Grade=C
Marks >= 600 Grade=D
Marks < 600 Grade=F
Exercise # 10 - ICS Practical # 18
1. Create the following sheet which have Rainfall data in Millimeter of some cities
2. Show the each city on Chart according to their Rainfall
2. Show the each city on Chart according to their Rainfall
Exercise # 11 - ICS Practical # 20
1. Create the following sheet
2. Show the Sales on Pie Graph
2. Show the Sales on Pie Graph
Exercise # 12 - ICS Practical # 21
1. Create the following sheet
2. Perform SIN, COS, TAN Function using Built-in-Functions
2. Perform SIN, COS, TAN Function using Built-in-Functions
Exercise # 13 - ICS Practical # 22
1. Create the following sheet
2. Find General Sales Tax of each item which is equal to 17% of each Item Price
3. Find Total Price of each item. Which is sum of Item Price + General Sales Tax
2. Find General Sales Tax of each item which is equal to 17% of each Item Price
3. Find Total Price of each item. Which is sum of Item Price + General Sales Tax
Basic IT IHF
Microsoft Excel Exercises
Exercise # 1
Instructions:
1. Create worksheet given below.
2. Calculate the total of each student row wise.
3. Calculate the total of each student column wise.
4. Fill yellow light color in Column “Name and Total”.
1. Create worksheet given below.
2. Calculate the total of each student row wise.
3. Calculate the total of each student column wise.
4. Fill yellow light color in Column “Name and Total”.
Exercise # 2
Prepare the following worksheet and save it
Perform the tasks:
a. Sale= Quantity*Rate
b. Commission = 7% of the sale
c. Profit = Sale + Commission
Perform the tasks:
a. Sale= Quantity*Rate
b. Commission = 7% of the sale
c. Profit = Sale + Commission
Exercise # 3
Create the worksheet provided according to the following instructions:
1. Create the worksheet of sam format onto your new worksheet as shown below.
2. Enter Sample data and apply formulae to calculate
i. Volume = Length*Height*Width
ii. Surface area = 2(Length*Height+Height*Width+Width*Length)
3. Find Maximum Volume, Minimum Volume, Maximum Area and Minimum Area.
1. Create the worksheet of sam format onto your new worksheet as shown below.
2. Enter Sample data and apply formulae to calculate
i. Volume = Length*Height*Width
ii. Surface area = 2(Length*Height+Height*Width+Width*Length)
3. Find Maximum Volume, Minimum Volume, Maximum Area and Minimum Area.
Exercise # 4
Prepare the following worksheet and save it with your own choice
Instructions:
Use sumifs function calculate the total expenditure against family “A”
Use sumifs function calculate the total expenditure against family “B”
Instructions:
Use sumifs function calculate the total expenditure against family “A”
Use sumifs function calculate the total expenditure against family “B”
Exercise # 5
Prepare the following worksheet and save it with your own choice
Exercise # 6
Calculate the worksheet given below.
1. Calculate Maximum Score as Row wise.
2. Calculate Minimum Score as Column wise.
3. Calculate Maximum score as column wise.
4. Calculate Minimum Score as Overall the Table.
5. Calculate Maximum Score as Overall the Table.
6. Draw a Pie and line Graph from column Batsman Name to Year 2000.
INTERNATIONAL CRICKET PERFORMANCE
1. Calculate Maximum Score as Row wise.
2. Calculate Minimum Score as Column wise.
3. Calculate Maximum score as column wise.
4. Calculate Minimum Score as Overall the Table.
5. Calculate Maximum Score as Overall the Table.
6. Draw a Pie and line Graph from column Batsman Name to Year 2000.
Exercise # 7
Prepare the following time table in excel
Exercise # 8
Calculate the following Undisbursement sheet
Exercise # 9
Prepare the salary sheet
Exercise # 10
Instructions
1. Create the worksheet for result sheet (sample given below).
2. Calculate Pass/Fail of each student, also mention supply subject in remarks, if student
has 1 or 2 supplies & no columns filled of pass/fail, total marks, %age, etc. calculated.
3. Grade calculated only if student passed in all subjects, with the criteria of A+>=95; A>=90; B>=80; C>=65; D>=50 and Fail below 50
4. Insert remarks according to grade of each student like on A+ Extra Ordinary and on Grade C, Average.
5. Draw a line graph of column Student vs English
6. Also show Student name and result that got maximum marks below the sheet.
1. Create the worksheet for result sheet (sample given below).
2. Calculate Pass/Fail of each student, also mention supply subject in remarks, if student
has 1 or 2 supplies & no columns filled of pass/fail, total marks, %age, etc. calculated.
3. Grade calculated only if student passed in all subjects, with the criteria of A+>=95; A>=90; B>=80; C>=65; D>=50 and Fail below 50
4. Insert remarks according to grade of each student like on A+ Extra Ordinary and on Grade C, Average.
5. Draw a line graph of column Student vs English
6. Also show Student name and result that got maximum marks below the sheet.
Exercise # 11
Instructions:
Prepare a yearly based attendance sheet for a whole year, each month separately and join using “Linking Worksheet”.
Every next month get data from last month and also supply conditional formatting on Absent, Leave etc.
Working days, present, absent,leave, percentage, and overall percentage with previous month, dropouts, working hours calculate automatically.
Prepare a yearly based attendance sheet for a whole year, each month separately and join using “Linking Worksheet”.
Every next month get data from last month and also supply conditional formatting on Absent, Leave etc.
Working days, present, absent,leave, percentage, and overall percentage with previous month, dropouts, working hours calculate automatically.
Comments
Post a Comment