← Return to Learning Hub
PGDCA-104 · Session 2025-26

MS Office
Practical Guide

Complete Step-by-step solutions with screen outputs · PGDCA-I Semester · All Questions

W Word X Excel P PowerPoint A Access Pu Publisher
50
Total Marks
3h
Duration
W

MS Word Practicals

Q1–Q18 · File operations, Formatting, Tables, Equations, Mail Merge

Q.1

Working with Word Processor — File, Edit, Format Operations (i–xx)

▾

Type the given passage and perform the following tasks:

Word1.doc — Microsoft Word
Home
Insert
Page Layout
References
Mailings
Review
View
✂ Cut
📋 Copy
📌 Paste
⬅ Undo
➡ Redo
🔍 Find
Replace
B
I
U
≡ Justify
← 0.2" · · · · · · · · · · · · · · · · · · · · · · 6" →

Working with Word Processor

As already mentioned, a word processor is a package that processes textual matter and creates organized and flawless documents. In addition to it a word processor not only remote all the limitations of typewriter but also offers various useful features that cannot be even dreamt of with typewriter.

Also if same textual matter is to be reproduced with minor changes, retyping the only option in typewriters.

The main components of a word processing system are listed below:

a. Computer
b. Printer
c. A word processing software

Page 1 of 1 · Words: 87 Zoom: 100%
i
Insert after 1st paragraph: Place cursor at end of 1st paragraph → Press Enter → Type the components list (Computer, Printer, A word processing software) using Home → Bullets
ii
Save as Word1.doc: Press Ctrl+S → File name: Word1.doc → Click Save
iii
Move 2nd paragraph using Drag & Drop: Select 2nd paragraph → Hold left mouse → Drag to document end → Release
iv
Move using Cut-Paste: Select paragraph → Ctrl+X → Click at document end → Ctrl+V
v
Undo: Press Ctrl+Z (or click Undo ⬅ button on toolbar)
vi
Redo: Press Ctrl+Y (or click Redo ➡ button)
vii
Go to End (one step): Press Ctrl+End
viii
Go to Beginning (one step): Press Ctrl+Home
ix
Insert Page Break before 3rd paragraph: Click before 3rd paragraph → Ctrl+Enter
x
Find "computer": Ctrl+F → Type computer → Check Match case + Find whole words only → Click Find All
xi
Replace "typewriters" → "word processor": Ctrl+H → Find: typewriters → Replace: word processor → Replace All
xii
Undo Replace: Ctrl+Z
xiii
Remove All page breaks: Ctrl+H → Find: ^m (manual break) → Replace: (empty) → Replace All
xiv
Zoom: View tab → Zoom → Select 75%, 100%, 150%, etc.
xv
Paragraph Formatting: Select all → Home → Paragraph dialog → Alignment: Justified · Indentation Left: 0.2", Right: 0.2" · Spacing Before: 6pt, After: 6pt · Special: First line 0.4" · Line spacing: 1.5 lines
xvi
Default Tab Stop: Home → Paragraph → Tabs → Default Tab Stop: 0.3"
xvii
Margins to 1.25: Page Layout → Margins → Custom → Top/Bottom/Left/Right: 1.25"
xviii
Page Format: Page Layout → Margins → Custom · Left: 0.5", Right: 0.5" · Top: 1.5", Bottom: 0.5" · Gutter: 1", Header/Footer: 0.5"
xix
Format "Word Processor" occurrences: Ctrl+H → More → Format → Font → Bold, Italic, Underline, Small Caps → Replace All
xx
Center & format heading: Select heading → Ctrl+E (center) → Bold: Ctrl+B · Underline: Ctrl+U · Italic: Ctrl+I
Q.2

Computers Document — Find, Replace, Case Change, Border, Header/Footer

▾
Computers.doc — Microsoft Word
Home
Insert
Page Layout
🔍 Find
Replace
Borders ▾
Header ▾
Footer ▾
aA Change Case ▾
Header: Creations — Page 1

COMPUTERS IN TODAY'S WORLD

Computers

COMPUTER is an electronic device that processes data and gives meaningful information...

EXPERT SYSTEMS

HUMAN THINKING AND ARTIFICAL INTELLIGENCE

Can computer think?

Footer: The school of computing — Page 1
1
Find "Computer" (all cases): Ctrl+F → Type Computer → Uncheck "Match case" → Find All
2
Find whole word only: Ctrl+F → More → Check "Find whole words only" → Search computer
3
Change uppercase to lowercase: Select all Ctrl+A → Home → Change Case → lowercase
4
Add heading: Click at top → Type COMPUTERS IN TODAY'S WORLD → Heading 1 style
5
Centre "Computer" heading: Select first line → Ctrl+E
6
Outside border on document: Page Layout → Page Borders → Box → Apply to: Whole Document
7
Outside border on heading only: Select heading → Home → Borders → Outside Border
8
Page Setup: Page Layout → Margins → Custom: Top 1.5", Bottom 1.5", Gutter 1", Left 1.5", Right 1" · Size: Width 7.5", Height 6.5" · Orientation: Portrait
9
Header & Footer: Insert → Header → type Creations · Insert → Footer → type The school of computing + Insert Page Number
10
Different First/Odd/Even pages: Header & Footer Tools → Check "Different First Page" + "Different Odd and Even Pages"
11
Save & Close: Ctrl+S → Ctrl+W
Q.3 & 4

Write Chemical & Mathematical Equations using MS Word Equation Editor

