Practical Questions
TASK 1: FONT FORMATTING Create a document and apply the following font
formatting:
1. Type "Annual Sales Report 2024" and format it as:
o Font: Arial
o Size: 18 pt
o Color: Dark Blue
o All Caps
o Add a double underline
2. Type the following paragraph and format as specified: "First Quarter
Results: The company achieved significant growth..."
o Font: Calibri
o Size: 12 pt
o Apply bold to "First Quarter"
o Apply italics to "significant growth"
o Add superscript to numerical values
o Change the case to Title Case
3. Create emphasizing text:
o Add text with strikethrough
o Apply subscript to chemical formulas
o Use small caps for abbreviations
o Apply text highlighting
o Add text effects (shadow, outline)
TASK 2: PARAGRAPH FORMATTING
1. Format a business letter with:
o Line spacing: 1.5 lines
o Before paragraph spacing: 12 pt
o After paragraph spacing: 6 pt
o First line indent: 0.5"
o Alignment: Justified
2. Create a bulleted list with:
o Custom bullet symbols
pg. 1
Practical Questions
oDifferent levels of indentation
o Hanging indent: 0.25"
o Space between bullets: 1.15
o Sort them alphabetically
o Include inside border
3. Set up paragraphs with:
o Left indent: 1"
o Right indent: 1"
o Mirror indents
4. Create columns with:
o Three newspaper-style columns
o Line between columns
o Different column widths
o Column break
o Balance columns
TASK 3: SALES COMPARISON CHART
1. Create a column chart showing monthly sales:
Store A Store B Store C
Jan $5,000 $4,500 $3,800
Feb $5,500 $4,800 $4,200
Mar $4,800 $5,200 $4,600
Apr $6,200 $5,600 $5,100
2. Format the chart:
Change chart type to 3D Clustered Column
Add chart title: "Quarterly Store Sales Comparison"
Add axis titles
Change colors of each store's columns
Add data labels
Add a legend at the right
Task 4: Write a sentence which should include a subscript, superscript, word art
and highlight a few words with yellow color. (Model Question Paper)
pg. 2
Practical Questions
Task 5: Create a pie chart for the following data (Model Paper)
Section Number of Students
A 27
B 36
C 32
D 45
Task 6: Create a line chart comparing the quarterly revenue of two companies for the year
2023.
DATA TABLE:
Quarter Company A Company B
Q1 2023 $250,000 $180,000
Q2 2023 $320,000 $220,000
Q3 2023 $280,000 $260,000
Q4 2023 $400,000 $340,000
1. Create Basic Chart:
Insert a line chart
Enter the provided data
2. Format Chart Elements:
Add chart title: "Company Revenue Comparison 2023"
Add axis titles:
o X-axis: "Quarters"
o Y-axis: "Revenue (USD)"
Add data markers (points on lines)
Format numbers as currency
3. Customize Appearance:
Change line styles:
o Company A: Blue, solid line, 2.75pt
o Company B: Red, solid line, 2.5pt
Add data labels to each point
Add gridlines for better readability
Position legend at left
Make markers visible at each data point
pg. 3
Practical Questions
TASK 7: Create a bar chart showing the annual sales of electronic devices for a
retail store.
DATA:
Product 2023 Sales
Smartphones $450,000
Laptops $380,000
Tablets $220,000
Smart Watches $180,000
Headphones $150,000
1. Basic Chart Creation:
Create a horizontal bar chart
Enter the given sales data
Arrange bars in descending order (highest to lowest)
2. Formatting Requirements:
Chart Title: "Electronic Device Sales 2023"
X-axis title: "Sales Revenue (USD)"
Y-axis title: "Product Category"
Bar Color: Use gradient blue shading
Add data labels showing values
Format numbers as currency
3. Additional Elements:
Add gridlines for better readability
Include a border around the chart
Format data labels to show currency
Add a subtle 3D effect to bars
Include a legend
pg. 4
Practical Questions
Task 8: You work at a travel agency and need to create an eye-catching newsletter.
The company name "Dream Vacations" should be displayed prominently at the top
using WordArt with a wave text effect and blue gradient fill. Below this, you need
to insert a hyperlink to your booking website (www.dreamvacations.com) that
displays the text "Click here to plan your next adventure!"
1. How would you create the WordArt title with the specified styling?
2. How would you insert and format the hyperlink?
3. If you later need to edit the hyperlink destination while keeping the same
display text, what steps would you take?
Task 9: You are working on a report in Microsoft Word and need to format it
according to standard guidelines. The guidelines require:
1. A header that includes the document title on the left side.
2. A footer with the page number centered at the bottom of each page.
3. The page numbers should begin from the second page, as the first page is a
title page and should not display a page number.
Task 10: Write a letter to your friend and use mail merge to create 5 copies with
customized name and address field. (Model question).
pg. 5
Practical Questions
Excel
1. You are given a dataset containing sales records of a company. Your task is to
sort and filter the data based on specific conditions.
Dataset (Sales.xlsx)
Order ID Customer Name Product Category Sales ($) Date Region
101 Alice Johnson Laptop Electronics 1200 05-Jan-2024 North
102 Bob Smith Phone Electronics 800 12-Feb-2024 South
103 Charlie Adams Chair Furniture 150 20-Mar-2024 East
104 David Brown Desk Furniture 300 25-Apr-2024 West
105 Emma Wilson Tablet Electronics 600 02-May-2024 North
106 Frank Green Sofa Furniture 700 18-Jun-2024 South
107 Grace White Monitor Electronics 250 22-Jul-2024 East
108 Henry Black Laptop Electronics 1100 10-Aug-2024 West
109 Ivy Taylor Chair Furniture 175 05-Sep-2024 North
110 Jack Evans Desk Furniture 350 15-Oct-2024 South
Tasks to Perform in Excel
1. Sorting Task:
o Sort the data in descending order based on Sales ($).
o Then, sort by Category (Furniture first, then Electronics).
2. Filtering Task:
o Apply a filter to show only Electronics category.
o Further filter to show only sales greater than $500.
3. Bonus Task (Advanced Filtering):
o Use an Advanced Filter to display only sales made in the North and East regions.
pg. 6
Practical Questions
2.You are given a dataset containing following records. Perform the following task
as instructed.
Customer Name Sales Amount Scores Due Date
Alice 3000 65 2024-01-10 00:00:00
Bob 7000 85 2024-02-15 00:00:00
Charlie 4500 50 2024-03-20 00:00:00
Alice 8000 90 2023-12-01 00:00:00
David 12000 75 2024-05-25 00:00:00
Eve 5000 40 2024-06-30 00:00:00
Frank 3500 95 2023-11-05 00:00:00
Grace 6200 60 2024-04-18 00:00:00
Henry 9000 88 2024-07-10 00:00:00
Ivy 4800 70 2023-10-15 00:00:00
Apply Conditional Formatting to demonstrate
1. Sales Data with values above $5000 highlighted in Green.
2. Duplicate Values in the "Customer Name" column highlighted in Red.
3. Data Bars for visualizing the "Sales Amount".
4. Color Scales to show performance levels in "Scores".
5. Expiration Dates highlighted if they are in between 2024-01-30 to 2024-
07-30.
3.Suppose we have a data set
Full Name Emails
John Smith john@example.com, HR
Alice Johnson alice@example.com, IT
Bob Williams bob@example.com, Finance
Emma Brown emma@example.com, Sales
David Miller david@example.com, Marketing
a. Split Full Name into First and Last Name.
b. Split Emails and Departments
pg. 7
Practical Questions
Note:
Instead of Text to Columns, you can use formulas like:
=LEFT(A2, FIND(" ", A2)-1) → Extracts First Name.
=RIGHT(A2, LEN(A2)-FIND(" ", A2)) → Extracts Last Name.
=TEXTSPLIT(A2, ",") (In Excel 365) → Splits text by a delimiter.
1. Create a Dropdown List for "Department"
1. Select the "Department (Dropdown)" column.
2. Go to Data → Data Validation.
3. Under Allow, select List.
4. Enter options like: HR, IT, Finance, Sales, Marketing.
5. Click OK.
2. Allow Age Between 1-100
1. Select the "Age (1-100)" column.
2. Go to Data → Data Validation.
3. Under Allow, select Whole Number.
4. Set Minimum: 1 and Maximum: 100.
5. Click OK.
3. Allow Only Future Dates for "Joining Date"
1. Select the "Joining Date (Future Only)" column.
2. Go to Data → Data Validation.
3. Under Allow, select Date.
4. Set Start Date: =TODAY().
5. Click OK.
4. Restrict "Experience" to Minimum 2 Years (Using Formula)
1. Select the "Experience (Min 2 Years)" column.
2. Go to Data → Data Validation.
3. Under Allow, select Custom.
4. Enter this formula: =A2>=2.
5. Click OK.
pg. 8
Practical Questions
pg. 9
