GURU GOBIND SINGH INDRARASTHA UNIVERITY

NEW DELHI

ITB PRACTICAL LAB

Submitted in particular fulfilment of the requirement
For the award of degree of BBA
Session: 2022-2025
SUBMITTED AT:
DELHI SCHOOL OF PROFECIONAL STUDIES AND
RESEARCH ROHINI, NEW DELHI-25
[AFFILATED TO GGSIPU- NEW DELHI]

Submitted To: - Submitted by: -

Mrs. Princy Aggarwal Parikshit BBA 1 A
02312501722
 INDEX
Sr Practical Name T. SIGN
NO.
1 Word document to create your Resume
2 Create a word document to use bullets and
numbering of different types
3 Word document t create a mail merge letter
4 Create a word document to insert citation
5 Create a word document to insert Footers &
Endnotes
6 Create a document create table of contents
7 Create word document to insert caption
8 Create a word document to insert header, footer,
Pictures and Watermark
9 Word document showing usage of Macros
10 Create a report in MS Excel containing the pay
details of the employee. (Use formulas or
functions to calculate DA, HRA, GROSS and TAX
etc.)
11 Create a simple bar chart to highlight the sales of a
company for 3 different periods
12 Excel file to implement logical function (if, or, and)

13 Excel file to implement Sorting

14 Excel file to implement Filter
15 Excel file to implement text functions (proper,
upper, lower, find, replace, left, right, mid,
concatenate)
16 Excel file to implement financial functions.
17 Excel file to implement statistical functions (sum if,
count if, average if)
18 Create a MS-Excel file to show Protection of cells,
sheet and file
19 Excel file to implement date and time functions
(today, now, year, hour, minute, day, workday)

20 PowerPoint presentation (including Animation,

Transition, Pictures, SmartArt, table etc.)

Practical-1
 Word Document to
create Your Resume
 CURRICULM VITAE

PARIKSHIT
MOBILE: +91 8851007519
Email id- Parikshity@14gmail.com

OBJECTIVE

To be in an environment where I can work up to my full potential,

enhance my skills and become a good asset to the organisation.

QUALIFICATION

QUALIFICATION INSITUTE BOARD YEAR PERCENTAGE

Grade x Universal Public school, 2020 65%
CBSE
Higher Secondary Universal Public school, 2022 75%
CBSE

PERSONAL SKILLS

 Excellent verbal communication skills.

 Ability to work independently or as a part of team work.
 Proven Leadership skills and ability to motivate.
 Highly organised and efficient.
 HOBBIES
 Reading newspaper
 Interacting with people
 Painting
 Listening Music
 Reading Motivational Books

PERSONAL BOOKS

o Date Of Birth: 26/06/2004

o Sex: Male
o Nationality: Indian
o Marital Status: Unmarried
o Category: OBC
o Language Known: English, Hindi
o Father’s Name: Arun Kumar Yadav
o Permanent Address: Vijay Enclave, Delhi

DECLARATION
I here by declare that all the Information given above is true to the
best of my knowledge.

Date: 22nd January 2023

Signature of Candidate
 Practical- 2

Create a Word
Document To Use
Bullets and
Numbering of
different types
Steps to insert bullets
❖ Click the Bullets button on the Formatting toolbar.
❖ Type the first item on your list, and press Enter.
❖ The next line will begin automatically with a new bullet.
❖ Type the next item on your list, and press Enter.
❖ When your list is complete, press the Enter key twice to
stop the bulleted list.

Steps to insert numberings

Click the Numbering button on the Formatting
toolbar.
❖ Type the first item on your list, and press Enter.
❖ The next line will begin automatically with the next number.
❖ Type the next item on your list, and press Enter.
❖ When your list is complete, press the Enter key twice to stop
the numbered list.
 Practical- 3

Word document to
create a mail merge
letter
Steps of mail merge
 In a blank Microsoft Word document, click on
the Mailings tab, and in the Start Mail Merge
group, click start mail merge

 Click Step-by-Step Mail Merge Wizard.

 Select your document type. In this demo we

will select letter.
 Click Next: Starting document.
 Select the starting document. In this demo we will
use the current (blank) document. Select Use the
current document and then
 Click Next: Select recipients.
 Note that selecting Start from existing document
(which we are not doing in this demo) changes the
view and gives you the option to choose your
document. After you choose it, the Mail Merge
Wizard reverts to Use the current document.
 Select recipients. In this demo we will create a new
list, so select Type a new list and then click Create

 Create a list by adding data in the New Address

List dialog box and Clicking Ok

 Save the list

 .
Note that now that a list has been created, the Mail
Merge Wizard reverts to Use an existing list and you
have the option to edit the recipient list
 Selecting Edit recipient list opens up the Mail
Merge Recipients dialog box, where you can edit
the list and select or unselect records. Click OK to
accept the list as is

Write the letter and add custom fields.

 Click Address block to add the recipients'
addresses at the top of the document.
 In the Insert Address Block dialog box, check or
