Anish It Practical

DEPARTMENT OF MANAGEMENT STUDIES
Practical File for IT Skills Lab–1

Session: 2024-2025
Subject Code: BMB151
SUBMITTED BY: SUBMITTED TO:

ANISH KUMAR DR. SUDHA SWAROOP
Admission No.: 24160CN426
Section: B
ANISH KUMAR Admission No.-24160CN426

INDEX
S. No. Name of Practical Signature &

Remarks
To Create and Design Admission/Enquiry Forms in MS

1
Word.
2 To design E-book cover pages / Magazine front/ books

front/back page using cover page option from Insert
menu in MS Word.
To create Business Cards using Shapes, text, and colours

3
in MS Word.
To use smart art and create organization charts in

4
MSWord.
5 To make books content page or index page in MS Word.
6 To insert image into the shape in MS Word.
To create a chart and show the products

7 pricescomparison between 2015, 2016, and 2017 in MS
Word.
To create letterhead, Identity card of any company or

8 institution that you got and insert the Watermark with
that company name in the document in MS Word.
9 To decorate word document with page border, content

border, add pattern and write beautiful text in it in MS
Word.

10 To write 10 lines or 10 sentences and then change the
font, style, colour, and size of each sentence. Make each
one different than previous and next in MS Word.
11 To demonstrate the use of Mail Merge in MS Word with

MS Excel.
12 To illustrate the use of MACRO in MS Word.
13 To insert hyperlink in MS Word.
14 To demonstrate the use of OLE (Object Linking and

Embedding) in MS Word.
15 To use the data given, get the sum of all the figures
within the range in MS Excel.
16 To use the given data, calculate the archived target off

employees by subtraction of all the figures within the
range in MS Excel.
17 To use the information given in the table below,

calculate the total amount payable by the company to the
employees in MS Excel.
18
On the occasion of children’s day school decided to

distributes toffees in their school then calculate the total
number of toffees each student will get from the given
data in MS Excel.

19 Calculate the students total marks, percentage and
average marks of the given data in MS Excel.
20 To enter the data given, get the sum of all the figure
within the range in MS Excel Calculate the totals for
each salesperson and get the grand total.
21 A payroll consists if a Basic Pay, dearness Allowance,

Travelling Allowance, House rent allowance, Gross
Salary, Provident fund, Profession tax, and Net Salary.
The DA is 40% of basic pay, TA is 30% of basic pay,
HRA is 15% of basic pay if house, PF is 12.5% of basic
pay and the P. Tax is applied by salary in between table
given.
22 Assume you are the Accountant of Stationery Supplies

Ltd. Below is the current payroll in the workbook OLD
PAYROLL.
The salary review is given to you in the workbook

INCREMENT in MS Excel.
Required:
Using formulas, you are required to update the payroll

with the changes in a blank worksheet. This new blank
sheet is in the workbook NEW PAYROLL.
23 You are in charge of a young and growing business.

You have identified the various factors (sources of
revenue and expenses) that influence the business as
shown in the table below. Use the figures provided and
the layout to create a financial projection model for the
business for the next six years in MS Excel.
24 From the data given create pie chart in MS Excel.
25 Find the correlation of the given data in MS Excel.
26 Find the regression of the given data in MS Excel
27 Use data in the given vertical table by using VLOOKUP

function and data validation tool in MS Excel
Use data in the given horizontal table by using

HLOOKUP function and data validation tool in MS
28 Excel
Prepare a profit and loss account of the given company

29 details in MS Excel
Prepare a balance sheet account of the given company

30 details in MS Excel
Calculate the monthly cash flow report which includes

total cash in, total cash out and closing balanve and of a
31 company in MS Excel
32 To change your slide layout in MS Power Point
To change your slide’s background colour in MS

33
PowerPoint.
To make design changes that will apply to all slides in

34
MS PowerPoint.
35 To create new slides in MS PowerPoint.

