COMPUTER APPLICATION IN MANAGEMENT

PRACTICAL REPORT

Submitted to the
DEPARTMENT OF MANAGEMENT STUDIES
By

NAME :
REG NO :

IN PARTIAL FULFILLMENT OF THE REQUIREMENT FOR THE AWARD OF

THE DEGREE OF

MASTER OF BUSINESS ADMINISTRATION

DEPARTMENT OF MANAGEMENT STYUDIES

Nehru College of Management

(Approved by AICTE, New Delhi & Affiliated to Bharathiar University, Coimbatore)
“Nehru Garden”, Thirumalayam Palayam,
Coimbatore - 6410105

MARCH 2025
 Nehru College of Management
Affiliated to Bharathiar University & Approved by AICTE, New Delhi
Accredited by NAAC, Recognized by UGC with 2(f) 12(B)
An ISO 9001: 2015 Certified Institution, Thirumalayampalayam,
Coimbatore - 641 105.

BONAFIDE CERTIFICATE

This is to certify that the contents of the practical record for Computer Applications in Management, is the
Bonafide work done by…………………………………………………………………………………..
Register number……………………of semester II in Master of Business Administration of Nehru College of
Management, Coimbatore- 641105.

Staff in Charge Director Principal

Submitted for the University Practical Examination held on ………………………………

Internal Examiner External Examiner

 TABLE OF CONTENT

Exercise
Date Title Page No Sign
No

MS Office Word

18/01/2023 FORMATTING TEXT

1 2

TABLE CREATION
2 18/01/2023 5

CREATING A RESUME USING

3 23/01/2023 8
TEMPLATE

4 23/01/2023 BROCHURE DESIGN 11

5 25/01/2023 MAIL MERGE 14

MS Office Excel

6 25/01/2023 EMPLOYEE PAYROLL SLIP 17

7 30/01/2023 MARK SHEET OF THE STUDENTS 20

MARK LIST CHART

8 30/01/2023 23

VLOOKUP AND HLOOKUP

9 01/02/2023 26

10 01/02/2023 PIVOT TABLE AND CHART 29

 TABLE OF CONTENT

Exercise
Date Title Page No Sign
No

MS Office PowerPoint

CREATING NEWS PRESENTATION

11 13/02/2023 32
WITH BLANK PRESENTATION

CREATING SEMINAR TOPIC IN

12 13/02/2023 35
POWERPOINT WITH TEMPLATES

CREATING PRESENTATION WITH

13 15/02/2023 38
AUTO SLIDE TRANSITION

CREATING PRESENTATION WITH

14 15/02/2023 TRANSITIONAL EFFECTS AND 41
ANIMATION EFFECTS
CREATING PRESENTATION WITH
15 27/02/2023 ADDING SOUNDS TO SLIDE AND 44
USING ACTION PLAY BUTTON

Tally ERP 9

16 01/03/2023 COMPANY CREATION 47

17 01/03/2023 LEDGER CREATION 50

18 13/03/2023 VOUCHER CREATION 53

19 13/03/2023 BALANCE SHEET CREATION 56

20 15/03/2023 INVOICE CREATION 59

 Exercise No: 1
FORMATTING TEXT
QUESTION:
THE TRAITS OF A GOOD MANAGER
1. Caring
Caring managers take time to get to know the individuals in their team. They’re genuinely
interested in a team member’s success and personal wellbeing, they regularly check in with
people about their lives, both at work and outside it.

2. Coaching
Good coaches focus on developing the people they work with as well as getting the job done.
They ensure they have regular 1-on-1 meetings with team members and encourage them to
present solutions to problems, rather than solving problems for them.

3. Communicating
Managers become great communicators by being good listeners. They allow time for others
to speak. They have a clear understanding of the organization’s vision and share it with the
people in their team in a way that motivates them. They keep their team up-to-date on what’s
happening in the organization.

4. Development
Managers who show a genuine interest in employees’ career development acknowledge
improvement and not just deliverables. They take time to discuss their direct report’s long-
term career aspirations and help them understand potential career paths within (and
potentially outside) the organization.

5. Emotional resilience
How a manager responds to challenging circumstances can have a significant impact on their
team. Managers who are emotionally resilient are aware of how their mood affects others.
They remain calm and productive under pressure and cope well with change.
Type the given content and perform the following function:
➢ Change the font size,
➢ Change the font style Bold, Italic, Underline,
➢ Alter the Line Spacing,
➢ Changing background colour and text colour,
➢ Inserting header and footer,
➢ Alignment Left, Right, Centre and Justified,
➢ Find and replace.

Page | 1
Exercise No: 1 FORMATTING TEXT
Date: 18/01/2023