▾
💡
How to insert: Insert tab → Equation (or press Alt+=) → Type equation using equation toolbar
Q3 — Equations
4H3PO3 = 3H3PO4 + PH3
PCL3 + CL2 = PCL5
(x+y)2 = x2 + y2 + 2xy
Q4 — Equations
C2H5OH + PCL5 = C2H5CL + POCL3 + HCL
A = πr2
a ÷ b ≠ 0
1
Open Equation Editor: Insert → Symbol group → Equation (π) OR press Alt + =
2
Subscript: In equation box, type base → click Subscript button or press Ctrl + =
3
Superscript: Press Ctrl + Shift + = or use Equation toolbar → Script → Superscript
4
Greek letters (π): In Equation editor → Symbols group → Greek letters → Select π
5
≠ symbol: Insert → Symbol → More Symbols → Find ≠ (Unicode 2260)
Q.5

Insert Special Symbols — °C, ©, ®, ™

▾
Symbols.doc

1. Preheat the oven to 220°C.

2. Copyright     ©

3. Registered    ®

4. Trademark    ™

1
°C (Degree): Type 220 → Insert → Symbol → More Symbols → Find ° (degree sign, Unicode 00B0) → Insert
2
© Copyright: Insert → Symbol → Special Characters tab → Copyright © → Insert (or type (c) — Word auto-corrects)
3
® Registered: Insert → Symbol → Special Characters → Registered ® → Insert (or type (r))
4
™ Trademark: Insert → Symbol → Special Characters → Trademark ™ (or type (tm))
Q.6

Create Student Marks Table in MS Word

▾
Table.doc
Name Rahul
Roll No. 101
Subject Max Min Obtain
Java 100 33 75
Multimedia 100 33 70
1
Insert Table: Insert → Table → Insert Table → 4 columns × 5 rows
2
Merge cells for Name/Roll row: Select columns 2-4 in row 1 → Table Tools → Layout → Merge Cells
3
Type data in each cell as shown above. Press Tab to move between cells
4
Format header row: Select Name/Roll/Subject row → Bold Ctrl+B
Q.7

Document with Watermark "Microsoft" + Formatted Quote

▾
Watermark.doc
Microsoft

measuring programming progress by lines of code is like measuring aircraft building progress by weight.

--Bill Gates

1
Add Watermark: Page Layout → Watermark → Custom Watermark → Text Watermark → Text: Microsoft → OK
2
Type the quote: Click in document body → Type the Bill Gates quote
3
Format quote: Select text → Italic Ctrl+I + Bold Ctrl+B → Center Ctrl+E
Q.8

Create Callout Shape: Person with "Time is money." speech bubble

▾
Callout.doc — Microsoft Word
Home
Insert
Drawing Tools
Shapes ▾
Callouts ▾
Text Box
Clip Art
Time is
money.
Page 1 of 1Insert
1
Insert Clip Art: Insert → Clip Art → Search "person" or "businessman" → Insert image
2
Insert Callout shape: Insert → Shapes → Callouts section → Select "Line Callout 1" or "Rounded Rectangular Callout"
3
Draw callout: Click and drag to draw callout near the person's head area
4
Type text: Right-click shape → Add Text → Type Time is money.
5
Position callout pointer: Click yellow handle of callout → Drag to point toward person's mouth
6
Format: Right-click → Format Shape → Fill: White, Line: Black
Q.9

Create Starburst / Explosion Shape with text "Multimedia"

▾
Starburst.doc
Home
Insert
Drawing Tools
Shapes ▾
Stars and Banners ▾
Multimedia
Page 1 of 1Insert
1
Insert → Shapes → Stars and Banners → Choose "Explosion 1" or "Explosion 2" (16-point star burst)
2
Draw shape on page. Right-click → Add Text → type Multimedia
3
Format shape: Right-click → Format Shape → No fill (white), Border: Black → OK
4
Select text "Multimedia" → Bold + Center aligned
Q.10

Admission 2011-2012 Table with Merged Cells

▾
Admission.doc

Admission 2011-2012

Course OC OB MBC SC/ST Total
Computer Science 9 18 5 5 37
Commerce 14 25 6 5 50
Mathematics 12 20 4 4 40
1
Insert → Table → 6 columns × 4 rows
2
Type "Admission 2011-2012" above table → Center + Bold
3
Fill all cells with data as shown. Apply shading to header row
Q.11

Create Car Price Table with Merged Cells

▾
CarTable.doc
Home
Insert
Table Tools — Layout
Merge Cells
Split Cells
Borders ▾
Shading ▾
Car Price
Maruti Omni Van 200000
Maruti 800 242000
Tata Sumo 390000
Sierra 447000
Page 1 of 1Normal
1
Insert Table: Insert → Table → 3 columns × 5 rows
2
Merge top-left cells for "Car" header: Select row1 cols 1+2 → Table Tools Layout → Merge Cells
3
Merge "Maruti" rows: Select rows 2-3 col 1 → Merge Cells → Type Maruti → Center vertically
4
Merge "Tata" rows: Select rows 4-5 col 1 → Merge Cells → Type Tata
5
Fill remaining cells with car names and prices. Bold the Car/Price header row.
Q.12

Insert WordArt Shapes — "Welcome" (Scroll) & "PC Software" (Banner)

▾
WordArtShapes.doc
Home
Insert
Drawing Tools
WordArt ▾
Shapes ▾
Stars & Banners ▾
Welcome
PC Software
Page 1 of 1Insert
1
Scroll shape for "Welcome": Insert → Shapes → Stars and Banners → Horizontal Scroll → Draw → Right-click → Add Text → type Welcome → Bold + Underline
2
Banner shape for "PC Software": Insert → Shapes → Stars and Banners → Pentagon / Chevron OR use Callout: Double Arrow Ribbon → Draw → Add Text PC Software
3
Format both shapes: Right-click → Format Shape → Fill: White, Line: Black (0.75pt)
4
Arrange side by side on page using Drawing Tools → Align
Q.13