To view all of your slides in a storyboard format in MS
36
PowerPoint.
37 To move text elements in MS PowerPoint.
38 To change typeface in MS PowerPoint.
39 To create a new text box in MS PowerPoint.
40 To add lines or shapes in MS PowerPoint.
41 To change line weight in MS PowerPoint.

To move overlapping elements to the front or back in
42
MS PowerPoint.
43 To fill (or un-fill) a shape in MS PowerPoint.

44 To add shadows to text in MS PowerPoint.
45 To add clipart in MS PowerPoint.
To have lists appear one line at a time in MS
46 PowerPoint.
To turn text into a hyperlink to link to other slides in
47
MS PowerPoint.
48 To add a movie in MS PowerPoint.
49 To add a sound to your slide show in MS PowerPoint.
50 To add a transition between slide in MS PowerPoint.

To make slides advance automatically in MS
51 PowerPoint.

PRACTICAL NO.: 01
Objective: To Create and Design Admission/Enquiry Form

Step :01- Open MS Word
Step:02 - Write and Make the form, Insert Table.

PRACTICAL NO.:02
Objective: To design E-book cover pages/Books front/back page in MS

Word
Step:01- Open MS Word
Step:02- Click Insert> InsertCover Pages
202

Practical NO.:03
Objective–To create Business Card Using Shapes Text andColours:
Step:01 -Open MS word

Step:02 -Click on insert option
Step:03 -Click the shapes > select the shape > edit it according to yourself.
ANISH KUMAR wallmart ENTERPRISES

Name – ANISH KUMAR
Contact no. –9905921191
Email– [email protected]

PRACTICAL NO.:04
Objective: To use smart art and create organization charts in MS

Word.
Step:02- Click on insert option
Step:03- Click on SmartArt > select the Chart > edit
President
Secretary
Operations Marketing Finance

Manager Manager Manager

PRACTICAL NO.:05
Objective: - To make books content page or index page in MS Word.

Step:02- Click on insert option.
Chapter Table of Contents Page No.

COVER PAGE a
CERTIFICATE OF COMPETITION b
ACKNOWLEDGEMENT C
TABLE OF CONTENT d
1 INTRODUCTION 1–3
Need for the Study 4
Signs and symptoms 5 – 22
Maternal/pregnancy changes 23 - 29
Nutrition during pregnancy 30 – 36
Exercise during pregnancy 37 - 43
Meditation during pregnancy 44 – 45
Sleep during pregnancy 46 - 49
Dental care during pregnancy 50 - 54
2 LITERATURE REVIEW 55 – 56
Depression 56 – 57
Maternal depression 57 – 63
Anxiety 63 – 64
Maternal anxiety 64 – 66
Comorbidity of 66
depression&anxiety
Shared case model of healthcare 66 – 68
Unit summary 69
3 METHODOLOGY OF RESEARCH 70 – 71
Variables of the study 71

PRACTICAL NO.:06
Objective: - Insert Image into The Shape

Step:02- Insert Menu >Select Shape >Insert Image>Bring Behind Text

PRACTICAL NO.:07
Objective: - Create a chart and show a product price between 2015,2016

and 2017
Step:02- Insert Menu >Chart
Step:03 - FilltheChart data and excel sheet.
PRICES COMPARISON
20000
18000
16000
14000
12000
10000
8000
6000
4000
2000
0
2015 2016 2017 2018
Series 1 Series 2 Series 3

PRACTICAL NO.: 08
Objective: - To Create letterhead, identity card of any company or

institution that you got and insert the Watermark with the company in the
document in MS Word.
Step:02- Insert Picture>Add Watermark.

PRATICAL NO.: 09
Objective: -To decorate Word Document With page border, containborder

add patternand white beautiful text in it MS Word.
Step:02- write text >page Layout>add Page border>contain
border>pattern

PRACTICAL NO.: 10
Objective:- Write 10 Lines and then change the font ,style, colour
and size of each sentences.
Step:02- Type 10 lines
Step:03- click home >select font>change font size>and change font colour

