Practical File ON It Applications in Business

PRACTICAL FILE
ON
IT APPLICATIONS IN BUSINESS
GURU GOBIND SINGH INDRAPRASTHA UNIVERSITY
In partial fulfilment of the requirement for the award of the degree

of
BACHELOR OF BUSINESS ADMINISTRATION
Batch 2024 – 2028
SUBMITTED BY: SUBMITTED TO:

SHOBHIT SONI Prof. (Dr.) Mahessh Sharma
(Professor,Department of Computer Science)
ENROLLMENT NO. : 7015501724
NEW DELHI INSTITUTE OF MANAGEMENT

61A, TUGHLAKABAD, NEW DELHI-62
ACKNOWLEDGEMENT
We need a person to guide us, Concentration, dedication and application are
necessary but not sufficient to achieve any goal. There must be awarded by
proper guidance, assistance and co-operation of any senior person to make it
enable.
Gratitude is short lived but when put in black and white; one hopes it to enjoy
a longer life. Many people have given their valuable time and ideas and
assistance. I cannot forget the whole hearted support, which has given me as
an expert and learned supervision of Prof. (Dr.) Mahessh Sharma (Professor,
Department of Computer Science).
Lastly, I thank all those, who have, directly or indirectly, helped me in
completion of project report.
SHOBHIT SONI
BBA (1st Sem)

CERTIFICATE
This is to certify that Shobhit Soni pursuing BBA (Gen) from NEW DELHI
INSTITUTE OF MANAGEMENT has completed this file under my
supervision and guidance. He has taken care of all necessary aspects and
shown interest and utmost sincerity during the completion of the practical file
to my full satisfaction.
I certify that the practical is up to my expectation and as per the guidance laid
down by GURU GOBIND SINGH INDRAPRASTHA UNIVERSITY.
Prof. (Dr.) Mahessh Sharma
(Professor, Department of Computer Science)

IT Applications in Business LaB
S.NO TOPIC SIGN.
1 FINAL & REPLACE ALL IN MS WORD
2 STYLES IN MS WORD
3 HEADER AND FOOTER IN MS WORD
4 INDENTION IN MS WORD
5 INVITATION CARD
6 BLOCK DIAGRAM OF COMPUTER IN MS

WORD
7 CALENDAR IN MS WORD
8 HYPERLINK
9 MAIL MERGE
10 Spreadsheet of purchase made by a

customer in a supermarket having different
fields
11 Create a record of 10 students consisting of s.NO
and Mark in two subjects then show the total
AND percentage
12 Line chart and pie chart
13 Pivot table
14 Bar graph
15 If & else
16 Financial formulas
17 Text formulas
18 Student performance report
19 Data validation
20 PPT presentation : topic TYPES OF

SOFTWARE
21 THANK YOU
PRACTICAL INDEX
RIYA GULATI
ENROLMENT NO. 56350601724
Practical No. 1
Steps:-
1) Open a New MS Word Document.
2) Enlist the Advantages and Disadvantages of Computer.
3) Click on Home Tab And Select “Replace” Option.
4) Specify the Word which you want to replace and the new Word.
5) Click On “Replace All”
6) Now to Protect the Document Click on “File” Option
7) Now Click On “Save As” Option
8) Then Click On Tools Option.
9) Add Password And You Are Done With It.
RIYA GULATI
Practical No. 2
Steps:-
1) First Of all write The Information You want to add
2) Now Add Different Styles to Text and It will look like this
3) Now for Sorting Click On Icon.
4) Now after Sorting It will Arrange According to alphabets.
RIYA GULATI
Practical No. 3
Steps:-
1) First Of All write Computer Basics and Advantages/ Disadvantages. Now to