Insert WordArt "Rabbit" + Arrow Shape + Rabbit Clipart

▾
WordArt_Q13.doc
Home
Insert
WordArt Tools
WordArt ▾
Shapes ▾
Clip Art
Rabbit
Page 1 of 1Insert
1
Insert WordArt "Rabbit": Insert → WordArt → Choose 3D shadow style (row 4 or 5) → Type Rabbit → Font: Arial Black, Size: 36 → OK
2
Format WordArt: Double-click → Format WordArt → Colors: Gray gradient fill to give 3D stone effect
3
Insert Arrow: Insert → Shapes → Block Arrows → Right Arrow → Draw between WordArt and clipart
4
Insert Rabbit Clipart: Insert → Clip Art → search rabbit → Insert → Resize to fit beside arrow
5
Arrange all 3 elements in a horizontal row. Use Format → Arrange → Align Middle.
Q.14

Text Case Options — Sentence, lowercase, UPPERCASE, Capitalise, tOGGLE

▾
TextCase.doc
aA Change Case ▾
Sentence case.
lowercase
UPPERCASE
Capitalise Each Word
tOGGLE cASE

➤ This is sentencecase.

➤ this is lowercase.

➤ THIS IS UPPERCASE.

➤ This Is Capitalise Each Word.

➤ tHIS IS tOGGLE cASE.

1
Type each line → Select text → Home → Change Case (Aa button) → Choose the appropriate option
2
Shortcut: Shift+F3 cycles through cases while text is selected
Q.15 & 16

Multi-level Numbered Lists — Actors/Actresses & Cricket Players

▾
Lists.doc

Q15:

  1. Actors
    1. Bruce Willis
    2. Gerard Butler
    3. Vin Diesel
  2. Actress
    1. Julia Roberts
    2. Angelina Jolie
    3. Kate Winslet
    4. Cameron Diaz

Q16:

  1. Cricket Players
    1. Batsman
      1. Sachin Tendulkar
      2. Rahul Dravid
      3. Virendra Sehwag
    2. Bowler
      1. Kumble
      2. Zaheer Khan
      3. Balaji
    3. Spinner
      1. Harbhajan
      2. Kumble
      3. Kartik
1
Multi-level List: Home → Multilevel List button → Choose numbering style
2
Increase/Decrease indent: Press Tab to go deeper, Shift+Tab to go up a level
3
Define new format: Home → Multilevel List → Define New Multilevel List → Set level 1 as 1,2,3 and level 2 as a,b,c
Q.17

Birthday Invitation Letter to Friend

▾
BirthdayLetter.doc
Rahul Kumar
123, MG Road, Bhopal - 462001
Mobile: 9981001001
Date: 06/05/2026
To,
Amit Sharma
456, Civil Lines, Indore - 452001
Sub: Invitation for Birthday Party

Dear Amit,

I am very happy to inform you that my birthday is on 15th May 2026. I am organizing a small birthday party at my residence and would love to have you with me on this special occasion.
The party will be held on 15th May 2026 at 6:00 PM at 123, MG Road, Bhopal. Your presence will make this day even more memorable.

Please do come and bring along the happiness with you.


Your loving friend,

Rahul Kumar

Q.18

Create Labels for Friends' Addresses using Mail Merge / Labels

▾
Labels.doc — Microsoft Word
Home
Insert
Mailings
Start Mail Merge ▾
Labels
Select Recipients ▾
Insert Merge Field ▾
Finish & Merge ▾
Amit Sharma
456, Civil Lines,
Indore - 452001
M.P., India
📞 9981002001
Priya Gupta
789, Nehru Nagar,
Bhopal - 462003
M.P., India
📞 9981003002
Rohit Verma
12, Station Road,
Jabalpur - 482001
M.P., India
📞 9981004003
Sneha Patel
34, MG Road,
Gwalior - 474001
M.P., India
📞 9981005004
Deepak Tiwari
567, Arera Colony,
Bhopal - 462016
M.P., India
📞 9981006005
Kavita Mishra
890, Napier Town,
Jabalpur - 482002
M.P., India
📞 9981007006
Page 1 of 1 · 6 LabelsAvery 5160 · 3×10
1
Open Mailings tab → Labels: Click Labels button → Label Options → Choose Avery 5160 (30 per page, 3 cols) → OK
2
Method A – Direct Entry: In the Address box, type friend's name and address → Click "New Document" → All labels on a sheet get populated
3
Method B – Mail Merge: Mailings → Start Mail Merge → Labels → Select label type → Select Recipients → Use Existing List (Excel file with addresses) → Insert Merge Fields → Finish & Merge
4
Format labels: Select all text in first label → Change font to Arial 10pt → Update Labels button
5
Print: File → Print → Load label paper in printer → Print
X

MS Excel Practicals

Q1–Q10 · Formulas, Functions, IF, Charts, Goal Seek, Conditional Formatting

Q.1

Employee Wages Worksheet — Total Salary, Bonus, % Increase

