ABHIJEET SINGH BCA 1A Manmeet Kaur BCA

1B

ICIT
PRACTICAL FILE

SUBMITTED BY: ABHIJEET

SINGH

Sec: BCA 1A

Roll No: - 36290202021

SUBMITTED TO: - MS. SWATI GUPTA

 ABHIJEET SINGH BCA 1A

INDEX
S.NO. Task Page Date Signature
No.

1 To explore Windows Explorer 1-3 15/12/2021

functionalities like Create,
Rename, Move, Delete folder
and files etc.
2 To explore the System settings – 4-8 28/12/2021
Personalisation, System, Devices,
Apps, Network & Internet.
3 To practice the use of basic 9-14 03/01/2022
formatting features – Format Printer,
Indentation, Line Spacing,
Background Color, Find, Replace,
Dictate Commands.
4 To practice the use of Layout – 15-18 07/01/2022
Margins, Orientation, Size, Columns,
Indent, Spacing etc.
5 To practice the use of insert Features 19-23 12/01/2022
– add picture, chart, Smart Art, Word
Art, Equation, Symbols, Header and
Footer, Page Numbering etc. and the
use of Design Features – Watermark,
Page Colour, Page Border, Themes
implementation etc.

6 MICROSOFT WORD STUDENT 24-36 18/01/2022

MANUAL
7 To practice the use of Insert 37-46 12/01/2022
Features – add picture, Chart,
SmartArt, WordArt, Equation,
Symbols, Header and Footer,
Page Numbering etc. and the use
of Design Features – Watermark,
Page color, Page Border, Themes
implementation etc.
8 To practice the use of Mail Merge 47-55 29/01/2022
Feature to generate Envelops and
Labels.
 ABHIJEET SINGH BCA 1A

S.NO. Task Page Date Signature

No.

9 56-58 27/01/2022
To practice the use of Layout
Features–Margins, Orientation,
Size, Columns, Indent, Spacing
etc.

10
Create a Folder by your name in 59-59 29/01/2022
your system, store all the work
done in this semester inside that
folder.

11 De sign an Invitation to Birthday 60-66 30/01/2022

Party using mail merge features
send the invitation to 10 friends.
12
Write an Article for Magazine 67-70 01/02/2022
with 3 columns and hyperlink.

13 MS DOS Commands 71-75 03/02/2022

14 Create a Power Point Presentation on 76-83
any topic of your choice using 05/02/2022
animation and transition features.
15 MS Excel student Manual 84-95 05/02/2022
16 Create a directory in MS DOS by your
name in that directory. Create file1 named
as ICIT and file2 named as ICIT Lab. In file
name as ICIT write 5 lines on MS DOS and 02/02/2022
perform following operations: 96-101

1) copy content of ICIT Lab

2) check the attribute of all file and directory
3) display above list in a tree like format
4) create a sub directory in main directory
named as sub directory1, move ICIT into
sub directory1 rename it as my file.
 ABHIJEET SINGH BCA 1A

Q1. To explore Windows Explorer functionalities

like create, rename, move, delete folder and files
etc.

A1. 1. Create folder

 Navigate to the location where
you where you want to place the
new folder.
 Right-click and select New.
 Select Folder.

 The folder will be displayed, with

the default name “New folder”.

1
 ABHIJEET SINGH BCA 1A

2. Rename Folders/Files

 Click File Explorer icon.

 Go to the location where stores your
file or folder.
 Right click the name of the file or
folder you wish to rename.
 Click Rename (on the menu that
opens up).
 Type a new name for the file and
press Enter.

3. Move Folders/Files

 Click File Explorer icon.

 Go to the location where stores your
file or folder (hard drive, USB,
etc.).
 Click the name of the file or
folder you wish to move.
 Click the Home tab at the top (on the
ribbon).
3.Click
the Move to button.
1. Click Choose Location (if
you don!t find the right spot
on the drop-down menu).
2. Go to the location you want to
move for this folder.
3. Click Move.

2
 ABHIJEET SINGH BCA 1A

4. Delete Folders/Files

 Click File Explorer icon.

 Go to the location where stores your file or folder.
 Click the name of the file or folder you wish to delete.
 Press the delete key (on the keyboard) or right click the
file or folder and click
Delete.

3
 ABHIJEET SINGH BCA 1A

Q2. To explore the System settings -

Personalization, System, Devices, Apps, Network
& Internet.

A2. 1.Personnalisation

4
 ABHIJEET SINGH BCA 1A

2. System

3. Devices

5
 ABHIJEET SINGH BCA 1A

4. Apps

6
 ABHIJEET SINGH BCA 1A

5. Network & Internet

Network and Sharing Centre - Opens the Network and Sharing

Centre window to view basic networking information, set up a new
connection, and troubleshoot network problems.

View network status and tasks - Open the Network and Sharing
Centre window (same as above).

Connect to a network - Open the available networks that which

include available Wi-Fi networks and the ability to turn on Airplane
mode and set up a mobile hotspot.

View network computers and devices - Opens

the Network window that shows computers on your network, media

7
 ABHIJEET SINGH BCA 1A

devices, network infrastructure (e.g., router), and other devices

(e.g., available IoT devices and Internet/Network connected
devices).

Homegroup - Opens the Homegroup window to set up, join, and

troubleshoot Homegroup settings and sharing settings.

Choose homegroup and sharing options - Opens

the Homegroup window (same as above).

Internet Options - Opens the Internet Properties window to adjust

Internet Explorer browser settings (e.g., home page, browsing
history, and other settings).

Change your homepage - Opens the Internet Properties window

