ST.

ANDREWSINSTITUTE
OFTECHNOLOGY&MANAGEMENT

GurgaonDelhi(NCR).
ApprovedbyAICTE,[Link],NewDelhi Affiliated
to Maharshi Dayanand University
‘A’GradeStateUniversity,accreditedbyNAAC Session:
2023-2025

MasterofBusinessAdministration A
Practical File
ComputerFundamentals
19IMG21C6

SubmittedTo: Submitted by:

[Link] Manikant Kumar
(Assistant Professor) MBA1stSemester
Roll No.: 23M1063
[Link]&M
ANAGEMENT

ListofPractical

[Link]. Name Sign

Createaresumeusing MS-Office Word.

01

02 CreateaMailMerge Letter.

03 Createadataflow diagraminformation systemlayout usingMS word

CreateaMacroforinserting apictureandFormattingthe text.
04

Createaworksheetwith4columns.Enter10recordsandfindthesumof all
05
columns in MS office excel.

CreateaReportcontainingthepaydetailsoftheEmployeeusingMS- Office
06 Excel.

CreateaStudentresultsheetusingMS-OfficeExcel.
07

CreateaSimpleBarchartto highlightthesalesofacompany.
08

09 CreateaPieChart forasampledataandgive legends.

10 CreateasimplepresentationusingPowerPoint presentation.
 Practical-1
CreateaResumeusingMS-Word.
Procedure:
1. Clickonstart button –MS-Word–File– New–Resumes andCover Letters.
2. Choosebest alternativetemplates.
3. Clickon templates -Create.
4. Filltherequiredinformation-MakeHeadingCareerObjectives,EducationalProfile,
Skills, Personal Details, Date, Place and Signature.
4
 Practical-2
CreateaMailMergeLetter.
Procedure:
1. Clickon startbutton–MSWord–File– New–Blank document.
2. Typeyourletterwhichyou wantto send to themultiple addresses.
3. OpenMSExcel,Clickonstartbutton–MSExcel–File–New–Blankworkbook,create the list of
the name of the members (First name, last name, address, mob. no., email id) and save it to
the desktop.
4. In MS-Word, go to Mailings – Start Mail Merge – Step by step mail merge wizard… -
MailMerge–clicknext:StartingDocument-Next:SelectRecipients–next:writeyourletter – select
date source – desktop – select file – open – click ok – again click ok.
5. TheninMailMergetoolbarclickInsertMergefieldswherever
Needed (First name, last name, address, mob. no., email id)
6. IfyouwanttochangethefieldnamesthenclickCustomize-SelecttheField–Rename– Click ok.
7. ThenfinallyinthemailMergetoolbar clickmergeto New
Document–All –Ok– Savethe file (next:preview yourletters–next: Completethemerge).
 OUTPUT

OUTPUT
To,
AryanGupta
Delhi
XXXXXX
aryan@[Link]
arAryanGupta,
ThisisABC,[Link] and
securely.
Thankyou.
To,
RajuKumar
Bihar
XXXXXX
raju@[Link]
rRajuKumar,
ThisisABC,[Link] Holiwithyourfriendsandfamilysafely and
securely.
Thankyou.

To,
AkashSingh
Varanasi
XXXXXX
akash@[Link]
earAkashSingh,
ThisisABC,[Link] and
securely.
Thankyou.
 Practical-3
CREATINGDED-DATAFLOWDIAGRAMINFORMATIONSYSTEMLAYOUT USING
MS WORD.
FOLLOWINGTHESESTEPS:-
1. OpenMsWord
2. Gotoinsert-wordart-selectthedesignandtypethetext“COCO COLA PPRODUCTION
DITRIBUTIONROADMAP”
3. Gotoinsert-pictures-selectthepicture.
4. Gotoinsert-smartart-selectthediagram-writetherequiredtextin it.
5. Gotoinsert-shapes-selectthetextboxanddrawitinthepage.
6. Tochangestheoutlineoftheshapes,selecttheshape,thenclickonformat,clickonshape outline
and select the colour.
7. Tosavethedocument,pressctrl+Sthedocumentwhereyouwanttosave
Kissan Jam DataFlowDiagram
 Practical-4
CreateaMacroforinsertingapictureandformattingthetext.
Procedure:
1. OpenMSOffice-MS Word–File–New.
2. GotoTool –Macro-Record newMacro-Givethemacro name.
3. Goto insert– Picture-fromFile-browsefor therequired picture-clickInsert.
4. Typesometext–SelectitbyholdingshiftKeyandright/leftarrowKeys -changethefont size,
color and style by the standard tool bar.
5. Goto Tool-Macro-click Stop recording.
6. OpenanewFilegoto –Tool–Macro-SelectthemacronamewhichuhaveCreated- click
Run.
 OUTPUT

SEVEN SISTER
 Practical-5