▾
wages.xls — Microsoft Excel
Home
Insert
Formulas
Data
E2
fx
=B2+C2+D2
A B C D E F G
1 Name Basic (Rs.) HRA(% of basic) DA (Rs.) Total Salary 1997 Bonus (Rs) Total Salary 1998 %(Increase)
2 Shirome 5000 10 450 = B2+(B2×C2/100)+D2
5950		 1200 = E2+F2
7150		 =(G2-E2)/E2×100
20.2%
3 Somy 9000 15 800 11150 200 11350 1.8%
4 Tanya 7000 12 900 8740 1800 10540 20.6%
Total Salary 1997 = Basic + (Basic × HRA% / 100) + DA
Cell D2: =A2+(A2*B2/100)+C2
Total Salary 1998 = Total Salary 1997 + Bonus
Cell F2: =D2+E2
% Increase = ((1998 Salary - 1997 Salary) / 1997 Salary) × 100
Cell G2: =((F2-D2)/D2)*100
Q.2

Student Grades using IF/IFS Formula

▾
Grades.xls
B3
fx
=IF(B2<40,4,IF(B2<50,3,IF(B2<60,2,1)))
A B C D E F
1 Roll No. ENG HINDI SCIENCE MATHS SO. SCI
2 110 45 56 67 78 60
3 GRADE 3 2 2 1 1
Grade Formula for B3:
=IF(B2<40, 4, IF(B2<50, 3, IF(B2<60, 2, 1)))
Logic: 0-40 → Grade 4 | 40-50 → Grade 3 | 50-60 → Grade 2 | 60+ → Grade 1
Copy formula across B3:F3
Q.3

Payroll — Bonus based on Service Years & Net Salary

▾
Payroll.xls — Pace Computer (ATC CEDT) Govt. of India
E2
fx
=IF(DATEDIF(C2,TODAY(),"Y")>2,8000,3000)
A B C D E F
1 Empcode Name DOJ Salary Bonus Net Salary
2 Emp001 Meenu 3-Mar-95 5000 8000 13000
3 Emp002 Manoj 4-Mar-06 4000 8000 12000
4 Emp003 Preeti 3-Mar-95 4800 8000 12800
5 Emp004 Sumita 6-Mar-07 7500 8000 15500
Bonus (E2): =IF(DATEDIF(C2,TODAY(),"Y")>2, 8000, 3000)
Net Salary (F2): =D2+E2
DATEDIF(start, end, "Y") → calculates years of service
Q.4

Salesman Commission — Slab-based Nested IF

▾
💡
Sales ≤ 30,000 → 5% · Next 40,000 (up to 70,000) → 10% · Above 70,000 → 15%
Commission formula (C2):
=IF(B2<=30000, B2*5%, IF(B2<=70000, 30000*5%+(B2-30000)*10%, 30000*5%+40000*10%+(B2-70000)*15%))
Commission.xls
A — NAME B — SALE C — COMMISSION
2 Salesman 1 25000 1250 (5%)
3 Salesman 2 50000 3500
4 Salesman 3 80000 6500
Q.5

Income Tax, Surcharge & Total Tax — Slab Formula

▾
Income Tax (C2) — Nested IF slabs:
=IF(B2<=150000, 0, IF(B2<=250000, (B2-150000)*10%, IF(B2<=325000, 10000+(B2-250000)*20%, 25000+(B2-325000)*30%)))
Surcharge (D2): =IF(B2>500000, C2*3%, 0)
Total Tax (E2): =C2+D2
IncomeTax.xls
A — NAME B — TAXABLE INCOME C — INCOME TAX D — SURCHARGE E — TOTAL TAX
2 Employee 1 200000 5000 0 5000
3 Employee 2 600000 60000 1800 61800
… … … … … …
Q.6

Student Marks — Total, Charts (Pie, Line, Column, Stacked)

▾
StudentMarks.xls
A — NAME B — SUB1 C — SUB2 D — SUB3 E — TOTAL
2 Deep 30 34 44 108
3 Jayesh 40 35 45 120
4 Yash 45 36 47 128
5 Sara 48 32 50 130
6 Gita 35 32 43 110
11 Rima 37 44 46 127
Total (E2): =SUM(B2:D2) — Copy down to E11
a
3D Pie Chart for Total marks: Select A1:A11 + E1:E11 → Insert → Chart → Pie → 3D Pie → Next → Title: "Total Marks" → Finish
b
2D Line Chart Sub1 & Sub3: Select A1:B11, hold Ctrl, select D1:D11 → Insert → Line → 2D Line
c
2D Column Chart: Select A1:D11 → Insert → Column → 2D Clustered Column
d
Stacked Column: Select A1:D11 → Insert → Column → Stacked Column
Q.7

What-If Analysis: Scenario Manager — Two Expense Scenarios

▾
Scenarios.xls — Microsoft Excel
Home
Insert
Data
Formulas
B9
fx
=SUM(B2:B8)
A — Items B — Costs
1 Items Costs
2 Machinery 60,000
3 Carriage 8,000
4 Transport 30,000
5 Office equipment 6,000
6 Postage 7,000
7 Miscellaneous 3,000
8 Generator 5,000
9 Total 1,19,000
📊 SCENARIO A: Machinery, Carriage & Postage Increase
Machinery (B2):80,000was 60,000
Carriage (B3):9,000was 8,000
Postage (B6):8,000was 7,000
New Total:1,41,000was 1,19,000
📊 SCENARIO B: Carriage, Office Equipment & Postage Change
Carriage (B3):10,000was 8,000
Office equipment (B5):7,000was 6,000
Postage (B6):9,000was 7,000
New Total:1,23,000was 1,19,000
1
Enter base data: Type all items and costs in A1:B9, with Total in B9 = =SUM(B2:B8)
2
Open Scenario Manager: Data tab → What-If Analysis → Scenario Manager → Click Add
3
Create Scenario A: Name: Scenario_A · Changing cells: B2,B3,B6 → OK → Enter values: 80000, 9000, 8000 → OK
4
Create Scenario B: Add → Name: Scenario_B · Changing cells: B3,B5,B6 → OK → Values: 10000, 7000, 9000 → OK
5
View results: Click Scenario A → Show → Total updates to 1,41,000. Click Scenario B → Show → Total = 1,23,000
6
Scenario Summary: Scenario Manager → Summary → Select B9 (Total) as result cell → OK → Summary sheet created automatically
Q.8

