GOVERNMENT BOYS

COMPREIHJENS�VE H�GHIER
SECONDARY SCHOOl AZ�ZABAD •

Roll No:---

N [Link]: ---

CamScanner
 XI PRACTICAL Word & Excel 2024-25

NAME ••

FATHER NAME:

CLASS •

GROUP •

ROLL NO •

EMAIL ••

CONTACT •
·

COLLEGE - •

�--------------
SESSION
. --��-------�---
•

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Certificate

This is to certify that s/o _

,holding Roll No. oXfI class, section

Computer science, has successfully comrpleted all the requ1irement

of this practical file forthe session 2024-25.

Course Instructor Sign,ature of H,ead of

the Institution

([Link] Hussain)

CamScanner
CamScanner
 XI PRACTICAL Word & Excel 2024-25

TABLE OF CONTE,NTS
Practical Object i1n Brief Page#
No.
Part-1 Microsoft DS-43
War�
1 Create a simple document file using MS-Word 1ent 6
docum
2 Letter to father, requesting him to send Rs. 14000/- for purchasing 9
3 Creating line representing left and right margin on the paper 11
4 Write a passage from the book insert head,er footer columns and clip art. 14
5 Formula of Area=2rrR2, Mean(n)=}:Xn, Sine+ Cos8= water=H20 16
6 Writing a paragraph from the book .Copying and pasting it. 18
7 Write an application to the librarian requesting him to issue books 22
8 Writing in columns of different Font sizes, name and Drop Cap 24
9 Write an application to your principal, asking him for leave certificate. 27
10 Create a Curriculum Vitae. 30
11 Create an Award Certificate 33
12 Application to the Principal, requesting him to grant you 7 days leave 35
13 Application to the librarian for issuance of books 37
14 Prepare a111 invitation card for friends 39
15 Write a passage from your book and apply header and footer 41
Part-2 Microsoft Excej
16 Creating Payroll on spread sheet of employees 45
17 Creating spread sheet ,r calculating daily wages. 49
fo
18 Creating an Attendance Sheet according to the given instructions 52
19 Creating Marks sheet for computing grade and ascending list 56
20 Creating complete Marks sheet showing percentage and grade 61
21 Creating complete Marks sheet of missing marks. 63
22 Creating expense sheet with graphs 66
23 Creating Electric Billl as per given instructions 69
24 Time Table of the College 72
25 Creating Expenditure Sheet of Different Provinces in Year 2018 75
26 Creating Expense Sheet of Pakistan Printing Press 78
27 Creating a utility Bill of Sui gas according to the instructions 83
28 Creating the profit sheet of Pak-Suzuki Motors 86
29 Creating the sch,olarship statement 89
30 Creating a utility bill of PTCL by following the given instructions 92
31 Extra Practical 95

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Part-1 icroso t or
or Processor

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical N,o.1-(Paragraph writingfor

Copy paste and Styling)
Obiect Create a simple document file using MS-Word document. Type three or four lines
paragraph and then, Copy one time arid paste five times. Also apply text formatting including
Fo,nt-Name, Font-Style, and Font- Size to each paragraph, Save and also print.

Procedure
Switching on Computer
11
Switch on your computer. Wait till the ope,ration system "Windows let you give access to
interact with the computer.

Searching and Opening MS-Word

With the help of mouse click "Start" Icon, generally present at bottom left side of the computer
screen-

Use Mouse click "Search Bar'', type "Microsoft Office Word" in it with the help of computer
keyboard to search and open MS-•Word.

Creating File
Double click the MS-Word icon to open MS-Word, New document having name
[Link] w'ill automatically be open.

Start typing the line from the left top position. Type three to four lines as said in the practical
object.

Selecting alll the text

Now press "Ctrl" with "A" to select all the typed lines. It will be highlighted.

Copying the entire text into the computer memory

Now press "Ctrl" with "C" to Copy the text into the computer memory

Pasting the memory resident text to the desired place

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Now place the cursor with the help of mouse to the position where you want to copy the
highlighted text. Press "Ctrln with "V" to paste this text.

Now repeat, step number 7, four times more, to make the t,otal number of copies five.

Now select the first copy of paragraph (second paragraph) w'ith the help of mouse i.e. by
continuously pressing the left button of mouse and moving the mouse cursor from the start of
paragraph to the end of paragraph.

Opening Font Menu to apply styles

Then press "Ctrl" with "D" to open "Font Menu'\ there change the "name" of font to "limes
New Roman", style of font to "Bold Italic" and size of the paragraph to "17".

Repeat step 1 0 with font Name"" ,Style"" and Size "9"

1

Repeat step 1 0 three more times with different font name i.e. ,Style i.e and size i.e.
1

Saving the Document

In the end save the file by pressing "Ctrl" with "S"

Printing the Document

If you want to,print the document press "Ctrl" with "P"

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Output

Assalam Alykum, this is a simple text file just for fulfilling the requirement of Word Practical. I
was given task to write any paragraph comprising of three to four lines. Then I have to copy it
one time and paste it five times. I am also supposed to apply new styles for every pasted copy.

Assalam Alykum, this is a simple text file just for fulfilling the
requirement of Word Practical. I was given task to write any
paragraph comprising of three to four lines. Then I have to copy it
one time and paste it five times. I am also supposed to apply new
styles for every pasted copy.
Assalam Alvkum, this is a simple text file just for fulf1lling the requirement of Word Practical. I
was given task to write anv paragraph comprising of three to four lines. Then I have to copy it
one time and paste it five times. I am also supposed to apply new styles for every pasted copy.

Assalam Alykum, this is a simple text file just for fulfilling the requirement of Word Practical.
I was given task to write any paragraph comprising of three to four lines. Then I have to
copy it one time and paste it five times. I am also supposed to apply new styles for every
pasted copy.

Assalam Alykurm, this is a simple text file [Link] for fulfilling the requirement of Word
Practical. I was given task to write a1ny paragraph comprising of three to four lines. Then
I have to copy it one time and paste it five times. I am also supposed to apply new styles
for every pasted copy.

Assalam Alykum, this is a simple text file just for fulfilling the
requirement of Word Practical. I was given task to write any paragraph
comprising of three to four lines. Then I have to copy it one time and
paste it five times. I am also supposed to apply new styles for every
pasted copy.

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.2-(Letter to Father)

Obiect Write a letter to your father, requesting him to send Rs. 14000/- for purchasing books.
L

Insert a table containing [Link]., Name of Books, Quantity and Price. Save and also print.

Procedure

Switching on Computer
11
Switch on your computer. Wait till the ope,ration system "Windows let you give access to
interact with the computer.

Searching and Opening MS-Word

With the help of mouse click "Start" Icon, generally present at bottom left side of the,computer
screen-

Use Mouse click "Search Bar'', type "Microsoft Office Word" in it with the help of computer
keyboard to search and open MS-,Word.

Creating File
Double click the MS-Word icon to open MS-Word, New document having name
[Link] w'ill automatically be open.

Start typing the line from the left top position ( where,typing cursor blinks). Type the given
material in your own wordings for asking your father to send you Rs.14000/=. Insert the table
for the [Link]., Name of Books, Quantity and Price

Inserting Table
Click the insert, then table and then draw five(0S) rows and four(04) columns. Insert the
headings in the first row and books concerning data in rest of the cell. Use tab or mouse
pointer to toggle between the cells of the table. Type in the concern cells what you want to
type,.

Saving the Document

In the end save the file by pressing "Ctrl" with "S"
Printing the Document
If you want to,print the document press "Ctrl" with "P"

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Output
Examination Hall,
Pakistan Shipowners' College,
Block R & S, North Nazimabad,
Kararchi

Dear Father Mohsin,

Assalam Alykum,
I am fine and hope you will also be fine. My course classes at my college are at full
swing, for which I need extra hard work and some m,ore supportive books
to,overcome the topics. Names of required books are as follows.

[Link]. Name of Book Quantity Price

1 Step by Step Practical Solution for XI Students 1 3500
2 The 10 Programming 1 3500
3 The Tenth Programming 1 3400
4 Word and Excel a complete guide 1 3600

Dear papa, for the above mentioned books I need worth Rs.14000/=. Therefore it is
requested to kindly sen1d me the said amount.

Thanks,

Your's Obediently,
Muhammad Hasan Khan
Pakistan Shipowner's Govt. College
Block R & .5, North Nazimabad,
Karachi

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.3-(Borders and Shading)

Ob iect create vertically dotted line representing left and right margin on the paper for different
L

paragraph Alignments. Use a paragraph for justification and also use the Borders and Shading. Save
and also print.

Procedure

Switching on Computer
11
Switch on your computer. Wait till the operation system "Windows let you give access to
interact with the·computer.

Searching and Opening MS-Word

11
With the help of mouse click "Start Icon, generally present at bottom left side of the·computer
screen-

11 11
Use Mouse click Search Bar'', type Microsoft Office Word" in it with the help of computer
keyboard to search and open MS-•Word.

Creating File
Double click the MS-Word icon to open MS-Word, New document having rname
[Link] will automatically be open.

Start typing the line fr,om the left top position ( where typing cursor blinks). Type three to four
lines as said in the practical object.

Selecting all the text

Now press "Ctrl" with "A" to select all the typed lines. It will be highlighted.

Copying the entire text into the computer memory

Now press "Ctrl" with "C" to Copy the text into the computer memory

Pasting the memory resident text to the desired place

Now place the cursor with the help of mouse to the position where you want to copy the
highlighted text. Press "Ctrl" with "V" to paste this text.

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Apply different font styles, sizes to each pasted text

Now place the cursor with the help of mouse to the position where you want to copy the
highlighted text. Press "Ctrl,, with "V" to paste this text.

Apply Borders
Now with the help of mouse click "Home" menu, then click "borders and shading" to apply
borders an,d shading to the first paragraph of text.

Repeat it with different styles of borders for the remaining paragraphs.

Saving the Document

In the end save the file by pressing "Ctrl" with "S"

Printing the Document

If you want to,print the document press "Ctrl" with "P,,

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Output
,, Assalam Alykum, this is a simple text file just for fulfilling the requirement of·Word Practical. I ,,
! was given task to write any paragraph comprising of three to four lines. Then I have to copy it I

I
I

1
one time and paste it five times. I am also supposed to apply new styles for every pasted copy.
/.E¥1Aal.<V.l.t¥J'..::.W.l$:it7J'..[Link]"l.ff1..ff!-la,,/.a,7/'..:7J:7.l'IWJ'a".I_.IH"[Link]!.-[Link].a-7J'..::.W.l.d7J'U/J'[Link]"!_1_l.<V.l-J'.MQ.l.,;«,"J'a".ll:JVIH"[Link]!Aa1-Ja,,/,a,7/'..::.V.l'U/.la".IIJWI.D"I.H'!.-fRJ.<Vl,mrJ,[Link].,;«/.l-.l-fff"[Link]!_1_l_.l.t¥/..::.Wl�.ll,[Link]!Aal.<[Link]'U/.[Link]!-1.-fRJ-IL¥/..::.Wl�/'