PRACTICAL NO.: 11
Objective: To demonstrate the working of Mail Merge in MS Word from MS Excel.
Step 1: Write a letter in MS Word with some fields to be customised like Recipient’s Name,
Address Contact No.etc (the records which will vary person to person) which is to be sent to
multiple contacts.
Step 2: Create the contact information list in MS Excel, so that instead of creating letter
separately for each contact we can fetch the contact details from MS Excel automatically.
Step 3: Carefully assign the Header Row in MS Excel, as each Header in MS Excel will replace
a placeholder in MS Word document.
Step 4: Click on mailings tab in MS Word.
Step 5: Click on select recipients’ option and select use an existing list.
Step 6: Browse and select the MS Excel contact list and check on First Row of Data contains
Column Headers.
Step 7: Click Ok.
Step 8: Select Edit Recipient List if you need to edit any contact’s record.
Step 9: Select Greeting Line and customize it.

MS Word Document to be Mail Merged

Customize Recipient’s Name in Address
Customize Address Block

Preview Results
Finish and Merge

Practical No. 12
Objective: To create and run Macro in MS Word.

Step 1: Open MS Word and Click on View Tab.
Step 2: Select Macro and click on Record Macro option.

Step 3: Select macro and click on Record macro-option.

Step 3: Start performing the task you want to record in your Macro, here we are creating the
layout of a letter.
Step 3: Select Stop Recording.
Step 4: Now to use Macro Click Macro and Select View Macro on a new file.

Step 5: Click Run Macro to automatically perform the above task.

PRACTICAL NO.: 13
Objective: To create a Hyperlink in MS Word.
Step 1: Open MS Word and write any text to be converted to hyperlink
Step 2: Select the text to be converted to a hyperlink.

Step 3: Click Insert > Select Hyperlink > Paste Web Address in the dialog box and click ok.
Step 4: Press Ctrl + Click to follow the link.

PRACTICAL NO.: 14
Objective: To use OLE (Object Linking and Embedding) in MS Word.
To Link
Step 1: Open MS Word -> Click Insert -> Select Object.
Step 2: Select Create from File option, and browse for the respective file.
Step 3: Select any file, check on Link to File and click ok.
The file will be linked on the MS Word document as below,

Changes made to the source document will be reflected in MS Word (include object again to see
changes).
To Embed
Step 1: Open MS Word -> Click Insert -> Select Object.
Step 2: Select Create New and the type of file to be embedded.
Step 3: Make changes to the file embedded as per requirement

PRACTICAL NO. :15
Objective: To use the given data to get sum of all the figures within the range in MS Excel.
SOLUTION
STEP:01=Open MS Excel
STEP:02=Copy the Question
FORMULA: (=SUM(VALUE1:VALUE2))

PRACTICAL NO. :16
Objective:-To use the given data, calculate the archived target off employees by substraction of all
the figures within the range in MS Excel.
Archived
Employee Name Sales Amount Target Amount Target
Pragati 28800 25000
Prerna 22500 20000
Nishtha 24400 20000
Preeti 13800 10000
Misthika 16900 15000
Palak 10200 10000
Neha 19800 15000
Payal 18500 15000
Parakh 14400 10000
Nandini 13200 10000
Poonam 17900 15000
GRAND TOTAL OF ARCHIVED TARGET
STEP 1: Open MS Excel and copy the table
Step 2 : Calculate the archived target by using the formula

PRACTICAL NO. :17
For Substraction - =(Sales amount cell – Target amount cell)
Objective:- Using the information given in the table below, calculate the total
For grand total - =(Select all archived target cell)
amount payable by the company to the employees.

PRACTICAL NO. :17
Objectives : Using the information given in the table below, calculate the amount payable and
total amount payable by the company to the employees.

SOLUTION
STEP :01=Open MS Excel
FORMULA: For multiplication [=(VALUE1*VALUE2)]
For sum [=SUM(VALUE1:VALUE2)]