Goal Seek — Find Interest Rate to Earn Interest ₹500

▾
GoalSeek.xls
A B
1 Principle 1500
2 Rate 4% ← Goal Seek changes this
3 Time 5
4 Interest =(B1*B2*B3)/100 = 500 (goal)
1
In B4 enter formula: =B1*B2*B3/100
2
Data tab → What-If Analysis → Goal Seek
3
Set cell: B4 · To value: 500 · By changing cell: B2 → OK
4
Result: Rate becomes 6.67% to earn ₹500 interest
Q.9

Data Table — Revenue Projections for Different Growth Rates

▾
💡 Image-1 gives base data. Image-2 shows a one-variable Data Table in column C (growth rates) + column D (projected revenues)
RevenueProjection.xls
Home
Data
Formulas
B5
fx
=B2+(B2*B3)
A B
1 Year Revenue
2 2024 $1,500,000
3 Min. Expected Growth Rate 12.00%
4
5 Projected Revenue 2025 $1,680,000
B5 formula: =B2+(B2*B3) → = 1,500,000 + (1,500,000 × 12%) = $1,680,000
D8 formula: =B2+(B2*C8) → substituted by Data Table engine
📊 One-Variable Data Table: Growth Rate → Projected Revenue
Row C — Growth Rate D — Revenue ($)
7 — $1,680,000 ← formula ref
8 12.50% $1,687,500
9 13.50% $1,702,500
10 14.50% $1,717,500
11 15.50% $1,732,500
12 16.50% $1,747,500
13 17.50% $1,762,500
14 18.50% $1,777,500
15 19.50% $1,792,500
16 20.50% $1,807,500
17 21.50% $1,822,500
18 22.50% $1,837,500
1
Set up Image-1: Enter in A1: Year, B1: Revenue · A2: 2024, B2: 1500000 · A3: Min Growth Rate, B3: 12%
2
Projected formula: In B5 type: =B2+(B2*B3) → Result: 1,680,000
3
Set up Data Table (Image-2): In C8:C19 enter growth rates: 12.5%, 13.5%, 14.5%… up to 22.5%
4
Formula cell D7: Type =B2+(B2*B3) in D7 (top of output column — same formula as B5)
5
Select range for Data Table: Select C7:D19 (includes formula in D7 and all growth rates in C8:C19)
6
Create Data Table: Data → What-If Analysis → Data Table → Column input cell: B3 (the growth rate cell) → OK
7
Excel fills column D with projected revenues for each growth rate automatically!
Q.10

Student Division — Total, Average, Division, Conditional Formatting

▾
Division.xls
F2
fx
=IF(E2>=60,"1st",IF(E2>=48,"2nd","3rd"))
A — Roll B — Name C — English D — Maths E — Total F — Avg G — Division
2 101 Anil 93 85 178 89 1st
3 102 Sunil 82 87 169 84.5 1st
4 103 Manish 80 69 149 74.5 2nd
Total (E2): =C2+D2
Average (F2): =AVERAGE(C2:D2)
Class Average (F5): =AVERAGE(F2:F4)
Division (G2): =IF(F2>=60,"1st",IF(F2>=48,"2nd","3rd"))
Max (E6): =MAX(C2:D4) → compare against 100
CF
Conditional Formatting: Select Division column → Home → Conditional Formatting → New Rule:
• 1st Division → Bold (Format: Bold)
• 2nd Division → Italic (Format: Italic)
• 3rd Division → Underline (Format: Underline)
P

MS PowerPoint Practicals

Q1–Q5 · Slides, Charts, Timings, Sound/Video, Hyperlinks, Themes

Q.1

Create PPT with 10+ Slides — Comparison Slide + Chart Slide

▾
Presentation1.pptx — Microsoft PowerPoint
Home
Insert
Design
Transitions
Animations
Slide Show
1
Title Slide
2
Introduction
3
Comparison
4
Chart
+ 6 more slides
PGDCA — Computer Applications
MS Word
  • Word Processing
  • Document Formatting
  • Mail Merge
MS Excel
  • Spreadsheet
  • Charts & Graphs
  • Data Analysis
Slide 3 of 10 — Comparison Layout
1
New presentation: Open PowerPoint → New Blank Presentation
2
Add slides: Home → New Slide → Choose layout. Add minimum 10 slides covering different topics
3
Comparison slide: New Slide → Layout: Comparison → Two-column layout with headings
4
Chart slide: New Slide → Insert → Chart → Choose type (Column/Bar/Pie) → Enter data in spreadsheet → Close
Q.2

Rehearse Timing for Slide Show — Output Screen

▾
Rehearse Timings — Slide Show Mode
Home
Insert
Design
Transitions
Slide Show
⏱ Rehearsal
▶   ⏸   🔄
0:00:08
Slide 2 of 10
Total: 0:00:42
Introduction to Computers
• What is a Computer?
• Types of Computers
• Applications in Daily Life
The total time for the slide show was 0:02:15. Save the new slide timings?
1
Slide Show tab → Rehearse Timings button — Presentation enters full screen, timer starts
2
Timer toolbar appears top-left: Play/Pause, Current Slide Time, Total Time
3
Advance each slide by clicking or pressing Space when ready
4
After last slide → dialog asks to save timings → click Yes
5
Slide Sorter view now shows time below each slide thumbnail
Q.3

