1 Roll no 40

OBJECT (a) MICROSOFT

WORD
1. Type the given phrase.
 Area of circle = 2m2
 Sin2θ+Cos2θ=1
 Arithmetic mean =∑ x/m
 Formula of water = H2o
2. Give a suitable border to the phrase and paste it three
times with different font size and style.
3. Give a suitable header and footer and then print it.

PROCEDURE
1. Double tap on MS WORD.
2. Click on new document.
3. Type the given phrase 3 times differently.
4. Now apply suitable borders and apply header and
footers.
5. Click on save.
6. Now print the file.


ADAMJE GOVT SCIENCE

COLLEGE
2 Roll no 40

RESULT
 Area of circle = 2m2
 Sin2θ+Cos2θ=1
 Arithmetic mean =∑ x/m
 Formula of water = H2o

 Area of circle = 2m2

 Sin2θ+Cos2θ=1
 Arithmetic mean =∑ x/m
 Formula of water = H2o

 Area of circle = 2m2

 Sin2θ+Cos2θ=1
 Arithmetic mean =∑ x/m
 Formula of water = H2o

ADAMJE GOVT SCIENCE

COLLEGE
3 Roll no 40

OBJECT 8b MICROSOFT
EXCEL
Create and print a salary sheet of employee of XYZ super
store.

INSTRUCTIONS
 Calculate overtime = Total hours work – (Days worked * 8)
 Using IF ( ) function ,calculate overtime charges as:
Overtime charges = overtime* 100, if worker type is A,
over time *50 , if worker type is B, overtime *40 , if
worker type is C otherwise overtime *30.
 Using if () function, calculate basic pay as:
Basic pay =days worked * 400 for worker type “A”, days
worked *300 for worker type “B”, days worked* 200 for
worker type “C” and for other days worked*100
 Using sum ( ) function calculate = net pay = basic par + over
time charges.

TABLE
Worker Emp# Day Total Overtime Overtime Basic Net pay
Type Worked Hour Charges pay
Worked
A 1001 20 190
B 1002 19 200
C 1003 18 240
D 1004 30 220
E 1005 24 210

ADAMJE GOVT SCIENCE

COLLEGE
4 Roll no 40

PROCEDURE
1. Double tap on MS EXCEL.
2. Click on new work sheet.
3. Make the require formula table.
4. Insert the values.
5. Now apply formulas on the cells.
6. Calculate the data.
7. Click on save.
8. Now print the file.

FORMULA
1. =D2-(C2*8)
2. =IF(A4="A",F4*100,IF(A4="B",F4*50,IF(A4="c",F4*40,F4
*30)))
3. =IF(A4="A",D4*400,IF(A4="B",D4*300,IF(A4="C",D4*200
,D4*100)))
4. =SUM(G4+H4)

ADAMJE GOVT SCIENCE

COLLEGE
5 Roll no 40

ADAMJE GOVT SCIENCE

COLLEGE
6 Roll no 40

OBJECT 2(a) MICROSOFT

WORD
Write a letter to your friend telling him about the
atmosphere of your college. Insert a graphics from the shape
category, from clip art gallery, at the top of the page.

PROCEDURE
1. Double tap on MS WORD.
2. Open a new document.
3. Insert clip art on the top of the page.
4. Type letter on the page.
5. Click on save.
6. Print the document.

ADAMJE GOVT SCIENCE

COLLEGE
7 Roll no 40

OUTPUT
ABC,
KARACHI,
DATE:26,11,23.

Dear friend,
I received your letter last week and was really happy for
your admission in the XYZ college. As you know We also have
got the admission in our respective colleges so that’s why I
am writing this letter to you to describe the academic
atmosphere of my college.
The very first I have got admission in adamjee science
college and when we talk about its atmosphere so believe me
my friend it’s amazing and I blessed to have admission in it
we get to receive all classes in a really good way and the
most virtuous is our library Where I recently finished the
novel and not only this our college also provide the sports
faculties our college is best there now I will wait for your
response.
Your truly,
XYZ.

ADAMJE GOVT SCIENCE

COLLEGE
8 Roll no 40

ADAMJE GOVT SCIENCE

COLLEGE
9 Roll no 40

ADAMJE GOVT SCIENCE

COLLEGE
10 Roll no 40

ADAMJE GOVT SCIENCE

COLLEGE
11 Roll no 40

ADAMJE GOVT SCIENCE

COLLEGE
12 Roll no 40

