Practical Worksheet
MS Word Tasks
1. Resume Creation
o Create a one-page professional resume for the position of Software Developer.
o Ensure the following:
Use bold, italics, and underline to highlight key information.
Insert a table to showcase your educational qualifications.
Include a chart showing your skill proficiency in at least 5 skills (e.g.,
communication, coding, teamwork, etc.).
Add a professional profile picture.
o Use Mail Merge to create personalized resumes for three candidates, changing
their names and addresses.
2. Newsletter Design
o Design a one-page newsletter for a school event.
o Include:
A title in a large, bold, and centered font.
At least two paragraphs with formatted headings and subheadings.
A table summarizing the schedule of events.
One image and one chart (e.g., pie chart showing student participation).
MS Excel
1. Sales Data Analysis
o You are given the following sales data:
Departmen Month Sales Expenses ($) Profit ($)
t ($)
Electronics Jan 15000 5000 10000
Fashion Jan 12000 4000 8000
Groceries Jan 10000 6000 4000
Electronics Feb 18000 8000 10000
Fashion Feb 14000 6000 8000
Groceries Feb 12000 7000 5000
o Tasks:
Format the table with borders and alternating row colors.
Sort the data in descending order of Profit ($).
Apply a filter to display only rows where Profit ($) is greater than or
equal to 8000.
Insert a chart showing the profit trends for each department over the
months.
Use functions to calculate the total, average, minimum, and maximum
profits.
Identify which department had the highest total profit.
2. Grade Analysis
o Use the following student grades:
Name Subject Marks
Alice Math 85
Bob Science 75
Charlie English 65
Diana Math 95
Edward Science 85
Fiona English 70
o Tasks:
Format the table with bold headers and number formatting for the Marks
column.
Sort the data alphabetically by Name.
Filter the data to display only students who scored above 80.
Create a bar chart to compare marks in different subjects.
Use functions to calculate the total marks for each subject and find the
subject with the highest average marks.
Solutions
MS Word Solutions
1. Resume Creation
o Add proper formatting for headings and bullet points.
o Insert a table like:
Degree Institution Year Percentage
B.Tech (CSE) XYZ University 2022 85%
o Use a chart with skill bars like:
Skill Proficiency (%)
Communication 90
Coding 80
o Customize mail merge for three names.
2. Newsletter Design
o Title: Annual Sports Meet 2024
o Add paragraphs with clear formatting.
o Use a table like:
Time Event Venue
10 AM 100m Race Playground
o Insert an image and a simple pie chart.
MS Excel Solutions
1. Sales Data Analysis
o Sort the table by Profit ($):
Department Month Sales Expenses Profit
Electronics Jan 15000 5000 10000
Electronics Feb 18000 8000 10000
o Filter to show profits >= 8000.
o Insert a line chart with months on the x-axis and profits on the y-axis.
o Total Profits: 48000, Average: 8000, Min: 4000, Max: 10000.
o Electronics had the highest total profit (20000).
2. Grade Analysis
o Sort by Name:
Name Subject Marks
Alice Math 85
o Filter marks > 80.
o Bar chart comparing marks: Subjects on x-axis, Marks on y-axis.
o Total: Math (180), Science (160), English (135).
o Math had the highest average marks (90).