(same as above).

Manage browser add-ons - Opens the Internet Properties window

in the Programs tab. From the Programs tab, you can manage any
add-ons that are installed into Internet Explorer and choose how the
computer opens links.

Delete browsing history and cookies - Opens the Internet

Properties window in the General tab that allows you to delete the
browsing history and change the browsing history settings and
delete cookies and adjust cookie settings.

Infrared - Open the Infrared window to adjust the infrared settings

and infrared device settings (e.g., a digital camera with infrared).

Send or receive a file - Open the Infrared window (same as above).

8
 ABHIJEET SINGH BCA 1A

Q3. To practice the use of basic formatting –

Format Painter, Indentation, Line Spacing,
Background color, Find, Replace, Dictate
Commands.

Use the Format Painter:

Use the Format Painter on the Home tab to quickly apply the
same formatting, such as colour, font style and size, and border
style, to multiple pieces of text or graphics. The format painter lets
you copy all of the formatting from one object and apply it to
another one – think of it as copying and pasting for formatting.

1. Select the text or graphic that has the formatting that you
want to copy.
2. On the Home tab, click Format Painter.

The pointer changes to a paintbrush icon.

THIS IS AN EXAMPLE:

THIS IS A LINE

TITLE OF THE BOOK:

“INTO THE ESCAPE”

3. Use the brush to paint over a selection of text or graphics to

apply the formatting. This only works once. To change the
format of multiple selections in your document, you must first
double-click Format Painter.

9
 ABHIJEET SINGH BCA 1A

4. To stop formatting, press ESC.

INDENTATION:

1. select the paragraph to be indented;

EXAMPLE: HOPES AND DREAMS WERE DASHED THAT DAY.

IT SHOULD HAVE BEEN EXPECTED, BUT IT STILL CAME AS A
SHOCK. THE WARNING SIGNS HAD BEEN IGNORED IN FAVOR
OF THE POSSIBILITY, HOWEVER REMOTE, THAT IT COULD
ACTUALLY HAPPEN. THAT POSSIBILITY HAD GROWN FROM
HOPE TO AN UNDENIABLE BELIEF IT MUST BE DESTINY. THAT
WAS UNTIL IT WASN'T AND THE HOPES AND DREAMS CAME
CRASHING DOWN.

2. From the Home tab, Paragraph group, select the dialog

box launcher;

3. Check that the Indents and Spacing tab is selected;

10
 ABHIJEET SINGH BCA 1A

4. In the Indentation section set the indent value you require.

AFTER INDENTATION:

HOPES AND DREAMS WERE DASHED

THAT DAY. IT SHOULD HAVE BEEN EXPECTED, BUT IT STILL CAME AS A
SHOCK. THE WARNING SIGNS HAD BEEN IGNORED IN FAVOR OF THE POSS
THAT IT COULD ACTUALLY HAPPEN.

THAT POSSIBILITY HADGROWN

FROM HOPE TO AN UNDENIABLE
BELIEF IT MUST BE DESTINY. THAT
WASUNTILIT WASN'T ANDTHE
HOPES AND DREAMS CAME
CRASHING DOWN.

CHANGE THE LINE SPACING:

1. Select one or more paragraphs to update. Press Ctrl + A
to select all.
2. Go to Home > Line and Paragraph Spacing

EXAMPLE:

THE TIMES ROMAN

BELL MT

ARIAL

VERDANA

11
 ABHIJEET SINGH BCA 1A

3. Select Line Spacing Options and choose an option in

the Line spacing box.

4. Adjust the Before and After settings to change spacing

between paragraphs.
5. Select OK.

BACKGROUND COLOR:

Add or change the background color:

1. Go to Design > Page Colour.
2. Choose the colour you want under Theme Colours or Standard
Colours.

12
 ABHIJEET SINGH BCA 1A

Remove the background color

1. Go to Design > Page Colour.

2. Select No Color.

FIND AND REPLACE TEXT:

1. Go to Home > Replace or press Ctrl+H.

2. Enter the word or phrase you want to locate in the Find box.
3. Enter your new text in the Replace box.

4. Select Find Next until you come to the word you want to update.

13
 ABHIJEET SINGH BCA 1A

5. Choose Replace. To update all instances at once, choose

Replace All.

To specify only upper or lowercase in your search, select More > Match
case.

HOW TO USE DICTATION:

1. Go to Home > Dictate. First-time users will be
prompted to enable microphone permissions.

2. A mic icon will appear - wait for it to turn on to be