I"'-·--·--·--·-·--·--·-·--·�-·-·--·--·--·--·�-·-·--·--·--·--·�-·-·-�·--·-·--·�-·-·--·--·--·--·�-·-·-�·--·--·--·--·-·-�·--·-·--·--·-·-�·--·--·-···--·-·--·--·-·--·--·-··�·--·--·--·--·-·-�·--·--·--·--·-·--·--·--·--·--·-·--·--·-·--·--·-·--·--·--··
)f\ssalam Alykum, this is a simple text file just for fulfilling the requirement of Word Practical. I
!was given task to write any paragraph [Link] rising of three to four lines. Then I have to copy it
!one time and paste it five times. I am also supposed to apply new styles for every pasted copy!.--
� · · ·-·-· · · · ·-· · · · · ·-· · · · · ·-· · ·-· · ·-· · ·-· · ·-· · · · · ·-· · · · · ·-· · · · · ·-· · ·-· ·-·-·-· · · · ·-·-·-· · ·-· ·-·-· · · · ·-·-·-· · ·-· ·-· · ·

r···-···-···-···-···-····-···-···-···-···-···-···-···-···-···-···-···-····-···-····-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···--··-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-····-···-···-···-···-···-····-···-···-···-··-···-··-···-···-···

Assalam Alykum, this is a simple text file just for fulfilling the requirement of Word Practical. I
was given task to write any paragraph comprising of three to four lines. Then I have to copy it
'
one time and paste,it five times. I am also supposed to apply new styles for every pasted cop�
L ••·-···-···-··-···-··-···-···-···-···-···-···-···-··-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-··-···-··-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-··-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-···-····-···-····-···-···-···-···-···-···-···1 •

Assalam Alykum, this is a simple text file just for fulfilling the requirement of Word
Practic,al. I was given task to write a1ny paragraph comprising of three to four lines.
Then I have to copy it one time and paste it five times. I am also supposed to a1pply
new styles for every pasted copy.

Assalam Alykum, this is a simple text f1ile just for fulfilling the
requirement of Word Practical. I was given task to write any paragraph
comprising of three to four llines. Then I have to copy it one time and
paste it five times. I am also suppos,ed to apply new styles for every
pasted copy.

. ssalam Alykum, this is a simple text file just for fulfilling the
requirement of Word Practical. I was given task to write any
riaragraph comprising of three to four lines. Then I have to copy ii
one time and paste it five times. I am also supposed to apply new
'$fyles for every pasted copy.

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.4-(Letter without table)

Obiect Write a letter to your father, requesting hirm to send Rs. 14000/- for purchasing books.
L

Insert bullets [Link]., Name of Books, Quantity and Price. Save and also print.

Procedure

Switching on Computer
11
Switch on your computer. Wait till the ope,ration system "Windows let you give access to
interact with the computer.

Searching and Opening MS-Word

With the help of mouse click "Start" Icon, generally present at bottom left side of the,computer
screen-

Use Mouse click "Search Bar'', type "Microsoft Office Word" in it with the help of computer
keyboard to search and open MS-,Word.

Creating File
Double click the MS-Word icon to open MS-Word, New document having name
[Link] w'ill automatically be open.
Start typing the line from the left top position ( where,typing cursor blinks). Type the given
material in your own wordings for asking your father to send you Rs.14000/ =. Insert the
table for the [Link]., Name of Books, Quantity and Price

Inserting Bullets/Numbering
First type [Link]., Name of Books, Quantity and Price with gaps in between them before inserting
the numbering or bullets.
11 11
Now click the "Home menu, then click "Bullets or "Numbering'' icon, then type the matter
what you want to numbers/bullets will automatically be written before each like. Re-press
numbering/bullets icon to discontinue the numbering/ bullets and return back to normal
typing.

Saving the Document

11
In the end save the file by pressing "Ctrl with "S"

CamScanner
 X XI PRACTICAL Word & Exc�l 2024-25

Printing the Document

If you want to print the document press "Ctrl" with "P,,

ou,tput
Examination Hall,
Pakistan Shipowners' College,
Block R & S, North Nazimabad,
Kar,archi

Dear Father Mohsin,

Assalam Alykum,
I am fine and hope you will also be fine. My course classes at my college are at full
swing, for which I need extra hard work and some more supportive books to overcome
the topics. Names of required books are as follows.

Sno. Name of Book Quantity Price

1. Word and Excel Complete Guide(Shahzada Wasim) 1 3600
2. Step by Step Practical So,lution for XI Students(Mohsin Ghori) 1 3500
3. The 10 Programming (Jamshed Hashmi) 1 3500
4. The Tenth Programming ( Asif Ali Sanghi) 1 3400

Dear papa, for the above mentioned books I need worth Rs.14000/=. Therefore it is
requested to kindly send me the said amount.

Thanks,

Your's Obediently,
Muhammad Omer Khan Ghori
Pakistan Shipowner's Govt. College
Block R & 5, INorth Nazimabad,
Karachi

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Pr,acti,cal No.5-(Formula writing)

Obiect Type the given phrase Area of circle= 2n:R2, Mean(n)=IXn. Sine+ Cose =1' Formula of
L

water= H2O Give a border to the phrase. Copy it thre·e times changing different colors. Write Formula
as heading on header and page number in footer. Save and print.

Procedure

Switching on Computer
Switch on your computer. Wait till the ope·rat:ion system "Windows" let you give access to
interact with the·computer.

Searching and Opening MS-Word

With the help of mouse click "Start" Icon, generally present at bottom left side of
the·computer screen-

Use Mouse click "Search Bar'', type "Microsoft Office Word" in it with the help of computer
keyboard to search and open MS-•Word.

Creating File
Double click the MS-Word icon to open MS-Word, New document having 11ame
[Link] will automatically be open.

Start typing the line from the left top position (where typing cursor blinks). Click "Alt" with "+n
sign to enter the formula of your type. Or
1

Click ulnsert" menu then click "Eq1..1ation (present at top right position of the MS-Word)" with
the help of mouse to type the equation/formula of your desire.
Repeat this for rest of the remaining three formulas.

Saving the Document

In the end save the file by pressing "Ctrl" with "S"

Printing the Document

If yol!I want to,print the document press "Ctrl" with "P"

CamScanner
CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.6-{Paragraph writing with

inserting Picture)
Obiect Write a paragraph from anywhere or fr,om1your book .Copy one time and paste three
times each paragraph change Font-style, Font size and Font Color, in the first paragraph, apply Border
and in the second paragraph insert the picture from clip art category. set Roll No. and Examination 2018
in Header and set Page No. in Footer. Save and also print.

Procedure

Switching on Computer
Switch on your computer. Wait till the ope,ration system "Windows" let you give access to
interact with the computer.

Searching and Opening MS-Word

With the help of mouse click "Start" Icon, generally present at bottom left side of
the,computer screen-

Use Mouse click "Search Bar", type "Microsoft Office Word'' in it with the help of computer
keyboard to search and open MS-•Word.

Creating File
Double click the MS-Word icon to open MS-Word, New document having 11ame
[Link] w'ill automatically be open.

Start typing the line from the left top position (where typing cursor blinks). Type whatever you
want or use your book for the starndard typing material. Type few lines.

Selecting alll the text

Now press "Ctrl" with "A" to select all the typed lines. It will be highlighted.

Copying the entire text into the computer memory

Now press "Ctrl" with "C" to,Copy the text into the computer memory

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Pasting the memory resident text to the desired place

Now place the cursor with the help of mouse to the position where you want to copy the
highlighted text. Press "Ctrl,, with "V" to paste this text.

Now repeat, above step of "Ctrl" with "V", two times more, to make the total number of copies
three a111d grand total of original plus copies four.

Now select the first copy of paragraph (second paragraph) w'ith the help of mouse i.e. by
continuously pressing the left button of mouse and moving the mouse cursor from the start of
paragraph to the end of paragraplh.

Opening Font Menu to apply styles

Then press "Ctrl" with "D,, to open "Font Menu", there change the "name" of font to "Times
New Roman", style of font to "Bold Italic" and size of the paragraph to "17".

Repeat this step with font Name '"' ,Style "" and Size "9,,

Repeat the above two steps two more time with different font name i.e. ,Style i.e and size i.e.

Applying Borders
Now select first copy (second paragraph) witlh the help of mouse (Left button drag) or keyboard
(Shift with arrow keys), then click "Home" menu, then click "Borders and Shading" icon usually
present in the mid ,of tool bar menu. Now click "Custom" for this "Borders and Shading" menu
and change the combo box of" Apply to" to the "Paragraph" fr,om "Text".

Inserting Picture
Now select second copy (third paragraph), then click "Insert" from Menu-Bar, then click
"Picture" or "Clip Art", then browse the location of picture or select the picture from clip art
library. Double click the picture or copy/paste it into the paragraph.

Inserting Header and Footer

Now click "Insert" again from Menu-Bar, then click "Header,, icon from it's tool-bar menu, then
select the header template from the available list for write your own header with contents of
your Roll No. and Examination 2018. After it, click tlhe "Footer" ic,on or "Page Number" icon. In
"Footer" 01ption again select the best template of footer showing pag:e number from available
list or if you opted "Page Number" icon then click bottom of the page to insert the page
number in the footer of your document.

Saving the Document

CamScanner
 XI PRACTICAL Word & Excel 2024-25
In the end save the file by pressing "Ctrl with "Sn
11

Printing the Document

11
If you want to,print the document press "Ctrl with "P"

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Output
Assalam Alykum, this is a simple text file just for fulfilling the requirement of Word
Practical. I was given task to write any paragraph comprising of three to four lines. Then I
have to copy it one time and paste it three times. I am also supposed to apply new styles for
every pasted copy.

Assalam Alykum, this is a simple text file just for fulfilling the
requirement of Word Practical. I was given task to write any
paragraph comprising of three to four lines. Then I have to copy it
one time and paste it three times. I am also supposed to apply new
styles for every pasted copy.