Insert Header and Footer. Click on the Insert tab, in the Header & Footer group,
click Header or Footer.
2) Click the header or footer design that you want. And it will look Like This.
RIYA GULATI
3) Now to Indent the Document Select the text you want to indent.
4) Click the Increase Indent command to increase the indent. The default is 1/2
inch. You can press the command multiple times.
4) Click the Decrease Indent command to decrease the indent.
Practical No. 4
Steps:-
1) To create an invitation card First of all Click Insert, and then select Clip Art.
RIYA GULATI
2) Now to insert Watermark Click on the Page Layout tab, in the Page Background
group, click Watermark.
3) Click Custom Watermark.
4) Click Picture watermark, and then click Select Picture.
5) Select the picture that you want, and then click Insert.
6) Select a percentage under Scale to insert the picture at a particular size.
7) Select the Washout check box to lighten the picture so that it doesn't interfere
with text.
Practical No. 5
Steps:-
1) Now To Create A Block Diagram We Must Use The Clipart And Shapes
Facility Of MS Word.
2) Insert a drawing canvas. On the Insert tab, in the Illustrations group, click
Shapes, and then click New Drawing Canvas.
3) Under Drawing Tools, on the Format tab, in the Insert Shapes group, click the
more buttons .
4) Click the shape that you want, click anywhere in the document, and then drag to
place the shape.
5) You Can Also Format The AutoShape You Have Inserted.
6) In this Way Block Diagram Can be Created.
Practical No. 6
RIYA GULATI
November 2023
Sunday Monday Tuesday Wednesday Thursday Friday Saturday
1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30
Steps to Create a Calendar:
1. Click on Insert option and Select Table
2. Make a 7*6 Table
3. Write the Names of the days of the week in the First Row of Table
4. Select the Names and Right Click then Select Cell Alignment option and choose
the Center Alignment
5. Change the Font Size and Style of the days of the week
6. Select the First Row and Right Click then choose Insert Row above option
7. Select the First Row and right Click to Choose Merge Cell option
8. Write the Name of the month in the First Row
9. Click on Table tools and Shade the Table as desired
10. Click on Table tools to give attractive border
11. Choose any of the Table styles to make it attractive
12. Highlight any two dates on the calendar
Practical No. 7
RIYA GULATI
Steps:-
 Mark the hyperlink location
1. Insert a bookmark in the destination file or Web page.
2. Open the file that you want to link from, and select the text or object you want to
display as the hyperlink.
3. Right-click and then click Hyperlink on the shortcut menu.
4. Under Link to, click Existing File or Web Page.
5. In the Look in box, click the down arrow, and navigate to and select the file that
you want to link to.
6. Click Bookmark, select the bookmark that you want, and then click OK.
 Add the link
1. Select the text or object that you want to display as the hyperlink.
2. Right-click and then click Hyperlink on the shortcut menu.
3. Under Link to, click Place in This Document.
4. In the list, select the heading or bookmark that you want to link to.
For Bookmark
1. Select the text or item to which you want to assign a bookmark, or click where
you want to insert a bookmark.
RIYA GULATI
2. On the Insert tab, in the Links group, click Bookmark.
3. Under Bookmark name, type or select a name.
Bookmark names must begin with a letter and can contain numbers. You can't
include spaces in a bookmark name. However, you can use the underscore
character to separate words — for example, "First heading."
4. Click Add.
Practical No. 8
Steps:-
1) To start a mail merge, open Microsoft Word 2007, and click on the
Mailings tab.
RIYA GULATI
2) Find the Start Mail Merge button under the Mailings tab and click the arrow
beside it. Choose the last option, Step by Step Mail Merge Wizard.
3) This brings up the task pane as shown below. Select Letters (or whatever
type you suits the job you’re working on as the type of document and then
click on the Next: Starting document link at the bottom of the task pane to
go to the next step to select your starting document.
RIYA GULATI
4) At this point you have options to use the current document you have open,
to select a template, or to browse to an existing document not open. For this
example we will start from a template. Select Start from a template. This
brings up a link you click on to Select template.
5) This will open the Select Template dialog box. Select the Letters tab and
choose Oriel Merge Letter. Click Ok. This will take you to the next step in
the Mail Merge process which you will select recipients.
RIYA GULATI
6) Select Use an existing list and click on the Browse link. Locate and open
the file containing your data source. Your data source can be anything from
a database holding thousands of records to a simple spreadsheet that
contains 10 names. For this exercise I will use an existing test spreadsheet.
RIYA GULATI
7) This opens the Mail Merge Recipients dialog box shown below. Here you
can select which recipients to include or deselect by unchecking the check
box by the name.
8) Pick the date and replace the letter content with your own and then go on to
the next step to preview your letters by clicking on the link at the bottom of
the task pane.
9) You can then click on the link, next: Complete the merger, which the
following message will appear.
RIYA GULATI
10) You can choose whether to merge all or selected records. Click OK
and then a new merged document entitled Letters1 is created. It contains the
individual letters for each recipient. If you look at the status bar, you will
see that it indicates multiple letters. At this point you have completed a mail
merge in Word 2007. When finished you can always save this document
you created for future reference.
Practical No. 9
RIYA GULATI
Steps:
1) Open a new excel doc.
2) Make columns for
 S. No.
 Product ID
 Product Name
 Product type (food, clothes, toys etc.)
 Quantity
 Price per unit