sure it started listening.
3. Tip: On Windows, use Alt + ` (backquote) to toggle
the mic.
4. Insert punctuation any time by saying them explicitly.
5. Fix mistakes with your keyboard or Dictation
suggestions without having to turn off the mic icon.
6. Exit dictation with Close (X) in the Dictation toolbar
or pressing the button in the ribbon again.

14
 ABHIJEET SINGH BCA 1A

Q4. To practice the use of Layout – Margins,

Orientation, Size, Columns, Indent, Spacing
etc.

Margins - Drop-Down. Let’s you choose from one of the built-

in margin settings or lets you customize your own. Similar to
Excel but has 2 more options "Moderate" and "Mirrored".
Custom Margins displays the "Page Setup" dialog box (Margins
tab).

Orientation - Drop-Down. Let’s you change the orientation of

the current section. The drop-down contains the commands:
Portrait and Landscape. This provides a shortcut to the (Page
Setup) (Page tab, Orientation).
Size - Drop-Down. Let’s you select from all the different
available paper sizes. This provides a shortcut to the (Page Setup)
(Page tab, Paper size drop-down).

Columns - Drop-Down. The drop-down contains the

commands: One, Two, Three, Left and Right and the command
More Columns. Provides access to 1,2,3 column layouts.

Breaks - Drop-Down. The drop-down contains the commands:

Insert Page Break, Remove Page Break and Reset All Page
Breaks.
Line Numbers - Drop-Down. The drop-down contains the commands:
None, Continuous, Restart Each Page, Restart Each Section, Suppress for
Current Paragraph and Line Numbering Options. The Line Numbering
Options displays the "Page Setup" dialog box (Layout tab).

15
 ABHIJEET SINGH BCA 1A

Hyphenation - Drop-Down. The drop-down contains the

commands: None, Automatic, Manual and Hyphenation
Options. The Hyphenation Options displays the "Hyphenation"
dialog box.

Paragraph:
You can quickly display the "Paragraph" dialog box, Indents and
Spacing tab, by clicking on the launcher in the bottom right
corner of this group.
These are options taken from the (Format Paragraph) (Indents
and Spacing tab) for quick access.

Indent Left - Textbox. This automatically updates to indicate

how much indentation has been applied to the paragraph of the
current selection. This can be used to change the left indentation for
the current selection.
Indent Right - Textbox. This automatically updates to indicate how
much indentation has been applied to the paragraph of the
current selection. This can be used to change the right
indentation for the current selection. Spacing
Before - Textbox. This automatically updates to indicate how
much spacing is defined before the paragraph of the current
selection. This can be used to change the spacing for the
current selection. Spacing After -
Textbox. The automatically updates to indicate how much
spacing is defined after the paragraph of the current selection.
This can be used to change the spacing for the current selection.

16
 ABHIJEET SINGH BCA 1A

Arrange:
This group also appears on the Drawing Tools - Format
contextual tab.

Position - Drop-Down. Displays a list of picture positioning

options. The drop-down contains the commands: In Line with Text
and Text Wrapping. You can select More Layout Options to
display the "Advanced Layout" dialog box.
Wrap Text - (Text Wrapping in 2007). Drop-Down. The
drop- down contains the commands: In Line with Text, Square,
Tight, Through, Top and Bottom, Behind Text, In Front of Text,
Edit Wrap Points and More Layout Options.

Bring Forward - (Bring to Front in 2007). Button with Drop-

Down. The button brings the selected object forward one level.
The drop-down provides a command to bring the selected
object in front of all the other objects.

Send Backward - (Send to Back in 2007). Button with Drop-

Down. The button brings the selected object back one level. The
drop-down provides a command to send the selected object to
the back of all the other objects.

Selection Pane - (Added in 2010). Displays the Selection Pane

task pane.

17
 ABHIJEET SINGH BCA 1A

Align - Drop-Down. The drop-down contains the commands:

Align Left, Align Center, Align Right, Align Top, Align Middle, Align
Bottom, Distribute Horizontally, Distribute Vertically, Align to Page,
Align to Margin, Align Selected Objects, View Gridlines and Grid
Settings. The Grid Settings displays the "Drawing Grid" dialog
box.

Group - Drop-Down. The drop-down contains the commands:

Group, Regroup and Ungroup.

Rotate - Drop-Down. The drop-down contains the commands:

Rotate Right 90, Rotate Left 90, Flip Vertical, Flip Horizontal and
More Rotation Options.

18
 ABHIJEET SINGH BCA 1A

Q5. To practice the use of Insert Features- add picture,

Smart Art, Word Art, Equation, Symbols, Header and Footer,
Page Numbering etc. and the use of Design Features –
Watermark, Page color, Page Border, Themes implementation
etc.

Set page border

To set page border,

1. Click More > Page Setup > Design tab

2. Select the page colour icon under Page Background.

19
 ABHIJEET SINGH BCA 1A

Border Properties
Select sides: Choose all sides or any specific side to apply a
border to your page.
Border colour: Set a unique colour to your page border.
Border width: Click to choose the width of the page border. You
can set width up to 10px.

Border style: Apply line style to your border.

Border radius: Set radius to the border's corner. You can set it under
the Border Properties header.

Distance from text: Choose the distance of your border from the text. You
can choose an option from the dropdown or apply custom margin, if
required.

Custom margins: Click Custom margins to customize the distance as per

your needs.

Show border on: You can add border to all the pages or just for your title
page to make it unique.

20
 ABHIJEET SINGH BCA 1A

Set page background

If you want to make interesting sketches or you simply' want a coloured
background, you can go for page colour.

To apply a page background colour,

1. Click More > Page Setup > Design tab

2. Select the page color icon under Page Background.
3. Select the required color from the palette. The page background
color will be set. Click the Reset button to reset the page background
color.

21
 ABHIJEET SINGH BCA 1A

Insert watermark
You can use a watermark to give washed-out text or images at the
background of the pages in your document.
To use watermark,

1. Click More > Page Setup > Design tab .

2. Click Watermark.
3. To insert a piece of text as watermark, select the As Text option,
enter the text, font, font size, font colour, placement (horizontal or
diagonal), and click Apply. To insert an image as watermark, select
the As Picture option, upload the image, select Scale and Washout
limits and click Apply.

22
 ABHIJEET SINGH BCA 1A

Move watermark
You can customize the size and position of the watermark in your

document. To move watermark,

1. Open the required document and double click on the header/footer

area.
2. Now the watermark text can be edited and can be dragged anywhere
in the document. Also, customize the size of the watermark, if
required.

23
 ABHIJEET SINGH BCA 1A

Q6. MS Word student Manual.

Microsoft Word is a two (2) to four (4) hour course designed to

familiarize you with the terminology, screen components and the most
commonly used functions offered by Microsoft Word. Emphasis will be
placed on proper document formatting techniques and file naming and
file management conventions.

Learning Goals:

• Identify the various benefits of using word processing software.

• Identify the main parts of the Microsoft Word window.

• Identify the purpose of the commands on the menu bar.

• Copy, cut and paste text.

• Work with the buttons on the toolbar.

• Type, edit and format text.

• Work with pictures.

• Work with language tools (spell check).

• Open, save, save as, and print Microsoft Word files.

24
 ABHIJEET SINGH BCA 1A

What is Microsoft word?

Microsoft Word is the word processing component of the Microsoft Office
Suite. It is used primarily to enter, edit, format, save, retrieve and print
documents.

Pay special attention to terminology

While different versions have different appearances, they all have most
of the same features. If you know what to call it, you should be able to
find it in other versions.
Open the 4.0.2 Cover Letter document located in your student folder.
Take notes and follow along as your instructor demonstrates common
word processing functions.

Minimize, maximize, and close buttons

25
 ABHIJEET SINGH BCA 1A

Horizontal and vertical scroll bars

Title bar

Tabs Bar

26
 ABHIJEET SINGH BCA 1A

Ribbon Components (Tab Groups)

1. File Tab

• Save –

• Save As -

27
 ABHIJEET SINGH BCA 1A

• Print –

2. Home Tab

• Clipboard –

 Copy
............................................................................................................

 Cut
............................................................................................................

 Paste
...........................................................................................................

28
 ABHIJEET SINGH BCA 1A

• Font –

 Face
............................................................................................................

 Size
............................................................................................................

 Type
............................................................................................................

 Style (B,I,U)
.................................................................................................

• Paragraph –

29
 ABHIJEET SINGH BCA 1A

 Alignment
...................................................................................................

 Bullets
.........................................................................................................

 Indent
.........................................................................................................

Editing
 Find –

 Insert Tab –

Pictures
............................................................................................................

Shapes
..............................................................................................................

30
 ABHIJEET SINGH BCA 1A

3. Page Layout Tab

Margins
............................................................................................................

Orientation
......................................................................................................

4. References Tab

5. Mailings Tab

6. Review Tab

Spelling & Grammar

.........................................................................................

Word Count
.....................................................................................................

31
 ABHIJEET SINGH BCA 1A

7. View Tab

 Print Layout
......................................................................................................

 Ruler
...........................................................................................................

 Zoom
...........................................................................................................

Microsoft Word Terminology:

Alignment: refers to the position of lines in a paragraph in relation to the

documents left and right margins

This text is left aligned.

This text is
centered.

This text is right aligned.

This text is fully justified. It is spread evenly from the left to the right
margin. All text in the paragraph will be justified between margins until
you hit the enter key to force a new paragraph.

Backspace: deletes data to the left of the insertion point.

32
 ABHIJEET SINGH BCA 1A

Bold: characters in bold appear on the screen in a higher intensity.

This text is bold. Bold should be used for emphasis, but like all
formatting characteristics, should be used sparingly.

Bullets: special characters or symbols that are used to set off a

paragraph.

• This is item one in a bulleted list.

• This is item two in a bulleted list.

Centering: the placement of a line of text in the center of the screen or

page where the left-most and right-most characters in the line are the
same distance from the left and right margins. (See alignment)

Clip Art: pre-designed images that can be placed within a document.

Close: closes the document and offers to save the changes you made
to the
document without exiting the program.

Copy: creates a duplicate of highlighted/selected text and saves to the

clipboard to be pasted elsewhere.

33
 ABHIJEET SINGH BCA 1A

Cut: removes highlighted/selected text and saves to the clipboard to be

pasted elsewhere.

Default: A default setting is the software manufacturer's preset option

for a particular command or function. Default settings can be changed.

Document: another name for a file created using Microsoft Word.

Font: a style of typeface, such as: Times New Roman, Arial Black,
Arial, and Freestyle Script. A font is a set of all the characters available
in one typeface and size, including uppercase and lowercase letters,
punctuation, and numerals.

Font Formatting: changes the appearance of the text. Font

formatting includes enhancements such as font style (bold, centering,
and underline), point size (12 pt.), and font typeface (Times New
Roman, Arial, and Courier New).

Format Painter: enables you to copy the formatting of one word or

paragraph and apply it to another word or paragraph.

Hard Return: You can force Word to end a paragraph and move to
the next line by pressing the enter key. The resulting “hidden” command
is called a Hard Return.

34
 ABHIJEET SINGH BCA 1A

I-beam Mouse Pointer: The mouse pointer turns into an

I-beam mouse pointer when it is within the document area. Use the
I-beam mouse pointer to place the insertion point in a document.

Indentation: the amount of space measured from the page

margin that is applied to a paragraph or an area of a document.

Insertion Point: the point at which the cursor is blinking on the

document screen.

Italics: Italicized characters appear on the screen slightly tilted to the

right. This text is italicized.

35
 ABHIJEET SINGH BCA 1A

Line Spacing: refers to the number of lines used by each line of text.
In single-line spacing, each line of text is followed by another line of text,
and there are no blank lines in between. In double-line spacing, each
line of text is followed by a blank line.

Margin: The amount of blank space, usually measured in inches or

characters, above and below and to the right and left of the main body of
a document.

Paragraph: A paragraph is any amount of text separated by a hard

return. Microsoft Word sees anything from a single word to an entire
page of text as a paragraph.

Paste: Adds previously copied or cut text at the insertion point.

Print Preview: Print Preview lets you see how your document will look
on the page before it is printed.

Wrapping: Text automatically wraps to the next line when typing in

Microsoft Word. The only time you need to hit the enter key is when you
want to start a new paragraph.

36
 ABHIJEET SINGH BCA 1A

QUES 7: - Insert features- add pictures, Chart, smart Art,

equation, symbols, watermark, page Color, page border,
theme implementation etc.

SOLUTION: -

Open insert tab:

 Click on pictures option.
 Select from where you want to import the image.

 Select the picture you want to insert in the document.

37
 ABHIJEET SINGH BCA 1A

 Click the insert button and the image will be inserted in your
document.

Using chart feature:

 Open insert tab.
 Click on the chart option from illustration’s section.

 Now select ok after clicking on ‘chart’.

38
 ABHIJEET SINGH BCA 1A

Using Smart Art:

 From insert tab, go to illustrations section.
 Select the ‘Smart Art’ option.

 For using more features click on it

39
 ABHIJEET SINGH BCA 1A

Using equation and symbol features:

 Go to the insert tab.

 Access the symbol section in it.

 Select equations and choose from them

40
 ABHIJEET SINGH BCA 1A

 Select symbol button from it.

 Now go to header and footer section.

 Click on header for creating heading in your document.

41
 ABHIJEET SINGH BCA 1A

 For adding footer to a document, click on footer option and

access it.

 For numbering your document’s page, click on ‘page number’ in

header and footer section.

42
 ABHIJEET SINGH BCA 1A

Accessing Design tab features:

 In design tab, go to page background section.

 Now select watermark feature.

43
 ABHIJEET SINGH BCA 1A

 For changing color, the pages in your document,

 Select the page color option in the page background section.

Adding borders to the pages:

 Access the design tab.

 Now go to the page and background section.

44
 ABHIJEET SINGH BCA 1A

 Click on the ‘page border’ and select the border of your choice to
add to your document.

Using themes for the word document:

 Open the design tab.

 Now access the theme tab on the top left corner in design tab.

45
 ABHIJEET SINGH BCA 1A

 Click on theme button and select the theme for your document.

46
 ABHIJEET SINGH BCA 1A

Q8. To practice the use of Mail Merge

Features to generate Envelops and Labels.
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. Here is an example of how to use it to create a letter thanking
people who donated to a particular fund.

1. Gathering Your Data:

 The first thing you do is create an Excel spreadsheet, creating a

header for each field such as First Name, Last Name, Address,
City, State, and Postal Code (NOTE: It’s important to not refer to
the postal code as a zip code, but more about that later).

 The field headers (i.e., first name, last name) are labelled
separately so that you can filter them alphabetically if you need to.

You can also add additional headers, such as a donation amount.

Be sure to label it something you’ll remember. If you are using
dollar amounts, change the type of number it is under ‘Number’ at
the very top to ‘Text’ for every dollar entry and manually type the
dollar sign otherwise the dollar sign ($) will not show up in your
letter.

47
 ABHIJEET SINGH BCA 1A

2. Prepare your letter in Microsoft Word. When creating a letter, it’s

a good idea to insert a placeholder where the information from the
mail merge will be placed, i.e. [Address], [Amount].

3. Under “Mailings” in Microsoft Word click on ‘Start Mail Merge’

and click on ‘Step by Step Mail Merge Wizard.’

4. A window will appear to the right of your document that says ‘Select
Document type.’ In this instance leave it on ‘Letters.’

 At the bottom click on Next: Starting Document.

48
 ABHIJEET SINGH BCA 1A

 The next step will read ‘Select Starting Document.’ If you currently
have the letter, you created leave the selection ‘Use the Current
Document’ selected.

 Next, click ‘Select Recipients’ at the bottom. You will see ‘Use
an Existing List’ the ability to browse for your list.

 Click on the ‘browse’ button and find your list on your computer
that you typed up in Excel.

49
 ABHIJEET SINGH BCA 1A

 Once you find your document click open and a box will show up
that says ‘Select table.’ If you only had one tab on your
spreadsheet, click okay.

 You will then see the data you had typed. You can also choose to
leave off certain names if you want to. Click okay.

50
 ABHIJEET SINGH BCA 1A

 The table will close and then the dialog box on the right will say
‘Currently Your Recipients Are Selected From:’ and will give the
title of your excel spreadsheet document.

 At the bottom of the dialog box click ‘write your letter.’

 From there you can start adding your fields from your spreadsheet.
Highlight the placeholder marked [Address] and then click on
Address block. The spreadsheet will pull in your data from your
spreadsheet.

51
 ABHIJEET SINGH BCA 1A

 If you did not write ‘postal code’ and wrote ‘zip code’ instead you
can click on ‘match fields’ and find the field that matches ‘postal
code’ instead. Be sure to cycle through your address list to make
sure your addresses are correct. Click okay.

 Highlight the greeting line placeholder and replace it with the

‘Greeting Line’ under Write Your Letter. You can also filter it to
where it only lists their first name.

52
 ABHIJEET SINGH BCA 1A

 For the other fields such as ‘amount’ you can highlight amount and
go to ‘More items.’ Then, go down to ‘amount’ and select it.

53
 ABHIJEET SINGH BCA 1A

 Next go to ‘preview your letters.’ From there the database

information will have populated your letter. You should be able to
cycle through the information you typed to make sure that your
addresses and amounts are correct.

 If you’re satisfied, click on ‘Complete the merge’ and then click on

‘print.’

54
 ABHIJEET SINGH BCA 1A

 It will give you the option to click on ‘print current record’ or you
can print all of the letters from your database.

 It’s important to thoroughly look over all your letters to make sure
there aren’t any typos or problems with formatting, especially on
the letter itself.

55
 ABHIJEET SINGH BCA 1A

Q9. To practice the use of Layout Features –

Margins, Orientation, Size, Columns, Indent,
Spacing, etc.

Accessing layout features:

 Margins:
1. Open the layout tab.
2. Now in page setup section, find margin option.

3. Click on the margin button.

4. Select the margin orientation for your document.

56
 ABHIJEET SINGH BCA 1A

 Orientation:

For changing the orientation of your document pages, select

the orientation option from the layout tab under the page
setup section.

 Size of the page for the document:

1. Open the layout tab.
2. Find the size option under page setup section.

57
 ABHIJEET SINGH BCA 1A

3. Click on the option for adjusting the size of pages for

your word document.

 Columns:
1. Open the layout tab for columns option.

2. Now select the column option for changing your typing

orientation i.e., for dividing your text documentation in
various patterns.

 Indent and spacing:

1. Open the layout tab.
2. Now go to paragraph tab.
3. And adjust the spacing and indentation of your texts.

58
 ABHIJEET SINGH BCA 1A

Q10. Create a Folder by your name in your system,

store all the work done in this semester inside that
folder.

59
 ABHIJEET SINGH BCA 1A

Q11. Design an Invitation to Birthday Party

using mail merge features send the invitation
to 10 friends.

1. Open the mailings tab.

2. Now click on the ‘start mail merge drop down
button.
3. Click the last option ‘step by step merge wizard

4. Select the document type as letters.

60
 ABHIJEET SINGH BCA 1A

5. And then click the next select recipient’s link.

6. In the recipient section select ‘use an existing

document’.

7. Select your excel document in which you have

stored the data of your 10 friends.

61
 ABHIJEET SINGH BCA 1A

8. Now after selecting click the position indicator.

9. Now go to the next page by clicking ‘write your
letter’ option in the mail merge feature and start
creating the letter.

10. Click on more items under mail merge.

11. Now add the address line for the letter.

62
 ABHIJEET SINGH BCA 1A

12. Add another address line and continue with

your letter.

13. After address greet your friend and add

his/her name in the letter by clicking on more
items option again.

63
 ABHIJEET SINGH BCA 1A

14. From the very next line start writing the

content for the letter.

Manmeet Kaur

64
 ABHIJEET SINGH BCA 1A

15. Now complete the merge and choose the

recipients.

Preeti,

Manmeet Kaur

65
 ABHIJEET SINGH BCA 1A

16. Choosing other recipient.

Umang,

Manmeet Kaur

66
 ABHIJEET SINGH BCA 1A

Q12. Write an Article for Magazine with 3

columns and hyperlink.

Inserting columns
Columns and column breaks can improve your document’s organization and
increase its readability. They also allow you to utilize all of the available
space on the page.
Steps to Add Columns:
Step 1: Select the text you want to format.
Step 2: Click the Page Layout menu tab.

Step 3: Click the columns command. A drop-down menu will appear (as
mentioned below).

Step 4: Select the number of columns you want to insert. The text will then
format into columns.
Step 5: Select the number of columns as 3.

67
 ABHIJEET SINGH BCA 1A

"Decline and leave your last

bright, sandy piece of beach
disaster impend, earthly point
of reference— you rolled your tube down to
but my thoughts
the start the trip—you slip into a
don’t linger there.
state of religious,
It shouldn’t
mystic timelessness.”
surprise me if
“I don’t look polite. I
at this time next
am big and droopy and need
week I’m
a haircut. No soul
surrounded by
would associate
family, gathered
mewith watercress
on short notice...
sandwiches. Still, every
to help
year or so someone
decide, after
takes me aside and says, you
what’s happened,
actually are weirdly polite,
what’s to be done
aren’t you? And I always thrill.
with me now. It
They noticed.”
must be this
“She rarely learned her
hovering
schedule more than three
knowledge, that
two-ton safe days before the start of
swaying on a a workweek, plunging
frayed rope just her into urgent
over my head, logistical puzzles
that makes over who would
everyone so glad watch the boy.
to see me again.” Months after starting the job
“Tubing, more she moved out of her aunt’s
than any home, in part because
narcotic, of mounting
fundamentally friction
changes your
perception of time.
The trip downriver
takes almost five
hours, but that’s
only by the clock.
As soon as you
68
 ABHIJEET SINGH BCA 1A

over the erratic

schedule,
which the
aunt felt
was also
holding her
family
captive. Ms.
Navarro’s degree was
on

indefinite
pause
because her
shifting
hours left her

unable to
commit to
classes. She
needed to
work all
she could,
sometimes
counting on
dimes from
the tip jar to
make the
bus fare
home. If she
dared ask
for more
stable hours, she
feared,
she would
get fewer
work
hours
over all.”
69
 ABHIJEET SINGH BCA 1A

Creating hyperlinks:

Insert a Link
1. Click the Insert tab.
2. Select the text or graphic you want to use as a hyperlink.

2. Expand the Links group, if necessary.

3. Click the Link button.
4. Select the type of object you want to link to on the left side of the dialog box:

 Existing File or Web Page: Creates a link that takes you to another document, a file
created in another program like an Excel worksheet, or to a webpage.
 Place in This Document: Jumps to a heading or bookmark in the same document.
 Create New Document: Creates a new Word document, then inserts a hyperlink to
the new document.
 E-mail Address: Creates a clickable email address that will create a new email
message when clicked.

70
 ABHIJEET SINGH BCA 1A

5. Specify where the link should lead to:

Depending on what you’re linking to, you’ll have different options here.
Specify an external file or webpage, a heading or bookmark in the document,
a new file name, or an email address.

EXAMPLE: Lorem ipsum dollar sit

6. Click OK.

To edit a hyperlink, right-click it and select Edit Hyperlink. To delete one,

right-click it and select Remove Hyperlink.

71
 ABHIJEET SINGH BCA 1A

Q13. To practice basic DOS commands like cd, md, dir.,

erase, cls, copy, date etc.

1. DIR Command - This is called a directory list. A directory list is a list of all
the files and subdirectories that a directory contains. In this case, you see all the files
and directories in the main or root directory of your drive. All the files and directories
on your drive are stored in the root directory.

2. Date Command - To View and change the

date C:\>date
Current date is: 01-01-2008
Enter new date (mm/dd/yy):21-03-2009

72
 ABHIJEET SINGH BCA 1A

3. Cls Command - To clear the screen.

\>cls

4. Time Command – To view and change the time.

C:\>Time
The current time is: 06:11:56.45a
Enter new time:1:15:48.57p

73
 ABHIJEET SINGH BCA 1A

5. Md/mkdir: Creates a new subdirectory. If you do not

specifically enter a path designation, the directory will be created as
a subdirectory within the current directory. There is no limit to the
number of directories you can create.

74
 ABHIJEET SINGH BCA 1A

6. CD Command: To change the directory.

7. Copy con: Copy con is an MS-DOS and Windows command line

command that allows the creation of a file through the command line. To use
this command, type "copy con" followed by the name of the file you want
to create, as shown below. After this command is typed, you are returned to
a blank line, which is the start of your file.

8. Copy: COPY is usually used to copy one or more files from one
location to another. However, COPY can also be used to create new files. By
copying from the keyboard console (COPY CON:) to the screen, files can be
created and then saved to disk.

9. Del: You can use wildcard characters (? and *) to delete groups of files.
If you don`t specify a pathname, the program assumes the files to be deleted
are on the drive and directory you are currently using.