Assalam Alvkum, this is a simple text flle iust fo,r ful(i1ling the requirement of Word Practical. I
was given task to write any paragraph comprising o,f three to four lines. Then I have to copy it
one time and paste it three times. I am also supposed to appf.y new styles for every pasted copy.
.,

---- ,_,...•• •,,.

.. .. ••--
__.. ..... �_...=
.
..-
- "l•-'-"'---'I.'----
_,,.. .. ,._,._�-
'
- ..
.._ .
- --1 ... .- ..-. ��-
.
'==JI "lu·..-...,_,.

•
.i..e....-..

-�•

f!" �
.
-
•=-e:e< ra

---
-
- IF N-

-- WWWW
.

E m� - - .. - . . ... . . .. . .. . .
w,_,. ,,,.....,
....,r,-."1-fl0<EGo'nff'C

-
----..·.��"'1

.,,,....,.,,_._ .._,,.,_ H_l..,10--

---
... "Ill .. 1.. . . .. - . . & - . . . = , a c:r ••----:0,,- -----

_:..,,..__.,..._,.,... ,...,. .w ........►�---�,-

..,.
..._,
,
...
.
._._..,, ,,. _• _..,
,. _ ._
.. ..,.'ii .. �.._.. - ■---[Link]•"

. . - ·-·-
_5.,,......................,,,._�
---.. . .. .. , .......

Assalam Alykum, this is a simple text file just for fulfilling the, requirement of Word Practical. I
was given task to write any paragraph comprising of three to four lines. Then I have to copy it
one tim1e and paste it three times. I am also supposed to apply new styles for every pasted
copy.

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.7-(App/ication to Librarian)

Obiect Write an application to the librarian requesting him/her to issue you some books from
L

lending library. Insert a table containing 5. No., Book Name, Author Name & Edition. Save and also print.

Procedure

Switching on Computer
Switch on your computer. Wait till the operation system "Windows" let you give access to
interact with the,computer.

Searching and Opening MS-Word

With the help of mouse click "Start" Icon, generally present at bottom left side of the,computer
screen-

Use Mouse click "Search Bar", type "Microsoft Office Word" in it with the help of computer
keyboard to search and open MS-•Word.

Creating File
Double click the MS-Word icon to open MS-Word, New document having 11ame
[Link] will automatically be open.

Start typing the line from the left top position (where typing cursor blinks). Type the given
material in your own wordings for asking your Ship Owner's college librarian to issue you
1

thebooks you mentioned in the table containing the [Link]., Name of Books, Quantity and Price

Inserting Table
Click the "Insert" from menu-bar, then "Table" icon from its tool-bar and the,n draw five(0S)
rows and four(04) columns. Insert th,e headings in the first row and books concerning
information in remaining cells. Use tab or mo,use pointer to toggle between the cells of the
table. Type in the concern cells what you want to type.

Saving the Document

In the end save the file by pressing "Ctrl" with "S"

Printing the Document

If you want to,print the document press "Ctrl" with "P"

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Output
To,
The Librarian,
Pakistan Shipowners' Govt. College,
Block R & S, North Nazimabad,
Karachi.

Sub: Boo,ks Issuance Request

Respect,ed Sir,
I am Muhammad Omer Kham roll no. 15557, of XI class in your college. Sir I need the following
books for my course study purpose

[Link]. Name of Book Author Edition

1 Step by Step Practi·cal Solution for XI Students 1 2019
2 The 10 Programming 1 2019
3 The Tenth Programming 1 2019
4 Word and Excel a complete guide 1 2019

Therefore, it is requested to kindly issue me above mentioned books.

Thanking you,

Yours' sincerely,
Muhammad Omer Khan Ghori,
Roll No. 15557,Class XI,
Pakistan Shipowners' Govt. College.

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.8-{Writing in Columns with

Drop cap_)
Obiect Write a passage from your book, Use MS-Word to create three columns in each collumn

apply different Font sizes, F,ont name and in first column apply Drop Cap. Save and also print.

Procedure

Switching on Computer
Switch on your computer. Wait till the operation system "Windows" let you give access to
interact with the,computer.

Searching and Opening MS-Word

With the help of mouse click "Start" Icon, generally present at bottom left side of
the,computer screen-

11 11
Use Mouse click Search Bar'', type Microsoft Office Word" in it with the help of computer
keyboard to search and open MS-•Word.

Creating File
Double click the MS-Word icon to open MS-Word, New document having 11ame
[Link] will automatically be open.

Start typing the line from the left top position. Type three to four lines as said in the practical
object.

Selecting all the text

Now press "Ctrl" with "A" to select all the typed lines. It will be highlighted.

Copying the entire text into the computer memory

Now press "Ctrl" with "C,, to Copy the text into the computer memory

Pasting the memory resident text to the desired place

CamScanner
 XI PRACTICAL Word & Excel 2024-25
Now place the cursor with the help of mouse to the position where you want to copy the
highlighted text. Press "Ctrln with "V,, to paste this text.

Now repeat, step number 7, four tim1es more, to make the total number of copies five.

Now select the first copy of paragraph (second paragraph) with the help of mouse i.e. by
continuously pressing the left button of mouse and moving the mouse cursor from the start of
paragraph to the end of paragraph.

Opening Font Menu to apply styles

Then press "Ctrl" with "D" to open "Font Menu", there change the "name" of font to "Times
New Roman", style of font to "Bold Italic" and size of the paragraph to "7,,_

Repeat step 1 0 with font Name "" ,Style "" and Size "9"
1

Repeat step 1 0 three more times with different font name Le. ,Style i.e and size i.e.
1

Saving the Document

In the end save the file by pressing "Ctrl" with "S"

Printing the Document

If you want to,print the document press "Ctrl" with "P"

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Output
times. I am also copy pasting it to save
supposed to apply new my time here. Repeat3
ssalam
styles for every pasted this is a simple text file
Alykum, this is
copy. Now in this just for fulfilling the
a simple text file just for
practical I have to, uIse requirement of Word
fulfilling the requirement
the Drop Cap feature, Practical. I was given
of Word PracticaL I was
moveover I have to uIse task to write any
given task to write any
column in this practical paragraph comprising of
paragraph c,omprising
also I have to apply the three to four lines. Then
of three to four lines.
font styles here. I ha1ve I have to copy it one
Then I have to copy it
no time to waste on this time and paste it five
one time and paste it
sort of typing so I am times. I am also
five times. I am also
copy pasting it to sa1ve supposed to apply new
supposed to apply new
my time here. Repeat2 styles for every pasted
styles for every pasted
this is a simple text file copy. Now in this
copy. Now in this
just for fulfilling the practical I !have to use
practical I have to use
requirement of Word the Drop Cap feature.
the Drop Cap feature,
Practical. I was given moveover I have to use
moveover I have to use
task to write any column in this practical
column in this practical
para1graph comprising of also I have to apply the
also I have to apply the
three to four lines. Then font styles here. I have
font styles here. I have
I have to copy it one no time to waste on this
no time to waste on this
time and paste it five sort of typiing so I am
sort of typing so I am
times. I am allso copy pasting it to save
copy pasting it to save
supposed to apply new my time here. Repeat4
my time here. Repeat1
styles for every pasted this is a simple text file
this is a simple text file
copy. Now in this just for fulfilling the
just for fulfiilling the
practical I have to uIse requirement of Word
requirement of Word
the Drop Cap feature, Practical. I was given
Practical. I was given
moveover I have to use task to write any
task to write any
column in this practical paragraph comprising of
paragraph c omprising
1

also I have to apply the three to four lines. Then

of three to four lines.
font styles here. I ha1ve I have to copy it one
Then I have to copy it
no time to waste on this time and paste it five
one time and paste it
sort of typing so I am time·s.
five

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.9-{Application for Leaving

Certificate J
a a

Obiect Write an application to your principal, asking him/her for leave certificate. Change the
type face of the entire document to 1.5 point Book Antiqua. Change the page background using File
effects with Texture Save and also print (without back ground).

Procedure

Switching on Computer
Switch on your computer. Wait till the operation system "Windows" let you give access to
interact with the·computer.

Searching and Opening MS-Word

With the help of mouse click "Start" Icon, generally present at bottom left side of the·computer
screen-

Use Mouse click "Search Bar", type "Microsoft Office Word" in it with the help of computer
ke·yboard to search and open MS-Word.

Creating File
Double click the MS-Word icon to open MS-Word, New document having rname
[Link] will automatically be open.

Start typing the line from the left top position (where typing cursor blinks). Type the application
in your own wordings to request your Shipowners' College Principal to issue you leaving
certificate.

Changing the Font

Now change the font by using keyboard by pressing "Ctrl" with "D" or by using mouse, click
"Home" from Menu-Bar then clicking combo box of font style to "Antiqua" a111d combo box of
font size to "15".

Inserting the Background

CamScanner
 XI PRACTICAL Word & Excel 2024-25
11
Now press "Page Layout}' from menu-bar, then click Page Colorn from its tool-bar menu. Then
click "Fill Effects}' and then click "Texturen tab from this menu and final select the texture which
yo,u want to use in the background of the document.

Saving the Document

In the end save the file by pressing "Ctrl" with "Sn

Printing the Document

If you want to,print the document press "Ctrln with "pn

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Output
To,
The Principal,
Pakistan Shipowners' Govt. College,
Karachi.

subject: Arpplication for leaving Certificate

Respected Sir,

With due veneration, I would like to say that I am student in your college. Sir1 my family is
shifting our home from Karachi to Peshawar for which I need leaving certificate for continuation
of my studies there in Peshawar.

Kindly issue me Leaving Certificate, so that I can continue my studies.

Thanking you,

Your's Obediently,

Muhammad Hasan Khan

Pakistan Shipowners' Govt. College,

Block R & S, North Nazimabad,

Karachi.

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.10-{C. V.J

Object Change the Create a Curriculum Vitae. Save and Print.

a) PERSONAL using Tab Keys and Format Tools.

b) ACDEMIC QUALIFICATIONS using Tables.
c) WORKING EXPERIENCES using Bullets.
d) HOBBIES using simple Format

Procedure
Switching on Computer
11
Switch on your computer. Wait till the operation system "Windows let you give access to
interact with the,computer.

Searching and Opening MS-Word

With the help of mouse click "Start" Icon, generally present at bottom left side of the,computer
screen-

Use Mouse click "Search Bar", type "Microsoft Office Word':' in it with the help of computer
keyboard to search and open MS-•Word.

Creating File
Double click the MS-Word icon to open MS-Word, New document having 11ame
[Link] will automatically be open.

Start typing the line from the left top position (where typing cursor blinks). Type your attributes
(Curriculum Vitae) in the way it is supposed to be typed, then apply the editing as it is asked in
practical object.

Editing Personal Information

Point the location where the personal lnformati<on is present, add the tab gap before the
caption and two, tab gaps between the caption/title or information by pressing tab or tabs as
per need in between these two

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Inserting and Editing Academic Information

Click "Insert" from menu-bar} then click "Table" icon from tool-bar, then draw 4x5 Table. Type
in the cells the academic information i.e. Capti,ons/Headers/title in ithe first row and
data/information in the rest of the rows to complete this academiic sect:iorn.

Hobbies
No need to apply any effects on hobbies section only select hobbies title press "Ctrln with "B"
for bold and "Ctrln with "Un for underline the heading/caption "Hobbies".

Saving the Document

In the end save the file by pressing "Ctrln with "S"

Printing the Document

If yol.11 want to,print the document press "Ctrln with "pn

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Output
Curriculum1Vitae
PERSONAL

Name Muhammad Omer Khan Ghori

Father Nrune Mohsin Ahmed Khan Ghori
CNIC 42101-1634587-7
Religion Isalam
Nationality Pakistani

ACDEMIC QUALIFICATIONS

Certificate/Degree Year Institute/Board/U niversiity Division/Grade

Matriculation 1993 Karachi Academy School A+

Intermediate 1995 Govt. College For Men, A

Nazimabad
Bachelor's 1998 University of Karachi B
Master's 2003 Haindard University A+

WORKING EXPERIENCES

• One y·ear working experience as Weh developer and Programmer in Micro Asian
Technologies.
• Two y·ears working experience in Law Enforcement Department
• Ten years working experience in Traffic Ma:nagement on Expressways, Highways and
• Motorways
• Four years working experience in Sindh Education Department.

HOBBIES
Internet Surfing, Watching sport/news and entertainment television channels, Playing and
watching i:n-door and outdoor games etc.

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.11-(Award Certificate) C