AIM: Type the given content and perform the following function:
➢ Change the font size,
➢ Change the font style Bold, Italic, Underline,
➢ Alter the Line Spacing,
➢ Changing background colour and text colour,
➢ Inserting header and footer,
➢ Alignment Left, Right, Centre and Justified,
➢ Find and replace.

ALGORITHM:

STEP 1: Start → All Programs Click start -> All Programs -> MS Office ->MS
Word.
STEP 2: Find and replace: select Home > find and replace
STEP 3: Formatting text like font changing, coloring, font size, Bold, Italic and
Underline
STEP 4: Aliening paragraphs like left alien, right alien, center and justified
STEP 5: Adjusting margin using page ruler, if ruler is not visible choose view > ruler
option and you can adjust margin using ruler
STEP 6: Line spacing by using line spacing option on ribbon
STEP 7: Bullet and numbering by using bullet option and numbering option on
ribbon
STEP 8: Insert a picture: Select Insert > Pictures > This Device for a picture on your
PC
STEP 9: Add header and footer: select insert > Header or Footer according to your
need
STEP 10: Press Ctrl+S to save the document.

Page | 2
OUTPUT:

RESULT: Thus, the given operations done and required output was obtained.
Page | 3
 Exercise No: 2
TABLE CREATION
QUESTION:
Create a class time table using table properties

DAYS I II III IV V VI VII VIII

MONDAY OM FM QT MM RM HRM

CLUB ACTIVITY

CLUB ACTIVITY
LUNCH
BREAK

BREAK
TUESDAY OM MM HRM QT RM FM

WEDNESDAY OM QT RM HRM FM MM

THURSDAY FM OM MM QT HRM MM

FRIDAY QT FM MM HRM OM RM

SATURDAY HRM FM QT OM RM MM

Page | 4
Exercise No: 2 TABLE CREATION
Date: 18/01/2023

AIM: To create a class time table using table properties

ALGORITHM:

STEP 1: Click start -> All Programs -> MS Office ->MS Word.

STEP 2: Click insert -> table

STEP 3: Select the required rows & columns

STEP 4: Enter the data given above

STEP 5: To merge the cells, first select the cells & right click then select merge cells,

command, or choose merge cell icon in the toolbar

STEP 6: To change text direction inside the table, choose table tools -> Layout ->

Alignment -> Text direction

STEP 7: Use table tools tab to formatting table contents

STEP 8: Press Ctrl+S to save the document.

Page | 5
OUTPUT:

RESULT: Thus, the given operations done and required output was obtained.

Page | 6
 Exercise: 3
CREATING A RESUME USING TEMPLATE
QUESTION:
Create a resume using template in MS Office Word

Page | 7
Exercise No: 3 CREATING A RESUME USING TEMPLATE
Date: 23/01/2023

AIM: To create a resume using template in MS Office Word

ALGORITHM:

STEP 1: Click start -> All programs -> MS Office ->MS Word.

STEP 2: Open Word. Click on file -> New ->Installed Template -> Resume
template

STEP 3: Choose a resume template by highlighting your choice

(Contemporary, Elegant or Professional)

STEP 4: Type your personal information in the template

STEP 5: Save and print your resume

STEP 6: Press Ctrl+S to save the document.

Page | 8
OUTPUT:

RESULT: Thus, the given operations done and required output was obtained.

Page | 9
 Exercise: 4
BROCHURE DESIGN
QUESTION:
Create a brochure using symbols and smart art features in MS Office word like below,

EVENTS

• GROUP DANCE
• MIME
• RAMP WALK
• RANGOLI 3 LAKH
• MEHANDI WORTH PRIZES
• MOBILE
CHALLENGE
• SHORT FILM
• TIK TOK

Page | 10
Exercise No: 4 BROCHURE DESIGN
Date: 23/01/2023

AIM: To create a brochure using symbols and smart art features in MS Office word

ALGORITHM:

STEP 1: Click start -> All programs -> MS Office ->MS Word.

STEP 2: Open Word. Click on file, then New -> other documents

STEP 3: Choose insert -> smart art and shapes and icons according to your

requirement

STEP 4: Choose insert -> symbols and select symbols according to your need

STEP 5: Enter the necessary contents

STEP 6: Press Ctrl+S to save the document.

Page | 11
OUTPUT:

RESULT: Thus, the given operations done and required output was obtained.

Page | 12
 Exercise: 5
MAIL MERGE
QUESTION:
Create a Mail merge for the below given content
From:
Hari Krishna
Nehru college of management
Nehru gardens, Thirumalayampalayam,
Coimbatore – 641105.
To:

Sub: PLACEMENT TRAINING