75
 ABHIJEET SINGH BCA 1A

10. Type: In computing, type is a command in various command-line

interpreters (shells) such as COMMAND.COM, cmd.exe, 4DOS/4NT and
Windows PowerShell used to display the contents of specified files on the
computer terminal.

11. Cd...: This command is used to back to the parent directory.

12. rd.: to remove a directory.

76
 ABHIJEET SINGH BCA 1A

Q14. Create a Power Point Presentation on any topic of

your choice using animation and transition features.

77
 ABHIJEET SINGH BCA 1A

78
 ABHIJEET SINGH BCA 1A

79
 ABHIJEET SINGH BCA 1A

80
 ABHIJEET SINGH BCA 1A

81
 ABHIJEET SINGH BCA 1A

82
 ABHIJEET SINGH BCA 1A

83
 ABHIJEET SINGH BCA 1A

84
 ABHIJEET SINGH BCA 1A

Q15.MS Excel student Manual.

MS Excel tutorial provides basic and advanced concepts of Excel. Our Excel tutorial is
designed for beginners and professionals by keeping their requirements in mind.

Microsoft Excel is a computer application program written by Microsoft. It mainly

comprises tabs, groups of commands, and worksheets. It stores the data in tabular form
and allows the users to perform manipulation operations on them.

Our MS Excel tutorial will cover all topics from basic to advance, such as Introduction of
MS Excel, worksheets, ribbon and tabs, functions, formula, MS Excel online, Excel VBA
editor, data validations, conditional formatting, and more. Along with it, we will also show
you the steps to download and activate MS Excel

