FIMT/IQAC/ADMIN/2021-22

Fairfield Institute of Management and Technology

TOPIC OF RESEARCH PROJECT

Subject Name: INFORMATION TECHNOLOGY FOR COMMERCE

Subject Code: 111

Submitted to: Submitted by:

Name of the Faculty Name: RAHUL SHARMA
MEENAKSHI VERMA Enrollment no: 04490188821
Course: BCOM HONS
Semester/Section:1

FIMT/IQAC/ADMIN/2021-22
 CONTENT

S.NO PARTICULARS

1. HYPERLINK
2. MAIL MERGE
3. HOW TO CONVERT WORD FILE INTO PDF
4. HOW TO INSERT TABLE, DESIGN, EFFECT
5. MACROS
6. HOW TO LINK EXCEL TO WORD
7. EXCEL SHEET { SUM,AVERAGE,MIN,MAX }

8. BAR CHART

9. HOW TO INSERT, DELETE OR MOVE EXCEL SHEET

 HYPERLINK
WHAT IS HYPERLINK?

A hyperlink is a word, phrase or image that you can click on to jump to a new
document, or a new section within the document, or to a webpage, etc.
Hyperlinks are found in nearly all web pages, and these links allow the users to
click their way from the current page to a new pages . Most of the time text
hyperlinks are often blue and underlined, but it is not all the time or a necessary
condition.

MS-Word also provides this feature to add a hyperlink to the document. with the
help of this, you can connect your document to the another document or also can
add webpage link as per your choice. This tool is very useful, and it is easy to use.

CREATING A HYPERLINK WITH HELP OF TEXT

STEP FOLLOW:

STEP 1: First open MS-Word on your PC.

STEP 2: Now, Open the document or create a new one in which you want to
perform this operation.

STEP 3: Select a text for creating a hyperlink.

STEP 4: Now, go to the Insert tab.
STEP 5: Now, In the insert tab go to the “Links” Section and in Link Section,
click on the “Hyperlink” option.

STEP 6: As you click on the Hyperlink option a new tab will open named
Insert hyperlink.

STEP 7: Now, In this tab, there is an address bar. In this address bar, you
have to add the link of webpage or address to new file anything you want.
STEP 8: After entering the address click ok.
STEP 9: Hyperlink is added to the selected text successfully.

CREATING A HYPERLINK WITH THE HELP OF AN IMAGE

STEP FOLLOW:
STEP 1: First open MS-Word on your PC.
STEP 2: Now, Open the document or create new one in which you want to
perform this operation.
STEP 3: Select an image for creating hyperlink.

STEP 4: Now, go to the “Insert tab”.

STEP 5: Now, In the insert tab go to the “Links” Section and in Link Section,
click on the “Hyperlink” option.
STEP 6: As you click on the Hyperlink option a new tab will open named
“Insert hyperlink“.

STEP 7: Now, In this tab there is an address bar. In this address bar you have
to add the link of webpage or address to new file or anything you want.
STEP 8: After entering the address click ok.
STEP 9: Hyperlink is added to the selected text successfully.

Press Ctrl+K to open the Insert Hyperlink dialog box.

 MAIL MERGE

WHAT IS MAIL MERGE ?

Mail Merge is a handy feature that incorporates data from both Microsoft Word
and Microsoft Excel and allows you to create multiple documents at once, such
as letters, saving you the time and effort of retyping the same letter over and
over.

TO USE MAIL MERGE:

STEP FOLLOW:

1. Click the Mailings tab.

2. Click the Start Mail Merge button.
3. Select Step-by-Step Mail Merge Wizard

4. Select a type of document to create.

5. Click Next: Starting document.

SELECT A DOCUMENT
This next step is to select a starting document.

1. Select a starting document.

You can use the current document as the basis for the mail merge,
or you can select a template or existing document instead.

2. Click Next: Select recipients.

SELECT RECIPIENTS
Now, you will need to choose where you’ll get your list of addresses from. This
example uses an existing list from a database, but you can also select Outlook
contacts or manually create your own list.

1. Select Use an existing list.

2. Click Browse
3. Select your data file.

A data file of mail merge recipients can be in a database file, an

Excel spreadsheet, another Word document, or other types of data
files.

4. Click Open.
The Mail Merge Recipients dialog box displays the addresses that
will be used. If you’re using an Excel spreadsheet as a data
source, you may also be prompted to select a worksheet
containing the addresses.

If there's an address you don't want to use, you can uncheck it.
 5. Make sure the right recipients are selected and click OK.
6. Click Next: Write your letter.

WRITE YOUR LETTER

After the main document is set and the recipient list is connected and edited, you
are ready to insert the merge fields in the document. The merge fields are
placeholders in the document for unique information from the recipients list.

When you put a merge field in the main document, information from that field
will appear for the document that is unique to that recipient.

1. Click where you want the information.

2. Select one of the placeholder options.

You can add merge fields from the wizard, or from the Write & Insert
Fields group on the ribbon:

o Address Block: This is a combination of fields to insert the