PRACTICAL NO. :18
Objectives:-On the occasion of children’s day school decided to distributes toffees in their
school then calculate the total number of toffees each student will get from the given data in MS
Excel.
G.L. BAJAJ
INSTITUTE OF
TECHNOLOGY AND
MANAGEMENT
Total no of No. of toffees each student will
Students Total no of toffees students get
Class 1 200 40
Class 2 144 72
Class 3 165 55
Class 4 136 68
Class 5 148 74
STEP 1: Open MS Excel copy the question .
STEP 2: Calculate total number of toffees each student will get by using formula
For Division - =(total no of toffees/total number of students)

PRACTICAL NO. :19
Objectives: Calculate the students total marks, percentage and average marks of
the given data in MS Excel.
G.L BAJAJ EXAM

REPORT
Total Marks
Obtained
Students Name Exam 1 Exam 2 Total Marks Percentage
Pragati 98 89
Neha 93 82
Prena 89 76
Nishtha 95 88
Apoorva 78 92
Deepti 85 90
Average Marks
Grand Total Marks
STEP 1: Open MS Excel copy the question.
STEP 2: Calculate total marks, percentage, average marks and grand total marks by using formula.
Calculation Formula
Total marks =SUM(Exam 1 +Exam 2 cell)
Percentage =(Total marks /200*100)
Average marks =AVERAGE(Select all the cell)
Grand total marks =SUM(Select total marks cell)

PRACTICAL NO. :20
Objective:To enter the data given, get the sum of all the figure within the range in MS
Excel Calculate the totals for each salesperson and get the grand total.
1 Calculate the totals for each salesperson get the grand total.
2 Format the worksheet as follows:

Make all the Total bold, two decimal places, comma, centre the title across columns
A-E and make it size 16, bold and italics
Stationery supplier
ltd
DATE SALESPERSON ITEMS RECEIPT NO VALUE
21-Nov CARL TOYS 1238 1782.1
26-Nov CARL STATIONERY 1255 4853.55
26-Nov CARL TOYS 1395 51.35
CARL'S TOTAL
21-Nov JOHN CARDS 1141 91.15
24-Nov JOHN BOOKS 1982 442.6
21-Nov JOHN TOYS 1885 561.5
26-Nov JOHN TOYS 1875 62.75
JOHN'S TOTAL
22-Nov JUDY BOOKS 1032 234.5
26-Nov JUDY SPORTS GOODS 1920 472.6
JUDY'S TOTAL
25-Nov MARY TOYS 1774 364.15
MARY'S TOTAL
22-Nov SUSAN ELECTRONICS 1160 52.95

23-Nov SUSAN CARDS 1075 81.6
23-Nov SUSAN OTHERS 1745 132.95
24-Nov SUSAN SPORTS GOODS 1662 2580.1
SUSAN'S TOTAL
GRAND TOTAL
3 Save the worksheet as stationery Analysis.
1) Calculate the total for each salesperson and get the grand total:
2) Format the worksheet as follows:
Mark all the totals bold, two decimal places, commas,centre the title across column A-E and make
it 16, bold and italic.

3) Put a double round the whole table and a single line border inside the table.
4) Save the worksheet as Stationery Analysis
STEP 1: Open MS Excel
STEP 2: Copy the question
STEP 3: Add values by using formula
FORMULA
For sum- =(select all the cells you want to add)
For grand total- =SUM(Select carl’s total cell + john’s total cell + Judy’s total cell + Mary’s total cell +
Susan’s total cell)

PRACTICAL NO. :21
Objective: A payroll consists if a Basic Pay, dearness Allowance, Travelling Allowance,
House rent allowance, Gross Salary, Provident fund, Profession tax, and Net Salary. The DA is
40% of basic pay, TA is 30% of basic pay, HRA is 15% of basic pay if house, PF is 12.5% of
basic pay and the P. Tax is applied by salary in between table given.
SALARY IN BETWEEN TAX AMOUNT