What is Microsoft Excel?

Microsoft Excel is an office use application designed by Microsoft. It comes with Office
Suite with several other Microsoft applications, such as Word, PowerPoint, Access,
Outlook, and OneNote, etc. It is supported in Windows as well as Mac operating system
too.

Microsoft Excel is one of the most suitable spreadsheet programs that help us to store and
represent the data in tabular form, manage and manipulate data, create optically logical
charts, and more. Excel provides you the worksheet to create a new document in it. You
can save the Excel file with .xls extension.

85
 ABHIJEET SINGH BCA 1A

Worksheet
A worksheet is made of rows and columns that intersect each other to form cells where
data is entered. It is capable of performing multiple tasks like calculations, data analysis,
and integrating data.

In Excel worksheet, rows are represented by numbers and columns by alphabets.

A single Excel workbook can consist of several sheets, named Sheet1, Sheet2, Sheet3…
Sheet N. You can add one or more sheets to your Excel document.

86
 ABHIJEET SINGH BCA 1A

Microsoft Excel Features

There are several features that are available in Excel to make our task more manageable.
Some of the main features are:

1. AutoFormat: It allows the Excel users to use predefined table formatting

options.
2. AutoSum: AutoSum feature helps us to calculate the sum of a row or
column automatically by inserting an addition formula for a range of
cells.
3. List AutoFill: It automatically develops cell formatting when a new
component is added to the end of a list.
4. AutoFill: This feature allows us to quickly fill cells with a repetitive or
sequential record such as chronological dates or numbers and repeated
documents. AutoFill can also be used to copy functions. We can also
alter text and numbers with this feature.
5. AutoShapes: AutoShapes toolbar will allow us to draw some geometrical
shapes, arrows, flowchart items, stars, and more. With these shapes, we
can draw our graphs.
6. Wizard: It guides us to work effectively while we work by displaying several
helpful tips and techniques based on what we are doing. Drag and Drop
feature will help us to reposition the record and text by simply dragging the
data with the help of the mouse.
7. Charts: This feature will help you to present the data in graphical form by