I here by requesting you to allot placement training in our college for the development of the
student’s carrier.
Hope you will accept the letter and grant us the permission.

Thanking you
Yours Faithfully

Hari Krishna

Page | 13
Exercise No: 5 MAIL MERGE
Date: 25/01/2023

AIM: To Create a Mail merge for requesting placement training from management

ALGORITHM:

STEP 1: Click start -> All Programs -> MS Office ->MS Word.

STEP 2: Choose mailing -> start mail merge-> step by step mail merge wizard

STEP 3: Select document type-> letters

STEP 4: Select starting document

STEP 5: Select recipients-> type a new list-> enter the recipients’ details

STEP 6: Write your letter -> address line, body content, greeting etc.

STEP 7: Preview your letter created

STEP 8: Complete the mail merge

STEP 9: Print the mail merge

STEP 10: Press Ctrl+S to save the document

Page | 14
OUTPUT:

RESULT: Thus, the given operations done and required output was obtained.
Page | 15
 Exercise: 6
EMPLOYEE PAYROLL SLIP
QUESTION:
Create an employee payroll slip with MS Office Excel

EMPLOYEES PAY SLIP

Employee Name BA TA DA HRA PF Gross Net
No pay pay
001 Ranjith 11000 300 1400 1000 1500 ? ?
Kumar
002 Saran 11000 400 1540 1100 1650 ? ?
003 Vishnu 10500 350 1470 1050 1575 ? ?
prabu
004 Yogesh 9000 200 1260 900 1350 ? ?
005 Abudhahir 8000 100 1120 800 1200 ? ?

006 Nalin 13000 500 1820 1300 1950 ? ?

007 MohanBabu 14000 600 1960 1400 2100 ? ?

Page | 16
Exercise No: 6 EMPLOYEE PAYROLL SLIP
Date: 25/01/2023

AIM: To create an employee payroll slip with MS Office Excel

ALGORITHM:

STEP 1: Click start -> All programs -> MS Office ->MS Excel.

STEP 2: Enter the given data into the required fields.

STEP 3: To find gross pay, select the required cell, sum the given data.

STEP 4: Type the formula =SUM(select the cells or enter the cell details ).

STEP 5: To find net pay , select the required cell, less Gross pay with PF ( Gross Pay

cell name – PF cell Name )

STEP 6: To copy the same formula for next cell drag the right corner of the cell

STEP 7: Press Ctrl+S to save the document

Page | 17
OUTPUT:

RESULT: Thus, the given operations done and required output was obtained.

Page | 18
 Exercise: 7
MARK SHEET OF THE STUDENTS
QUESTION:
Create a student mark list on MS Office Excel
STUDENT MARK LIST

Reg NO Name Sub Sub Sub Sub Sub Sub Total Percentage Result
-1 -2 -3 -4 -5 -6 (%)
MBA001 Ashwin 92 98 88 91 88 92 ? ? ?

MBA002 Dharanidharan 88 91 79 76 64 94 ? ? ?

MBA003 Fahim 87 92 78 81 85 93 ? ? ?

MBA004 Alfred 91 22 76 83 69 98 ? ? ?

MBA005 Arun 84 89 35 98 68 85 ? ? ?

MBA006 Gopi Krishnan 91 95 98 92 35 89 ? ? ?

MBA007 Elango 75 81 87 76 68 87 ? ? ?

MAB008 Athul Krishna 68 79 82 94 62 88 ? ? ?

MBA009 Bragadheeswaran 88 83 22 92 61 82 ? ? ?

MBA010 Kunal 78 88 70 88 78 79 ? ? ?

Page | 19
Exercise No: 7 MARK SHEET OF THE STUDENTS
Date: 30/01/2023

AIM: To Create a student mark list on MS Office Excel

ALGORITHM:

STEP 1: Enter the given data into the required fields.

STEP 2: To find Total Marks, select the required cell, sum the given data.

STEP 3: Type the formula =SUM(select the cells or enter the cell details ).

STEP 5: To find the percentage pf the students

Type the formula =total cell number / No of subject

STEP 5: To find result

Type the formula

=if(and(sub1>=50,sub2>=50,sub3>=50,sub4>=50,sub5>=50,sub6>=50),”pass”,”fail”)

STEP 5: Press Ctrl+S to save the document

Page | 20
OUTPUT:

RESULT: Thus, the given operations done and required output was obtained.

Page | 21
 Exercise: 8
STUDENTS MARK LIST CHART
QUESTION:
Create a student mark list chart on MS Office Excel
STUDENT MARK LIST

Reg NO Name Sub Sub Sub Sub Sub Sub Total Percentage Result
-1 -2 -3 -4 -5 -6 (%)
MBA001 Ashwin 92 98 88 91 88 92 549 91.5 Pass