Import Sound & Video Clips — Output Screen

▾
MediaSlide.pptx
Home
Insert
Animations
Playback
1
Title
2
Media Slide
3
Content
Multimedia Presentation
▶
🎬 video.mp4
🔊
background.mp3
▶
0:00 / 0:45 🔊
1
Insert Audio: Insert → Audio → Audio from File → Select .mp3 or .wav → Insert. Speaker icon appears on slide.
2
Audio Playback settings: Click speaker → Playback tab → Start: Automatically → Check "Hide During Show" + "Loop until Stopped"
3
Insert Video: Insert → Video → Video from File → Select .mp4 → Insert → Resize video frame on slide
4
Video Playback: Click video → Playback tab → Start: On Click or Automatically → Trim Video if needed
5
Test: Slide Show → From Current Slide → F5 to preview media playback
Q.4

Hyperlinks in PowerPoint — Output Screen

▾
Hyperlinks.pptx
Home
Insert
Slide Show
1 Index
2 About
3 Contact
Index Slide — Click to Navigate
🔗 Go to Slide 2 — About Us → Slide Link
🌐 www.google.com → Website
📧 student@pgdca.edu.in → Email link
▶ Next Slide
1
Hyperlink to slide: Select text → Ctrl+K → Place in This Document → Select slide number → OK
2
Hyperlink to website: Select text → Ctrl+K → Existing File or Web Page → type URL → OK
3
Email hyperlink: Select text → Ctrl+K → E-mail Address → type email → OK
4
Action Button: Insert → Shapes → Action Buttons → Select shape → Draw → Action Settings → Hyperlink to: Next Slide → OK
5
Test in Slide Show mode: F5 → hover over links (cursor becomes hand pointer) → click to navigate
Q.5

Apply Themes & Transitions — Output Screen

▾
ThemeTransition.pptx
Home
Insert
Design
Transitions
Office
Default
Apex
Apex
Civic
Applied ✓
Flow
Flow
Metro
Metro
1
2
3
PGDCA Computer Applications
• Theme Applied: Civic (Green)
• Transition: Fade — Duration: 0.70s
• Sound: Chime
• Applied to all slides ✓
⚡ Fade → All Slides
1
Apply Theme: Design tab → Themes gallery → Hover to preview → Click to apply (or right-click → Apply to All Slides)
2
Customise theme: Design → Variants → Colors dropdown → choose a color scheme · Fonts dropdown → choose font pair
3
Apply Transition: Transitions tab → Transition gallery → Select Fade (or Wipe / Push) → Duration: 0.70 seconds
4
Transition sound: Transitions → Sound dropdown → Select Chime
5
Apply to all: Transitions → Click "Apply to All" button → All slides now have same transition
6
Press F5 to preview full presentation with transitions
A

MS Access Practicals

Q1–Q7 · Tables, Queries, Forms, Reports, Relationships, Data Validation

Q.1

Create Contacts Table with All Data Types in MS Access

▾
Database1.accdb — Microsoft Access
Home
Create
External Data
Database Tools
Table Design
📋 tblContacts — Design View
Field Name Data Type Description
🔑 ContactID AutoNumberPK Primary Key — Auto-generated
ContactType Text 50 Type of contact (Wholesale, dealer, other)
Name Text 50 Contact's first name
Company Text 50 The Contact's employer
Address Text 50 Contact's address
City Text 50 Contact's city
State Text 50 Contact's state
ZipCode Text 50 Contact's zip code
Phone Text 50 Contact's phone
Fax Text 50 Contact's fax
E-Mail Text 100 Contact's e-mail address
WebSite Text 100 Contact's Web address
LastSalesDate Date/Time The most recent purchase date
DiscountPercent Number The customary discount provided
Notes Memo Notes and observations
Active Yes/No Whether customer is still active
1
Create Table: Create tab → Table Design → Opens Design View
2
Set ContactID as PK: Click ContactID row → Table Tools Design → Primary Key (🔑 icon)
3
Add each field: Type field name → Tab → Select Data Type from dropdown → Tab → Type description
4
Save: Ctrl+S → Name: tblContacts → OK
Q.2

Three Related Tables — Products, SalesLineItems, Sales (with Foreign Keys)

▾
SalesDB.accdb — Relationships Window
📦 tblProducts
Field Type Note
🔑 ProductID AutoNumber Primary Key
Description Text
Category Text
Quantity Number
Cost Currency
RetailPrice Currency
ProductNumber Text
SalePrice Currency
Taxable Yes/No
📋 tblSalesLineItems
Field Type Note
🔑 SalesLineItemID AutoNumber Primary Key
🔗 InvoiceNumber Number FK → tblSales
🔗 ProductID Number FK → tblProducts
ProductNumber Text
Quantity Number
Description Text
Price Currency
Discount Number
🧾 tblSales
Field Type Note
🔑 InvoiceNumber AutoNumber Primary Key
SaleDate Date/Time
InvoiceDate Date/Time
Buyer Text
PaymentMethod Text
TaxLocation Text
TaxRate Number
1
Create all 3 tables in Design View with fields and Primary Keys as shown above
2
Set Relationships: Database Tools → Relationships → Add all 3 tables → Drag ProductID from tblProducts to tblSalesLineItems → Check "Enforce Referential Integrity" → Create
4
Save relationships → Close
Q.3

Create Student Table — RollNo (PK), Name, Class, Marks

