MAHARAJA SURAJMAL INSTITUTE

C4, JANAKPURI, NEW DELHI-110058

Affiliated to Guru Gobind Singh Indraprastha University

Department of Business Administration

IT APPLICATIONS IN BUSINESS
LAB (BBA115)

Submitted to Submitted by:

Ms. Neha Mathur R Saimurugan

Assistant Professor, BBA

12
13
14
CONTENTS

S.NO. TOPIC

I. Syllabus

II. Introduction

III. Hardware and Software requirements

IV. List of experiments

15
I. SYLLABUS

16
 II. Introduction to Subject

1. MS WORD
Microsoft Word is one of the most popular software programs in the world, used by millions of
office workers, students and home users to create, read and edit documents. Many people don't
use all the features of MS Word because not all of them are necessary for every user. It can be
useful to familiarize yourself with the basic features and characteristics of MS Word, even if you
don't need them all immediately, in case they ever come in handy.

2. MS-EXCEL
Definition:
Microsoft Excel is a very powerful spreadsheet application that is designed, primarily,
to perform mathematical calculations. It also can be used to create a simple (non-
relational) database or to create charts and graphs. The power behind Excel is that
once formulas are entered into a worksheet, calculations can be performed on data
entered into the worksheet. What is a spreadsheet (Worksheet)?
A spreadsheet is similar to working with tables—it has rows and columns, and the space
where these two intersect are called “cells”.
What are cells?
A cell reference is its location or “address” within spreadsheet and is identified by what
column it is located (which uses letters) and what row it is in (which uses numbers), such
as A1 or E15. You can tell which cell you’re currently working in using the following
methods:
1)The “Name Box” displays the cell reference.
2)The cell is “highlighted” by a bold outline.
3)The column and row headings the cell is located in are highlighted.

column cell

17
 NOTE:
1. Each new Excel file is referred to as a workbook.
2. Initially, each new workbook contains three separate pages called worksheets
(Sheet1, Sheet2, Sheet3).
3. The intersection of each row and column is called a cell.
4. Each cell can hold a text string, numbers, or a formula that performs calculations
on one or more other cells.
5. The cell name, or cell reference, is a combination of the cell’s column and row number.
6. There are a total of 16,384 columns in each worksheet and 1,048,576 rows.
7. Columns are identified by the letters A-Z. After the 26th column, column
headings become double letters (A-Z, AA-AZ, BA-BZ etc.), until 16, 384
columns ending at XFD
8. Formulas always start with the equals sign (=).
9. Text data is always automatically formatted to be left-justified in a cell and
numeric data is automatically right-justified.

3. MS POWERPOINT

MS PowerPoint is a program that is included in the Microsoft Office suite. It is used to make
presentations for personal and professional purposes.

Given below are a few important things that one must know about the development and
introduction of Microsoft PowerPoint:

 The program was created in a software company named Forethought, Inc. by Robert Gaskins and
Dennis Austin.
 It was released on April 20, 1987, and after 3 months of its creation, it was acquired by
Microsoft.
 The first version of this program, when introduced by Microsoft was MS PowerPoint 2.0 (1990).
 It is a presentation-based program that uses graphics, videos, etc. to make a presentation more
interactive and interesting.
 The file extension of a saved Powerpoint presentation is “.ppt”.
 A PowerPoint presentation comprising slides and other features is also known as PPT.

Gradually, with each version, the program was more creative and more interactive. Various other
features were added in PowerPoint which massively increased the requirement and use of this MS
Office program.

18
 III. Hardware and Software Requirements

In addition to Windows 2007, Windows 2016 and Windows XP, following configuration is
required:

COMPONENT MS OFFICE
Computer and Processor 500 MHZ
Memory(RAM) 256 MB
Hard Disk 2 GB
Display 1024x 768

19
 IV. List of Experiments
S.No. Application Problem Statement
Area/Functionality/ Concept
on which practical is based
1 MS-Word Introduction to MS-Word
2 MS-Word Create a document containing text that should be
properly aligned with proper format. Use the
“replace all” option in find and replace to replace
each instance of some word.
List down different components of computer along
with their functionality and then apply at least 5
different styles
3 MS-Word Create a document containing computer basic including
advantages and dis advantages using header, footer,
etc.

Create an invitation card for the fresher’s party using

the clip art facility of MS-Word.

4 MS-Word Create a block diagram of computer using drawing

facility of MS WORD.

Insert a 7-column, 6-row table to create a calendar for

the current month.

a. Enter the names of the days of the week in the first