MBA002 Dharanidharan 88 91 79 22 64 94 492 82 Fail

MBA003 Fahim 87 92 78 81 85 93 516 86 Pass

MBA004 Alfred 91 68 76 83 69 98 504 84 Pass

MBA005 Arun 84 89 35 98 68 85 509 84.83333 Fail

MBA006 Gopi Krishnan 91 95 98 92 35 89 529 88.16667 Fail

MBA007 Elango 75 81 87 76 68 87 474 79 Pass

MAB008 Athul Krishna 68 79 82 94 62 88 473 78.83333 Pass

MBA009 Bragadheeswaran 88 83 22 92 61 82 497 82.83333 Fail

MBA010 Kunal 78 88 70 88 78 79 481 80.16667 pass

Page | 22
Exercise No: 8 STUDENTS MARK LIST CHART
Date: 30/01/2023

AIM: To Create a student mark list chart on MS Office Excel

ALGORITHM:

STEP 1: Click start -> All programs -> MS Office ->MS Excel.

STEP 2: Enter the given data into the required fields.

STEP 3: Select the required data for chat

STEP 4: To insert a chart, choose insert tab on the ribbon,

STEP 5: Choose chat on chart section,

STEP 6: To edit chart use chart tools,

STEP 7: Press Ctrl+S to save the document

Page | 23
OUTPUT:

RESULT: Thus, the given operations done and required output was obtained.

Page | 24
 Exercise: 9
VLOOKUP AND HLOOKUP
QUESTION:
Perform a Vlookup and Hlookup using the student mark list given below
STUDENT MARK LIST

Reg NO Name Sub Sub Sub Sub Sub Sub Total Percentage Result
-1 -2 -3 -4 -5 -6 (%)
MBA001 Ashwin 92 98 88 91 88 92 549 91.5 Pass

MBA002 Dharanidharan 88 91 79 22 64 94 492 82 Fail

MBA003 Fahim 87 92 78 81 85 93 516 86 Pass

MBA004 Alfred 91 68 76 83 69 98 504 84 Pass

MBA005 Arun 84 89 35 98 68 85 509 84.83333 Fail

MBA006 Gopi Krishnan 91 95 98 92 35 89 529 88.16667 Fail

MBA007 Elango 75 81 87 76 68 87 474 79 Pass

MAB008 Athul Krishna 68 79 82 94 62 88 473 78.83333 Pass

MBA009 Bragadheeswaran 88 83 22 92 61 82 497 82.83333 Fail

MBA010 Kunal 78 88 70 88 78 79 481 80.16667 pass

Page | 25
Exercise No: 9 VLOOKUP AND HLOOKUP
Date: 01/02/2023

AIM: To perform a Vlookup and Hlookup using the student mark list

ALGORITHM:

STEP 1: Click start -> All programs -> MS Office ->MS Excel.

STEP 2: Enter the given data into the required fields.

STEP 3: In the Formula Bar, type =VLOOKUP( lookup,value,table array,column

index number,true or false ), For VLOOKUP

STEP 4: In the Formula Bar, type =HLOOKUP( lookup,value,table array,column

index number,true or false ), For HLOOKUP

STEP 5: Press Ctrl+S to save the document

Page | 26
OUTPUT:

RESULT: Thus, the given operations done and required output was obtained.
Page | 27
 Exercise: 10
PIVOT TABLE AND CHART
QUESTION:
create a pivot table for student mark list in MS Office Excel
STUDENT MARK LIST

Reg NO Name Sub Sub Sub Sub Sub Sub Total Percentage Result
-1 -2 -3 -4 -5 -6 (%)
MBA001 Ashwin 92 98 88 91 88 92 549 91.5 Pass

MBA002 Dharanidharan 88 91 79 22 64 94 492 82 Fail

MBA003 Fahim 87 92 78 81 85 93 516 86 Pass

MBA004 Alfred 91 68 76 83 69 98 504 84 Pass

MBA005 Arun 84 89 35 98 68 85 509 84.83333 Fail

MBA006 Gopi Krishnan 91 95 98 92 35 89 529 88.16667 Fail

MBA007 Elango 75 81 87 76 68 87 474 79 Pass

MAB008 Athul Krishna 68 79 82 94 62 88 473 78.83333 Pass

MBA009 Bragadheeswaran 88 83 22 92 61 82 497 82.83333 Fail

MBA010 Kunal 78 88 70 88 78 79 481 80.16667 pass

Page | 28
Exercise No: 10 PIVOT TABLE AND CHART
Date: 01/02/2023

AIM: To create a pivot table for student mark list