3) Make all the text bold and underline by clicking the home tab button.
4) Add border form the home tab.
RIYA GULATI
Steps:
Open a new excel doc. To auto sum do as under:
1) Select the cell in which you want to result to appear.
2) On the Home tab, in the Editing group, click on the SUM icon.
3) Observe the formula bar. The range that Excel guessed is displayed.
4) If the guess is correct, press Enter. You are done.
5) If the guess is incorrect, select the range of cells you want to use.
6) Press Enter.
RIYA GULATI
Practical No. 10
RIYA GULATI
Steps to Sort the records in ascending order of Marks 1:
1. Select all the values of Marks I
2. Click on Home tab
3. Select Sort & Filter option
4. Click on Sort Smallest to Largest and Select- Continue with current

selection and Click OK
RIYA GULATI
Steps to Sort the records according to decreasing order of Names:
1. Select all the Names
4. Click on Sort A to Z and Select- Continue with current selection and Click OK
Steps to Round off Percentage to one unit:
1. Select all the values of Percentage
4. First Click on Increase Decimal Then Click on Decrease Decimal and Click OK
RIYA GULATI
Steps to Convert the Percentage in Text:
1. Select all the values of Percentage
4. Click on Number Format
5. Select More Number Format
6. Now Select Text and Click OK
RIYA GULATI
Steps to Apply Filter on Course Field:
1. Select whole D-Column
4. Click on Filter 5. Now Click on Arrow in Course Field and Unselect BBA or
BCA and Click OK
Practical No. 11
RIYA GULATI
Steps to Insert Line Chart:
1. Select the names of products and values of all 3 years
2. Click on Insert tab
3. Select Insert Line Chart and Select 4th type of Chart
4. Now Select Legend in Layout tab and Select above Chart
5. Now Select Data Label and Select either Centre, Above, Below, Right or Left.
6. Now in same tab Select Axis Title and Select 2^nd option in both Horizontal and
Vertical Axis Title and write Series in Vertical Axis and Product Name in
Horizontal Axis
7. Now Select Gridlines in Layout tab and Select Minor in Vertical Gridlines
RIYA GULATI
Steps to Insert Pie Chart:

1. Select the names of products and values of 2012, 2013 and 2014 one-by-one
3. Select Insert Pie Chart and Select different types of Chart for all the years
4. Now in same tab Select Chart Title and Select Above Chart and write year of
Sales
5. Now Select Data Label and Select either Centre, Above, Below, Right or Left.
Practical No. 12
RIYA GULATI
Steps to Create Pivot Chart:
1. Select the Table
2. Click on Insert tab and Select Pivot Chart option
3. Drag State and Year in Legend
4. Drag Manufacturer and Product in Axis
5. Drag Quantity in Values
Practical No. 13
RIYA GULATI
Steps to Create a Bar Graph:
2. Select Insert Bar Graph
3. Now Select First Graph Type
Steps to Switch Column:
1. Select the Graph
2. Click on Design tab
3. Select Switch Row/Column
Steps to Change Graph to Column Chart
RIYA GULATI
1. Select the Graph
2. Click on Design tab
3. Select Change Chart Type
4. Now Select Column and in this First Chart
5. Then Click OK
Practical No. 14
Steps to Fill Grade A as Pink, B as Blue, C as Yellow & D as Red:
1. Select all the values of Grade
3. Select Conditional Formatting
4. Then Select Highlight Cell Rules and in this Select Equal to
RIYA GULATI
5. Then Write A, B, C & D one-by-one & Select Color respectively
Steps to Split Roll No in 4 Parts:
1. Insert 3 Columns after First Column
2. Select all Roll No's
3. Click on Data tab
4. Select Text to Columns
5. Select Fixed Width & Click Next
RIYA GULATI
Steps to Split Name in 2 Parts:
1. Insert 3 Columns after Name
2. Select all Names’
4. Select Text to Columns
5. Select Fixed Width & Click Next
6. Place the arrow to Split in 2 Parts & Click Next
7. Now Finish
RIYA GULATI
Steps to Remove Duplicate Course:
1. Select the entire Course
3. Select Remove Duplicates
4. Then Select Continue with the current selection
5. Now Click on Remove Duplicates & Then Click OK
Practical No. 15
RIYA GULATI
Steps to Change the Time Period for earning minimum Rs5000:
1. Select the Cell
3. Select What if Analysis
4. In this Select Goal Seek
5. Write 5000 in To Value
6. Now Select the Time Cell and Click OK
RIYA GULATI
Steps to Change the Principle Value for earning minimum Rs10000:
1. Select the Cell
3. Select What if Analysis
4. In this Select Goal Seek
5. Write 10000 in To Value
6. Now Select the Principle Cell and Click OK
RIYA GULATI
Steps to apply Freeze Panes:
1. Click on View tab
2. Select Freeze Panes
3. Now Select Freeze Top Row
Practical No. 16
RIYA GULATI
Practical No. 17
Steps:
1. Create a new MS Excel sheet.
2. Write down student performance after merging cell in center. Then, write
S.no, name, M1, M2, M3, M4, M5, M6 (Total).
3. Enlist all the marks for each student in all M sections.
4. Go to “Home” tab, select the option “Conditional Formatting”.
5. Use the following specification under ‘Conditional Formatting’; Greater than,

