Front Page

1
Table of Content
MICROSOFT WORD
S.N. CONTENT PAGE
1.1 PROCEDURE TO CREATE SIMPLE 5
NEWS LETTER
OUTPUT 6 TO 8

1.2 PROCEDURE TO CREATE 9

GREETING CARD
OUTPUT 10

1.3 PROCEDURES TO CREATE A 11

COVER PAGE OF A PROJECT
REPORT
OUTPUT 12

1.4 PROCEDURES TO CREATE A MAIL 13

MERGE LETTER
OUTPUT 14

2
1.5 PROCEDURES TO CREATE A 15
MACRO FOR INSERTING A
PICTURE AND FORMATTING THE
TEXT
OUTPUT 16

MICROSOFT EXCEL
S.N CONTENT PAGE
2.1 PROCEDURES TO CREATE A 17
WORKSHEET WITH 4 COLUMNS,
ENTER 10 RECORDS AND FIND THE
SUM OF ALL COLUMNS
OUTPUT 18
2.2 PROCEDURES TO CREATE A 19
REPORT CONTAINING THE PAY
DETAILS OF THE EMPLOYEE
OUTPUT 20
2.3 PROCEDURES TO CREATE A SIMPLE 21
BAR CHART TO HIGH LIGHT THE
SALES OF A COMPANY FOR 3
DIFFERENT PERIODS

3
 OUTPUT 22
2.4 PROCEDURES TO CREATE A PIE 23
CHART FOR A SAMPLE DATA AND
GIVE LEGENDS
OUTPUT 24
2.5 PROCEDURES TO CREATE A MACRO 25
WHICH CREATES A LINE CHART
USING THE DATA IN THE
WORKSHEET
OUTPUT 26

MICROSOFT POWERPOINT:
S.N C ONTENT PAGE
3.1 PROCEDURES TO CREATE A SIMPLE 27&28
PRESENTATION TO DATABASE
OUTPUT 29 TO
32
3.2 PROCEDURES TO CREATE A SIMPLE 33
PRESENTATION ABOUT DISCIPLINE &34
OUTPUT 35 TO
39

4
3.3 PROCEDURES TO CREATE A SIMPLE 40&41
PRESENTATION ABOUT SOCIAL
MEDIA.
OUTPUT 42 TO
46
Lab Exercise 1.1
PROCEDURE TO CREATE SIMPLE NEWS LETTER:

1. Open MS Office-MS Word – File – New - Type the heading.

2. When ever you want to change the number of columns then go to
Insert – Break - Select the section break type as continuous - Click
OK.
3. Go to Format – Column - select the number of columns u want and
click ok.
4. Type news and when ever you need curser in the next column then
go to Insert - Break- now select Column Break – click Ok.
5. If you want picture to be inserted then go to Insert- Picture-From
file-and browse for the required picture/file-then click Insert.
6. Format the text by changing the font size and color by selecting the
required text and chose font size, style and color in the formatting
tool bar below the menu.
7. Formatting text can also be done by selecting the text and applying
the Wordart. For that go to Insert- Picture-Wordart- then chose
the style u Want and click Ok. To change the color of the wordart
text, right click on the text and go to Format Wordart.

5
6
7
8
Lab Exercise 1.2
PROCEDURE TO CREATE GREETING CARD:

1. Open MS Office-MS Word – File – New

2. Keep the cursor where you want to insert a picture and then go to
Insert-Picture-From file-and browse for the required picture/file-
then click insert.
3. In order to insert text on the picture go to Insert-Text box-and
draw it on the page. Enter the required text and Format the text
by selecting the required text and choosing font size, style and
Color in the formatting tool bar below the menu.
4. Select the text box and drag it on to the picture. Place it
whereever you want.
5. Select the text box on the picture and go to Format Text box –
select the Color and lines Tab- Make Fill Color to Nil and
Transparency to 100%.
6. Make Line Color to No Line –click Ok.
7. Go to the Format- Border and Shading- Select the Border tab and
the style and color of your choice-click OK.

9
हिन्दु िरुको मिान चाड हिजया दशमीको अिसरमा
हिशेष गरी दे शभररका युिा- यु िहििरुमा शान्ति, सदभाि
र ब्यन्तिगि, पाररवाररक र सामाहजक सम्बृहिको लाहग
लाग्ने ऊजाा प्राप्त िोस भन्दै निदु गाा मािासॅग प्राथना गदा छु

10
Lab Exercise 1.3

PROCEDURES TO CREATE A COVER PAGE OF A

