HARSH CHOPRA 0201BBA078

A Project  
On
LAB WORK
COMPUTER APPLICATIONS FOR BUSINESS

Submitted in partial fulfillment of the requirements for 

 the award of degree of Bachelor of Business 
 Administration 2020 – 2023  
 
 
Submitted by –
Harsh Chopra
ERP: 0201BBA078                                                                                  Guided by –
Ms. Preeti
Taneja

 
 
 

 
 
Bharati Vidyapeeth (Deemed to be University) 
Institute of Management & Research, New Delhi 
Re-Accredited with Grade “A+” by NAAC 
A- 4, Paschim Vihar, New - Delhi, Ph: 011 - 25286442 Fax 011 - 25286442 

1
HARSH CHOPRA 0201BBA078

LAB WORK – 1
Q. Using MS – Word, create a table of your
qualifications in the format:
S. NO. BOARD SCHOOL YEAR OF % OF MARKS CLASS
NAME PASSING

STEPS:
1. Click on insert tab
2. Select table
3. Choose the number of rows and columns
4. A blank table will be inserted

2
HARSH CHOPRA 0201BBA078

LAB Work: 2
Q. Take a double column book or newspaper and
design or create similar paragraph style in the word
document

STEPS:
1. CLICK ON LAYOUT TAB
2. SELECT COLUMNS
3. FURTHER SELECT MORE COLUMNS
4. THEN SELECT ‘APPLY TO – THIS POINT FORWARD’ AND ‘2 COLUMNS’
AND ENTER OK

3
HARSH CHOPRA 0201BBA078

LAB WORK – 3
Q. Create a file in MS Word in to create Diwali
greeting using Clip Art, Word Art & give proper
message in your greeting.

STEPS:
1. Open MS. Word

2. Select any template you want to use

3. For using different word arts, go to Insert option and select any word art you want

4. For Clip Art, go to Insert option, click on online pictures option, type the picture you are
looking for and press enter. Then insert the picture by clicking on insert option.

4
HARSH CHOPRA 0201BBA078

LAB WORK – 4
Q. Insert a 7-column,6-row table to create a calendar
for the current month and do:
STEPS:
a. Enter the names of the days of the week in the first
row of the table.
b. Centre the day names horizontally and vertically.

c. Change the font and font size as desired.

d. Insert a row at the top of the table.

5
HARSH CHOPRA 0201BBA078

e. Merge the cells in the row and enter the current

month and year using a large font

size.
f. Shade the row.

6
HARSH CHOPRA 0201BBA078

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.

7
HARSH CHOPRA 0201BBA078

LAB WORK – 5
Q. Create the resume using the resume Template
facility and write down the steps for the same.

STEPS:
1. Open MS- Word
2. Select any resume template you want to use
3. Write down your details in the resume

8
HARSH CHOPRA 0201BBA078

LAB WORK – 6
Q. Create a table in MS-Word with the following
entries: S. No., Name, M1, M2, M3, M4, M5 and apply
the following operations on it
a. Calculate the minimum marks in M1 & M3.
b. Calculate the maximum marks in M2 & M5.
c. Find the sum of total marks obtained in Each
subject.
d. Insert a new column named grade in the Table.
e. Sort the table with respect to the column M6.
f. Convert the table into text

9
HARSH CHOPRA 0201BBA078

10
HARSH CHOPRA 0201BBA078

LAB WORK – 7
Q. Write 10 mathematics equations in MS word from
Insert option using equation and symbol tab. e.g.: 𝐴 =
𝑚c 2

1. x 2+ y 2+2 xy=( x + y)2

2.( x− y )2=x 2 + y 2−2 xy
3. A=π r 2
4. A = 4πr^2
5. A = πr^2
6. P = 2πr
7. x 2+ y 2=z 2
a
∗b
8. b =1
a
a
∗b
9. b
=
ab
c bc

( )
nt
r
10. A=P 1+ n

11
HARSH CHOPRA 0201BBA078