ADAMJE GOVT SCIENCE

COLLEGE
13 Roll no 40

ADAMJE GOVT SCIENCE

COLLEGE
14 Roll no 40

ADAMJE GOVT SCIENCE

COLLEGE
15 Roll no 40

ADAMJE GOVT SCIENCE

COLLEGE
16 Roll no 40

ADAMJE GOVT SCIENCE

COLLEGE
17 Roll no 40

ADAMJE GOVT SCIENCE

COLLEGE
18 Roll no 40

OBJECT 6(a) MICROSOFT

WORD
Create a document using header and footer with following
steps:
a) Automatically insert date /time at top left of page(header)
b) Automatically insert page number in footer.
c) Convert the source document into two column
d) Use the drop cap.
e) Insert a picture from clip art.
f) Save and print.
PROCEDURE
 Create a word document
 Insert header and footer as instructions.
 Insert clip art.
 Break the page into two column.
 Save and print the document.

ADAMJE GOVT SCIENCE

COLLEGE
19 Roll no 40

OBJECT 8b MICROSOFT
EXCEL
Create and print payrole of employee according to the
following instructions.
INSTRUCTIONS
I. Calculate medical allowance = *% of basic pay and
house rent= 40 % of basic pay.
II. Calculate gross pay = basic pay +medical allowance +
house rent.
III. Using if ( )function calculate, tax which is 4 % , if gross
pay is greater than 1500, other wise 3%.
IV. Calculate net pay by subtracting tax from gross pay.
V. Using if ( ) function, assign “grade1”, if net pay is
greater than 15000,other wise “grade 2”.
FORMULA
1. =8/100*b2
2. =40/100*b2
3. =b2+c2+d2
4. =if(e2>=15000,e2*4/100,e2*3/100)
5. =e2-f2
6. =if(g2>=15000,”grade-1”,”grade-2”)

ADAMJE GOVT SCIENCE

COLLEGE
20 Roll no 40

OBJECT 7(a) MICROSOFT

WORD
Write a letter to your father requesting Him to send you
rupees 9000 for hostel expenditure insert a table containing
hotel charges, charges, washing clothes, bus fare and daily
expenditure.
PROCEDURE
1. Open Microsoft word.
2. Create a text file.
3. Write a letter to your father.
4. Insert the expenditure table.
5. Insert expenses.
6. Save file and print.

ADAMJE GOVT SCIENCE

COLLEGE
21 Roll no 40

OUTPUT
Sector 14
Orange town
Karachi
16th feb 2024
My dear father,
Assalam o alikum, I hope this letter finds you well. I
wanted to provide you with an update regarding the recent
hotel expenses. I understand the importance of transparency
and want to ensure that you are informed about how the funds
were utilized during my stay.
I have attached the detailed invoice and receipts for your
reference. The breakdown includes the nightly rate, taxes, and
any incidentals incurred during my stay. Rest assured that I
made an effort to minimize any unnecessary expenses and
adhered to a prudent spending approach.
hostel mess Washing Bus fair Daily
charges charges cloths expenditur
e.
2100 3400 1000 1500 1000
If you have any questions or concerns about the
expenses, please feel free to reach out. I am more than willing
to discuss any aspect of the trip and provide additional
information as needed.
Thank you for your understanding and support. I look
forward to hearing from you soon.
Your loving son
Xyz.

ADAMJE GOVT SCIENCE

COLLEGE
22 Roll no 40

ADAMJE GOVT SCIENCE

COLLEGE
23 Roll no 40

OBJECT 8b MICROSOFT
EXCEL
Create an print a spread sheet according to the given
instructions.
INSTRUCTIONS:
1. Calculate gross amount = labour cost + capital cost +
miscellaneous cost.
2. Calculate the net amount = gross amount – 2% of gross
amount.
3. Sale price = 30% of net amount + net amount.
4. Calculate profit = sale price – net amount.
TABLE:
ITEM LABOU CAPITA MISCCELLANEO GROS NET SALE PROFIT
R COST L COST US COST S AMOUN PRIC
COST T E
Motor 5100 95000 5000
bike
Car 15000 200000 20000
Cultus 20000 300000 30000
Wago 22000 350000 28000
nR
High 19000 290000 18000
roof
PROCEDURE:
1. Double click on ms excel.
2. Choose a new document.
3. Now create a spread sheet.
4. Fill the blank columns using formulas.
5. Save the file and print it.
FORMULAS:

ADAMJE GOVT SCIENCE

COLLEGE
24 Roll no 40

1. gross amount = labour cost + capital cost +

miscellaneous cost.
2. net amount = gross amount – 2% of gross amount.
3. Sale price = 30% of net amount + net amount.
4. Calculate profit = sale price – net amount.

OBJECT 8(a) MICROSOFT

WORD
Write an application to your principal asking him for leaving
certificate change the typeface of the entire document to 14
points, “Time new Roman” change the page background
using fill effect with picture save and print it.
PROCEDURE
1. Open Microsoft word.
2. Create a text file.
3. Write an application to your principal.
4. Change font to Time new roman.
5. Change the font to 14
6. Insert a background using fill effect.
7. Save file and print.

ADAMJE GOVT SCIENCE

COLLEGE
25 Roll no 40

OBJECT 8b MICROSOFT
EXCEL
Create a marksheet slash certificate of internal exam by
following instruction.
INSTRUCTIONS
1. Use sum ( ) function to find out the total marks of each
student.
2. Calculate the percentage of each student.
3. Using if ( ) function assign the grade according to the
falling criteria.
a. If percentage is greater than is equal to 70, print “A-
grade”.
b. If percentage is greater than is equal to 60, print “B-
grade”.
c. If percentage is greater than is equal to 50, print “C-
grade”.
TABLE
Nam Compu Physi Engli Urd Tota Percenta Grad
e ter Mat cs sh u l ge e
Science h
Asad 89 78 97 93 87
Imra 65 97 77 77 98
n
Farha 79 78 98 33 68
n
Yosu 97 67 69 74 98
f
Izhan 99 79 63 82 58

ADAMJE GOVT SCIENCE

COLLEGE
26 Roll no 40