less than, equal to, between, data bar, color scales.
Practical No. 18
RIYA GULATI
STEPS:
1) Open a new excel sheet.
2) Enter the details s.no, name, date of birth, age, marks, remarks.
3) Select one or more cells to validate.
4) On the Data tab, in the Data Tools group, click Data Validation.
5) On the Settings tab, in the Allow box, select List
RIYA GULATI
RIYA GULATI
Practical No. 19
Prepare a Presentation on the Topic : TYPES OF SOFTWARE
RIYA GULATI
RIYA GULATI
RIYA GULATI
RIYA GULATI
RIYA GULATI
RIYA GULATI
RIYA GULATI

Practical File ON It Applications in Business

Uploaded by

Copyright:

Available Formats

Practical File ON It Applications in Business

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Practical File ON It Applications in Business

Uploaded by

Copyright:

Available Formats

PRACTICAL FILE

GURU GOBIND SINGH INDRAPRASTHA UNIVERSITY

In partial fulfilment of the requirement for the award of the degree

BACHELOR OF BUSINESS ADMINISTRATION

Batch 2024 – 2028

SUBMITTED BY: SUBMITTED TO:

NEW DELHI INSTITUTE OF MANAGEMENT

We need a person to guide us, Concentration, dedication and application are

proper guidance, assistance and co-operation of any senior person to make it

an expert and learned supervision of Prof. (Dr.) Mahessh Sharma (Professor,

Department of Computer Science).

Lastly, I thank all those, who have, directly or indirectly, helped me in

completion of project report.

BBA (1st Sem)

INSTITUTE OF MANAGEMENT has completed this file under my

down by GURU GOBIND SINGH INDRAPRASTHA UNIVERSITY.

Prof. (Dr.) Mahessh Sharma

(Professor, Department of Computer Science)

S.NO TOPIC SIGN.

1 FINAL & REPLACE ALL IN MS WORD

3 HEADER AND FOOTER IN MS WORD

6 BLOCK DIAGRAM OF COMPUTER IN MS

10 Spreadsheet of purchase made by a

18 Student performance report

20 PPT presentation : topic TYPES OF

1) Open a New MS Word Document.

2) Enlist the Advantages and Disadvantages of Computer.

3) Click on Home Tab And Select “Replace” Option.

5) Click On “Replace All”

6) Now to Protect the Document Click on “File” Option

7) Now Click On “Save As” Option

8) Then Click On Tools Option.

9) Add Password And You Are Done With It.

1) First Of all write The Information You want to add

3) Now for Sorting Click On Icon.

4) Now after Sorting It will Arrange According to alphabets.

1) First Of All write Computer Basics and Advantages/ Disadvantages. Now to

4) Click the Decrease Indent command to decrease the indent.

3) Click Custom Watermark.

4) Click Picture watermark, and then click Select Picture.

6) Select a percentage under Scale to insert the picture at a particular size.

5) You Can Also Format The AutoShape You Have Inserted.

6) In this Way Block Diagram Can be Created.

Steps to Create a Calendar:

1. Click on Insert option and Select Table

2. Make a 7*6 Table

8. Write the Name of the month in the First Row

9. Click on Table tools and Shade the Table as desired

10. Click on Table tools to give attractive border

11. Choose any of the Table styles to make it attractive

12. Highlight any two dates on the calendar

 Mark the hyperlink location

1. Insert a bookmark in the destination file or Web page.

3. Right-click and then click Hyperlink on the shortcut menu.

4. Under Link to, click Existing File or Web Page.

 Add the link

2. Right-click and then click Hyperlink on the shortcut menu.

3. Under Link to, click Place in This Document.

2. On the Insert tab, in the Links group, click Bookmark.