Below 5000 0
5000-6000 60
6000-10000 80
10000-15000 100
15000-20000 150
In the given below worksheet, indicate in each cell what will be inserted, that is- valued or a formula. In
the case of a formula, write down the formula in the cell.
PAYROLL
OF UP
INDUSTRIES
BASIC House GROSS NET
DEPARTMENT PAY DA(40%) TA(30%) (Yes/No) SALARY PF(12.5%) P.TAX SALARY
SALES 25000 NO
AUDIT 14000 YES
MEDIA 8000 NO
SALES 18000 NO
ADMINISTRATION 9000 NO
ACCOUNTANT 4000 NO
MEDIA 16000 NO
SALES 19000 NO
ACCOUNTANT 8000 NO
AUDIT 12000 YES
STEP 1 :Open MS Excel
STEP 2 :Copy the question
STEP 3 :Calculate DA, TA, HRA, Gross Salary, PF,P. Tax, Net Salary by using the formula.

PAYROLL CATEGORY FORMULA
DA (BASIC PAY*40%)
TA MAX(BASIC PAY*30%,1500)
IF(BASIC PAY="NO",BASIC PAY
HRA CELL*15%,0)
IF(HOUSE ALLOTED="NO",BASIC PAY
Gross Salary CELL*15%,0)
PF (BASIC PAY*12.5%)
Net Salary (Gross salary cell-PF Cell-P. Tax)

PRACTICAL NO. :22
Objective: Assume you are the Accountant of Stationery Supplies Ltd. Below is
the current payroll in the workbook OLD PAYROLL. The salary review is given to
you in workbook INCREMENT in MS Excel.
OLD PAYROLL
The following salary review is given to you in the workbook INCREMENT.
INCREMENT

Required:
Using formulas, you are required to update the payroll with the changes in a blank
worksheet. This new blank sheet is in the workbook NEW PAYROLL.
SOLUTION
FORMULA: For sum [=SUM(VALUE1:VALUE2)]
Allowance:25%Of Basic pay
Gross salary: Basic pay +Allowance
Deduction:12% of Gross salary
Net salary: Gross Salary-Deduction

PRACTICAL NO. :23
Objective: You are in charge of a young and growing business. You have
identified the various factors (sources of revenue and expenses) that influence the
business as shown in the table below. Use the figures provided and the layout to
create a financial projection model for the business for the next six years. The
parameters are given on Sheet 2.

SOLUTION
STEP:01=Open MS Excel
FORMULA: For sum [=SUM(VALUE1:VALUE2)]
Allowance:25%Of Basic pay
Gross salary: Basic pay+Allowance
Deduction:12% of Gross salary
Net salary:Gross Salary-Deduction

PRACTICAL NO. :24
Objective: From the data given in the table below, create a Pie Chart to show the
distribution of the total amount amongst the various salesmen.
SOLUTION
STEP:03=Insert Menu > Pie Chart

PRACTICAL NO. :25
OBJECTIVE: Find the correlation of the given data in MS Excel.
TEMPERATURE(IN DEGREE
CELCIUS) ICE CREAM SALES
18 350
22 375
24 400
25 435
27 450
29 500
30 540
32 590
40 625
STEP 1: Open MS Excel and copy the question
STEP 2: Select a empty cell > calculate correlation by using formula-

=CORREL(select x&y cell)

PRACTICAL NO. :26
Objective: Find the regression of the given data in MS Excel.

TEMPERATURE(IN DEGREE
CELCIUS) ICE CREAM SALES
18 350
22 375
24 400
25 435
27 450
29 500
30 540
32 590
40 625
STEP 1: Open MS Excel and copy the question.
STEP 2: We have to add analysis tools for calculating the scientific data like correlation, regression and
many more.
a) Go to file menu> option> Add-ins> select the analysis tool pak and click on Go.
b) Select the analysis toolpak and click o