87
 ABHIJEET SINGH BCA 1A
using Pie, Bar, Line charts, and more.

88
 ABHIJEET SINGH BCA 1A

8. PivotTable: It flips and sums data in seconds and allows us to execute

data analysis and generating documents like periodic financial statements,
statistical documents, etc. We can also analyse complex data relationships
graphically.
9. Shortcut Menus: The shortcut menu helps users to make the work done
through shortcut commands that need a lengthy process.

Excel Interface
It is the main interface of an Excel worksheet, where we work and store our data. This
interface contains various components. Before start working with Excel worksheet, you
should be familiar with these components so that you can use the Excel application
efficiently.

Once you get familiar with the Excel interface, you will able to identify the basic and most-
used components of an Excel workbook. We have explained a bit about these
components.

89
 ABHIJEET SINGH BCA 1A

Quick Access Toolbar

The Quick Access Toolbar contains some common and most used commands of Excel,
which users repeatedly need while working with Excel. By default, Save, Undo, and
Repeat commands are added in the quick access toolbar.

It provides fast access to its users by adding most-used commands in it. This quick access
toolbar is customizable. It means you can add other commands, whichever you need
most.

Add commands to the Quick Access toolbar

Step 1: Click on the drop-down arrow to the right of the Quick Access toolbar.