ALGORITHM:

STEP 1: Click start -> All programs -> MS Office ->MS Excel.

STEP 2: Enter the given data into the required fields.

STEP 3: Select the required data for pivot table and chart

STEP 4: To insert a pivot table and chart, choose insert tab on the ribbon,

STEP 5: Choose pivot table and chart,

STEP 6: To edit pivot table, use necessary pivot functions,

STEP 7: Press Ctrl+S to save the document

Page | 29
OUTPUT:

RESULT: Thus, the given operations done and required output was obtained.

Page | 30
 Exercise: 11
CREATING NEWS PRESENTATION WITH BLANK PRESENTATION
QUESTION:
Create a news presentation with blank presentation in MS Office PowerPoint
"Grateful Adani Group Has Shown Faith In Australia": Ex PM Tony Abbott
Australia's former Prime Minister Tony Abbott has dismissed allegations of fraud by US based
short seller Hindenburg Research against the Adani group as just that, allegations.
New Delhi: Australia's former Prime Minister Tony Abbott has dismissed allegations of fraud
by US based short seller Hindenburg Research against the Adani group as just that, allegations.
He said the regulators will look into the matter, and as far as he is concerned, he is "grateful
for the faith Adani group has shown in Australia."
"It's easy to make allegations. Just because something has been alleged, doesn't make it true.
My recollection of the principles of the common law is you're innocent until proven guilty,"
Mr Abbott told NDTV in an interview today.
"So if there is anything in it, I'm sure the regulators will look into it and let the cards fall where
they may. But as far as I am concerned, I am grateful for the faith Adani group has shown in
Australia," he said, referring to Adani investments worth billions of dollars in his country.

Page | 31
Exercise No: 11 CREATING NEWS PRESENTATION WITH BLANK
PRESENTATION
Date: 13/02/2023

AIM: To Create a news presentation with blank presentation

ALGORITHM:

STEP 1: Click start -> All programs -> MS Office ->MS PowerPoint.

STEP 2: Choose file -> New -> Blank presentation

STEP 3: Enter the given data into the slides.

STEP 4: To add slides, choose insert -> New slide, or press Ctrl + M,

STEP 5: To format the content use required formatting tools in home tab,

STEP 6: To insert picture, table, chart use insert tab,

STEP 7: Press Ctrl+s to Save the document.

Page | 32
OUTPUT:

RESULT: Thus, the given operations done and required output was obtained.

Page | 33
 Exercise: 12
CREATING SEMINAR TOPIC IN POWERPOINT WITH TEMPLATES
QUESTION:
Create a seminar topic in PowerPoint with templates
What is GST and How it Works?
GST is referred as Goods and Services Tax. It is an indirect tax that was implemented to replace
a variety of previous indirect taxes, including the value added tax, service tax, purchase tax,
excise duty, and others. GST is a tax that India imposes on the supply of specific products and
services. There is only one tax that is imposed in India.
How GST Works in India?
Manufacturer: The manufacturer will have to pay GST on the raw material that is purchased
and the value that has been added to make the product.
Service Provider: In this case, the service provider will be responsible for paying GST on both
the product's purchase price and the value added to it. However, the manufacturer's tax payment
may be deducted from the total GST that must be paid.
Retailer: It must be paid by the retailer on both the product they bought from the distributor
and the margin they added. However, the retailer's tax payment may be deducted from the total
amount of GST that must be paid.
Consumer: GST must be paid on the product that has been purchased.
Types of GST in India
The four different types of GST are given below:
Central Goods and Services Tax: CGST is charged on the intra state supply of products and
services.
State Goods and Services Tax: SGST, like CGST, is charged on the sale of products or
services within a state.
Integrated Goods and Services Tax: IGST is charged on inter-state transactions of products
and services.
Union Territory Goods and Services Tax: UTGST is levied on the supply of products and
services in any of the Union Territories in the country, viz. Andaman and Nicobar Islands,
Daman and Diu, Dadra and Nagar Haveli, Lakshadweep, and Chandigarh. UTGST is levied
along with CGST.

Page | 34
 Exercise No: 12 CREATING SEMINAR TOPIC IN POWERPOINT
WITH TEMPLATES

Date: 13/02/2023

AIM: To Create a seminar topic in PowerPoint with templates

ALGORITHM:

STEP 1: Click start -> All programs -> MS Office ->MS PowerPoint.

STEP 2: Choose file -> New -> Template Presentation

STEP 3: Enter the given data into the slides.

STEP 4: To add slides, choose insert -> New slide, or press Ctrl + M,

STEP 5: To format the content use required formatting tools in home tab,

STEP 6: To change slide design choose design tab and select design