PROCEDURE:
1. Double click on ms excel.
2. Choose a new document.
3. Now create a spread sheet.
4. Fill the blank columns using formulas.
5. Save the file and print it.
FORMULA
1. =SUM(B3:F3)
2. =G3*100/500
3. =IF(H3>=70,"A-Grade",IF(H3>=60,"B-Grade","C-
Grade"))

ADAMJE GOVT SCIENCE

COLLEGE
27 Roll no 40

OBJECT 9(A) MS WORD:

Write a letter to your uncle thanking him for your birthday gift and apply a
page border to your document and give date at the top centre of the
page along with the time at the bottom centre of your page and use
double spacing line left for your document and use the font TAHOMA
11.

PROCEDURE:
 Double click on ms word.
 Now choose a new document.
 Write a letter.
 Apply date in header at top center.
 Apply time in footer center.
 Use font TAHOMA 11.
 Give a border to your document.
 Use double line spacing.
 Save the file and print it.

ADAMJE GOVT SCIENCE

COLLEGE
28 Roll no 40

OUTPUT:
ABC road,

Karachi.

Date: 3/4/204

Dear uncle,

I am fine here by the grace of Allah and hope same for you . Uncle I received your last
letter along with the birthday gift that you send to me.

I was really glad when I opened it , you know I had saved money to buy those football
shoes and you gifted me the same one . I really want to thank you for that , I cant define
my happiness level for these shoes .

Now I want to give you a surprise too as you gave me , Uncle we are coming to Dubai this
week end along with grandma. Dad just informed me this the day before and I was like
wooww! So uncle be ready we will leave on 5/3/2024 and will reach to you around
6/3/2024.

Now give me permission to leave and pay my regards to aunt and ali and thank you so
much again for that gorgeous gift.

Allah Hafiz!

Yours truly,

xyz

ADAMJE GOVT SCIENCE

COLLEGE
29 Roll no 40

OBJECT 9(b) MS EXCEL

Create and print a spread sheet with the following data
instructions:
INSTRUCTIONS:
 Use sum() function , calculate departmantive total.
 Use sum() function , calculate grand total.
 Find minimum , maximum , & average expenditure for
each quarter using statistical function , average() , min() ,
max().
TABLE:
PAKISTAN ENGINEERING BOARD (EXP : 2024)
DEPARTMENT 1ST QTR 2ND QTR 3RD QTR 4TH QTR TOTAL
Engineering 25676 45451 61660 55335
Marketing 67567 43434 66554 54545
Sales 64219 56564 21222 32121
Purchase 35651 21312 23122 88323
Production 12323 15432 77622 76543
Grand total
Minimum
Maximum
Avearge

PROCEDURE:
 Double click on ms excel.
 Choose new document.
 Create spread sheet using given ins and formulas.
 Save the file and print it.
FORMULAS:
 Sum() to calculate total.
 Sum() to calculate grand total.
 Min(B2 : B6).
ADAMJE GOVT SCIENCE
COLLEGE
30 Roll no 40

 Max(B2 : B6).
 Average(B2 : B6).

OBJECT 10(A) MS WORD

Using word processor create a vertically dotted line
representing left and right margin on paper for different
paragraphs.

PROCEDURE:
 Double click on ms word.
 Choose new document.
 Create the document from given ins.
 Save the file and print it.

ADAMJE GOVT SCIENCE

COLLEGE
31 Roll no 40

OBJECT 10(b) MS EXCEL

Create and print utility bill of SUI gas with the following data
instructions:
INSTRUCTIONS:
Calculate the nits consumed.
Using if() , calculate the gas charges as 10.5/unit if the units
consumed are less than 200 , otherwise 15.50/unit.
Calculate sales tax on 10% of gas charges.
Calculate amount payable = gas charges + sales tax
TABLE:
SUI GAS UTILITY BILL EXP(2024)
METER PREVIOU CURRENT UNITS GAS SALE AMOUNT
UNIT S UNIT UNITS CONSUMED CHARGES TAX PAYABLE
3001 7382 7393
3002 88829 88840
3003 454512 454902
3004 13900 1400
3005 93248 92583

PROCEDURE:
Double click on ms excel.
Choose new document.
Create utility bill of suii gas using given ins and formulas.
Save the file and print it.
FORMULAS:
C2-B2.
IF(D2<200 , D2*10.5 , D2*15.5).
10/100*E2.
E2+F2.

ADAMJE GOVT SCIENCE

COLLEGE
32 Roll no 40

OBJECT 11(a) MS WORD

Write an invitation to a friend invited her to your birthday
Party. Give page border to your invitation inside graphic from
event category set page orientation at landscape.
PROCEDURE
 Double click on ms word.
 Choose new document.
 Create the document from given instruction.
 Set page orientation to land scape.
 Save the file and print it.

ADAMJE GOVT SCIENCE

COLLEGE
33 Roll no 40

OBJECT 11(b) MS EXCEL

Create, save and print marksheet of internal exams using
given instructions.
INSTRUCTIONS
1. Calculate percentage of each student .
2. Using if ( ) function assign remarks according to the
following criteria.
a. If percentage is greater than equal to 80, print
“EXCELENCE”
b. If percentage is greater than equal to 70, print “V
GOOD”
c. If percentage is greater than equal to 60, print
“GOOD”
d. If percentage is greater than equal to 50, print
“FAIR else POOR”
TABLE
MARKSHEET
NAME COMP PHYS ENGL MA UR TOT PERSEN REMA
UTER ICS ISH TH DU AL TAGE RKS
ASAD 89 78 78 89 76
ALI 90 98 86 99 84
AHME 47 87 34 76 55
D
AMMA 78 92 47 89 65
R
SHAHM 67 87 86 88 85
EER

ADAMJE GOVT SCIENCE

COLLEGE
34 Roll no 40

OBJECT 12(a) MS WORD

Draw a 3D box in your document, write “computer science”
in it using word art.
PROCEDURE
 Double click on MS WORD.
 Choose new document.
 Create the document from given instruction.
 Insert 3d box and write computer science.
 Save the file and print it.

ADAMJE GOVT SCIENCE

COLLEGE
35 Roll no 40

Comput
er
The Evolution and Impact of Computer Science
Science
Computer science, a discipline that has revolutionized the
modern world, encompasses a vast array of theories,
algorithms, and technologies. From its humble beginnings as a
niche field in mathematics and engineering, computer science
has grown into a pervasive force shaping every aspect of
human life. This essay delves into the evolution and impact of
computer science, tracing its journey from theoretical
concepts to practical applications that permeate our daily
existence.

Foundations of Computer Science:

The foundations of computer science can be traced back to the
mid-20th century with the advent of electronic computers.
Pioneers such as Alan Turing, Claude Shannon, and John von
Neumann laid the groundwork for the theoretical
underpinnings of computing. Turing's concept of the Turing
machine, Shannon's work on digital circuits and information
theory, and von Neumann's architecture for stored-program
computers provided the theoretical foundation upon which
modern computers are built.

ADAMJE GOVT SCIENCE

COLLEGE
36 Roll no 40

ADAMJE GOVT SCIENCE

COLLEGE
37 Roll no 40

OBJECT 12(b) MS EXCEL

Create, save and print a spreadsheet with the following data
and instructions.
INSTRUCTIONS
1. Use sum( ) to find out the total expenditure of province
in year.
2. Select the rows enclosed in rounded rectangle to create a
line chart showing the trend in the expenditure over the
year using chart wizard. Title the chart “Total
expenditure”.
TABLE
Expenditure of different province (2024).
Province 1st qtr 2nd qtr 3rd qtr 4th qtr Total
s
Sindh 442.5 521 453.4 396.1
Punjab 867 735.8 630.1 776
Baluchist 235.83 361.8 301 307.3
an
KPK 399.5 405 363 286.4

ADAMJE GOVT SCIENCE

COLLEGE
38 Roll no 40

OBJECT 13(a) MS WORD

Write an application to principal requesting him to sanction
rupees 3000 For the purchase of sports item inside a table
containing serial number, items, quantity and price.
PROCEDURE
 Double click on MS WORD.
 Choose new document.
 Create the document from given instruction.
 Insert table infill with the given instructions
 Save the file and print it.

ADAMJE GOVT SCIENCE

COLLEGE
39 Roll no 40

OUTPUT
To,
The principal,
AGSC,
Karachi.

Subject: Request for Financial Assistance for Purchase of

Sports Items

Dear principal,
I hope this letter finds you in good health and high
spirits. As a dedicated member of the community, I am
writing to request financial assistance for the purchase of
sports items essential for the enhancement of our school's
athletic program.

As you are aware, physical education and extracurricular

sports activities play a crucial role in the holistic development
of students. They promote teamwork, discipline, and a healthy
lifestyle among our students.i am inserting the table according
to need.
S.NO Item Quantity Price
1 Badminton 2 pair 1200
2 NET 1 200
3 NET stand 1 pair 600
4 Shuttle cork 12 pices 1000
Thank you for your attention to this matter. I eagerly await
your positive response.

ADAMJE GOVT SCIENCE

COLLEGE
40 Roll no 40

You’re sincerely.
XYZ
DATE: 29 February 2024 Class XI

OBJECT 13(b) MS EXCEL

Create save and print a spreadsheet with the following data
and instructions.
INSTRUCTIONS
1. Use sum( ) to find out the total expenditure of province
in year.
2. Select the rows enclosed in rounded rectangle to create
Pie chart showing the trend in the expenditure over the
year using chart wizard. Title the chart “Total
expenditure”.
TABLE
Expenditure of different province (2024).
Province 1st qtr 2nd qtr 3rd qtr 4th qtr Total
s
Sindh 442.5 521 453.4 396.1
Punjab 867 735.8 630.1 776
Baluchist 235.83 361.8 301 307.3
an
KPK 399.5 405 363 286.4

ADAMJE GOVT SCIENCE

COLLEGE
41 Roll no 40

OBJECT 14(a) MS WORD

Write an application to your principal requesting him to grant
you leave for seven days you single spacing and left
alignment Change the typeface of the entire document to 12
point Arial save and print your documents
PROCEDURE
 Double click on MS WORD.
 Choose new document.
 Create the document from given instruction.
 Change the typeface of the entire document to 12 points,
Ariel.
 Save the file and print it.

ADAMJE GOVT SCIENCE

COLLEGE
42 Roll no 40

OUTPUT
To,
The principal
AGBC
KARACHI
Subject: Request for Seven Days Leave

Dear Principal

I hope this letter finds you in good health and spirits. I am writing to request a leave
of absence from school for seven days. Because I have some word due to my big
brothers weeding

During my absence, I will ensure that I catch up on any missed assignments or

coursework to minimize any disruption to my academic progress. I will also
coordinate with my teachers to obtain any necessary materials and ensure a smooth
transition upon my return.

I understand the importance of consistent attendance and academic engagement,

and I assure you that I will prioritize my studies upon my return to school. I am
committed to maintaining high academic standards and contributing positively to the
school community.

Thank you for considering my request. I kindly request your approval for the
aforementioned leave of absence. If you require any further information or
documentation, please do not hesitate to contact me.

Yours sincerely,
XYZ
Class XI

ADAMJE GOVT SCIENCE

COLLEGE
43 Roll no 40

OBJECT 14(b) MS EXCEL

Create and print a utility bill of electricity.
INSTRUCTIONS
1. Enter a formula to calculate units consumed.
2. Cost of one unit of electricity is 2.06.
3. Compute Surcharge as 15% of electricity Charges.
4. Calculate the Amount Payable as: Amount Payable =
Electricity Charges + Surcharge.
5. Round up the amount payable to one decimal place using
round () function.
TABLE
Meter Previou Current Unit Electric Surchar Amount
Number s unit unit consum ity ge tax payable
ed charges
MN- 69236 7000
1101
MN- 14011 14638
1102
MN- 76321 76428
1103
MN- 38476 38890
1104
MN- 4853 4996
1105

ADAMJE GOVT SCIENCE

COLLEGE
44 Roll no 40

OBJECT 15(a) MS WORD

Create a simple dot TXT file using WordPad type some text
then copy one time and past five times also apply text
formatting including font name font style and font size to each
line save and also print.
PROCEDURE
 Double click on MS WORD.
 Choose new document.
 Create the document from given instruction.
 Type any text then copy one time and paste 5 times.
 Save the file and print it.

ADAMJE GOVT SCIENCE

COLLEGE
45 Roll no 40

OUTPUT
Computer science, a discipline that has revolutionized the modern world, encompasses a vast array of theories,
algorithms, and technologies. From its humble beginnings as a niche field in mathematics and engineering,
computer science has grown into a pervasive force shaping every aspect of human life. This essay delves into
the evolution and impact of computer science, tracing its journey from theoretical concepts to practical
applications that permeate our daily existence.

Computer science, a discipline that has revolutionized the modern world,

encompasses a vast array of theories, algorithms, and technologies. From its
humble beginnings as a niche field in mathematics and engineering, computer
science has grown into a pervasive force shaping every aspect of human life. This
essay delves into the evolution and impact of computer science, tracing its journey
from theoretical concepts to practical applications that permeate our daily
existence.Line 1: Arial, Regular, 12pt

Computer science, a discipline that has revolutionized the modern world, encompasses a vast array of theories, algorithms, and technologies. From its humble
beginnings as a niche field in mathematics and engineering, computer science has grown into a pervasive force shaping every aspect of human life. This essay
delves into the evolution and impact of computer science, tracing its journey from theoretical concepts to practical applications that permeate our daily
existence.Line 2: Times New Roman, Italic, 7pt

Computer science, a discipline that has revolutionized the modern world, encompasses a vast array
of theories, algorithms, and technologies. From its humble beginnings as a niche field in
mathematics and engineering, computer science has grown into a pervasive force shaping every
aspect of human life. This essay delves into the evolution and impact of computer science, tracing its
journey from theoretical concepts to practical applications that permeate our daily existence .Line 3:
Calibri, Bold, 11pt

Computer science, a discipline that has revolutionized the modern world, encompasses a vast array of theories,
algorithms, and technologies. From its humble beginnings as a niche field in mathematics and engineering,
computer science has grown ino a pervasive force shaping every aspect of human life. This essay delves into
the evolution and impact of computer science, tracing its journey from theoretical concepts to practical
applications that permeate our daily existence.Line 4: Verdana, Underline, 8pt

Computer science, a discipline that has revolutionized the modern world, encompasses a vast array of theories, algorithms,
and technologies. From its humble beginnings as a niche field in mathematics and engineering, computer science has grown
into a pervasive force shaping every aspect of human life. This essay delves into the evolution and impact of computer
science, tracing its journey from theoretical concepts to practical applications that permeate our daily existence.Line 5:
Courier New, Regular, 9pt

ADAMJE GOVT SCIENCE

COLLEGE
46 Roll no 40

OBJECT 15(b) MS EXCEL

Create save and print a spreadsheet with the following data
and instructions.
INSTRUCTIONS
1. Use sum( ) to find out the total expenditure of province
in year.
2. Select the rows enclosed in rounded rectangle to create
bar showing the trend in the expenditure over the year
using chart wizard. Title the chart “Total expenditure”.
TABLE
Expenditure of different province (2024).
Province 1st qtr 2nd qtr 3rd qtr 4th qtr Total
s
Sindh 442.5 521 453.4 396.1
Punjab 867 735.8 630.1 776
Baluchist 235.83 361.8 301 307.3
an
KPK 399.5 405 363 286.4

ADAMJE GOVT SCIENCE

COLLEGE