▾
Table: Students
RollNo Number 🔑 Name Text Class Text Marks Number
101 Rahul Kumar PGDCA 85
102 Sonia Jain PGDCA 92
103 Amit Singh PGDCA 78
1
Create → Table → Switch to Design View → Save as "Students"
2
Define fields: RollNo (Number), Name (Text), Class (Text), Marks (Number)
3
Select RollNo row → Click Primary Key (🔑 icon)
4
Switch to Datasheet View and enter student records
Q.4

Designing a Query — Filter Students with Marks > 80

▾
Students
*
RollNo
Name
Class
Marks
Field:
RollNo
Name
Class
Marks
Table:
Students
Students
Students
Students
Sort:
Ascending
Criteria:
>80
1
Create → Query Design → Select "Students" table → Add
2
Double-click fields (RollNo, Name, Class, Marks) to add them to the grid
3
In Criteria row under Marks column, type >80
4
Design tab → Run (❗ icon) → View filtered results
Q.5

Data Entry Form — User-friendly Interface for Students

▾
Student Entry Form ✖
Roll Number:
104
Full Name:
Sneha Sharma
Course/Class:
PGDCA SEM-I
Marks Obtained:
88
1
Select "Students" table → Create → Form (or Form Wizard)
2
Switch to Design View → Use Design tab to add labels and buttons
3
Add Command Buttons (Navigation and Operations) from the Controls group
4
Save as "StudentForm" and switch to Form View for data entry
Q.6

Generate Professional Report — Student Marks Summary

▾
Student Progress Report
Session 2025-26 · Date: 07/05/2026
Roll No Student Name Class Marks
101 Rahul Kumar PGDCA 85
102 Sonia Jain PGDCA 92
103 Amit Singh PGDCA 78
104 Sneha Sharma PGDCA 88
Total Students: 4 · Average Marks: 85.75
1
Create → Report Wizard → Select all fields from Students table
2
Add grouping (optional) and Sort by Name (Ascending)
3
Choose "Tabular" layout and "Portrait" orientation
4
Finish → View Print Preview → Save as "StudentReport"
Q.7

Define Table Relationships — One-to-Many Connection

▾
💡
Connecting the Students table to a Fees table using RollNo.
Students
🔑 RollNo
Name
Class
1
∞
Fees
FeeID (PK)
RollNo (FK)
Amount
Date
1
Database Tools tab → Relationships group → Relationships
2
Show Table → Add "Students" and "Fees" → Close
3
Drag RollNo from Students to RollNo in Fees
4
Check "Enforce Referential Integrity" → Create
Pu

MS Publisher Practicals

Q1–Q7 · Business Card, Greeting Card, Letterhead, Flyer, Brochure, Certificate, Advertisement

Q.1

Create Business Card for Your Business

▾
BusinessCard.pub — Microsoft Publisher
Home
Insert
Page Design
Rahul Kumar
Owner · Computer Solutions
📍 123 MG Road, Bhopal - 462001
📞 +91 9981001001
✉ rahul@pgdca.edu.in
🌐 www.pgdca.edu.in
1
Open Publisher: File → New → Business Card → Choose template → Create
2
Edit text boxes: Double-click text boxes → Replace with your: Company Name, Your Name, Title, Address, Phone, Email, Website
3
Add Logo: Insert → Picture → From File → Browse your logo image → Insert → Resize
4
Save: File → Save As → BusinessCard.pub
Q.2

Create Greeting Card with Images (Front, Inside, Back)

▾
GreetingCard.pub
🎉
Happy Birthday!
Wishing you a wonderful day full of joy and happiness
— With Love, Your Friend
1
New Greeting Card: File → New → Greeting Cards → Choose style → Create (4-page layout)
2
Front (Page 1): Add greeting text, insert picture (Insert → Picture)
3
Inside left (Page 2): Leave blank or add image
4
Inside right (Page 3): Personal message + Made by + Cost
5
Back (Page 4): Company info, image on back
Q.3

Create Business Letterhead

▾
Letterhead.pub
PGDCA
Computer Applications Institute
123 MG Road, Bhopal · 📞 9981001001 · ✉ info@pgdca.edu.in · 🌐 www.pgdca.edu.in
Date: ______________ | Ref: ______________
[Letter content area]
Affiliated to Barkatullah University, Bhopal · Estd. 2000
1
New Letterhead: File → New → Letterheads → Choose template → Create
2
Edit header area: Add Logo, Company Name, Address, Phone, Email, Web address
3
Add footer with additional information or decorative line
Q.4

Create Open House Flyer

▾
OpenHouseFlyer.pub
🎓
YOU'RE INVITED!
PGDCA Open House 2025-26
📍 Computer Applications Institute, Bhopal
📅 15th May 2026 · 🕒 10:00 AM – 4:00 PM

Explore our Computer Applications programs,
meet faculty, and learn about admissions.

🍕 Refreshments · 🎁 Door Prizes · 📋 Free Registration
Register: 9981001001 | www.pgdca.edu.in
1
New Flyer: File → New → Flyers → Choose template → Create
2
Add: Logo, Company Name, Address, Open House title, Date & Time, Description, Food promises, Door prizes
3
Insert 2–3 relevant images (Insert → Picture)
Q.5

Create a Tri-fold Brochure — College/Computer Institute