STEP 7: To insert picture, table, chart use insert tab,

STEP 8: Press Ctrl+s to Save the document.

Page | 35
OUTPUT:

RESULT: Thus, the given operations done and required output was obtained.

Page | 36
 Exercise: 13
CREATING PRESENTATION WITH AUTO SLIDE TRANSITION
QUESTION:
create presentation with auto slide transition in MS Office PowerPoint
What is GST and How it Works?
GST is referred as Goods and Services Tax. It is an indirect tax that was implemented to
replace a variety of previous indirect taxes, including the value added tax, service tax,
purchase tax, excise duty, and others. GST is a tax that India imposes on the supply of
specific products and services. There is only one tax that is imposed in India.
How GST Works in India?
Manufacturer: The manufacturer will have to pay GST on the raw material that is purchased
and the value that has been added to make the product.
Service Provider: In this case, the service provider will be responsible for paying GST on
both the product's purchase price and the value added to it. However, the manufacturer's tax
payment may be deducted from the total GST that must be paid.
Retailer: It must be paid by the retailer on both the product they bought from the distributor
and the margin they added. However, the retailer's tax payment may be deducted from the
total amount of GST that must be paid.
Consumer: GST must be paid on the product that has been purchased.
Types of GST in India
The four different types of GST are given below:
Central Goods and Services Tax: CGST is charged on the intra state supply of products and
services.
State Goods and Services Tax: SGST, like CGST, is charged on the sale of products or
services within a state.
Integrated Goods and Services Tax: IGST is charged on inter-state transactions of products
and services.
Union Territory Goods and Services Tax: UTGST is levied on the supply of products and
services in any of the Union Territories in the country, viz. Andaman and Nicobar Islands,
Daman and Diu, Dadra and Nagar Haveli, Lakshadweep, and Chandigarh. UTGST is levied
along with CGST.

Page | 37
Exercise No: 13 CREATING PRESENTATION WITH AUTO SLIDE
TRANSITION

Date: 15/02/2023

AIM: To create presentation with auto slide transition in MS Office PowerPoint

ALGORITHM:

STEP 1: Click start -> All programs -> MS Office ->MS PowerPoint.

STEP 2: Choose file -> New -> Template Presentation

STEP 3: Enter the given data into the slides.

STEP 4: To add slides, choose insert -> New slide, or press Ctrl + M,

STEP 5: To format the content use required formatting tools in home tab,

STEP 6: To insert picture, table, chart use insert tab,

STEP 7: To start a slide show, choose slide show tab -> from the beginning

STEP 8: To change the slide, press the directional keys

STEP 9: Press Ctrl+s to Save the document.

Page | 38
OUTPUT:

RESULT: Thus, the given operations done and required output was obtained.

Page | 39
 Exercise: 14
CREATING PRESENTATION WITH TRANSITIONAL EFFECTS AND
ANIMATION EFFECTS
QUESTION:
Create a presentation with transitional effects and animation effects In MS Office PowerPoint
What is GST and How it Works?
GST is referred as Goods and Services Tax. It is an indirect tax that was implemented to
replace a variety of previous indirect taxes, including the value added tax, service tax,
purchase tax, excise duty, and others. GST is a tax that India imposes on the supply of
specific products and services. There is only one tax that is imposed in India.
How GST Works in India?
Manufacturer: The manufacturer will have to pay GST on the raw material that is purchased
and the value that has been added to make the product.
Service Provider: In this case, the service provider will be responsible for paying GST on
both the product's purchase price and the value added to it. However, the manufacturer's tax
payment may be deducted from the total GST that must be paid.
Retailer: It must be paid by the retailer on both the product they bought from the distributor
and the margin they added. However, the retailer's tax payment may be deducted from the
total amount of GST that must be paid.
Consumer: GST must be paid on the product that has been purchased.
Types of GST in India
The four different types of GST are given below:
Central Goods and Services Tax: CGST is charged on the intra state supply of products and
services.
State Goods and Services Tax: SGST, like CGST, is charged on the sale of products or
services within a state.
Integrated Goods and Services Tax: IGST is charged on inter-state transactions of products
and services.
Union Territory Goods and Services Tax: UTGST is levied on the supply of products and
services in any of the Union Territories in the country, viz. Andaman and Nicobar Islands,
Daman and Diu, Dadra and Nagar Haveli, Lakshadweep, and Chandigarh. UTGST is levied
along with CGST.

Page | 40
Exercise No: 14 CREATING PRESENTATION WITH
TRANSITIONAL EFFECTS AND ANIMATION
EFFECTS

Date: 15/02/2023

AIM: To Create a presentation with transitional effects and animation effects In MS Office
PowerPoint