PROJECT REPORT:
1. Open MS Office-MS Word – File – New
2. Type university name, project title, guide name etc
line by line. Select the text and click align center on
the standard tool bar. Keep the cursor where you
want to insert the institution logo and then go to
Insert-Picture-From File-and browse for the required
picture/file - then click insert.
3. Format the title of your project by selecting and
applying the Wordart. For that go to Insert- Picture-
Wordart- then chose the style you Want and click
Ok. To change the color of the wordart text, right
click on the text and go to Format Wordart- chose
the color- click ok
4. In order to insert the border for your project cover
page Go to the Format-Border and Shading- Select
the Border tab and the style and color of your
choice-click OK.

11
Tribhuvan University

Submitted by:
Ritika Dahal

Guided By:
Madhu Kumar Singh Sir
(Head of BBA and BBM Department)

12
Lab Exercise 1.4

PROCEDURES TO CREATE A MAIL MERGE LETTER:

1. Open MS Office-MS Word – File – New.
2. Type your letter which you want to send to the
multiple addresses.
3. Go to Tool-Letters and Mailings-Mail Merge-
click next: Starting Document- Next: Select
Recipients- Click Type a new list- Click Create –
Enter the address- to enter one more click New
Entry.
4. If you want to change the field names then click
Customize- Select the Field- Rename- Click ok.
5. Then in Mail Merge tool bar click Insert Merge
fields where ever needed.
6. Then finally in the mail Merge tool bar click
Merge to New Document-All- Ok- Save the file.

13
TO
Maya
Hetauda-2
Chitwan
Kathmandu

Sir/Madam,
Subject: Interview letter for the post of Cook

You are hereby informed to attend the interview for

the post of Cook on 29th sept, [Link] all the
documents and original marks cards without fail.

Date: 5-Sept-20
Your faithfully
Ritika Dahal

14
Lab Exercise 1.5

PROCEDURES TO CREATE A MACRO FOR INSERTING A

PICTURE AND FORMATTING THE TEXT:
1. Open MS Office-MS Word – File – New
2. Go to Tool-Macro-Record new Macro- Give
the macro name
3. Go to Insert- Picture- From File- browse for
the required picture- click Insert.
4. Type some text – Select it by holding shift
Key and right/left arrow Keys- change the
font size, color and style by the standard tool
bar.
5. Go to Tool- Macro- click Stop recording.
6. Open a new File go to- Tool-Macro- Select
the macro name which u have Created- click
Run.
15
Nature’s Beauty

16
Lab Exercise 2.1
PROCEDURES TO CREATE A WORKSHEET WITH 4
COLUMNS, ENTER 10 RECORDS AND FIND THE
SUM OF ALL COLUMNS:

1. Open MS Office-MS Excel – File – New

2. Select 3 column and 3 rows at the center of the
beginning- right click-Format cells - click select
the alignment tab- tick Merge cells option- ok-
Type the Heading.
3. Enter the 4 column Heading and 10 row heading
by clicking the cursor on to the particular cell.
4. Enter the data for the 4 columns.
5. Select the first column whole data, except the
heading and click ∑ (auto sum) in the standard
tool bar- this will add the column’s data and
places the result at the end.
6. Repeat the same for remaining 3 columns.

17
18
Lab Exercise 2.2
PROCEDURES TO CREATE A REPORT CONTAINING THE
PAY DETAILS OF THE EMPLOYEE:
1. Open MS Office-MS Excel – File – New
2. Select few column and few rows at the center of the
beginning- right Click- Format cells - click select the
alignment tab- tick Merge cells option- ok-Type the
Heading.
3. Enter the column Headings. Enter the data of following
columns manually Sl No, Name, Employee Id, Basic, CCA
(100 for all the employee) and LIC.
4. Enter the following formula to calculate the respective
values.
DA (60% of BASIC) =D5*0.6
HRA (7.5% of BASIC) =D5*0.075
Gross =SUM (D5:G5) or
D5+E5+F5+G5
GPF (7% of BASIC) =D5*0.07
KGID (8% of BASIC) =D5*0.08
Tot Deduction =SUM (I5:K5) or
I5+J5+K5

19
Net Salary =H5-L5

5. After Writing each formula select the cell and drag to the
entire column to apply.

20
Lab Exercise 2.3
PROCEDURES TO CREATE A SIMPLE BAR CHART TO
HIGH LIGHT THE SALES OF A COMPANY FOR 3
DIFFERENT PERIODS:

1. Open MS Office -- MS Excel – File – New

2. Select few column and few rows at the center
of the beginning- right Click- Format cells - click
select the alignment tab- tick Merge cells
option- ok-Type the Heading.
3. Enter the column Heading and row heading.
Enter the data in each Column.
4. Select the complete row and column data
including the header.
5. Go to Insert- Chart-Bars-Select the Chart Type -
Custom type- Select the type- Next- Select
Column - next – under Title give the Heading at
Chart title -Finish.