90
 ABHIJEET SINGH BCA 1A

Step 2: Select the command you wish to add in the quick access toolbar from the drop-
down menu.

Step 3: Here, we have selected command Print Preview and Print that has been added
to the Quick Access toolbar along with other commands. You can see it here.

91
 ABHIJEET SINGH BCA 1A

Excel Ribbon
Excel 2016 utilizes a tabbed Ribbon system instead of traditional menus. The
Ribbon includes multiple tabs, each with several groups of commands. We will use
these tabs to perform the most common function in Excel.

File, Home, Insert, Page Layout, Formula, Data, Review, View, and Help are the tabs
consists by the Excel ribbon.

Each tab of Excel Ribbon contains its related operations list. For example, the formula tab
contains all the mathematical, logical, text, string, finance, Date, and time functions.

To minimize and maximize the Ribbon

The Ribbon is designed to respond to our current function, but we can choose to minimize
it if we find that it takes up too much screen space.

1. To click the Ribbon Display Options arrow in the upper-right corner of the Ribbon.

92
 ABHIJEET SINGH BCA 1A

2. Select the desired minimizing options from the drop-down menu:

o Auto-hide Ribbon: Auto-hide shows our workbook in full-screen mode and hides
the Ribbon completely. To show the Ribbon, click Expand Ribbon command at
the top of the screen.