c) Data analysis tool pak is added in your data menu section in the upper right corner.
STEP 3: For calculating regression go to data menu > select data analysis tool pak> select regression
and click okay.

STEP 4: Regression popup box opens > input Y range (select ice cream sale cells), X range (temperature
cell)
STEP 5 :Click on labels checkbox > click on output range (select any empty cell) > click on residuals
checkbox > click ok.

PRACTICAL NO. :27
OBJECTIVE: Use data in the given vertical table by using VLOOKUP function and data validation tool in
MS Excel.
NAME DEPARTMENT SALARY

Pragati SALES 15791
Neha AUDIT 15537
Prerna MEDIA 15506
Nishtha SALES 15417
Preeti ADMINISTRATION 15008
Palak ACCOUNTANT 14969
Mishthika MEDIA 14651
Payal SALES 14618
Muskaan ACCOUNTANT 14553
Praishi AUDIT 14508
STEP 1: Open MS Excel and copy the table
STEP 2: Go to the data tab and select the Data Validation.

STEP 3: Select the List in the Allow.
STEP 4: In the Source box, Select the range without the header in the Table.
STEP 5: Finally, press Enter.
STEP 6: Your Data Validation drop- down list will appear.
STEP 7: Now use VLOOKUP FUNCTION FORMULA for what you want to lookup in the data, here I am
using lookup formula to look the Pragati’s department and salary.
FORMULA - =VLOOKUP(LOOKUP value, table array, column index number, range lookup)

PRACTICAL NO. :28
OBJECTIVE:Use data in the given horizontal table by using HLOOKUP function and data
validation tool in MS Excel.
NAME Pragati Neha Prerna Nishtha Preeti Palak Mishthika Payal Muskaan Praishi
DEPARTMENT SALES AUDIT MEDIA SALES ADMINIS ACCOUNT MEDIA SALES ACCOUNT AUDIT
SALARY 15791 15537 15506 15417 15008 14969 14651 14618 14553 14508
STEP 1 :Open MS Excel and copy the table
STEP 2 :Go to the Data tab and select the Data Validation.
STEP 3 :Select the List in the Allow.
STEP 4 :IN the Source box, select the range without the header in the Table.
STEP 5 :Finally, press Enter.
STEP6 :Your Data Validation drop- down list will appear.
STEP 7 : Now use HLOOKUP function for what you want to lookup in the data,
here I am using lookup formula to look the Pragati’s department and salary.
FORMULA - =HLOOKUP(lookup value, column array, column index number,

range lookup)

PRACTICAL NO. :29
OBJECTIVE:Prepare a profit and loss account of the given company details in MS

Excel.
DETAILS AMOUNT
Rent 500
Salary 2000
Gross Profit 1000
Interest received 1000
Commission received 2000
Commission paid 1500
Discount received 2500
Discount paid 3000
Advertisement 1000
Bad debts 3500
STEP 1: Use the above data and distinguish the particulars in debit and
credit side.
STEP 2: Open MS Excel and draw the profits and loss format of the given
company.
STEP 3: Enter the data in the profit and loss format.
STEP 4: Calculate the given data by using formula
FORMULA
Grand Total - =SUM(select the cell values)

PRACTICAL NO. :30
Details Amount
264761
Cash 111273
Outstanding expense 20000
Accounts receivable 74018
Accounts payable 57003
Prepaids 4500
Debt 377549
OBJECTIVE: Prepare a balance sheet account of the given
company details in MS Excel.