uncheck boxes and select options on the left until
the address appears the way you want it to.

 Note that you can use Match Fields to correct any

problems. Clicking Match Fields opens up the
 Match Fields dialog box, in which you can
associate the fields from your list with the fields
required by the wizard

Press Enter on your keyboard and click Greeting

line... to enter a greeting.
 In the Insert Greeting Line dialog box, choose the
greeting line format by clicking the drop-down
arrows and selecting the options of your choice,
and then click OK

 Note that the address block and greeting line are

surrounded by chevrons (« »). Write a short letter
and click Next: Preview your letters.
 Preview your letter and click Next: Complete the
merge

 Click Print to print your letters or edit individual

letters to further personalize some or all of the
letters
To Rahul Mishra,
Date: 7th March,2023
Sub: Letter of Invitation for Farewell Party.
This is to inform you that, our college is organising
Farewell Party, for BCOM & BBA 1st Year Students. This
Party will be free for 1st year students. The Party will
be on 15th March, 2023 at College Hall.
Hoping to see your presence which will make our party
more colourful.
With thanks,
Regards,
Parikshit
 Practical- 4

Create a Word
document and to
insert citation
Steps to insert citation
 On the References tab, in the Citations &
Bibliography group, click the arrow next to Style
and click the style that you want to use for the
citation and source. For example, social sciences
documents usually use the MLA or APA styles for
citations and sources

 Click at the end of the sentence or phrase that you

want to cite.
 On the Reference tab, click Insert Citation and
then do one of the following

 To add the source information, click Add New

Source, and then, in the Create Source dialog box,
click the arrow next to Type of Source, and select
 the type of source you want to use (for example, a
book section or a website).
 To add a placeholder, so that you can create a
citation and fill in the source information later,
click Add New Placeholder. A question mark
appears next to placeholder sources in Source
Manager.
 If you chose to add a source, enter the details for
the source. To add more information about a
source, click the Show All Bibliography Fields check
box.
 Click OK when finished. The source is added as a
citation at the place you selected in your
document

Education is very important for all of us. Either

you are a child or old, it can help you at any age.
Education is a type of learning that can be achieved in
your school as well as in the playground because we
can learn from anywhere.
Education can help you in many ways, as it can
play a very important role in your overall development.
The earnestness of your learning can also make you an
allrounder. It is not always necessary to be scientific to
invent. Your knowledge and different perspectives can
also make you do things in a different way. For
example, it was Dr. Abdul Kalam’s way of thinking, that
he imagined of a flying machine thorough a bird,
discussed by his science teacher. Education helps us to
broaden our imagination and promote our way of
thinking. We should learn from others and develops
our own thoughts and this is the correct way of
learning. Every year, some sought of books are served
in each class but some students understand the true
essence of learning and perform in an extraordinary
way. You will be told about the same football
techniques every time, but some of us develop some
special types and techniques and apply our imagination
which leads them to success.
 Practical- 5

Create a word
document to insert
footnotes and
endnotes
Steps to insert footnotes and endnotes
 Click where you want to reference to the
footnote or endnote.
 On the References tab, select Insert Footnote
or Insert Endnote.

 Enter what you want in the footnote or

endnote.
 Return to your place in the document by
double clicking the number or symbol at the
beginning of the note.
What is computer?
A computer is a programmable electronic device 1 that
accepts raw data as input and processes it with a set of
instructions (a program) to produce the result as
output. It renders output just after performing
mathematical and logical operations and can save the
output for future use. It can process numerical as well
as non-numerical calculations. The term "computer" is
derived from the Latin word "compute" which means
to calculate. A computer is designed to execute
applications and provides a variety of solutions through
integrated hardware2 and software 3 components. It
works with the help of programs and represents the
decimal numbers through a string of binary digits. It
also has a memory that stores the data, programs, and
result of processing. The components of a computer
such as machinery that includes wires, transistors,
circuits, hard disk are called hardware. Whereas, the
programs and data are called software. It is believed
that the Analytical Engine was the first computer which
was invented by Charles Babbage in 1837. It used
punch cards as read-only memory. Charles Babbage is
also known as the father of the computer.
 component for controlling the flow of electrical
currents for the purpose of information processing
and system control.
 the physical components that a computer system
requires to function.
 the programs and other operating information
used by a computer
 Practical- 6

Word document
to create table of
contents
Steps to create table of
content
 Put your cursor where you want to add the table
of contents.
 Go to References > Table of Contents. and choose
an automatic style

 If you make changes to your document that affect

the table of contents, update the table of contents
by right- clicking the table of contents and
choosing Update Field.
 Table of contents
Average Function
Description.........................................33
Syntax ...............................................33
Remarks..........................................34
Note …………………………31
AVERAGE function
This article describes the formula syntax and usage of
the AVERAGE function in Microsoft Excel.
Description
Returns the average (arithmetic mean) of the
arguments. For example, if the range A1:A20 contains
numbers, the formula =AVERAGE (A1:A20) returns the
average of those numbers.
Syntax

AVERAGE (number1, [number2], ...)