Createaworksheetwith4columns.Enter10recordsandfindthesum of all
columns in MS Office Excel.
Procedure:
1. OpenMSOffice-MSExcel –File–New.
2. Select4columnand3rowsatthecentreofthebeginning -rightclick-Formatcells-click select the
alignment tab - tick Merge cells option – ok - Type the Heading.
3. Enterthe4columnsHeadingand10rowheadingbyclickingthecursorontothe
particular cell.
4. Enterthe dataforthe 4columns.
5. Selectthefirstcolumnwholedata,excepttheheadingandclick∑(autosum)inthe standard
tool bar - this will add the column’s data and places the result at the end.
6. Repeatthesameforremaining 3 columns.
OUTPUT
 Practical-6
CreateaReportcontainingthepaydetailsoftheEmployeeusingMS- Office
Excel.
Procedure:
1. Clickonstart button –MS-Excel –File– New- Blank workbook.
2. Selectfewcolumnsandfewrowsatthecentreofthebeginning –Home–Merge&centre – Type
the Heading.
3. Enter the column Headings. Enter the data of following columns
Manually [Link]. Name, Employee Id, Basic, DA, HRA, CCA (100 for
Alltheemployee),Gross,GPF,KGID,TotalDeductionandnetSalary.
4. Enterthefollowingformulatocalculatetherespectivevalues: DA
(60% of BASIC) = E7*0.6
HRA (7.5% of BASIC) =
E7*0.075Gross=SUM(E7:H7)orD6+E6+
F6+G6 GPF (7% of BASIC) = E7*0.07
KGID(8%ofBASIC)=E7*0.08
TotalDeduction=SUM(J7:K7)orJ7+K7 Net
Salary = I7-L7

5. AfterWritingeachformulaselectthecell anddragtotheentirecolumnto apply.

OUTPUT
 Practical-7
CreateaStudentresultsheetusingMS-OfficeExcel. Procedure:
1. Clickonstart button –MS-Excel –File– New–Blank workbook.
2. Selectfewcolumnsandfewrowsatthecentreofthebeginning– Home
– Merge & centre – type the heading.
3. Enter the column Headings. Enter the data of following columns
[Link],[Link].,Name,BO,BM,BC,FA,CF,MEBD,Total,
%age,Result.
4. Enterthefollowingformulatocalculatetherespectivevalues.
Total = SUM (D7:I7)
Percentage=J7/6
Result=IF(AND(D7>=35,E7>=35,F7>=35,G7>=35,H7>=35,I7>=35), ”PASS”,”FAIL”)
5. AfterWritingeachformulaselectthecellanddragtotheentire
Column to apply.
OUTPUT
 Practical-8
CreateaSimpleBarcharttohighlightthesalesofacompany.
Procedure:
1. Clickonstart button –MS-Excel –File– New–Blank workbook.
2. Selectfewcolumnandfewrowsatthecentreofthebeginning –Home– Merge&centre– type the
heading.
3. [Link](Period,
Product1, Product2, Product3, and Product4).
4. Selectthecompleterowandcolumndataincludingtheheader.
5. GotoInsert–Chart– Barschart–SelecttheCharttype–Selectthe Type –
Next – under Title give the Heading at Chart title – Finish.
OUTPUT
 Practical-9
CreateaPieChartforasampledataandgivelegends. Procedure:
1. Clickonstartbutton –MS-Excel–File–New–Blankwork book.
2. Selectfewcolumnandfewrowsatthecentreofthebeginning–Home– Merge&centre– type the
heading.
3. Enterthe columnHeading. Enterthedata ineach Column(S. No.,Expenses and Amount).
4. Selectthecompleterowandcolumndataincludingtheheader.
5. GotoInsert–Chart– Pie–SelecttheChartType–Next–undertitlegivetheHeadingat Chart title
– Finish.
OUTPUT
 Practical-
10CreateasimplepresentationusingPowerPoint.
Procedure:
1. Clickon startbutton –MS-PowerPoint– File–New–Blankpresentation.
2. ClicktheOtherTaskPanesdropdownmenu–tickSlideLayout–SelecttheLayoutyou want.
3. ClicktheOtherTaskPanesdropdownmenu–tickSlideDesign– Select
the Design of your choice.
4. Clickon theslidetotypethetext–align thetext usingstandard tool bar.
5. Inorder toinsert new slide– goto insert– NewSlide –Typeyourtext.
6. Eachslidemayhavethedifferentslidelayoutsdependingonthe
Content.
7. Aftercreatingalltheslides–ByholdingCtrlkeyselectalltheslides –gotoSlideshow– Slide
transition – the transition – select speed to minimum – tick Automatically after and
enterthetimeofinterval foreachslidetoappearinslideshow–ClickApplytoalltheslide.
8. You can also use Custom animation to apply animation to the
Text/Content, for that select the object – go to Slide Show – Custom
Animation – click add effect – choose the style.
9. FinallygotoSlideShow–viewShow.
OUTPUT