STEP 1: Use the above data and distinguish the paerticulars in liabilities
and assest table side.
STEP 2: Open MS Excel and draw the balance sheet format of given
company.
STEP 3; Enter the data in the balace sheet format
STEP 4: Calculate the given data by using formula
FORMULA
Grand total - =SUM(select the amount

PRACTICAL NO. : 31
OBJECTIVE: Calculate the monthly cash flow report which includes total cash
in, total cash out and closing balance and of a company in MS Excel.
CASH FLOW
REPORT OF UP
INDUSTRIES
2021 - 2022
APR MAY JUNE JULY AUG SEP OCT NOV DEC JAN FEB MAR
Opening
balance
Cash in
Bank loan 60000 20000 10000
Sales 5000 3000 8000 2000 6000 9000 12000 15000 17000 7000 4000 1000
Other
income 2000 1000 5000 850 1190 1480 750 350 500 900
Total cash
in
Cash out
Loan
payment 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100 1100
Loan
interest 250 290 320 360 280 350 400 390 300 200 200
Advertising 1000 1200 1200 1200 1200 1200 1200 1200 1200 1200 1200 1200
Stationery 7000 7000 7000
Website 5000 3000 2800 2500
Total cash
out
Closing
Balance
STEP 1 :Open MS Excel copy the question

STEP 2 :Calculate total cash in, total cash out, opening balance and
closing balance by using formula.

Particulars Formulas
Total cash in =SUM(Select all the cash in values cell)
Total cash
out =SUM(Select all the cash out values cell)
Closing =(Opening balance cell + total cash in cell -
Balance total cash out cell)

PRACTICAL NO. :32
Objective: To change your slide layout
Open MS PowerPoint
Click on Design > Select any Layout
Go to Home Tab > Select Layout and choose any desired layout.

PRACTICAL NO. :33
Objective: To change your slide’s background colour
Open MS PowerPoint
Click on Design -> Select Format Background
Choose Solid Fill and select any desired
colour.

PRACTICAL NO. :34
Objective: To make design changes that will apply to ALL slides
Open MS PowerPoint
Click on Design -> Select any Layout

IT SKILL LAB 1(BMB151)
PRATICAL NO.:35
Objective: To create new slides
Open MS PowerPoint
Click on Home Tab -> Select New Slide option.

PRATICAL NO.:36
Objective: To view all of your slides in a storyboard format
Open MS PowerPoint
Click on View -> Select Slide Sorter.
Click on View -> Select Normal to return to Design View.

PRATICAL NO.:37
Objective: To move text elements
Open MS PowerPoint
Type any text.
Select the word(s), then click and drag the box to a new location.

IT SKILL LAB 1(KMBN 151)
PRACTICAL NO. 38
Objective: To change typeface
Open MS PowerPoint
Select the word(s), then use the Format tab/Text Tools to change formatting.

PRACTICAL NO. :39
Objective: To create a new text box
Open MS PowerPoint
Click Insert -> Select Text Box

Click and drag to draw the Text Box and type inside to Text Box to add text

PRATICAL NO.:40
Objective: To add lines or shapes
Open MS PowerPoint
Click Insert -> Select Shapes.

PRATICAL NO.:41
Objective: To change line weight
Open MS PowerPoint
Click Insert > Select Shapes > Choose Line.
Click Format Tab > Select Shape Outline > Select Weight and choose any desired
weight.

PRATICAL NO.:42
Objective: To move overlapping elements to the front or back
Open MS PowerPoint
Draw/Insert the overlapping elements/pictures.
Choose any one element by clicking on it.
Click on Format Tab > Select Send Backward / Bring Forward to move the
elements.

PRATICAL NO.:43
Objective: To fill (or unfill) a shape
Open MS PowerPoint
Click Insert -> Select Shape -> Click and Drag to draw the Shape.
Click Format Tab ->Select Shape Fill -> Choose Colour/ picture/ Gradient/
Texture to be filled.

PRATICAL NO.:44
Objective: To add shadows to text
Open MS PowerPoint
Type any text.
Select the text and Click Format Tab.
Click Shape Effects -> Select Shadows -> Choose any desired style of shadow.

PRATICAL NO.:45
Objective: To add clipart
Open MS PowerPoint
Click Insert -> Select Icons -> Choose any desired Icon.

PRATICAL NO.:46
Objective: To have lists appear one line at a time
Open MS PowerPoint
Type any Text
Click Animations Tab -> Select text (lines) one by one and choose
desiredanimation.

PRATICAL NO.:47
Objective: To turn text into a hyperlink to link to other slides
Open MS PowerPoint
Type any text to be converted to hyperlink
Click Insert -> Select Link/Hyperlink
Select “Place in this Document” option.
Choose the slide you wish to link.
Click on the text using ctrl+click to land on the mapped slide.


PRACTICAL NO.:48
Objective: To add a movie
Open MS PowerPoint
Click Insert > Select Video.
Choose video either from the system or online.

PRACTICAL NO.:49
Objective: To add a sound to your slide show
Open MS PowerPoint
Click Insert Tab > Choose Audio > Choose either Sound from This PC or Record
Sound.
Locate your sound in your and click Insert

PRACTICAL NO.:50
Objective: To add a transition between slides
Open MS PowerPoint
Click Transition Tab -> Select any desired Transition.


Anish It Practical

Uploaded by

Copyright:

Available Formats

Anish It Practical

Uploaded by

Document Information

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

Anish It Practical

Uploaded by

Copyright:

Available Formats

DEPARTMENT OF MANAGEMENT STUDIES

Practical File for IT Skills Lab–1

Subject Code: BMB151

SUBMITTED BY: SUBMITTED TO:

ANISH KUMAR Admission No.-24160CN426

S. No. Name of Practical Signature &

To Create and Design Admission/Enquiry Forms in MS

2 To design E-book cover pages / Magazine front/ books

To create Business Cards using Shapes, text, and colours

To use smart art and create organization charts in

5 To make books content page or index page in MS Word.

6 To insert image into the shape in MS Word.

To create a chart and show the products

To create letterhead, Identity card of any company or

9 To decorate word document with page border, content

ANISH KUMAR Admission No.-24160CN426

11 To demonstrate the use of Mail Merge in MS Word with

12 To illustrate the use of MACRO in MS Word.

13 To insert hyperlink in MS Word.

14 To demonstrate the use of OLE (Object Linking and

16 To use the given data, calculate the archived target off

17 To use the information given in the table below,

On the occasion of children’s day school decided to

ANISH KUMAR Admission No.-24160CN426

21 A payroll consists if a Basic Pay, dearness Allowance,

22 Assume you are the Accountant of Stationery Supplies

The salary review is given to you in the workbook

Using formulas, you are required to update the payroll

23 You are in charge of a young and growing business.

24 From the data given create pie chart in MS Excel.

25 Find the correlation of the given data in MS Excel.

26 Find the regression of the given data in MS Excel

27 Use data in the given vertical table by using VLOOKUP

ANISH KUMAR Admission No.-24160CN426

Use data in the given horizontal table by using

Prepare a profit and loss account of the given company

Prepare a balance sheet account of the given company

Calculate the monthly cash flow report which includes

32 To change your slide layout in MS Power Point

To change your slide’s background colour in MS

To make design changes that will apply to all slides in

35 To create new slides in MS PowerPoint.

38 To change typeface in MS PowerPoint.

39 To create a new text box in MS PowerPoint.

40 To add lines or shapes in MS PowerPoint.

41 To change line weight in MS PowerPoint.

43 To fill (or un-fill) a shape in MS PowerPoint.

ANISH KUMAR Admission No.-24160CN426

48 To add a movie in MS PowerPoint.

49 To add a sound to your slide show in MS PowerPoint.

50 To add a transition between slide in MS PowerPoint.

ANISH KUMAR Admission No.-24160CN426

Objective: To Create and Design Admission/Enquiry Form

ANISH KUMAR Admission No.-24160CN426

Objective: To design E-book cover pages/Books front/back page in MS

ANISH KUMAR Admission No.-24160CN426

Objective–To create Business Card Using Shapes Text andColours:

Step:01 -Open MS word

ANISH KUMAR wallmart ENTERPRISES

ANISH KUMAR Admission No.-24160CN426