LAB WORK – 8
Q. Create a manual by writing steps and pasting
screenshots of Mail-Merge
STEPS:
1. Prepare the required excel worksheet

2. On word, prepare a letter for mail merge

12
HARSH CHOPRA 0201BBA078

13
HARSH CHOPRA 0201BBA078

LAB WORK – 9
Q. Create a spreadsheet of the purchases made by a
customer in a super mart having
the following fields:
a. [Link]
b. Product ID
c. Product Name
d. Product type (food, clothes, toys etc)
e. Quantity
f. Price per unit
Note: All the field names should be bold and
underlined. Also Insert Borders to the
spreadsheet. For the spreadsheet created above, find
the total bill, using the auto sum
facility of Ms Excel
STEPS:
1. GO TO EXCEL
2. PREPARE THE DATA
3. SELECT THE FIELD NAME MAKE THEM BOLD AND
UNDERLINED
4. Select the range of cells to which you want to add
borders

14
HARSH CHOPRA 0201BBA078

5. On the home tab, click the border option and

select the type of border you want

6. To find total bill, select the total column and go to

formulas tab
7. Select Auto Sum option and further select Sum

15
HARSH CHOPRA 0201BBA078

8. FINAL RESULT WILL LOOK LIKE THIS

16
HARSH CHOPRA 0201BBA078

LAB WORK – 10
Q. Create a student performance report using
Conditional formatting in
M.S. Excel the following specifications:
a. Greater than 70 yellow
b. Less than 50 green
c. Equal to 60 blue
d. Between 80-90 pink
STEPS:
1. Enter the marks of students named M1, M2, M3, M4 and M5
2. Add the marks either by using the auto sum formula

3. Select the total marks and click on conditional formatting

4. Click on highlight cell rules and perform the functions given in
the above question

17
HARSH CHOPRA 0201BBA078

18
HARSH CHOPRA 0201BBA078

LAB WORK – 11
Q. Make use of the purpose of following functions in
MS-Excel ROUND (), SQRT (),
MIN (), Lower (), ABS ()
Steps-

1. Write the digits and in the next cell, type [-ROUND (cell address)] to get the round off of
that number.
2. Write any digit and in the cell type [-SQRT (cell address)] to get the square root of that
number.
3. Write a few numbers and in the next cell type [-MIN (cell address)] to get the minimum
numbers among them.
4. Write any word with random upper or lower-case letter and in the next cell type [-
LOWER (cell address)] to get the word completely in lower case letters.
5. Write any negative number and in the next cell type [-ABS (cell address)] to get a
positive value (i.e. it removes all the signs from the number).

19
HARSH CHOPRA 0201BBA078

20
HARSH CHOPRA 0201BBA078

LAB WORK – 12
Q. Create a list in Excel with the fields as Cust Code,
Cust Name, Address, Order No, Discount and Tax
-Calculate the following as
Discount is 10% of Order Amt
Tax is 2% of Order Amt
Steps-

1. Write the information under the cells given in the above question
2. Use the formula –E2* F1 ……. –E5* F1 to get the 10% discount on the order amount.
3. Use the formula –E2* G1 …… -E5*G1 to get the 2% tax on the order amount.

21
HARSH CHOPRA 0201BBA078

LAB WORK – 13
Q. Draw a pie chart for sales report of XYZ Company
for the last 5 years.
STEPS:
1. OPEN THE EXCEL SHEET
2. WRITE THE DATA REQUIRED
3. CLICK INSERT THEN SELECT THE PIE CHART

22
HARSH CHOPRA 0201BBA078

LAB work 14
Q. Create a record of Bank consisting of the following columns: (Goal Seek)
a. Customer id
b. Customer Name
c. Principle Deposited
d. Rate of Interest
e. Time
f. Now for the above table find the interest earned by each customer.
(i) Each customer must earn minimum interest of Rs5000, by changing
the value of time period for which money must be deposited
ii) change the minimum interest to Rs 10000 by changing the value of
Principle.