names and addresses of recipients.
o Greeting Line: This is a combination of fields to insert the
recipient’s name in the greeting line.
o Insert Merge Field: When you click this button, a list of
additional merge fields you can insert appears.
1. Customize the placeholder.

2. Click Ok.
3. Repeat steps to add each merge field you want to include.

4. Click Next: Preview your letters.

PREVIEW YOUR MAIL MERGE
Sometimes, it is helpful to see what the data will look like once it has been
inserted into a document, instead of only viewing the merge field names.

You can easily preview how the mail merge will appear before finishing the
mail merge. This is encouraged to make sure the results appear as you want
them to.

1. Use the arrow buttons in the Mail Merge pane to preview each
merged document.
You can also use the arrow buttons in the Preview Results group
on the ribbon.
Click the Find Recipient button in the Preview Results group or in
the Mail Merge pane to search for a specific recipient.
2. Click Next: Complete the merge.
COMPLETE THE MERGE
Once you’ve added the list of recipients and filled out a document with merge
fields, the last step is to finish the merge by making a separate version of the
document for each recipient.

There are a couple of different ways you can finish the mail merge:

 Edit Individual Documents: Puts the results of the mail merge in a

new document. You are free to edit the results of the mail merge and
save and print them, just like any other document.
 Print Documents: Merges records and sends them directly to the
printer.
1. Select the option you want to use to finish the mail merge.

You can also click the Finish & Merge button on the ribbon and
select a merge option there.

You’re also given the option to choose which records to merge.

You can merge all the records in the list, only the currently
displayed record, or specify a range.

2. Select the records you want to merge.

3. Click OK.
 HOW TO CONVERT WORD FILE INTO PDF

If you have the desktop version of Microsoft Word installed on your Windows
PC or Mac, the easiest way to convert your document to PDF is right in Word
itself.

Open the document you want to convert and then click the “File” tab.

On the backstage screen, select “Save As” from the list on the left.

Next, from the Save As screen, select where you would like the PDF to be
saved
Click the dropdown arrow on the right side of the “Save As Type” box and
select PDF from the dropdown menu.

If you want to, you can change the filename at this time. When you’re ready,
click the “Save” button.

After saving the PDF, you’ll be returned to your Word document, and the new
PDF will open automatically in your default PDF viewer.
 HOW TO INSERT TABLE, DESIGN EFFECT

For a basic table, click Insert > Table and move the cursor over the grid until
you highlight the number of columns and rows you want. For a larger table, or
to customize a table, select Insert > Table > Insert Table. Tips: If you already
have text separated by tabs, you can quickly convert it to a table.

TO APPLY A TABLE STYLE:

1. Click anywhere on the table, then click the Design tab on the right side
of the Ribbon. Clicking the Design tab.
2. Locate the Table Styles group, then click the More drop-down arrow to
see all available table styles. ...
3. Select the desired style. ...
4. The selected table style will appear.
Enrollment in local colleges, 2005
College New students Graduating students Change
Undergraduate
Cedar University 110 103 +7

Elm College 223 214 +9

Maple Academy 197 120 +77

Pine College 134 121 +13

Oak Institute 202 210 -8

Graduate
Cedar University 24 20 +4

Elm College 43 53 -10

Maple Academy 3 11 -8

Pine College 9 4 +5

Oak Institute 53 52 +1

Total 998 908 90

Source: Fictitious data, for illustration purposes only

 MACRO

WHAT IS MACRO?
Macros are considered a standard feature in programming as well as the use
of computer programs. They are basically subprograms that developers and
users can create to save sequences of commands or operating instructions,
which can then be started with a simple action. When faced with many
regularly recurring tasks, Microsoft Word is typically an application that
benefits from the option to automate work steps.
RECORDING WORD MACRO EXECUTED BY BUTTON

The typical solution for a new macro in Word is one that can be run by
clicking a button. If you would like to create such a macro using the
developer tools, first click on the “Developer” tab and then select the option
“Record Macro”:

Now enter a name for the macro and select the document you wish to create
the macro for under “Store macro in:”. If you would like to create a cross-
program macro, simply select the option “All Documents (Normal.dotm)”. To
enable the macro to be executed in Word using a button, finally click on
“Button”:
Select the macro you wish to create in the left window and click on “Add”,
making it also selectable in the right window. Click on it here again and then
press the “Change” button. You can now assign your new Word macro any
icon you wish.

Confirm your desired button by clicking on “OK” twice. Now perform the
actions you want to save in the macro. Word will record your mouse clicks as
well as key strokes. However, the recorder will not save any movements or
highlighting with the mouse. So if you want to select some text, for example,
you will need to use the keyboard (hold down the [Shift] key and use the arrow
keys).

Once you have finished the sequence for the macro, you can stop the
recording via “Stop Recording”:
CREATING WORD MACROS EXECUTED VIA KYE COMBINATION
You can create a Word macro that can be started using a unique key
combination in essentially the same way as for macro buttons: Start the
process using the “Record Macro” button in the macro menu under
“Developer”, enter a suitable name, and decide whether you want to make the
macro available in all documents or only in a certain project. In the final step
before beginning the recording, you should choose the “Keyboard” option in
order to open the menu for new hotkeys:

In the “Customize Keyboard” menu that then appears, select the macro under
“Commands”. Next, click on the “Press new shortcut key” field with the left
mouse button and press your desired key combination. Here it is important
to press these keys simultaneously. In the following Word macro example, we
used the [Ctrl], [Shift], and [#] keys.
Under “Save changes in”, you can define whether the key combination should
be valid universally (“Normal”) or only for a certain Word document; to confirm
your choice, click on the “Assign” button. As soon as you close the menu, the
macro recording will start.

EXECUTING WORD MACROS

1. Click on the “Macros” button under the “Developer” tab or alternatively

on “Macros” in the menu under the “View” tab, and then on “View
Macros”.
2. Select the desired macro from the list using a left mouse click.
3. Now press “Run”.

ADDING MACRO BUTTON TO A WORD TAB RIBBON

If the macro icon is too small for you in the quick-access toolbar or if you would
like to add a button for a macro executable via key combination, you can also
integrate a macro button into the ribbon of any tab. To do so, simply create
a user-defined group for the tab and add the desired macro to it. You can do
both in the “Customize Ribbon” menu in the Word options (accessibly via “File”
-> “Options”).
CREATING A USER DEFINED GROUP:
In the right window under “Customize Ribbon”, select the tab in which you wish
to create the new group and then click on the “New Group” button. In addition
to the standard groups here, the entry “New Group (User-Defined)” will now
appear. Click on this and then press “Rename” to give the group a suitable
name as well as an icon:
 HOW TO LINK EXCEL TO WORD
To insert any part of an Excel worksheet in a Word document :

1. Open the Word document where the worksheet will display.

2. Open the Excel worksheet that contains the data you want to link to
the Word document.
3. In Excel ,select and copy the range of cell to include. If you plan to
insert more columns or rows into the worksheet, select the entire
worksheet.

4. In the Word document, position the cursor where you want to insert
the linked table.
5. Right-click and select Link & Use Destination Styles or Link &
Keep Source Formatting.

6. The Excel data pastes directly into the Word document where the
cursor was positioned. If changes are made to the source Excel file,
the Word document updates with those changes automatically.
 HOW TO PROTECT OUR DOCUMENT WITH PASSWORD
Passwords are case-sensitive and can be a maximum of 15 characters long.
If you lose or forget your password, Word won't be able to recover it for you.
Be sure to keep the a copy of the password in a safe place or create a strong

First, open the Office document you would like to protect. Click the File menu,
select the Info tab, and then select the Protect Document button. Click Encrypt
with Password.

Enter your password then click OK.

Enter the password again to confirm it and click OK.

Microsoft Word will now indicate the document is protected. Each time
you open the document, you will be prompted to enter your password to
access its contents.
 EXCEL SHEET

{SUM,MIN,MAX,AVERAGE}

ROLL NAME ENGLISH HINDI MATHS SCIENCE SST TOTAL MIN MAX AVERAGE
NO
1 SAURABH 85 79 89 68 79 400 68 400 158.5

2 HARVENDRA 56 79 84 57 69 345 56 345 136.375

3 SAPNA 75 82 97 76 81 411 75 411 163.5

4 LALIT 87 96 84 75 68 410 68 410 162.25

5 ROHIT 86 75 98 75 68 402 68 402 159.25

BAR CHART
 HOW TO INSERT, DELETE OR MOVE EXCEL SHEET

INSERT A WORKSHEET

 Select the plus icon at the bottom of the screen.

 Or, select Home > Insert > Insert Sheet.

RENAME A WORKSHEET

 Double-click the sheet name on the Sheet tab to quickly rename it.
 Or, right-click on the Sheet tab, click Rename, and type a new name.

DELETE A WORKSHEET

 Right-click the Sheet tab and select Delete.

 Or, select the sheet, and then select Home > Delete > Delete Sheet.
 MOVE OR COPY WORKSHEETS OR WORKSHEET DATA

COPY A WORKSHEET IN THE SAME WORKBOOK

 Press CTRL and drag the worksheet tab to the tab location you want.

OR

1. Right click on the worksheet tab and select Move or Copy.

2. Select the Create a copy checkbox.
3. Under Before sheet, select where you want to place the copy.
4. Select OK.
5.
 FORMAT FOR RESEARCH REPORT

Content of Synopsis

1) Title of Research Project

2) Table of contents
Including columns for ‘contents’, ‘page number’ E.g.:

Contents Page No.

3) Introduction

It includes Brief Introductory information related to the study which

develops conceptual frame work of students.

4) Objective(s)
•
To develop further understanding of the theories and concepts covered
in the course.
•
To develop a practice of learning new aspects of the subject and
develop a habit of research related to the subject.

5) Expected Outcomes/Conclusion
This Point includes expected result of the study.

6) Bibliography:

Books: Name of the Author & Publishing House

Journals: Name of the Journal and Year of Publishing Magazines Website