▾
Brochure.pub — Microsoft Publisher
Home
Insert
Page Design
Contact Us
📍 123 MG Road
Bhopal - 462001
📞 0755-111111
✉ info@pgdca.edu.in
🌐 www.pgdca.edu.in
Mail to:
Why Choose Us?
✔Expert Faculty with industry experience
✔State-of-the-art computer labs
✔100% placement assistance
✔Practical-focused curriculum
✔Affordable fee structure
Courses Offered
• PGDCA
• BCA
• MCA
• Tally ERP
Excellence in Computing
💻
Post Graduate Diploma in
Computer Applications
Session 2025-26 | Admissions Open
1
New Brochure: File → New → Brochures → Choose a template → Create. Publisher opens a 3-panel tri-fold layout
2
Replace placeholder graphics: Click existing images → Delete → Insert → Picture → Browse new graphic → Insert
3
Replace text: Click each text box → Select all → Type new text (company info, courses, contact)
4
Use minimum 2 graphics: Insert → Picture → Add logo + add a computer or campus image
5
Front panel = Cover (right), Inside = middle/left, Back = mailing panel (left outer)
6
File → Save As → Brochure.pub
Q.6

Create Invitation Card — Birthday / Event

▾
InvitationCard.pub
Home
Insert
Page Design
🎉
You're Invited!
Rahul Kumar's Birthday Celebration
📅 Date: 15th May, 2026
🕕 Starting Time: 6:00 PM
📍 Place: 123 MG Road, Bhopal
👔 Dress Code: Formal / Semi-Formal
🎁 Please Bring: Good Wishes & Smile!
RSVP: 9981001001 by 12th May
1
New Invitation: File → New → Invitations → Choose style → Create
2
Fill in: Your Name, The Event (Birthday Party / Annual Function etc.), Starting Time, Place
3
Add What to Wear (Dress Code) and What to Bring sections
4
Add decorative border: Insert → Borders & Accents → Select ornate border
5
Insert a festive clip art or image (balloons/stars) to decorate the card
Q.7

Create Award Certificate / Certificate of Appreciation

▾
Certificate.pub
🏆
Certificate of Appreciation
PGDCA · Computer Applications Institute
This is proudly presented to
Rahul Kumar
in recognition of outstanding performance
in the PGDCA Program · Session 2025-26
Dr. Sanjay Kumar
Director
Date: 15/05/2026
Dr. A.K. Tiwari
Principal
1
New Certificate: File → New → Award Certificates → Choose template → Create
2
Add: Recipient Name, Institution Name, Achievement description, Date, Signatures
3
Add decorative border: Insert → Borders & Accents → Choose border style
4
Insert eye-catching graphic/clip art as decoration
5
Print on certificate paper or plain paper as required
Q.8

Breakfast Product Advertisement — "SunCrunch" Cereal

▾
BreakfastAd.pub — One Page Only
Home
Insert
WordArt
1
New blank page: File → New → Blank → Page size: A4 (one page only)
2
Product name via WordArt: Insert → WordArt → Choose bold/curved style → Type SunCrunch™ → Choose font, size, color
3
Rotate slogan: Insert text box → Type slogan → Click green rotation handle → Drag to rotate slightly
4
Insert max 3 graphics: Insert → Picture → Add cereal bowl image, sun graphic, health icon
5
Add bullet selling points: Insert Text Box → Home → Bullets → List selling points
6
Create coupon: Insert → Shape → Rectangle → Draw at bottom → Add border → Add text: product name, ₹ savings amount, expiry date
7
Use ONE font family only — vary size (10pt body, 24pt headline, 16pt slogan) and colors
Q.9

Create Grand Opening Banner

▾
GrandOpeningBanner.pub
Home
Insert
Page Design
1
New Banner: File → New → Banners → Choose landscape template → Create (Publisher sets wide page automatically)
2
Add border: Insert → Borders & Accents → Choose decorative border → Apply to page
3
Business Name & Logo: Insert WordArt for company name. Insert → Picture for logo image.
4
Add details: Text boxes for: Date, Contact Information (phone, email, website)
5
Incentive text: Add a highlighted text box with promotion/offer text — use bright yellow/red background
6
Unique design: Use gradient background, star shapes, confetti clip arts to make it eye-catching
Q.10

Create Gift Certificate / Gift Card

▾
GiftCertificate.pub
Home
Insert
Page Design
GIFT
📞 9981001001 · www.pgdca.edu.in
Gift Card
This certificate entitles
Amit Sharma
to the value of
₹500
towards any Computer Course Enrollment
Valid Until: 31 Dec 2026
Certificate No: GC-2026-0042
Authorised by
Director, PGDCA
1
New Gift Certificate: File → New → Gift Certificates → Choose template → Create
2
Business info: Replace template placeholder with: Business Name (PGDCA Store), Logo, Phone, Website
3
Recipient Name: Click "Recipient" text box → Type friend/customer name
4
Amount: Click amount field → type ₹500 (or any amount)
5
Add unique design: Change background color/gradient → Insert decorative border → Add clip art gift/star graphic
6
Other info: Add Expiry Date, Certificate Number, Authorized signature line, Terms of use
7
File → Save As → GiftCertificate.pub → Print on card stock for best results
Q.11

Design a Professional Newsletter Layout

▾
TECH INSIDER
Monthly Newsletter · May 2026 · Issue #05
IMG
Inside this issue
  • AI Revolution
  • MCU Exam Tips
  • Tally Workshop

The Rise of Artificial Intelligence in Education

Artificial Intelligence is transforming how we learn and teach. In this issue, we explore the impact of LLMs on computer science education and how students can leverage these tools effectively...

FEATURED IMAGE
1
File → New → Built-in → Newsletters → Choose a multi-column design
2
Edit the Masthead (Title area) with newsletter name and date
3
Insert articles by clicking on the placeholders. Use Text Box Tools to link boxes across pages
4
Add images and captions. Set Text Wrapping to "Tight" to flow text around images