STEPS:
1. OPEN EXCEL
2. FILL THE DATA
3. GO TO DATA AND SELECT GOAL SEEK
4. CHANGE THE DATA ACCORDING TO THE QUESTION
5. YOU WILL GET THE DESIRED RESULT.

23
HARSH CHOPRA 0201BBA078

24
HARSH CHOPRA 0201BBA078

25
HARSH CHOPRA 0201BBA078

LAB WORK – 15
Q. Create a record or table of BBA (1ST Sem)
consisting of the following fields:
a. [Link](number)
b. Name (text)
c. Date of birth(date)
d. Age (should not be less than 18)
e. Marks (not more than 100)
f. Remarks
g. For the above record, apply the appropriate data
validation.
Steps-

1. Open Excel
2. Write the headings required
3. For data validation, select the column and click on Data option
4. Go to data validation option, enter the required information and click on okay.

26
HARSH CHOPRA 0201BBA078

DATA VALIDATION ON D.O.B-

DATA VALIDATION ON AGE

27
HARSH CHOPRA 0201BBA078

DATA VALIDATION ON MARKS

PART-B: For the record created above for BBA, protect your worksheet by providing password

1. Hide/unhide cells
2. Allow users to select columns
3. Allow users to sort cells
4. Freeze and unfreeze the rows and columns.

Steps-

1. Select the column and right click the selected column

28
HARSH CHOPRA 0201BBA078

2. Further select hide option.

3. For protecting your file, go to file option

4. Click on information and further click protect workbook
5. Then click protect current sheet

6. Click on view tab and go to freeze panels option

7. Freeze and unfreeze the columns and rows as desired

29
HARSH CHOPRA 0201BBA078

30
HARSH CHOPRA 0201BBA078

LAB WORK - 16
Q. Assuming you have 10 mins. time to prepare a presentation on your new
business idea or product of your choice or your dream future venture and gain
attention of an angel investor to earn initial investment amount.
-Prepare an attention grabbing 2 slide presentation using template (excluding
introduction and thank you slide) Save the ppt with your name and take screen
shots

STEPS:
1. FIRST SLIDE AS INTRODUCTION

2. SECOND SLIDE AS BUSINESS PLAN

INTRODUCTION

31
HARSH CHOPRA 0201BBA078

3. THEN TELL ABOUT PROCEDURE OF YOUR

BUSINESS PLAN

4. FINAL SLIDE WILL BE OF THANK YOU

32
HARSH CHOPRA 0201BBA078

33
HARSH CHOPRA 0201BBA078

LAB WORK – 17
Q. Create a presentation on Types of Memory having
a table for the Types of Memory
and then create hyperlinks on the types of Memory in
the master slide that opens new
slides for it.
STEPS:
1. Open power point
2. Prepare your presentation

3. For hyperlink, select the text, go to hyperlink and add the hyperlink as required

34
HARSH CHOPRA 0201BBA078

35
HARSH CHOPRA 0201BBA078

LAB WORK – 18
Q. Create a presentation on types of Operating
Systems with different themes and
apply the animation effects on it. For the presentation
created apply the different slide
show options and protect the presentation to restrict
unauthorized access.

APPLY DIFFERENT STYLES IN PRESENTATION

36
HARSH CHOPRA 0201BBA078

PROTECT THE FILE BY APPLYING PASSWORD

37
HARSH CHOPRA 0201BBA078

LAB WORK – 19
Q. Create a ppt on the topic Windows versions. Apply
slide number, header and
footer on the slides
STEPS:
1. Prepare your presentation
2. Go to the insert option
3. Apply header and Footer

38
HARSH CHOPRA 0201BBA078

LAB WORK – 20
Q. Create a quiz on the subject Computer application
for business (10 slides)

39
HARSH CHOPRA 0201BBA078

40
HARSH CHOPRA 0201BBA078

41
HARSH CHOPRA 0201BBA078

42
HARSH CHOPRA 0201BBA078

43