ALGORITHM:

STEP 1: Click start -> All programs -> MS Office ->MS PowerPoint.

STEP 2: Choose file -> New -> Template Presentation

STEP 3: Enter the given data into the slides

STEP 4: To add slides, choose insert -> New slide, or press Ctrl + M,

STEP 5: To format the content use required formatting tools in home tab,

STEP 6: To insert picture, table, chart use insert tab,

STEP 7: To add animation effects choose animation tab and choose necessary

animation effects

STEP 8: To add transitional effects, choose transition tab and choose necessary

transition effects

STEP 9: To start a slide show, choose slide show tab -> from the beginning

STEP 10: Press Ctrl+s to Save the document.

Page | 41
OUTPUT:

RESULT: Thus, the given operations done and required output was obtained.

Page | 42
 Exercise: 15
CREATING PRESENTATION WITH ADDING SOUNDS TO SLIDE
AND USING ACTION PLAY BUTTON
QUESTION:
Create presentation with adding sounds to slide and using action play button in MS Office
PowerPoint
What is GST and How it Works?
GST is referred as Goods and Services Tax. It is an indirect tax that was implemented to
replace a variety of previous indirect taxes, including the value added tax, service tax,
purchase tax, excise duty, and others. GST is a tax that India imposes on the supply of
specific products and services. There is only one tax that is imposed in India.
How GST Works in India?
Manufacturer: The manufacturer will have to pay GST on the raw material that is purchased
and the value that has been added to make the product.
Service Provider: In this case, the service provider will be responsible for paying GST on
both the product's purchase price and the value added to it. However, the manufacturer's tax
payment may be deducted from the total GST that must be paid.
Retailer: It must be paid by the retailer on both the product they bought from the distributor
and the margin they added. However, the retailer's tax payment may be deducted from the
total amount of GST that must be paid.
Consumer: GST must be paid on the product that has been purchased.
Types of GST in India
The four different types of GST are given below:
Central Goods and Services Tax: CGST is charged on the intra state supply of products and
services.
State Goods and Services Tax: SGST, like CGST, is charged on the sale of products or
services within a state.
Integrated Goods and Services Tax: IGST is charged on inter-state transactions of products
and services.
Union Territory Goods and Services Tax: UTGST is levied on the supply of products and
services in any of the Union Territories in the country, viz. Andaman and Nicobar Islands,
Daman and Diu, Dadra and Nagar Haveli, Lakshadweep, and Chandigarh. UTGST is levied
along with CGST.

Page | 43
Exercise No: 15 CREATING PRESENTATION WITH ADDING
SOUNDS TO SLIDE AND USING ACTION PLAY
BUTTON

Date: 27/02/2023

AIM: To Create presentation with adding sounds to slide and using action play button in
MS Office PowerPoint

ALGORITHM:

STEP 1: Click start -> All programs -> MS Office ->MS PowerPoint.

STEP 2: Enter the given data into the slides,

STEP 3: To add slides, choose insert -> New slide, or press Ctrl + M,

STEP 4: To format the content use required formatting tools in home tab,

STEP 5: To insert picture, table, chart use insert tab,

STEP 6: To add animation effects, choose animation tab and choose necessary

animation effects,

STEP 7: To add transitional effects, choose transition tab and choose necessary

transition effects,
STEP 8: To add sounds, choose transitions -> sounds -> select sound,

STEP 9: To add action button, choose insert -> shapes ->action button,

STEP 10: To start a slide show, choose slide show tab -> from the beginning

STEP 11: Press Ctrl+s to Save the document.

Page | 44
OUTPUT:

RESULT: Thus, the given operations done and required output was obtained.

Page | 45
 Exercise – 16
COMPANY CREATION
QUESTION:
Create a company with the following details.
Name: Senthamizh&co
Address: Nehru gardens, Thirumalayampalayam, Coimbatore-641105
Email: senthamizh&co@gmail.com
Phone No: 9998877766
Financial year from: 1-4-2023
Books beginning from: 1-4-2024
Use security control: Yes

Page | 46
Exercise No: 16 COMPANY CREATION

Date: 01/03/2023

AIM: To Create a company with the following details

ALGORITHM:

STEP 1: Click start -> All programs -> Tally Erp 9.

STEP 2: Go to Gate way of Tally > alt+f3,

STEP 3: From the Company Info menu, select Create Company option, Now
Company
creation Screen will display.
STEP 4: Type the following details in appropriate fields.
Field Type
Name: Senthamizh&co
Address: Nehru gardens, Thirumalayampalayam, Coimbatore-641105
Email : senthamizh&co@gmail.com
Financial year from: 1-4-2023
Books beginning from: 1-4-2024
Use security control: Yes