Obiect Create an Award Certificate, Choose Landscape orientation, use a Page Border and insert
L

graphic from leisure category. Save and also print.

Procedure

Switching on Computer
11
Switch on your computer. Wait till the ope,ration system "Windows let you give access to
interact with the computer.

Searching and Opening MS-Word

With the help of mouse click "Start" Icon, generally present at bottom left side of the computer
screen-

Use Mouse click "Search Bar'', type "Microsoft Office Word" in it with the help of computer
keyboard to search and open MS-,Word.

Creating File
Double click the MS-Word icon to open MS-Word, New document having name
[Link] w'ill automatically be open.

Start typing the line from the left top position (where typing cursor blinks). Type and design the
certificate as per desire also notice this file's output is in portrait form make it's landscape if
take printout. Click "Insert" from menu-bar, then "Clip Art" icon from it's tool-bar, then goto
leisure and then select best picture from the available list to copy and paste it in the certificate.

Saving the Document

In the end save the file by pressing "Ctrl" with "S"

Printing the Document

If you want to,print the document press "Ctrl" with "P"

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Output (take printout in landscape)

,
ertt o rectatton
tcate
Is awarded to

[Link] KHAN s/ o PARWANA KHAN

I

IN AKNOWLEDGEMENT AND SINCERE APPRE CIATION FOR HAVING SERVED AS

1

SPEAKER
FROM
MATHEMATICS DEPARTMENT PAKISTAN SHIPOWNERS' GOVT.
COLLEGE
In the lectures entitled

''COMPUTER ORIENTATION OFFICE WORK COURSE''

In the month of March and April, 2018 at Computer Lab Pakistan Shipowners' Govt. College, North

Nazimabad, Karachii.

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.12-(7 [Link] leave application)

Obiect
L
Write an application to the Principal, requesting him to grant you 7 days leave. Use the
single spacing and left alignment. Change the formatting Font- size 12 point and Font -Name "Arial".
Save and also print.

Procedure

Switching on Computer
Switch on your computer. Wait till the ope·rat:ion system "Windows" let you give access to
interact with the,computer.

Searching and Opening MS-Word

With the help of mouse click "Start" Icon, generally present at bottom left side of the computer
screen-

Use Mouse click "Search Bar'', type "Microsoft Office Word" in it with the help of computer
keyboard to search and open MS-,Word.

Creating File
Double click the MS-Word icon to open MS-Word, New document having name
[Link] w'ill automatically be open.

Start typing the line from the left top position (where typing cursor blinks). Type the application
in your own wordings to request your Shipowners' College Principal to grant you seven days
leave,.

Changing the Font

Now change the font by using keyboard by pressing "Ctrl" with "D" or by using mouse, click
"Home" from Menu-Bar then clicking combo box of font style to "Arial" and combo box of font
size to "12".

Saving the Document

In the end save the file by pressing "Ctrl" with "S"

Printing the Document

If you want to,print the document press "Ctrl" with "P"

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Output

To,

The Principal,

Pakistan Shipowners' Govt. College,

Karachi.

Subject: Application for Seven days leave

Respected Sir,

With due respect, I would like to say that I am student in you1r college. Sir, my family is
going from Karachi to Quetta to attend the wedding ceremony of my beloved cousin
Shezada Waseem Shahid ,for which I need seven days leave

Therefore it is requested to please grant me seven days leave, so that I can attend my
cousin's wedding.

Thanking you,

Your's Obediently,

Muhammad Omer Khan

Pakistan Shipowners' Govt. College,

Block R & S, North Nazimabad,

Karachi.

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.13-{Pamph/et)
Obiect Using "Word Pro,cessor" create a pamphlet of A4 size paper/ letter. Use complete
L

drawing menu, Fonts and Borders. Save and also Print.

Procedure

Switching on Computer
Switch on your computer. Wait till the operation system "Windows" let you give access to
interact with the computer.

Searching and Opening MS-Word

1
With the help of mouse click "Start ' Icon, generally present at bottom left side of the
computer screen-

Use Mouse click "Search Bar", type "Microsoft Office Word" in it with the help of computer
keyboard to search and open MS-•Word.

Creating File
Double click the MS-Word icon to open MS-Word, New document having name
[Link] w'ill automatically be open.

Start typing the line from the left top position (where typing cursor blinks). Type and design the
Pamphlet as per your skills use "Word Art", "Clip Art", Headings and styles to make it attractive
and apply page borders as well

Saving the Document

In the end save the file by pressing "Ctrl" with "S"

Printing the Document

If you want to,print the document press "Ctrl" with "P"

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Output

Model Colony, Karachi, Pakistan.

•

•
Students are passed in high numbers just like
"A-1" and "A". Highly coalfield teachers available in this center, And computer Lab,
Physics Lab, Chemistry Lab are available, And In this center are playing the games.

Admission Open

V to X, XI, XII, [Link], [Link], [Link]

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.14-(Birthday Invitation)

Obiect Prepare an invitation card for friends, invite them to your birthday party. Give a Page
L

Border in this invitation card, insert graphic objects from,event category. Set Landscape as
orientation. Save and also print.

Procedure

Switching on Computer
11
Switch on your computer. Wait till the operation system "Windows let you give access to
interact with the·computer.

Searching and Opening MS-Word

With the help of mouse click "Start" Icon, generally present at bottom left side of the,computer
screen-

Use Mouse click "Search Bar'', type "Microsoft Office Word" in it with the help of computer
keyboard to search and open MS-•Word.

Creating File
Double click the MS-Word icon to open MS-Word, New document having rname
[Link] will automatically be open.

Start typing the line from the left top position (where typing cursor blinks). Type and design the
invitation card as per your desire use "Word Art", "Clip Art", Headings and styles to make it
attractive and apply page borders as well, also change the page layout to landscape.

Saving the Document

In 11 11
the end save the file by pressing "Ctrl" with $

Printing the Document

If you want to print the document press "Ctrl" with "P,,

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Output

My Dear Friend Faysal Butt,

Assalamualikum, I am fine and hope you will also be finein your
Railway Police Department.
Dear You are invited in my birthday ceremony, Which will be
held on 18 of April 2019.
th

hankYotl

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.l,5-{Using Header/Footer)

Obiect Write a passage from your book. Using W,ord Processor create any document using header
L

and footer. Save and also print.

■ Insert Date & Time in header.

■ Insert page number in footer.
■ Convert the document in two columns.
■ Use drop caps in the document.
Insert clipart in the docume,nt.

Procedure
Switching on Computer
Switch on your computer. Wait till the operation system "Windows" let you give access to
interact with the,computer.

Searching and Opening MS-Word

With the help of mouse click "Start" Icon, generally present at bottom left side of the computer
screen-

Use Mouse click "Search Bar'', type "Microsoft Office Word" in it with the help of computer
keyboard to search and open MS-,Word.

Creating File
Double click the MS-Word icon to open MS-Word, New document having rname
[Link] will automatically be open.

Start typing the line from the left top position (where typing cursor blinks). Type/Write any
material you want up to few lines (Use your Regional language like URDU if you want). Apply
decent font style, size by selecting the text with "Ctrl" with "A" then for font effects press "Ctrl"
with "D".

Inserting Header and Footer

Now click "Insert" again from Menu-Bar, then click "Header" icon from it's tool-bar menu, then
select the header template from the available list for write your own header with contents of
yo,ur Roll No. and Examination 2018. After it, click the "Footer" icon or "Page Number" icon. In

CamScanner
 XI PRACTICAL Word & Excel 2024-25
"Footer/} option again select the best template of footer showing page number from available
list or if you selected "Page Number" icon then click bott,om of th,e page to insert the page
number in the footer of your document.

Saving the Document

In
11
the end save the file by pressing "Ctrl" with "5

Printing the Document

If you want to,print the document press "Ctrl" with "P,,

CamScanner
CamScanner
 XI PRACTICAL Word & Excel 2024-25

Part-2 icroso t Exce

S rea S eet

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.16-{Pavrol/J L

Ob Liect Create a Pay Roll of employees according to the instructions:

16000

oo

oo

00

I) Calculate Medical Alllowance = 12 % of Basic Pay and Hose Rent= 40 % of Basic Pay.
II} Calculate: Gross Pay= Basic Pay+ Medical Allowance+ House Rent
Ill) Develop an IF( ) Function to compute Tax which is 4% of the Gross Pay if Gross pay is
greater than 15000 otherwise it is 3%.
IV) Compute Net Pay by Subtracting Tax from Gross Pay.
V) Using IF( ) Function, Assign Gra,de-1 if Net Pay is greater than 15000 otherwise assign
Grade-2.

Procedure

Switching on Computer
Switch on your computer. Wait till the ope,rat:ion system "Windows" let you give [Link] to
interact with the,computer.

Searching and Opening MS-Excel

With the help of mouse click "Start" Icon, generally present at bottom left side of the computer
screen-

Use Mouse click "Search Bar", type "Microsoft Office Excel" in it with the help of computer
keyboard to search and open MS-Excel.

Creating File

CamScanner
 XI PRACTICAL Word & Excel 2024-25
Double click the MS-Excel icon to open MS-Excel, New File having name Book1 with spread
sheet having name sheet:1 will automatically be open.

Start typing the text from the left top position (where cursor is present by default), but you can
select your own cell address as well by clicking that specific cell location with mouse, in my
case first column, fifth row ''AS"( alphabet 'A' represents column, digit '5' represernts row). Now
type-in the data information already given in the object.

Calculating Medical Allowanc,e

Medical Allo,wance = 12 % of Basic Pay

C6= (12 * 86)/ 100

Calculating House Rent

House Rent = 40% of Basic Pay

D6 = ( 40 * B6) / 100
Calculating Gross Pay

Gross [Link] = Ba1sic Pay+ Medical Allowance+ House,Rent

E6 = Sum(B6..D6)
Calculating Tax

Tax= 4% of Basic pay, if Basic [Link] > 15000 else 3% o,f Basic pay

F6 = if( 86>15000,4%*86,3%*86)

Computing Net pay

Net Pay = Gross Pay - Tax

CamScanner
 XI PRACTICAL Word & Excel 2024-25

G6 = E6- F6
Determining the Grade
11
Grade= "Grade-1 if Net Pay>lS000 else "Grade-2''