o Show Tabs: This option hides all command groups when not in use, but tabs will
remain there. To show the Ribbon, simply click on any of the tabs.

93
 ABHIJEET SINGH BCA 1A

o Show Tabs and Commands: This option maximizes the Ribbon. All of the tabs
and commands will always be visible to the user. This option is selected by default
when we open Excel for the first time.

Formula Bar
In the formula bar, we can enter or edit data, a formula, or a function that will occur in a
specific cell. It allows to write the function and formulas to manipulate the data.

In the image below, cell C1 is selected, and 2000 is entered into the formula bar. Note how
the data contains in both the formula bar and in cell C1.

94
 ABHIJEET SINGH BCA 1A

Name Box
The Name box presents the location or "name" of a selected cell.

In the image below, cell B4 is selected. Noted that cell B4 is where column B and row 4
intersect.

The Backstage View (The File Menu)

Click the File tab on the Ribbon. The Backstage view will emerge.

95
 ABHIJEET SINGH BCA 1A

It is the backstage view of MS Excel and information about the options it contains.

The Worksheet Views

Excel 2016 has a variety of displaying options that change how our workbook is showed.
We can choose to view any workbook in the Normal view, Page Layout view, or Page
Break view. These views can be useful for several tasks, especially if we're planning
to print the spreadsheet.

To change the worksheet views, locate and choose the desired worksheet view command
in the bottom-right corner of the Excel window.

96
 ABHIJEET SINGH BCA 1A

Zoom Control
To use a Zoom control, click and drag the slider. The number to the right of the slider
reverse the zoom percentage. It presents at the bottom right corner of the Excel worksheet.

By default, Excel view zoom percent is 100%.

97
 ABHIJEET SINGH BCA 1A

Q16. Create a directory in MS DOS by your name in that directory. Create file1
named as ICIT and file2 named as ICIT Lab. In file name as ICIT write 5 lines on MS
DOS and perform following operations:

1) copy content of ICIT Lab

2) check the attribute of all file and directory
3) display above list in a tree like format
4) create a sub directory in main directory named as sub directory1, move ICIT into
sub directory1 rename it as my file.

CREATING DIR AND FILES

98
 ABHIJEET SINGH BCA 1A

1) copy content of icit to icit lab

99
 ABHIJEET SINGH BCA 1A

2) check the attributes of all files and dir.

100
 ABHIJEET SINGH BCA 1A

3) display above listing in a tree like format

101
 ABHIJEET SINGH BCA 1A

102
 ABHIJEET SINGH BCA 1A

4) create a sub dir. in main dir. named as sub directory 1 move icit file
into sub directory 1 renamed it as my file.

103