STEP 5: After entering the above details press Enter until the last field and look at the
new dialog box on the screen.

STEP 6: Accept Yes or type Y, the new company has been created.

Page | 47
OUTPUT:

RESULT: Thus, the given operations done and required output was obtained.

Page | 48
 Exercise – 17
LEDGER CREATION
QUESTION:
Create Ledger Account under appropriate Groups from the following trial balance

Ledger Name Debit Credit

Purchases 36,000
Sales 42,000
Daily Wages 5,000
Debtors 22,000
Interest 2000
Commission 5,000
Rent 8,000
Capital 200000
Cash 5000
machinery 173000
2,49,000 2,49,000

Closing stock: 6,000

Page | 49
Exercise No: 17 LEDGER CREATION

Date: 01/03/2023

AIM: To Create Ledger Account under appropriate Groups from the following trial balance

ALGORITHM:

STEP 1: Click start -> All programs -> Tally Erp 9.

STEP 2: Go to Gate way of Tally,

STEP 3: From the Gate way of tally select accounting info > ledger > single ledger >
create.

STEP 4: Type the following details in appropriate fields.

STEP 5: To view ledger list > single ledger > display

STEP 6: To alter ledger > single ledger > alter

Page | 50
OUTPUT:

RESULT: Thus, the given operations done and required output was obtained.

Page | 51
 Exercise – 18
VOUCHER CREATION
QUESTION:
Create a voucher with the following details.

Ledger Name Debit Credit

Purchases 36,000
Sales 42,000
Daily Wages 5,000
Debtors 22,000
Interest 2000
Commission 5,000
Rent 8,000
Capital 200000
Cash 5000
machinery 173000
2,49,000 2,49,000

Closing stock: 6,000

Page | 52
Exercise No: 18 VOUCHER CREATION

Date: 13/03/2023

AIM: To Create a voucher with the following details.

ALGORITHM:

STEP 1: Click start -> All programs -> Tally Erp 9.

STEP 2: Go to Gate way of Tally,

STEP 3: From the Gate way of tally select accounting voucher>payment

STEP 4: Type the following details in appropriate fields.

STEP 5: From the Gate way of tally select accounting voucher>receipt

STEP 6: Type the following details in appropriate fields.

STEP 7: To view reports > display > receipts and payments

Page | 53
OUTPUT:

RESULT: Thus, the given operations done and required output was obtained.
Page | 54
 Exercise – 19
BALANCE SHEET CREATION
QUESTION:
Create a balance sheet with the following details.

Ledger Name Debit Credit

Purchases 36,000
Sales 42,000
Daily Wages 5,000
Debtors 22,000
Interest 2000
Commission 5,000
Rent 8,000
Capital 200000
Cash 5000
machinery 173000
2,49,000 2,49,000

Closing stock: 6,000

Page | 55
Exercise No: 19 BALANCE SHEET CREATION

Date: 13/03/2023

AIM: To Create a balance sheet with the following details.

ALGORITHM:

STEP 1: Go to Gate way of Tally,

STEP 2: From the Gate way of tally select accounting voucher>payment

STEP 3: Type the following details in appropriate fields.

STEP 4: From the Gate way of tally select accounting voucher>receipt

STEP 5: Type the following details in appropriate fields.

STEP 6: To view reports > balance sheet

Page | 56
OUTPUT:

RESULT: Thus, the given operations done and required output was obtained.
Page | 57
 Exercise – 20
INVOICE CREATION
QUESTION:
Create an invoice with the following details.
Fasi Traders
a) Purchase as follows
1. LG Fridge - 50pcs@15,000
2. Redmi Mobile - 20pcs@10,000
3.Samsung washing machine - 100pcs@20,000

Vijay Traders
b) Sales as follows
1. LG Fridge - 30pcs@32,000
2. Redmi Mobile - 12pcs@15,000
3.Samsung washing machine - 20pcs@30,000

Page | 58
Exercise No: 20 INVOICE CREATION

Date: 15/03/2023

AIM: To Create an invoice with the following details.

ALGORITHM:

STEP 1: Go to Gate way of Tally,

STEP 2: From the Gate way of tally select inventory info > create group , unit of
measure, items

STEP 3: Type the following details in appropriate fields.

STEP 4: From the Gate way of tally select accounting voucher>purchase

STEP 5: Type the following details in appropriate fields.

STEP 6: From the Gate way of tally select accounting voucher>sales

STEP 7: Type the following details in appropriate fields

STEP 8: To view reports > accounting voucher >sales>print

Page | 59
OUTPUT:

RESULT: Thus, the given operations done and required output was obtained.
Page | 60