row of the table.
b. Name of days should be centre aligned.
c. Change the font and font size as desired.
d. Insert a row at the top of the table.
e. Merge the cells in the row and enter the current
month and year using a large font size.
f. Shade the row.
g. Enter and right-align the dates for the month in the
appropriate cells of the table.
h. Change the outside border to a more decorative
border. Identify two important dates in the calendar and
shade them.

5 MS-Word Create a document on generations of computer.

Create a table in MS-Word with the following entries:

Name, M1, M2, M3, M4, M5 and apply the following

operations on it
1) Calculate the minimum marks in M1 & M3.

20
 2) Calculate the maximum marks in M2 & M5.
3) Insert two new columns named total and average.
4) Find the sum and average of marks obtained in each
subject.
5) Sort the table with respect to the column average.
6) Covert the table into text.

6 MS-Word Create a document. Insert at least 5 hyperlinks. In the

same document insert at least 3 bookmarks.

Write 10 mathematical equations

7 MS-Word Create the resume using the resume template facility

and write down the steps for it.

Make a table of contents of unit-I of the subject

Computer Applications using “Place in the document”
facility of hyperlink in MS-Word.

8 MS-Word Send fresher’s party invitation card created above to 5

different people using mail merge.

Count the no of characters, word, pages, paragraphs

and lines using word count facility of MS-Word and
also check the spelling and grammar in the current
document.

9 MS-Word Create a macro using toolbar. Write steps for the same.

MS-Excel Introduction to MS-Excel.

10 MS-Excel 1. Create a spread sheet of the purchases made by

a customer in a super mart having the
following fields:
 S.NO
 Product ID
 Product Name
 Product type (food, clothes, toys etc.)
 Quantity
 Price per unit
2. Create a student performance report using
Conditional formatting in M.S. Excel the
following specifications:
 Greater than
 Less than

21
  Equal to
 Between
 Data bar
 Colour Scales

11 MS-Excel 3. Create a record of ten students consisting of

S.no, name and marks in two subjects (M1,
M2) and perform the following operations:
 Sort the records in ascending order of marks
M1
 Sort the records in descending order of marks
M2
 Sort the record according to descending order
of names
 Find the minimum marks and replace it by the
text “put more efforts”.
4. Create the Column Chart and Pie Chart for the
sales report for laptops of ABC Pvt. Ltd. Enter
year wise records (at least 7 records)
for different types of laptop companies
Apply the following properties of Column Chart such

 Fill Colour
 Border Colour
 Border Style
 Size

12 MS-Excel 5. Create the Pivot Chart for the sales laptop of

KCL Pvt. Ltd for the last 5 years.

Create a Bar graph for 5 states for 3 years depicting

the literacy rate. For the graph created above
perform the following
 Switch Row/column,
 fill colour
 add borders
 change size
6. Create the student grade (A, B, C& D) report
using IF and IF Else condition in M.S. Excel.
Now using the conditional formatting fill the A
grade as -red, B grade as yellow, C grade as
green and D grade as pink.

13 MS-Excel 7. Create the student record consisting of the

following entries:

22
  S.no
 Name
 Marks in M1,M2,M3,M4,M5

Now for the table perform the following functions:

 Find the maximum marks in M2
 Find the minimum marks in M5
 Find the total marks obtained by each
student
 Find the average marks of each student
 Sort the table according to total marks.
 Create a new field named "percentage" and
calculate it.
8. Create a record of ten companies consisting of
columns:
 S. no
 Name of company
 NAME OF CEO
 No. Of employees
 Profit in year 2017
 Profit in year 2018

For the record above, protect your worksheet by

providing password
 Hide/unhide cells.
 Allow users to sort cells
 Don’t allow users to delete cells
 Don’t allow users to format cells.

14 MS-Excel 9. Create a record of ABC Company with the

following columns:
 Customer Name
 Income
 % Tax

Now for the above table find the Tax deducted for each
customer. Total Tax deducted must be equal to150000,
by changing the value of income of Customer C.
10. Create a record of 10 household items. It
should include:
 S. No.
 Name
 Price
 Quantity

Find the price of any item from the name list using

23
 VLOOKUP function.
15 MS-Excel Create two sheets with following data:
 First sheet should have a list of 10 students
with their respective subject marks.
 Second list should contain the same list of
students with their actual marks.

You have to link the two lists together.

Create a record of BBA (1ST Semester) consisting of
the following fields:
 S.No
 Name
 Date of birth
 Age
 Marks
 Remarks

For the above record, apply the appropriate data

validation.
16 MS-Excel Create a record of budget for 5 years with following
fields:

 Sales
 Expenses

Calculate the annual profit and create scenarios and

summaries report.

MS-PowerPoint Introduction to MS-PowerPoint.

24