The AVERAGE function syntax has the following
arguments:
▪ Number1 Required. The first number, cell reference,
or range for which you want the average.
 ▪ Number2, ... Optional. Additional numbers, cell
references or ranges for which you want the average,
up to a maximum of 255.
Remarks

▪ Arguments can either be numbers or names, ranges,

or cell references that contain numbers. ▪ Logical
values and text representations of numbers that you
type directly into the list of arguments are not
counted.
▪ If a range or cell reference argument contains text,
logical values, or empty cells, those values are ignored;
however, cells with the value zero are included.
▪ Arguments that are error values or text that cannot
be translated into numbers cause errors.
▪ If you want to include logical values and text
representations of numbers in a reference as part of
the calculation, use the AVERAGEA function.
▪ If you want to calculate the average of only the
values that meet certain criteria, use the AVERAGE IF
function or the AVERAGEIFS function.
Note: The AVERAGE function measures central
tendency, which is the location of the centre of a
group of numbers in a statistical distribution.
 Practical- 7

Create a word
document to insert
caption
Steps to insert caption
 Click the picture you want to add a caption
to.
 Click References > Insert Caption.

 To use the default label (Figure), type your

caption in the Caption box.
Content
FIGURE 1
................................................................................................15
FIGURE 2
..............................................................................................15
FIGURE 3
...........................................................................................15
FIGURE 4
............................................................................................16
FIGURE 5
........................................................................................16
 Figure: 1

Figure:2

Figure:3

Figure:4
Figure:5
 Practical:8

Create a word document to insert header,

footer, picture & Watermark
Steps to insert header, footer
 Go to Insert > Header or Footer.
 Choose the header style you want to use.
 Add or change text for the header or footer.
 To eliminate a header--like deleting it on
the title page--select it and then check the
Different First Page box.
 Select Close Header and Footer or press Esc
to exit.

Steps to insert picture

 On the Insert tab, in the Illustrations group, click
Picture.
 Locate the picture that you want to insert. For
example, you might have a picture file located in
Documents.
 Double-click the picture that you want to insert.

Steps to insert watermark

 In the Insert Watermark dialog, select Text and
either type your own watermark text or select
one, like DRAFT, from the list. Then, customize the
 watermark by setting the font, layout, size,
colours, and orientation. ...
 Select Ok.
 Practical- 9

Word document
Showing usage of
Macros
steps to use MACROS
 Place the cursor where you want to start recording
the macro.
 Click the Record Macro button. The Record Macro
window opens, where you can set up the macro’s
name, description, and triggering mechanism
before you record it.
 Give the macro a name. Notice that the macro will
be saved to the Normal template, meaning that it
will be available in other documents created using
that template. If you need it saved to another
template or document, make sure to specify that
here. Next, you can choose whether the macro
gets triggered to run by a button that can be
added to the Quick Access Toolbar, or a keyboard
shortcut key combination. This lesson will cover
adding a macro that uses a keyboard shortcut.
 Click the Keyboard button.
 Press the keyboard shortcut keys that you want to
use. Make sure to use a keyboard shortcut
combination that won’t interfere with any other
Word or system commands
 Click Assign.
 Click Close. The macro immediately begins
recording.
 Record the macro. While recording, the macro
captures keystrokes and buttons clicked, but text
selection made with the mouse will not be
recorded. Use the keyboard to select text and
move the cursor, if you want those actions
recorded. A Stop button will also appear on the
status bar while a macro is recording.
 Click the Stop button when you’re finished
recording.

The recording stops, and the macro is saved.

Good morning, Mam

Good morning, Mam

Good morning, Ma
 Practical- 10
Create a report in MS excel
containing the pay detail of
the employee. (Use formulas
or functions to calculate
Dearness allowance, house
rent allowance, gross and tax
Practical- 11
Create a simple bar chart to
highlight the sales of a
company for 3 different period
 Practical- 12

Create a MS excel file to

show protection of cells,
sheet, and file
Steps to show protection of cells, sheet and
file
 Select the cells you want to lock.
 On the Home tab, in the Alignment group, click the
small arrow to open the Format Cells popup
window.
 On the Protection tab, select the Locked check
box, and then click OK to close the popup.
 On the Review tab in the ribbon, in the Changes
group, select either Protect Sheet or Protect
Workbook, and then reapply protection. See
Protect a Worksheet or Protect a workbook
 Practical- 13

Excel file to
implement
sorting
 Practical- 14

Excel file to
implement filter
 Practical- 15

Excel file to
implement logical
functions (if, or, and)
Practical- 16
(Excel file to
implement text
function (proper,
upper, lower, find,
replace, left, right,
mid, concatenate)
 Practical- 17

Excel file to
implement financial
functions
 Practical- 18

Excel file to
implement statistical
functions (sum if,
count if, average if)
 Practical-19
Excel file to
implement data and
time functions
(today, now, year,
hour, minute, day,
workday)
 Practical-20
Power point
presentation
(including animation,
transition, pictures,
smart art, table etc.)