21
22
Lab Exercise 2.4
PROCEDURES TO CREATE A PIE CHART FOR A
SAMPLE DATA AND GIVE LEGENDS:

1. Open MS Office -- MS Excel – File – New

2. Select few column and few rows at the center
of the beginning- right Click- Format cells - click
select the alignment tab- tick Merge cells
option- ok-Type the Heading.
3. Enter the column Heading and row heading.
Enter the data in each Column.
4. Select the complete row and column data
including the header.
5. Go to Insert- Chart- Pie -Select the Chart Type -
Next- Select Column –next – under Title give
the Heading at Chart title –Finish.

23
24
Lab Exercise 2.5
PROCEDURES TO CREATE A MACRO WHICH
CREATES A LINE CHART USING THE DATA IN THE
WORKSHEET:
1. Open MS Office -- MS Excel – File – New
2. Select few column and few rows at the center
of the beginning- right Click- Format cells - click
select the alignment tab- tick Merge cells
option- ok-Type the Heading.
3. Enter the column Heading and row heading.
Enter the data in each Column.
4. Select the data with column heading (excluding
the first column)
5. Go to Tool-Macro-Record new Macro- Give the
macro name
6. Go to Insert- Chart- Under standard types select
Line - Next- Under Title give the Heading at

25
 Chart title – under Legends choose the
Placement –next- select the place Chart – Finish
7. Go to Tool-Macro –click Stop Recording.
8. Open a new File go to Tool-Macro- Select the
macro name which u have Created- click Run.

26
Lab Exercise 3.1
PROCEDURES TO CREATE A SIMPLE
PRESENTATION TO DATABASE
1. Open MS Office-MS Power Point – File – New -
Blank Presentation
2. Click the Other Task Panes drop down menu-
tick Slide Layout- Select the Layout you want.
3. Click the Other Task Panes drop down menu-
tick Slide Design – Select the Design of your
choice.
4. Click on the slide to type the text- align the text
using standard tool bar.
5. In order to insert new slide –go to Insert - New
Slide-Type your text.
6. Each slide may have the different slide layouts
depending on the content.

27
7. After creating all the slides- By holding Ctrl key
select all the slides- go to Slide show - Slide
transition- the transition- select speed to
minimum – tick Automatically after and enter
the time of interval for each slide to appear in
slide show- Click Apply to all the slide.
8. You can also use Custom animation to apply
animation to the text/content ,for tat select the
object –go to Slide Show- Custom animation-
click add effect –choose the style.
9. Finally go to Slide Show –view Show.

28
29
30
31
32
Lab Exercise 3.2
PROCEDURES TO CREATE A SIMPLE PRESENTATION
ABOUT DISCIPLINE.
1. Open MS Office-MS Power Point – File – New -
Blank Presentation
2. Click the Other Task Panes drop down menu- tick
Slide Layout- Select the Layout you want.
3. Click the Other Task Panes drop down menu- tick
Slide Design – Select the Design of your choice.
4. Click on the slide to type the text- align the text
using standard tool bar.
5. In order to insert new slide –go to Insert - New
Slide-Type your text.
6. Each slide may have the different slide layouts
depending on the content.

33
7. After creating all the slides- By holding Ctrl key
select all the slides- go to Slide show - Slide
transition- the transition- select speed to minimum
– tick Automatically after and enter the time of
interval for each slide to appear in slide show- Click
Apply to all the slide.
8. You can also use Custom animation to apply
animation to the text/content ,for tat select the
object –go to Slide Show- Custom animation- click
add effect –choose the style.
9. Finally go to Slide Show –view Show.

34
35
36
37
38
39
Lab Exercise 3.3

PROCEDURES TO CREATE A SIMPLE

PRESENTATION ABOUT SOCIAL MEDIA.
1. Open MS Office-MS Power Point – File – New -
Blank Presentation
2. Click the Other Task Panes drop down menu- tick
Slide Layout- Select the Layout you want.
3. Click the Other Task Panes drop down menu- tick
Slide Design – Select the Design of your choice.
4. Click on the slide to type the text- align the text
using standard tool bar.
5. In order to insert new slide –go to Insert - New
Slide-Type your text.
6. Each slide may have the different slide layouts
depending on the content.

40
7. After creating all the slides- By holding Ctrl key
select all the slides- go to Slide show - Slide
transition- the transition- select speed to minimum
– tick Automatically after and enter the time of
interval for each slide to appear in slide show- Click
Apply to all the slide.
8. You can also use Custom animation to apply
animation to the text/content ,for tat select the
object –go to Slide Show- Custom animation- click
add effect –choose the style.
9. Finally go to Slide Show –view Show.

41
42
43
44
45
46