HG= if(G6>15000, ''Grade-1'','''Grade-2'')

Saving the Document

In the end save the file by pressing "Ctrl" with "S"

Printing the Document

11
If you want to print the document press Ctrl" with up"

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Output
Name Basic Medical House Rent Gross Tax Net Pay Grade
Pay Allowance Pay

Jamshed Hashmi 15000 1800 6000 22800 912 21888 Grade-1

Asif Ali Sanghi 10000 1200 4000 15200 608 14592 Grade-2
Shahzada
Waseem 16500 1980 6600 25080 1003.2 24077 Grade-1

Ali Akber 20300 2436 8120 30856 1234.24 29622 Grade-1

CamScanner
 XI XI PRACTICAL Word & Ex�el2024-25

Practical No.17-(Dail.v Wages)

Obiect Create and print a spread sheet following the given instructions:
L

Hours Tota work Income

Worker Emp Days
Emp# Worked l Charge Gross Tax
Type Name Worked
per day Hour s per Amoun
Sana s hour t
ULLAH worked
Asher 20 9 100
A 0221
Saeed
Aalam 19 7 120
B 0222
Anees

C 0223 Musta,q 24 10 90
1

D 0224 21 8 125

I) Total Hours worked=days worded* Hours worked per day

II) Gross Amount= Total Hours worked* w·ork charges per
hour Ill) Calculate Two Percent ( 2%) Income lax of each
employee.
IV) Use AVERAGE( ) Function , Calculate separately Average Gross Amount in a cell below the
above work sheet.
V) Save and also print.

Procedure
Switching on Computer
11
Switch on your computer. Wait till the operation system "Windows let you give access to
interact with the·computer.

Searching and Opening MS-Excel

With the help of mouse click "Start" Icon, generally present at bottom left side of the computer
screen-

Use Mouse click "Search Bar"1 type "Microsoft Office Excel" in it with the help of computer
keyboard to search and open MS-Excel.

Creating File
Double click the MS-Excel icon to ope·n MS-Excel, New File having name Bookl with spread
sh,eet having name sheet1 will automatically be open.

CamScanner
 XI PRACTICAL Word & Excel 2024-25
Start typing the text from the left top p,osition (where cursor is present by default), but you can
select your ow·n cell address as well by clicking that specific cell location with mouse, in my
case first colum111, fifth row"AS"( alphabet 'A' represents column1 digit '5' represe11ts row). Now
type-in the data/information already given in the object.

Calculating Total Hours Worked

Total Hours worked=days wo,rked * Hours worked per day

F6 = D6 * E6
Calculating Gross Amount

Gross Amount = Per day Hours Worked* P,er Hours worked Charges

HG= F6 * G6
Calculating Income Tax

Income Tax = 2% of Gross Amount

16 = 2/100 * HG
Calculating Average Gross Amount

Average Gross Amount = Average of {06 to D10)

D11 = Average(D6:D1.0)

Saving the Document

In the end save the file by pressing "Ctrl" with "5"

Printing the Document

If you want to print the docum1ent press "Ctrl" with "P"

Output

CamScanner
 XI PRACTICAL Word & Excel 2024-25
Worker Emp# Emp Days Per day Total Per Hour Gross Income
Type Worked Hours Hours worked Amount Tax
Name Worked worked charges

Sana
ULLAH
A 0221 20 9 180 10 18000 360
0
Asher
Saeed
Aalam
B 0222 19 7 133 12 15960 319.2
0
Anees
C 0223 24 10 240 90 21600 432
Mustaq
D 0224 2:ll 8 168 12 21000 420
5

Average 19140

CamScanner
CamScanner
 XI PRACTICAL Word & Excel 2024-25

Use Mouse click "Search Bar", type "Microsoft Office Excel" in it with the help of computer
ke·yboard to search and open MS-Excel.

Creating File
Double click the MS-Excel icon to open MS-Excel, New File havin,g name Bookl with spread
sheet having name sheet:1 will automatically be open.

Start typing the text from the left top p,osition (where cursor is present by default), but you can
select your own cell address as well by clicking that specific cell location with mouse, in my
II 11
case first column, fifth row AS
( alphabet 'A' represents column, digit '5' represernts row).
Now type-in the data/information already given in the object.

Calculating Total Attendance

11 11
Total Attendance = Count of Total Present IP days

M6 = CountlF(A6..N6,''P'')
Calculating Total Attendance
11
Total Attendance = Count of Total Present "IP days

M6 = CountlF(A6..N6,''P'')
Calculating Percentage of the Attendance
11 11
Percentage of Attendance= Present P days* 100 / Total Number of Day

N6 = MG * 100 / 10
Calculating Attendance Marks

Attendance Marks= 20 if Attenda1nce >80%, else if Attendance

Marks= 10 when .Attendance> 50%, else if Mlarks=S when
Attendance marks> 20 % else Attendance Marks= 0

CamScanner
 XI PRACTICAL Word & Excel 2024-25

06 = if( M6>80, 20, if( M6>50, 10, if( MG> 20, 5, 0)))
Sorting the Attendance List

Now select the entire column of total attendance and press Sort/Filter
option1from home menu tool bar (normally present at the riglht top corner
of the tool bar menu) and expand the selection to rest of the columns when
asked to sort the list according to Ascending and Descending order.

Saving the Document

In the end save the file by pressing "Ctrl" with "S"

Printing the Document

If you want to print the document press "Ctrl" with "P,,
1

CamScanner
CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.19-{Grade Computing and

Marks Sorting in Ascending Order_)
Obiect L!Jsing Spread Sheet, Generate the following output.
L

Roll No Name Marks Grade

1 Masroor 80

2 Yameen 76

3 Mohsin 71

4 Khalill 56

5 Ahmer 97

6 Uzair 45

7 Aqeel 81

8 Faz 65

9 Waqas 77

10 Yaseen 89

11 Wali 99

12 Wasif 91

Instructions:
I) Use IF( ) function assign Grade according to the following criteria:
a) If the Marks is greater than or equal 80 Grade"'A-1
b) If the Marks is Less than 80 or equal to 70 Grade=A.
c) If the Marks is Less than 70 or equal to 60 Grade=B.
d) If the Marks is Less than 60 or equal to 50 Grade;;; C.
e) Else Grade;;; FAIL.
11) Sort the list by Marks
Ill) Using Bar Chart show each student's bar according with its marks.
IV) Save and also Print.

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Procedure
Switching on Computer
Switch on your computer. Wait till the operation system "Windows" let you give access to
interact with the·computer.

Searching and Opening MS-Excel

With the help of mouse click "Start" Icon, generally present at bottom left side of
the·computer screen-

Use Mouse click "Search Bar", type "Microsoft Office Excel" in it with the help of computer
keyboard to search and open MS-Excel.

Creating File
Double click the MS-Excel icon to ope·n MS-Excel, New File having name Bookl with spread
sheet having name sheetl will automatically be open.

Start typing the text from the left top p,osition (where cursor is present by default), but you can
select your own cell address as well by clicking that specific cell location with mouse, in my
case first column, fifth row "AS"( alphabet 'A' represents column, digit '5' represe11ts row).
Now type-in the data/information already given in the object.

Calculating Grade

Gra,de = A-1 if marks>= 80, else Grade= A if (marks>=70 but [Link]

< 80), else Grade= B if (marks>=60 but marks< 70), else Grade= C
if(marks>=S0), else Grade=Fail

D6 = if( C6>=80, ''A-1'', if( AND(C6>=70,C6<80), ''A'',

if( AND(C6>=60,C6<70) ., ''B'', if( AND{C6>=50,C6<60),
''C''1 ' FAIL''))))
1

Sorting the Attendance List

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Now select the entire column of total attendance and press S,ort/Filter
option1from home menu tool bar (normally present at the riglht top corner
of the tool bar menu) and expand the selection to rest of the columns when
asked to sort the list according to Ascending and Descending order.

Saving the Document

In the end save the file by pressing "Ctrl" with "S"

Printing the Document

If you want to print the document press "Ctrl" with "P,,

CamScanner
CamScanner
 XI PRACTICAL Word & Excel 2024-25

Pra,ctical No.20-{Marks sheet)

Obiect
L
Use Spreadsheet to create and print Marks Certificate according to the following
instructions.

Computer
Marks
Name Maths Science Physics English Udru Percentage Grade
Obtained

Khasif 70 37 49 69 39
Asim 86 73 53 61 82
Adil 63 so 63 33 55
Mohsin 52 46 67 52 68
Shafi 43 48 52 65 39

I) Use SUM () Function to find out the marks obtained of each student.
II) Calculate Percentage of each student with Total Marks;;;;5Q0.
Ill) Use IF() function assign Grade according to the following criteria:
(a)lf Percentage is greater than or equal to 80, print A+
(b) If Percentage is greater than or equal to 70, print A
(c) If Percentage is greater than or equal to 60, print B
(d) If Percentage is greater than or equal to 50, print C else Print F
IV) Save and also print.

Procedure
Switching on Computer
Switch on your computer. Wait till the ope·ration system "Windows" let you give access to
interact with the,computer.

Searching and Opening MS-Excel

With the help of mouse click "Start" Icon, generally present at bottom left side of the,computer
screen-

Use Mouse click "Search Bar", type "Microsoft Office Excel" in it with the help of computer
keyboard to search and open MS-Excel.
Creating File
Double click the MS-Excel icon to ope,n MS-Excel1 New File having name Bookl with spread
sh,eet having name sheet1 will automatically be open.

CamScanner
 XI PRACTICAL Word & Excel 2024-25
Start typing the text from the left top p,osition (where cursor is present by default), but you can
select your ow·n cell address as well by clicking that specific cell location with mouse, in my
case first colum111, fifth row "AS"( alphabet 'A' represents column, digit '5' represe11ts row). Now
type-in the data/information already given in the object.

Calculating Total Marks Obtained

Marks Obta1ined = Su1m of all subjects (Mathis, Comp, Phy, Eng, Urdu )

G6 = Sum(B6..F6)
Calculating Percentage

Percentage= Total Marks Obtained * 1,00 / 500 (given in Object)

H6 = G6 * 1 00 /
1
500
Calculating Grade

Gra,de = A+ if marks>= 80%, else Grade= A if marks>=70%, else

Gra,de = B if marks>=60%, else Grade= C if marks>=50%, else
Gra,de=F

16 = if( H6>=80, ''A+'', if( H6>=70, ''A'', if( H6>=60,

''B'', if(H6>=50, ''C'',''F''))))
Saving the Document
In the end save the file by pressing "Ctrl" with "S"

Printing the Document

If you want to,print the document press "Ctrl" with "P"

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Output
Name Math Computer Physics English Urdu Total Percentage Grade
Science
Khasif 78 67 49 69 39 302 60.40 B
Asim 86 67 53 78 82 366 73.20 A
Adil 61 so 45 33 55 244 48.80 FAIL
Mohsin 52 46 67 52 68 285 57.00 FAIL
Shafi 43 48 52 65 39 247 49.40 FAIL

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.21{Marks sheet with subiect a

missing marks.)
Obiect L!Jse Excel Use Spreadsheet, create and print Marks Certificate according to the folllowing
L

instructions.

Name Math Computer Physics English Udru Marks Percentage Remarks

Science
Obtained
Sana 98 67 89 79 421
Ullah
Dilshad 86 67 78 82 366
Mohsin 61 50 33 55 244
Anees 52 46 52 68 285
Mustaq 43 48 65 39 247
(I) Develop a formula to find out physics marks of each student.
II) Calculate the Percentage of each student.
Ill) Using IIF( ) function assign remarks according to the following criteria:
a) If Percentage is greater than or equal to 80, print "Excellent"
b) If Percentage is greater than or equal to 70, print "V. Good"
c) If Percentage is greater than or equal[to 60, print "Good"
d) If Percentage is greater than or equal to SO, print "Fair" else
"poor"
VI) Save and also print.

Procedure
Switching on Computer
Switch on your computer. Wait till the ope·ration system "Windows" let you give [Link] to
interact with the·computer.

Searching and Opening MS-Excel

With the help of mouse click "Start" Icon, generally present at bottom left side of the computer
screen-

Use Mouse click "Search Bar", type "Microsoft Office Excel" in it with the help of computer
keyboard to search and open MS-•Excel.
Creating File

CamScanner
 XI PRACTICAL Word & Excel 2024-25
Double click the MS-Excel icon to open MS-Excel, New File having name Bookl with spread
sheet having name sheet:1 will automatically be open.

Start typing the text from the left top position (where cursor is present by default), but you can
select your own cell address as well by clicking that specific cell location with mouse, in my
case first column, fifth row ''AS"( alphabet 'A' represents column, digit '5' represernts row). Now
type-in the data/information already given in the object.

Computing Physics Marks

Physics Marks= Total Marks Obtained - Sum of oth,er subjects (Maths,

Comp,Eng, Urdu )

D6 = G6 - Sum{B6,C6,E6,F6)
Computing Percentage

Percentage= Total Marks Obtained * 1,00 / 500 (given in Object)

H6 = G6 * 1 00 / 500 1

Generating Remarks

Remarks= ''Excellent'' if marks>= 80%, else Remarks= ''Very Giood''

if m1arks>=7O%, else Grade= ''Good'' if marks>=6O%, else Grade=
''Fair'' if marks>=5O%, else Grade= ''Poor''

16 = if( H6>=80 , ''Excellent'', if( H6>=70 , ''Very Good'',

if( H6>=60, ''Good'', if(H6>=50, ''Fair'',''Poor''))))

Saving the Document

In the end save the file by pressing "Ctrl" with "S"

Printing the Document

If you want to,print the document press "Ctrl" with "P"

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Output
Name Math Computer Physics English Udru Marks Percentage Re1marks
.Science Obtained

San 98 67 88 89 79 421 84.2 Excellent

a
Ullah
Dilshad 86 67 53 78 82 .366 73.2 Very
Good
Mohsin 61 50 45 33 55 244 48.8 Poor

Anees 52 46 67 52 68 285 57 Fair

Mustaq 43 48 52 65 39 .247 49.4 Poor

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.22{Expenditure o.f

Departments.)
Ob iect Create spreadsheet with the following data and follow the instructions:
L

Differ,ent Expenditures by the Province in Year 2018 (Rs. in Mlillion)

Department 1st Qtr 4,th Qtr

Education 4.3 6.1 6.4

Health 6.87 7.51 7.81 78.6

Law & Order 1.47 2.49 3.64 3.91

Welfare 50.5 53.7 60.12 78.5

I) select the rows and columns consisting of numbers only to create a Column Chart
showing comparison among the Expenditure by different Department using chart
wizard. Title the chart "Expenditure in Year 2018;,. Title Y-Axis ''( Rs. In Million)';
II) Display legend of chart.
II) Print both the worksheet and Chart.

Procedure

Switching on Computer
Switch on your computer. Wait till the ope,ration system "Windows" let you give access to
interact with the,computer.

Searching and Opening MS-Excel

With the help of mouse click "Start" Icon, generally present at bottom left side of
the,computer screen-

Use Mouse click "Search Bar", type "Microsoft Office Excel" in it with the help of computer
keyboard to search and open MS-Excel.

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Creating File
Double click the MS-Excel icon to open MS-Excel, New File having name Bookl with spread
sheet having name sheetl will automatically be open.

Start typing the text from the l,eft top position (where cursor is present by default), but you can
select your own cell address as well by clicking that specific cell location with mouse, in my
case first column, fifth row "AS,"( alphabet 'A' represents column, digit '5' represents row).

Generating Remarks

Select part of sheet in which statistics of expendliture is written, then click insert, then click
desired chart .

Insert/exchange data range of x-axis and y-axis if the chart isn't in desired form.

Saving the Document

In the end save the file by pressing "Ctrl" with "S"

Printing the Document

If yoll want to,print the document press "Ctrl" with "P"

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Output

Department 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr

Education 4.3 6 6.1 6.4

Health 6.87 7.51 7.81 78.6

Law & Order 1.47 2.49 3.64 3.91

Welfare 50.5 53.7 60.12 78.5

Different !Expenditures by the Departments

in
Vear2018
90

80

70

60

so
40

30

20

0
1st Qtr 2nd Otr 3rd Otr 4th Otr

■ Education ■ Health ■ Law & ■ Welfare

Order

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.23-{Electricitv bill) L

Obiect Using Spreadsheet, Create a utility bill ,of electricity according to the instructions:
L

Meter Previous Current Units Electricity Amount

Number Units Units Consu1med Charge Surcharge Payable

HU-2201 12536 12750

HU-4202 1230 1523
HU-1203 96312 96642
HU-5620 5853 5996

I)
Enter a formula to calculate units consumed.
11)
Cost of one unit of electricity is Rs. 8.25.
Ill)
Compute the Surcharge as 15% of Electricity Charges.
IV)Compute the Amount Due as
Amount Due= Electricity Charges+ Surcharge
and round up the amount payable to one decimal place using ROUND() function.
V) Save and also print.

Procedure
Switching on Computer
11
Switch on your computer. Wait till the ope,ration system "Windows let you give access to
interact with the, computer.

Searching and Opening MS-Excel

With the help of mouse click "Start" Icon, generally present at bottom left side of the, computer
screen-

Use Mouse click "Search Bar", type "Microsoft Office Excel" in it with 11:he help of computer
keyboard to search and open MS-•Excel.

Creating File

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Double click the MS-Excel icon to open MS-Excel, New File having name Book1 with spread
sheet having name sheet:1 will automatically be open.

Start typing the text from the left top position (where cursor is present by default), but you can
select your own cell address as well by clicking that specific cell location with mouse, in my
case first column, fifth row ''AS"( alphabet 'A' represents column, digit '5' represernts row). Now
type-in the data/information already given in the object.

Calculating Unit Consumed

Unit Consumed = Current Units - Previous Units

D6= C6-B6
Computing Electricity Charges

Electric,ity Charges= Unit Consumed x 8.25

E6 = D6 * 8.2,5

Computing Surcharge

Surcharge= 15 / 100 x Electricity Charges

f 6= 15 / 100 * E6

Computing Amount Payable

Amount Payable= Electricity Charges+ Surcharge

,GG= E6 + F6

Rounding-up 'the Amount Payable

G6= Round(Amount Payable,1)

G6 = Round((E6 + F6),1)

Saving the Document

CamScanner
 XI PRACTICAL Word & Excel 2024-25

In 11 11 11
the end save the file by pressing Ctrll" with S

Printing the Document

11
If you want to,print the document press "Ctrl with "P"

Output
Meter Previous Current Units Electricity Amount
Nlumber Units Units Consumed Charge Payable
Surcharge

1765.5 264.825
HU-2201 12536 12750 214 556.2
2417.25 362.5875
HU-4202 1230 1523 293 761.6
2722.5 408.375
HU-1203 96312 96642 330 857.7
1179.75 176.9625
HU-5620 5853 5996 143 371.7

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.24-{Co//ege Time Table)

Obiect Use Table to,create a time table of your college.
L

TIME TABLE

Periods Mon Tue Wed Thu Fri Sat

Procedure
Switching on Computer
11
Switch on your computer. Wait till the ope,ration system "Windows let you give access to
interact with the·computer.

Searching and Opening MS-Excel

With the help of mouse click "Start" Icon, generally present at bottom left side of the computer
screen-

Use Mouse click "Search Bar", type "Microsoft Office Excel" in it with 11:he help of computer
keyboard to search and open MS-•Excel.

Creating File
Double click the MS-Excel icon to open MS-Excel, New File having name Bookl with spread
sheet having name sheetl will automatically be open.

CamScanner
 XI PRACTICAL Word & Excel 2024-25
Start typing the text from the l•eft top position (where cursor is present by default}, but you can
select your own cell address as well by clicking that specific cell location with mouse, in my
case first column, fifth row "AS"( alphabet 'A' represents column, digit 'S' represents row).

Inserting Data int,o the time table

Click the cell number "AS" type Periods, then click the cell number "BS,CS,DS,ES,FS,GS" and
enter the values "Mon", "Tue", "Wed", "Thu", "Fri", "Sat", respectively in these cells.

Click the cell number "A6,A7,A8,A9,A10 ,A11" and type "1,2,3,4,5,6" respectively in it.
1

Now fill the rest of the cells of time table by ins,erting the values, which cross ponds to the
college time table.

Saving the Document

In the end save the file by pressing "Ctrl" with "S"

Printing the Document

If you want to,print the document press "Ctrl" with "P"

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Output

Periods Mon Tue Wed Thu Fri Sat

1 English Urdu lslamiat Comptuer Maths Physics

2 English Urdu lslamiat Comptuer Maths Physics

3 English Urdu lslamiat Comptuer Maths Physics

4 Urdu English lslamiat Physics Maths Comptuer

5 Urdu English lslamiat Physics Maths Comptuer

6 Urdu English lslamiat Physics Maths Comptuer

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.25-(Expenditure bLy Provinces)

Ob iect Create spr,ead sheet with the following data and Follow the instructions:
L

Expenditure by Different Provinces in Year 2018 (Rs. in Million)

Province 1st Qtr 2nd Qtr Year

Sindh 542.5 561.5 643.4 796.2 l---------------,'

I
I I
Punjab 887 835.8 930.5 936.5 I
I
I
I
-- I
I I
I I
Balochistan 244.81 261.5 301.7 299.3 I I
! I
• I
I
KPK 391.5 424.5 377.6 300.5 I .., , I
" I

l)Use the SUM () function to find the Total Expenditure by province in year.
ll)Select the columns enclosed in the rounded rectangle to create a Pie Chart showing
Contribution of each province in Total Expenditure using Chard Wizard
Ill) Display Legend of Chart
V) Print both the worksheet and Chart

Procedure

Switching on Computer
Switch on your computer. Wait till the ope,ration system "Windows" let you give access to
interact with the computer.

Searching and Opening MS-Excel

With the help of mouse click "Start" Icon, generally present at bottom left side of
the,computer screen-

Use Mouse click "Search Bar", type "Microsoft Office Excel" in it with the help of computer
keyboard to search and open MS-•Excel.

Creating File
Double click the MS-Excel icon to ope,n MS-Excel, New File having name Bookl with spread
sheet having name sheet1 will automatically be open.

CamScanner
 XI PRACTICAL Word & Excel 2024-25
Start typing the text from the 1,eft top position (where cursor is present by default}, but you can
select your own cell address as well by clicking that specific cell location with mouse, in my
case first column, fifth row "AS"( alphabet 'A' represents column, digit '5' represents row).

Computing Yearly Expenditure

Yearly Expenditure= 1sr Quarter+ 2N° Quarter+ 3Ro Quarter+ 4TH Quarter

F6 = Sum( B6.. E6)

OR
F6 = (B6+C6+D6+E6)
Drag and drop eelI "F6,, from cell "F7,, to cell ''F9,,

Inserting Graph
First select the entire data then click "Insert,, from the menu-bar, then click
11 11
"Pie , then click "2-D Pie corresponding graph will automatically be
,

display.

Place the mouse pointer on the Pie graph, by m,oving mouse and click
11
mouse's right button, then click."Select data option from the menu appear,
if there is niee,dof a11y change in the graph view.

Saving the Document

11 11
In the end save the file by pressing Ctrll" with 5,,

Printing the Document

If you want to,print the document press "Ctrl" with "P"

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Output

Expenditure by Different Province in Year 2018 (in [Link])

Province 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr Year

Sindlh 542.5 561.5 643.4 796.2 2543.6

Punjab 887 835.8 930.5 936.5 3589.8

Balochistan 244.81 261.S 301.7 299.3 110 7.31

1

NWFP 391.5 424.5 377.6 300.5 1494.1

Expenditu1re by Different Province in Year 2018

(in [Link]) Vear
1

■ Sindh
■ Punjab
■ Balochistan
■ NWFP

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.26-{Printing Press)

Obiect
L
Ulsing the spreadsheet with the following data and follow the instruction:
Pakistan Printing Press (Expenditure2018)
Department 1st Qtr 2 111d
Qtr 3rd Qtr ,4th Qtr Total
Engineer 25356 45451 67735 45451
Marketing 67735 46421 47881 69421
Computer 4881 56421 84221 55568
Sales 84221 785621 25356 45451
Purchase 59006 58000 67735 605981
Production 8887 99956 4881 56421
Grand Total
Minimum
Maximum
Average

I) Calculate department wise Total, Apply currency Format with 2 decimal places.
II) Use the SUM () f1.Jnctio11 to calculate Grand Total.
Find the Minimum, Maximum and Average expenditure for each quarter using statistical functions =
MIN(}, MAX(), and AVERAGE().

Procedure
Switching on Computer
Switch on your computer. Wait till the operation system "Windows" let you give access to
interact with the·computer.

Searching and Opening MS-Excel

With the help of mouse click "Start" Icon, generally present at bottom left side of the·computer
screen-

Use Mouse click "Search Bar", type "Microsoft Office Excel" in it with the help of computer
ke·yboard to search and open MS-Excel.

Creating File
Double click the MS-Excel icon to ope·n MS-Excel, New File having name Bookl with spread
sheet having name sheet1 will automatically be open.

CamScanner
 XI PRACTICAL Word & Excel 2024-25
Start typing the text from the left top p,osition (where cursor is present by default), but you can
select your ow·n cell address as well by clicking that specific cell location with mouse, i'n my
case first colum111, fifth row "AS"( alphabet 'A' represents column, digit '5' represe11ts row). Now
type-in the data/information already given in the object.

Computing Total Expenditure,o·f Every Department

Total Expenditure= 1st Quarter+ 2nd Quarter+ 3rd Quarter+ 4 Quarter

Or

Total Expenditure= Sum(Starting Celll..Ending Cell)

F6 = Sum(B6...E6) or F6= B6+C6+D6+E6

Simply select F6 cell and then drag and drop the cell number "F6" from "F7" to l{F11" to copy
the formula for rest of the department or simple use mouse pointer to goto the particular cell
and type the following formulas in it.

F7 = Sum(B7.. E7)
F8 = Sum(B8.. E8)
F9 = Sum(B9..E9)
FlO = Sum(B10..ElO)
Fll = Sum(B11..Ell)

Computing Grand Total of Every Quarter

Grand Total= Sum(Starting Cell : Ending Cell)

B12(:lst Quarter)= Sum(B6:B11)

Simply select cell and then drag and drop the cell number l{A12" from "B12" to "D12" to copy
the formula for rest of the Quarters or simple use mouse pointer to goto the particular cell and
type the following formulas in it.

CamScanner
 XI PRACTICAL Word & Excel 2024-25

C12(3rd Quarter) = Sum(C6:Cll)

D12(4th Quarter) = Sum (D6:Dll) 1

E12(2nd Quarter) = Sum(EG:E.11)

Computing Grand Total of the year(Grand total!of total)

Grand Total of year = Sum{Starting Cell : Ending Cell)

F12= Sum(F6:Fll)

Computing MINIMUM of Every Quarter

Minimum of any Quarter= Min{Starting Cell : Ending Cell)

st
B13(1 Quarter)= Min(B6:B11)
11 11 11
Simply select cell number B13 , drag and drop the this cell number "B13 , from "B14" to
"E14" to copy this minimum computing formula for rest of the quarters or simple use mouse
pointer to go to the particular cell and type the following formulas in it.

C13(3r·d Quarter) = Min(C6:Cll)

D13(4th Quarter) = Min(D6:D11)
E13(2nd Quarter) = Min(E6:Ell)

Computing Mlinimum of the year(Total)

Minimum of the year = Mi1n{Starting Cell : Ending Cell}

F13= Min(F6:Fll)

Computing MAXIMUM of Every Quarter

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Maximum of any Quarter= Max(Starting Cell : Ending Cell}

B14(1st Quarter)= Max(B6:B11)

Simply select cell number"B14", drag and drop the this cell number "B14", from "C14" to
"E14" to copy this minimum computing formula for rest of the quarters or simple use mouse
pointer to go to the p,articular cell and type the following formulas in it.

C14(3rd Quarter) = Max(C6:C11)

D14,(4th Quarter) = Max(D6:D11)
E14(2nd Quarter) = Max(E6:E.11)

Computing Maximum of the year(Total)

Maximum of the year = Max(Starting Cell : Ending Cell)

F14= Max(F6:F11)

Computing AVERAGE of Every Quarter

Average of any Quarter= Average(Starting Cell : Ending Cell}

BlS(lst Quarte,r) = Average{B6:B11)

1

Simply select cell number"B15"} drag and drop the this cell number "BlSn, from "ClS" to
"ElS,, to copy this Average c,omputing formula for rest of the quarters or simple use
mouse p,ointer to go to th,e particular cell and type the following formulas in it.

C15(3rd Quarter) = Average(C6:Cll)

D1,5(4th Quarter) = Average(D6:D11)
E15{2nd Quarter) = .Average{E6:E11)
Computing Maximum of the year(T,otal)
Average of the year = Max(Starting Cell : Ending Cell)

CamScanner
 XI PRACTICAL Word & Excel 2024-25

FlS= Average(F6:Fll)
Saving the Document
In the end save the file by pressing "Ctrll" with "S"

Printing the Document

If you want to,print the document press "Ctrl" with "P"

Output

Department 1st Qtr 2nd Qtr 3rd Qtr 4th Qtr Total

Engineer 25356 45451 67735, 45451 183993.00

Marketing 67735 46421 47881 69421 231458.00

Computer 4881 56421 84221 55568 2010,91.00

Sales 84221 785621 25356 45451 940649.00

Purchase 59006 58000 67735 605981 790722.00

Production 8887 99956 4881 56421 170145.00

Grand Total 250086 1091870 297809 878293 2518058.00

Minimum 4881 45451 4881 45451 170145.00

Maximum 84221 785621 84221 605981 940649.00

Average 41681 181978.3 49634.83 146382.2 419676.33

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.27-(Gas Bill)

Ob iect Use spreadsheet to create utility Bill of Sui gas according to the instructions:
L

Meter Previous Current Units Gas Amount

Number Units Units Consu1med Charges Sales Tax Payable

SS-7290 69236 69452

7382 7399
SS-7292
33842 33998
SS-7293
45732 45795
55-7294
82556 82715
55-7295
5699 5754

I) Develop a f,ormula to calcullate Unit Consumed.

11) Using IF() function, compute Gas charges which are Rs. 1.75/unit if the Units
consumed are less than 200, otherwise charges are Rs. 2.75/ units.
Ill) Compute the Sales Tax as 15% of Gas Charges.
IV) Compute the Amount due to
1. Amount Due= Gas Charges+ Sales Tax.
V) Save and also print.

Procedure

Switching on Computer
Switch on your computer. Wait till the ope,ration system "Windows" let you give [Link] to
interact with the computer.

Searching and Opening MS-Excel

With the help of mouse click "Start" Icon, generally present at bottom left side of the computer
screen-

Use Mouse click "Search Bar", type "Microsoft Office Excel" in it with 11:he help of computer
keyboard to search and open MS-•Excel.

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Creating File
Double click the MS-Excel icon to open MS-Excel, New File having name Bookl with spread
sh,eet having name sheetl will automatically be open.

Start typing the text from the left top p,osition (where cursor is present by default), but you can
select your ow·n cell address as well by clicking that specific cell location with mouse, in my
case first column, fifth row "AS"( alphabet 'A' represents column, digit '5' represe11ts row). Now
type-in the data/information already given in the object.

Calculating Unit Consumed

Unit Consumed= Current Units - Previous Units

D6= C6-B6

Computing Gas Charges

Gas Charge,s= Unit Consumed x 1.75 if Unit< 200, else

G,as Charges= Unit Consumed x 2.75
E6= if(D6<,200,D6*1.,75,D6*2.75)

Computing Sales Ta1x

Sales Tax= 15 / 100 x Gas Charges or 15% of Gas Charges

f 6= 15 / 100 * E6
Computing Amount Due

Amount Due = Gas Charges+ Sales Tax

G6 = E6 + F6
1

Saving the Document

11 11
In the end save the file by pressing Ctrll with u5"

Printing the Document

CamScanner
 XI PRACTICAL Word & Excel 2024-25
11 11 11
If you want to print the document press Ctrl with P''

Output
Meter Previous Current Units ,Gas Sales Amount
Number Units Units Tax Consumed Payable
,charges

SS-7290 69236 69452 216 594.00 89.10 683.10

SS-7291 7382 7399 17 29.75 4.46 34.21

5S-7292 33842 33998 156 273.00 40.95 313.95

SS-7293 45732 45795 63 110.25 16.54 126.79

5S-7294 82556 82715 159 278.25 41.74 319.99

SS-7295 5699 5754 55 96.25 14.44 110.69

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.28-(Pak Suzuki Motors)

Ob iect Create a spreadsheet according to the instructions:
L

Pak Motors (Ptv.)

Item Labour Capital Miscellaneous Gross Net Sale Profit

Cost Cost Cost Amount Amount Price

Motor Bike 500 10500 1000 1200 11640 15132 3492

Alto 2019 1200 140000 2000

Luxury Car 1500 450000 8000

High Roof 1600 150000 4000

I) Calculate Gross amount by adding labour, capital, Miscellaneous.

11) Calculate: Net Amount= Gross Amount -2% of Gross Amount.
111)
Calculate: Sale Prince= 30 % Net Amount+ Net Amount.
IV) Find out profit by subtracting Net Amount from sale Price.
V) Save and also print.

Procedure

Switching on Computer
Switch on your computer. Wait till the ope,ration system "Windows" let you give access to
interact with the computer.

Searching and Opening MS-Excel

With the help of mouse click "Start" Icon, generally present at bottom left side of
the,computer screen-

Use Mouse click "Search Bar", type "Microsoft Office Excel" in it with the help of computer
keyboard to search and open MS-,Excel.

Creating File

CamScanner
 XI PRACTICAL Word & Excel 2024-25
Double click the MS-Excel icon to open MS-Excel, New File having name Bookl with spread
sheet having name sheetl will automatically be open.

Start typing the text from the left top position (where cursor is present by default), but you can
select your own cell address as well by clicking that specific cell location with mouse, in my
case first column, fifth row ''AS"( alphabet 'A' represents column, digit '5' represernts row). Now
type-in the data/information already given in the object.

Calculating Gross Amount

Gross Amount= Labour cost+ Capital Cost+ Miscellaneous

E6 = B6 + CG + D6
Calculating Net Amount

Net Amount= Gross Amount - 2% of Gross Amount

F6 = E 6 - {2/100 * E6)
1

Calculating Sale Price

Sale !Price = 30% of Net Amount+ Net Amount

G6 = (30/100 * F6) + F6
Calculating Profit

Profit= Sale Price - Net Amount

HG= G6- F6
Saving the Document
In the end save the file by pressing "Ctrll" with "S"

Printing the Document

If yol..l want to,print the document press "Ctrl" with "P"

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Output

Pak Suzuki Motors (PTV.)

Item labour Capita Misce,Uaneous Gross Net Sale Price Profit
Cost l Cost Cost Amount Amount

Motor Bike 500 10500 1000, 12000 '11760.00 15288.00 3528.00

Alta 2019 1200 140000 2000, 143200 140336.00 182436.80 42100.80

Luxury Car 1500 450000 8000, 459500 450310.00 585403.00 135093.00

Hi-Roaf 1600 150000 4000 1 155600 152488..00 198234.40 45746.40

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.29-{StudentsJ Scholarship)

Obiect Use spreadslheet to create the following scholarship statement.
L

Roll Marks Total Full Scholarship Payable

Name
No. Obtained Marks Fee Amount Fee

CE100012 lmran 599 900 80000

CE100014 Noman 488 900 80000

CE100010 Junaid Ur Rehman 787 900 80000

Abdul Sa1mad
CE100035 667 900 80000
Shafiq

Muhammad
CE100030 782 900 80000
Shahzaib

CE100083 Saddam Husain 663 900 80000

I) Apply formula to calculate the Scholarship on the following range of marks.

a) No Scholarship for those students who obtained marks below 500.
b) 30% Scholarship of Full Fee will be awarded to those who obtained marks between 500
to 600.
c) 40% Scholarship of Full Fee will be awarded to thos,e who obtained marks between 600
to 700.
d) 60% Scholarship of Full Fee will be awarded to those whose secured marks above 700.
II) Count the number of students gained Scholarship using COUNT( ) function and display
in a cell below the above worksheet.
Save and also print.

Procedure

Switching on Computer
Switch on your computer. Wait till the ope,rat:ion system "Windows let you give access to
11

interact with the,computer.

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Searching and Opening MS-Excel

With the help of mouse click "Start" Icon, generally present at bottom left side of the
computer screen-

11
Use Mouse click "Search Bar , type "Microsoft Office Excel" in it with the help of computer
keyboard to search and open MS-•Excel.

Creating File
Double click the MS-Excel icon to open MS-Excel, New File having name Book1 with spread
sh,eet having name sheetl will automatically be open.

Start typing the text from the left top p,osition (where cursor is present by default), but you can
select your own cell address as well by clicking that specific cell location with mouse, in my
case first column, fifth row "AS"( alphabet 'A' represents column, digit '5' represernts row).
Now type-in the data/information already given in the object.

Calculating Scholarship Amount

Scholarship Amount = O if Marks Obtained < 500, else 30% of Full Fee if
Marks Obtained >=500 but Marks Obtained<600, else 4 0% of Full Fee if 1

Marks Obtained >=600 but Marks Obtained<700, else 6 0% of Full Fee if 1

Marks Obtained >=700

F6 =
IF(C6<500,0,IF(AND(C6>=500,C6<600),30%*E6,IF(AND
11
(C6>=600,C6<700),40%*E6,IF(C6>=700,60'%*E6, lnvali
d Result''))))
Drag and drop the cell "F6" from cell "F7'' to "Fll'' inthis way all the
formulas will be copied to rest of the students content

Calculating Payable Fee

Payable Fee = Full Fee - Scholarship Amount
G6 = E6- F6

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Saving the Document

In the end save the file by pressing "Ctrll" with "S"

Printing the Document

If yoll want to,print the document press "Ctrl" with "P,,

Output
Roll Marks Total Full Scholarship Payable
Name
No. Obtained Marks Amount Fee
Fee

CE100012 lmran 599 900 80000 24000 56000

CE100014 Noman 488 900 80000 0 80000

CE100010 Junaid Ur Rehman 787 900 80000 48000 32000

Abdul 32000 48000

CE100035 667 900 80000
Sa1mad
Shafiq
Muhammad 48000 3,2000
CE100030 782 900 80000
Shahzaib

CE100083 Saddam Husain 663 900 80000 32000 48000

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.30-{PTCL Bill)

Obiect L
Create and print a utility bill of PTCL by following the given instructions:

Where Due date is 25/6/2018 and Line rent is 174

User Pay date Local Total Total Mobile Total Tax Total
ID Call Local Mobile Call Dues
Charges Duration CLI Charges Charges

1101 28/6/2018 67 140.7 22 66.0 40 420..7 71.52 492.22

1102 20/5/2018 389 76 40

1103 02/7/2018 785 213 0

1104 09/7/2018 113 20 0

I) Calculate Total Local Charges @Rs. 2.10 per call

II} Calculate Total Mobile Charges @Rs. 3.0 per minute
111) Calculate Total Call Charges as:
Total Call charges = total Local Charges+ Mobile Charges+ Line rent+ CLI
IV) Calculate tax as 17%of Total Call Charges
V) Using IF() function, Compute total dues if pay date is within due date as:
Total Dues =Total Call Charges+ Tax, Otherwise id pay date is after Due date.
Total Dues= Total Call Charges+ Tax+ 5.01% of Surcharge

Procedure

Switching on Computer
Switch on your computer. Wait till the ope·ration system "Windows" let you give access to
interact with the computer.

Searching and Opening MS-Excel

With the help of mouse click "Start" Icon, generally present at bottom left side of the·computer
screen-
Use Mouse click "Search Bar", type "Microsoft Office Excel" in it with the help of computer
keyboard to search and open MS-Excel.

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Creating File
Double click the MS-Excel icon to open MS-Excel, New File having name Bookl with spread
sh,eet having name sheet1 will automatically be open.

Start typing the text from the left top position (where cursor is present by default), but you can
select your ow·n cell address as well by clicking that specific cell location with mouse, in my
case first column, fifth row "AS"( alphabet 'A' represents column, digit '5' represe11ts row). Now
type-in the data/information already given in the object.

Calculating Local Call Charges

Locail Call Cha1rge = Total Lo,cal Call * 2.10

D6 = CG * 2.:10
Calculating Mobile Charges

Mobile Charges = Total Mobile Call Duration(in minutes) * 3.0

F6 = E6 * 3.0
Calculating Sale Price
Total Call charges= total Local Charges+ Mobile Charges+ Line rent+ CLI

HG = D6+F6+16
Tax

Profit= Sale Price - Net Amount

HG= G6- F6
Total Dues

Profit= Sale Price - Net Amount

CamScanner
 XI PRACTICAL Word & Excel 2024-25

H6 = G6- F6

Saving the Document

In the end save the file by pressing "Ctrll" with "S"

Printing the Document

If you want to,print the document press "Ctrl" with "P"

Output

D� 25/6/2018
e
D,at
e
User Pay Lo Total Total Mobi Lin CLI Total Tax Total
ID Date cal Local Mob le e Rent Call Dues
Call Charges Duration Charge Charges
s

1101 28/6/2018 67 140.7 22 66.0 174 40 420.7 71.52 492.22

1102 27/6/2018 389 816.9 76 228.0 174 40 1,258.9 214.01 1535.98

1103 2/7/2018 785 1648.5 213 639.0 174 0 2,461.5 418.46 2879.96

1104 9/7/2018 113 237.3 20 60.0 174 0 471.3 80.12 551.42

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Practical No.31-(Extra-Marksheet for a

grade computing with missing marks)

Obiect
L
L!Jse Spreadsheet, create and print Marks Certificate according to the following
instructions.

Name Math Computer Physics English Udru Marks Percentage Grade

Science
Obtained
Ali Akber 98 67 89 79 421
Ashar Saeed Aalam 86 67 78 82 366
Muhammad Naeem 61 50 33 55 244
Muhammad Anees 52 46 52 68 285
Mustaq Ahmed 43 48 65 39 247
(I) Devellop a formula to find out physics marks of each student.
(11)1Calculate the Percentage of each student.
(Ill) Using IF1( ) function assign Grade according to the following criteria:
a) If Percentage is greater than or equal to 80, print "A+"
b) If Percentage is greater than or equal to 70, print "A"
c) If Percentage is greater than or equal to 60, print "B"
d) If Percentage is greater than or equal to SO, print "C" else "Fail"
IV) Save and also print..

Procedure
Switching on Computer
Switch on your computer. Wait till the operation system "Windows" let you give access to
interact with the·computer.

Searching and Opening MS-Excel

With the help of mouse click "Start" Icon, generally present at bottom left side of the·computer
screen-

Use Mouse click "Search Bar", type "Microsoft Office Excel" in it with the help of comput,er
keyboard to search and open MS-Excel.

Creating File
Double click the MS-Excel icon to open MS-Excel, New File having name Book1 with spread
sh,eet having name sheet:1 will automatically be open.

CamScanner
 XI PRACTICAL Word & Excel 2024-25

Start typing the text from the left top p,osition (where cursor is present by default), but you can
select your own cell address as well by clicking that specific cell location with mouse, in my
case first column, fifth row "AS"( alphabet 'A' represents column, digit '5' represe11ts row). Now
type-in the data/information already given in the object.

Computing Physics Marks

Physics Marks= Total Marks Obtained - Sum of oth,er subjects (Maths,

Comp,Eng, Urdu )

D6 = G6 - Sum{B6,C6,E6,F6)

Computing Percentage

Percentage= Total Marks Obtained * 100 / 500 (given in Object)

H6 = G6 * 1 00 / 500 1

Computing Grade

Gra,de = ''A+'' if marks>= 80%, else Grade= ''A''' if marks>=70%, else

Gra,de = ''B'' if marks>=60%, else Grade= ''C'' if marks>=50%, else
Gra,de= ''FaiI''

16 = if( H6>=80 , ''A+'', if( H6>=70 , ''A'', if( H6>=60,

''B'', if{H6>=50, ''C'',''Fail''))))

Saving the Document

In the end save the file by pressing "Ctrl" with "S"

Printing the Document

If you want to print the document press "Ctrl" with "P"

CamScanner
 X XI PRACTICAL Word & Exc�l 2024-25

Output
Name IMath Computer Physics English Udru Marks Percentage Grade
Science Obtained
Ali Akber 98 67 88 89 79 421 84.2 A+

Ashar Saeed Aalam 86 67 53 78 82 366 73.2 A

Muhammad Naeem 61 50 45 33 55 244 48.8 Fail

Muhammad Anees 52 46 67 52 68 285 57 C

Mustaq Ahmed 43 48 52 65 39 247 49.4 Fail

CamScanner