ICIT PRACTICAL FILE

SUBJECT CODE-BCA-153
PRACTICAL-II (IT LAB)

Submitted to: Submitted by:

Dr. Amit Choudhary Name: Abc
Associate Professor Enrollment No.: - 00014902020
Deptt. of Comp. Sc. Course: BCA 1st Shift Sec-A

DEPARTMENT OF COMPUTER APPLICATIONS

MAHARAJA SURAJMAL INSTITUTE
C-4, JanakPuri, New Delhi, 110058
 LIST OF CONTENTS
(A) MS Word Assignments:
I. Introduction to various components of a computer cabinet
II.Introduction to MS Office, features and services
III. Introduction to Word Processor, MS Word, its
features
IV. Major components of MS Word window
V. Resume using template
VI. Invitation to Freshers Party
VII. Article with 2 columns and hyperlink
VIII. Article with 3 columns, 3 font colour, 3 font size, 3
font styles
IX. Explain Mailmerge, its advantages
X. Describe procedure of Mailmerge, write a letter to 15
people using it, also, write an invitation to 5 people.
XI. What is Macro, create using toolbar
XII. What are the steps of Macro, create one using
keyboard
XIII. Create a Timetable on Ms word
XIV. Draw a flowchart on MS word

(B) MS Excel Assignments:

I. What is Excel, Ribbon and toolbars
II.Create your own marksheet
III. Create a marksheet of 10 students
 IV. Create a Timetable of your class on Excel
V. Prepare an Invoice
VI. Prepare a Company’s monthly salary slip
VII. Make a monthly/yearly salesmen report
VIII. Create an items list of Mother Dairy
IX. Create a record of customer, account, interest etc.
X. Use mathematical functions, string, logical etc.
XI. Create a Pivot table for a fruits and vegetable
company.

(C) MS PowerPoint Assignments:

I. What do you understand by MS PowerPoint ? What are
the qualities of a good ppt.
II.Explain components of a PowerPoint window
III. Create a PowerPoint on any topic of your choice
 MS
WORD
ASSIGNMENTS
 MAHARAJA SURAJMAL INSTITUTE
COMPUTER APPLICATIONS LAB.

Assignment 1:
Identification and introduction to various Internal
Components of a computer Cabinet.

Mainly Computer system consists of 3 parts, that are CPU, Input Devices
and Output Devices. CPU is further divided into ALU, MU and CU. A
large amount of data is stored in the computer memory with the help of
Auxiliary Storage devices. CPU is like the heart/brain of the computer.
The user does not get desired output, without the necessary option taken
by CPU. It is responsibe fot the processing of all the instructions which
are given by the user to the computer system. Data is entered through
input devices, CPU processes it and produces the output, Further Output
gets presented to the user through Output devices.

The Components of Computer can be described as follows:

1. Input Devices: They help the users to provide data and instructions to
the computer, they also convert the user data into the machine language.
Examples: Keyboard, Mouse etc.

2. Output Devices: Used for displaying the results. They convert

information into human-readable form. Examples: Monitor, Printers etc.

3. Control Unit: CU directs the operation of the Processor. It tells the

computer’s memory, ALU, Input & Output devices on how to respond to
instructions sent to the processor.

4. Arithmetic Logic Unit: It performs functions like addition,

subtraction, division and multiplication; comparisons like less than,
Greater than, equal to etc.

5. Auxiliary Storage: It holds programs and data for future use. It is non
volatile and hence it is used to store inactive programs. Examples: Hard
disk, floppy etc.

6. Main Memory: Space on the hard drive that is briefly used for working
space. This usually occurs in a chip. Types: RAM(Volatile) & ROM(Non-
Volatile).
Assignment 2:

Introduction to MS Office: its Features and

various Services.
Submitted by – Anubhav Roy, B.com (Hons.) {shift 1}, Batch:
2020-23

An introduction to the MS Office: -

Microsoft office, or simply office, is a family of client software, server software, and
services developed by Microsoft. It was first announced by Bill Gates on 1st August,
1988, at COMDEX in Las Vegas. The first version of Office contained MS Word, MS
Excel, and MS-PPT. Over the years, Office applications have grown substantially
closer with shared features such as a common spell checker, OLE data integration
and Visual Basic applications for scripting language. Microsoft also positions Office
as a development platform for line-of-business software under the Office business
application brand. On July 10, 2012, Softpedia reported that Office was being used by
over a billion people worldwide.
Office is produced in several versions targeted towards different end-users and
computing environments. The original, and most widely used version, is
the desktop version, available for PCs running the Windows and macOS operating
systems. Microsoft also maintains mobile apps for Android and iOS. Office on the
web is a version of the software that runs within a web browser.
The current on-premises, desktop version of Office is Office 2019, released on
September 24, 2018.
New Features Introduced in Microsoft Office 2019 [latest version of Office]: -

 Scalable Vector Graphics for Word, Excel, PowerPoint

 Microsoft Translator in Word, Excel, PowerPoint
 Create Math Equations with LaTeX equation in Word
 Create smoother animations and movements with Morph in PowerPoint
 New navigation feature called Zoom for PowerPoint
 Use Surface Pen to navigate slides in PowerPoint
 Exciting new functions in Excel
 More powerful Inking functionality for all of Office 2019

Services Under Microsoft Office: -

 MS Word: a word processor included in Microsoft Office and some editions

of the now-discontinued Microsoft works. The first version of
Word, released in the autumn of 1983, was for the MS-DOS
operating system and introduced the computer mouse to
more users. Word 1.0 could be purchased with a bundled
 mouse, though none was required. Word for Mac was released in 1985. Word
for Mac was the first graphical version of Microsoft Word.

 MS Excel: a spreadsheet editor that originally competed with

the dominant Lotus 1-2-3 and eventually outsold it. Microsoft
released the first version of Excel for the Mac OS in 1985 and the
first Windows version (numbered 2.05 to line up with the Mac)
in November 1987.

 Microsoft PowerPoint: a presentation program used to

create slideshows composed of text, graphics, and other
objects, which can be displayed on-screen and shown by the
presenter or printed out on transparencies or slides.

 Microsoft One note: a note making program that gathers handwritten or

typed notes, drawings, screen clippings and audio
commentaries. Notes can be shared with other OneNote
users over the Internet or a network. OneNote was initially
introduced as a standalone app that was not included in
any MS Office 2003 edition. However, OneNote eventually
became a core component of Microsoft Office; with the
release of Microsoft Office 2013, OneNote was included in all Microsoft Office
offerings.

 MS Outlook: a personal information manager that replaces Windows

Messaging, Microsoft Mail, and Schedule+ starting in
Office 97; it includes an e-mail client, calendar, task
manager and address book. On the Mac OS, Microsoft
offered several versions of Outlook in the late 1990s, but
only for use with Microsoft Exchange server. In Office
2001, it introduced an alternative application with a
slightly different feature set called Microsoft Entourage. It reintroduced
Outlook in Office 2011, replacing Entourage.
  Microsoft OneDrive: A file hosting service that allows users to sync files
and later access them from a web browser or mobile device.

 Skype for Business: an integrated communications client for conferences

and meetings in real-time, it is the only Microsoft Office desktop app that is

neither useful without a proper network infrastructure nor has the "Microsoft"
prefix in its name.

 Microsoft Teams: a platform that combines workplace chat, meetings,

notes, and attachments. Microsoft announced that Teams
would eventually replace Skype for Business.

Assignment 3:
Introduction to word processor software- MS Word
and its various features.
Word Processor: A word processor is a type of software application used for
composing, editing, formatting and printing documents. Word processors have a
variety of uses and applications within the business environment, at home and in
educational contexts.
Word processors are used to create, edit and print documents, and saving them
electronically.
Word processors have the following main functionalities:

 Insert
 Copy
 Cut and paste
 Delete
 Find and replace
 Print
 Word wrap

Advanced word processors, referred to as full-featured word processors, support

additional features such as:

 File management
 Graphics
 Font specification
 Footnotes
 Cross reference
 Headers and footers
 Macros
 Layout
 Spell check

Examples of Word Processor software:

 Abiword.
 Apple iWork - Pages.
 Apple TextEdit - Apple macOS included word
processor.
 Google Docs (online and free).
 LibreOffice -> Writer (free).
 Microsoft Office -> Microsoft Word.
 Microsoft WordPad
 SoftMaker FreeOffice -> TextMaker (free).
 OpenOffice -> Writer (free)
 Sun StarOffice (discontinued).
MS Word: Microsoft Word is one of the most
popular software programs in the world, used by
millions of office workers, students and home users
to create, read and edit documents.

Features of MS Word:

1. CHECK YOUR SPELLING: You can correct your spelling errors all in one go, to
ensure you have not left any stone unturned. We can do that by running a full Word
spell check from the Review tab, Proofing, Spelling and Grammar button (or press
the F7 keyboard shortcut).

2. FIND AND REPLACE: Word Replace can search for all occurrences of a
particular word, phrase, or set of characters and replace them with an alternative. In
this way, you can save your precious time. It gives you the option to replace all
occurrences or to move through them individually, accepting or rejecting each
change.

3. WATERMARKS: If you're sending an important document, you want to be able

to protect your content without having to edit much of it. Insert a watermark specific
to your objectives via the page layout button. You can also create your watermark,
and also insert your picture.

4. HEADER AND FOOTER: It's essential to use the space in your header and
footer. In this way you can save space in other areas of your document. This also
makes your file to have a professional look. However, people don't seem to take
advantage. That is the fact that they can insert images, more specifically, a company
logo or an idea in context with the document's overall theme.

5. HYPERLINKS: The best way to give your Word document that extra cutting
edge is to insert hyperlinks. It makes images and texts of your document interactive.
A great way to further utilize this tool is to direct users to another article or web page
that has your digital footprint all over.
Assignment 4:
Describe major components of MS-Word document window.

 Menu bar: Contains File,Edit, View, Insert, Format, Tools, Table, Window
and Help menus.

 Standard Tool Bar: Contains icons for shortcuts to menu commands.

 Formatting tool bar: Contains pop-up menus for style, font, and font size;
icons for boldface, italic, and underline; alignment icons; number and bullet
list icons; indention icons, the border icon, highlight, and font color icons.

 Ruler: Ruler on which you can set tabs, paragraph alignment, and other
formats.

 Insertion point: Blinking vertical bar that indicates where text you type will
be inserted. Don’t confuse the insertion point with the mouse I-beam. To
move the insertion point, just click the mouse where you want the point
moved.
 End-of-file marker: Non-printing symbol that marks the end of the file.
You cannot insert text after this mark.

 Selection Bar: Invisible narrow strip along the left edge of the window. Your
mouse pointer changes to a right-pointing arrow when it is in this area. It is
used to select a line, a paragraph, or the entire document.

 Status Bar: Displays page number, section number, and total number of
pages, pointer position on page and time of day.

 Office Assistant: An animated character that can provide help and

suggestions. There are multiple characters to choose from, and it is possible to
turn the Office Assistant off.

 Task Pane: Displays and groups commonly used features for convenience.

 Split Handle: Double-click to split the window in two (to view different
portions of the same file). Double-click to return to one window
Assignment 5:
Create your Resume using Resume Template on MS
word

Steps taken to make a Resume on MS-word:

1. Open MS Word, then, under file, search for a resume template and
finalize the one of your choice.
2. The template gets opened in the workplace. Now, remove the data
already present as the information needs to be of your own.
3. The subheadings under Resume can be altered as well, as per your
requirement.
4. Now type your name at the place allocated for it in the template. You
can insert your image too.
5. Now fill in further information under sub-heads like:
 Personal information
 Communication
 Leadership
 Education qualifications (A table can be inserted here to present it
in a better manner.)
 Additional experience etc.
6. Now add your contact details such as:
 Email address
 Residential address
 Contact no. etc.
7. Resume using template on MS word is done.
Assignment 6:
Create an invitation for Fresher’s party using Page border,
background effect, watermark, pictures/clip art and using
Word Art.

Steps taken to make an invitation of freshers’ party on MS

Word:

1. Open MS Word and select blank document.

2. Then set the background for which you need to select Design on the
menu bar, and then go to page color.
3. Under page colour, you may select some pattern, color, gradient or
texture for the background.
4. On the right of page color, you may select a page border as well.
5. On the left, there is an option of watermark, select that, a drop down
list will open, select custom watermark. Then, type whatever you want as
your watermark and then select the style you want it to appear, then
press ok.
6. Now, begin drafting your invitation.
7. First of all give a heading and type the name of the instituition issuing
the poster.
8. Next, give a title to your event (use word art) and then type a nice
quote.
9. Then, mention the following details:
 Date
 Time
 Venue
 Any important instructions
 Activities etc.
10. An image may be inserted to make it more visually appealing.
11. Lastly, give details of the person whom the invitees need to contact in
case of any query.
12. Freshers party Invitation on MS Word is done.
Assignment 7:
Design an article for a magazine with 2 columns using
different font styles, font sizes, and font effects. Use
hyperlinks, pictures, word art, Smart Art.

Steps Taken:

1. Open MS word and type an article on a topic of your choice. You may
choose the font style and font size as per your choice.

2. Select the whole content of the article, go to layout, click on columns,

and then click on the second option ‘two’ which stands for two columns.

3. For heading, use wordart which can be accessed by going on insert

menu.

4. Select individual paragraphs and then change the font color.

5. Then, go to insert, select pictures, and then insert one or more

relevant pictures.

6. Now select some text, go to insert, select the option of link/hyperlink.

7. Copy and paste the relevant URL which you want your hyperlink to be
connected with, press ok.
Assignment 8:
Write an article using at least three columns different Font
style,three font sizes,three font colors and three font effects.

The Good and Bad Effects of TV on Children

Steps taken in this Assignment:
1. Open MS Word and type an Article of 1-2 pages
on a topic of your choice and give a suitable
heading.
2. Now select the whole content, go to layout,
select columns.
3. A drop down list will get opened so now select
option three.
4. Now select the first column, choose a distinct
font colour, font style and font size.
5. Repeat the same steps for the second column.
6. Lastly, do the same for the third column and
now, the assignment is over.
Assignment 9:
Explain the Mail Merge feature of Word and write the
advantages of Mail Merge.

Mail Merge: It is one of the functions available on MS Word. Mail merges are one
of the quickest ways to customize documents like emails, newsletters, and other
personalized messages. A mail merge lets you create personalized documents that
automatically vary on a recipient-by-recipient basis. This spares you the trouble of
manually personalizing each document yourself!

Mail merges can be used to create personalized messages automatically for

documents such as:

 Marketing emails

 Envelopes

 Mailing labels

 Newsletters

 Custom catalogs

 Form letters

 And more!

Advantages of mail merge:

 saves your time and effort.

 Producing mass mailings is much simplified, especially compared to the process of
preparing individual letters or envelopes to many people.
 Typography, Formatting & Graphics.
 Coordination Within Microsoft Office. (The names of these merge fields correlate
with field names in a list document that you create in Microsoft Excel, Microsoft
Access, or through a form built in to the mail merge process in Word.)
Assignment 10:
Describe the mail merge procedure. Also, write a letter to
atleast 15 people using mail merge. Also write an invitation
card to 5 people using mailmerge.
Steps to be followed for doing mail merge:-

1. In a blank Microsoft Word document, click on the Mailings tab, and in the Start Mail
Merge group, click Start Mail Merge.

2. Click Step-by-Step Mail Merge Wizard.

3. Select your document type. In this demo we will select Letters. Click Next: Starting
document.
4. 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.

5. Select recipients. In this demo we will create a new list, so select Type a new list and
then click Create.
6. Write the letter and add custom fields.

Click Address block to add the recipients' addresses at the top of the document.

7. 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
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.
 Application of Mailmerge

Mr. Paul Legrand

ABC.Pvt.Ltd,

C-72,

Janak puri,

New Delhi - 110058, Delhi

India

1122335517

2345678799

paulegrand@gmail.com

February 15 th , 2021

Dear Mr. Legrand,

Subject: Invitation for product launching event

We are pleased to inform you that our company- Roy Artgallery.Pvt.Ltd is coming up with a huge number
of new products including statues, Wall hangings and many more, for which, we are organising a Product
Launching Event.

We invite you for the same on February 22 nd , 2021 at Radisson blu, Dwarka, at 10:00am. The event will
take place is hall no. 1. There will be refreshments for the guests. There will also be cultural performances
from all over India.

Looking forward for a positive response from your side.

Thanks and Regards

Anubhav Roy

(CEO: Roy Artgallery.Pvt.Ltd.)

Ms. Anne Ortha

PQRS.Ltd,

D-14,

Janak puri,

New Delhi - 110058, Delhi

India

1247627899

1234567890

annortha@gmail.com

February 15 th , 2021

Dear Ms. Ortha,

Subject: Invitation for product launching event

We are pleased to inform you that our company- Roy Artgallery.Pvt.Ltd is coming up with a huge number
of new products including statues, Wall hangings and many more, for which, we are organising a Product
Launching Event.

We invite you for the same on February 22 nd , 2021 at Radisson blu, Dwarka, at 10:00am. The event will
take place is hall no. 1. There will be refreshments for the guests. There will also be cultural performances
from all over India.

Looking forward for a positive response from your side.

Thanks and Regards

Anubhav Roy

(CEO: Roy Artgallery.Pvt.Ltd.)

Mr. Ray Sin

ABCD.org,

A-90,

Rajouri Garden,

New Delhi - 110035, Delhi

India

0987654321

0987654345

Ray@gmail.com

February 15 th , 2021

Dear Mr. Sin,

Subject: Invitation for product launching event

We are pleased to inform you that our company- Roy Artgallery.Pvt.Ltd is coming up with a huge number
of new products including statues, Wall hangings and many more, for which, we are organising a Product
Launching Event.

We invite you for the same on February 22 nd , 2021 at Radisson blu, Dwarka, at 10:00am. The event will
take place is hall no. 1. There will be refreshments for the guests. There will also be cultural performances
from all over India.

Looking forward for a positive response from your side.

Thanks and Regards

Anubhav Roy

(CEO: Roy Artgallery.Pvt.Ltd.)

Ms. Hazel Rosewood

XYZ.Co.,

B-62,

Rajouri Garden,

New Delhi - 110035, Delhi

India

1653627281

2345657698

HR@gmail.com

February 15 th , 2021

Dear Ms. Rosewood,

Subject: Invitation for product launching event

We are pleased to inform you that our company- Roy Artgallery.Pvt.Ltd is coming up with a huge number
of new products including statues, Wall hangings and many more, for which, we are organising a Product
Launching Event.

We invite you for the same on February 22 nd , 2021 at Radisson blu, Dwarka, at 10:00am. The event will
take place is hall no. 1. There will be refreshments for the guests. There will also be cultural performances
from all over India.

Looking forward for a positive response from your side.

Thanks and Regards

Anubhav Roy

(CEO: Roy Artgallery.Pvt.Ltd.)

Mr. Cesar Salad

DEF.Ltd.,

Z-12,

Vikas puri,

New Delhi - 110067, Delhi

India

4568754567

9654567767

Cesar@gmail.com

February 15 th , 2021

Dear Mr. Salad,

Subject: Invitation for product launching event

We are pleased to inform you that our company- Roy Artgallery.Pvt.Ltd is coming up with a huge number
of new products including statues, Wall hangings and many more, for which, we are organising a Product
Launching Event.

We invite you for the same on February 22 nd , 2021 at Radisson blu, Dwarka, at 10:00am. The event will
take place is hall no. 1. There will be refreshments for the guests. There will also be cultural performances
from all over India.

Looking forward for a positive response from your side.

Thanks and Regards

Anubhav Roy

(CEO: Roy Artgallery.Pvt.Ltd.)

Ms. Allie Grater

IJK.ltd,

H-345,

Uttam Nagar,

New Delhi - 110045, Delhi

India

2348987659

5456787656

Alliegrater@gmail.com

February 15 th , 2021

Dear Ms. Grater,

Subject: Invitation for product launching event

We are pleased to inform you that our company- Roy Artgallery.Pvt.Ltd is coming up with a huge number
of new products including statues, Wall hangings and many more, for which, we are organising a Product
Launching Event.

We invite you for the same on February 22 nd , 2021 at Radisson blu, Dwarka, at 10:00am. The event will
take place is hall no. 1. There will be refreshments for the guests. There will also be cultural performances
from all over India.

Looking forward for a positive response from your side.

Thanks and Regards

Anubhav Roy

(CEO: Roy Artgallery.Pvt.Ltd.)

Mr. Perry Scope

LMN.pvt.ltd,

F-21,

Greater Kailash,

New Delhi - 110097, Delhi

India

1368646786

3456654345

Pscope@gmail.com

February 15 th , 2021

Dear Mr. Scope,

Subject: Invitation for product launching event

We are pleased to inform you that our company- Roy Artgallery.Pvt.Ltd is coming up with a huge number
of new products including statues, Wall hangings and many more, for which, we are organising a Product
Launching Event.

We invite you for the same on February 22 nd , 2021 at Radisson blu, Dwarka, at 10:00am. The event will
take place is hall no. 1. There will be refreshments for the guests. There will also be cultural performances
from all over India.

Looking forward for a positive response from your side.

Thanks and Regards

Anubhav Roy

(CEO: Roy Artgallery.Pvt.Ltd.)

Mr. Ginger Plant

OPQ.ltd,

J-67,

Hauz Khas,

New Delhi - 110054, Delhi

India

8765788886

3456786487

Gingerplant@gmail.com

February 15 th , 2021

Dear Mr. Plant,

Subject: Invitation for product launching event

We are pleased to inform you that our company- Roy Artgallery.Pvt.Ltd is coming up with a huge number
of new products including statues, Wall hangings and many more, for which, we are organising a Product
Launching Event.

We invite you for the same on February 22 nd , 2021 at Radisson blu, Dwarka, at 10:00am. The event will
take place is hall no. 1. There will be refreshments for the guests. There will also be cultural performances
from all over India.

Looking forward for a positive response from your side.

Thanks and Regards

Anubhav Roy

(CEO: Roy Artgallery.Pvt.Ltd.)

Ms. Anne T. Dote

RST.co,

L-35,

Karol Bagh,

New Delhi - 110064, Delhi

India

6787678898

3467765459

Anne@gmail.com

February 15 th , 2021

Dear Ms. T. Dote,

Subject: Invitation for product launching event

We are pleased to inform you that our company- Roy Artgallery.Pvt.Ltd is coming up with a huge number
of new products including statues, Wall hangings and many more, for which, we are organising a Product
Launching Event.

We invite you for the same on February 22 nd , 2021 at Radisson blu, Dwarka, at 10:00am. The event will
take place is hall no. 1. There will be refreshments for the guests. There will also be cultural performances
from all over India.

Looking forward for a positive response from your side.

Thanks and Regards

Anubhav Roy

(CEO: Roy Artgallery.Pvt.Ltd.)

Ms. Amanda Hug

UVW.ltd,

J-23,

Dwarka,

New Delhi - 110075, Delhi

India

2527292977

1234567654

Amanda@gmail.com

February 15 th , 2021

Dear Ms. Hug,

Subject: Invitation for product launching event

We are pleased to inform you that our company- Roy Artgallery.Pvt.Ltd is coming up with a huge number
of new products including statues, Wall hangings and many more, for which, we are organising a Product
Launching Event.

We invite you for the same on February 22 nd , 2021 at Radisson blu, Dwarka, at 10:00am. The event will
take place is hall no. 1. There will be refreshments for the guests. There will also be cultural performances
from all over India.

Looking forward for a positive response from your side.

Thanks and Regards

Anubhav Roy

(CEO: Roy Artgallery.Pvt.Ltd.)

Ms. Ivana B. Withew

AB.ltd,

O-87,

Saket,

New Delhi - 110085, Delhi

India

9865433783

9876543456

Ivanabw@gmail.com

February 15 th , 2021

Dear Ms. B. Withew,

Subject: Invitation for product launching event

We are pleased to inform you that our company- Roy Artgallery.Pvt.Ltd is coming up with a huge number
of new products including statues, Wall hangings and many more, for which, we are organising a Product
Launching Event.

We invite you for the same on February 22 nd , 2021 at Radisson blu, Dwarka, at 10:00am. The event will
take place is hall no. 1. There will be refreshments for the guests. There will also be cultural performances
from all over India.

Looking forward for a positive response from your side.

Thanks and Regards

Anubhav Roy

(CEO: Roy Artgallery.Pvt.Ltd.)

Mr. Greg Arias

LMON.co,

S-322,

Paschim Vihar,

New Delhi - 110012, Delhi

India

2556287652

6567897656

Gregar@gmail.com

February 15 th , 2021

Dear Mr. Arias,

Subject: Invitation for product launching event

We are pleased to inform you that our company- Roy Artgallery.Pvt.Ltd is coming up with a huge number
of new products including statues, Wall hangings and many more, for which, we are organising a Product
Launching Event.

We invite you for the same on February 22 nd , 2021 at Radisson blu, Dwarka, at 10:00am. The event will
take place is hall no. 1. There will be refreshments for the guests. There will also be cultural performances
from all over India.

Looking forward for a positive response from your side.

Thanks and Regards

Anubhav Roy

(CEO: Roy Artgallery.Pvt.Ltd.)

Mr. Ben Dover

PQRST.ltd,

P-456,

C.R. Park,

New Delhi - 110005, Delhi

India

3637474646

2345654398

Bend@gmail.com

February 15 th , 2021

Dear Mr. Dover,

Subject: Invitation for product launching event

We are pleased to inform you that our company- Roy Artgallery.Pvt.Ltd is coming up with a huge number
of new products including statues, Wall hangings and many more, for which, we are organising a Product
Launching Event.

We invite you for the same on February 22 nd , 2021 at Radisson blu, Dwarka, at 10:00am. The event will
take place is hall no. 1. There will be refreshments for the guests. There will also be cultural performances
from all over India.

Looking forward for a positive response from your side.

Thanks and Regards

Anubhav Roy

(CEO: Roy Artgallery.Pvt.Ltd.)

Ms. Bess Twishes

UVWXY.pvt.ltd,

D-364,

Moti Nagar,

New Delhi - 110043, Delhi

India

2827363636

2345678909

Bestwishes@gmail.com

February 15 th , 2021

Dear Ms. Twishes,

Subject: Invitation for product launching event

We are pleased to inform you that our company- Roy Artgallery.Pvt.Ltd is coming up with a huge number
of new products including statues, Wall hangings and many more, for which, we are organising a Product
Launching Event.

We invite you for the same on February 22 nd , 2021 at Radisson blu, Dwarka, at 10:00am. The event will
take place is hall no. 1. There will be refreshments for the guests. There will also be cultural performances
from all over India.

Looking forward for a positive response from your side.

Thanks and Regards

Anubhav Roy

(CEO: Roy Artgallery.Pvt.Ltd.)

Mr. Mark Ateer

QRS.ltd,

I-283,

Tilak Nagar,

New Delhi - 110057, Delhi

India

8837767283

1456765798

Mark@gmail.com

February 15 th , 2021

Dear Mr. Ateer,

Subject: Invitation for product launching event

We are pleased to inform you that our company- Roy Artgallery.Pvt.Ltd is coming up with a huge number
of new products including statues, Wall hangings and many more, for which, we are organising a Product
Launching Event.

We invite you for the same on February 22 nd , 2021 at Radisson blu, Dwarka, at 10:00am. The event will
take place is hall no. 1. There will be refreshments for the guests. There will also be cultural performances
from all over India.

Looking forward for a positive response from your side.

Thanks and Regards

Anubhav Roy

(CEO: Roy Artgallery.Pvt.Ltd.)

Freshers Party Invitation to 5 people using Mailmerge.
Assignment 11: What is Macro in Ms-Word? Write the
advantages of Macro. Also, create a Macro using toolbar in Ms-
Word.

Macro: Macro is a series of commands and instructions that you combine together as a
single command to complete a task automatically. When writing documents, there are
certain tasks which are repetitive in nature such as author's contact, info criteria, using a
macro for such tasks can save you time. It is just like keeping a copy of what you type.

Advantages of using macro.

 A macro is a name given to a block of the code which can be substituted where the
code snippet is to be used for more than once.

- The speed of the execution of the program is the major advantage of using a macro.

- It saves a lot of time that is spent by the compiler for invoking / calling the
functions.

- It reduces the length of the program.

 If you can verbally describe what you want a macro to do, you can post a request
to the Office Programming forum, and one or more of the experts who will read
your request will be happy to write the macro for you.

 The code of a macro can be copied as text from a reliable trustworthy source and
added to the NewMacros module of a template, from which it will always be
available.

 Macros that are stored in a template that you obtain from a reliable trustworthy
source can be made available by installing the template or by using the Organizer
to copy the applicable module into an installed template.

 Macros can be created by using the Macro Recorder, which records the steps that
you perform and translates them into macro code.
Macro using Toolbar in Ms Word. (Result of students in different subjects)

Subject: French

Subject Teacher: Ms. Archana Shrivastava

Maximum Marks: 100

Highest Marks: 96

Lowest Marks: 82

S.No Name of Student Marks Grade Pass/Fail

.
1. Anubhav 93 A1 PASS
2. Helene 96 A1 PASS
3. Paul 88 A2 PASS
4. Pierre 82 A2 PASS

Subject: Business Studies

Subject Teacher: Ms. Sushma Anthwal

Maximum Marks: 100

Highest Marks: 98

Lowest Marks: 91

S.No Name of Student Marks Grade Pass/Fail

.
1. Anubhav 95 A1 PASS
2. Helene 92 A1 PASS
3. Paul 95 A1 PASS
4. Pierre 91 A1 PASS

Subject: Accountancy

Subject Teacher: Ms. Shweta Bhargava

Maximum Marks: 100

Highest Marks: 99

Lowest Marks: 83

S.No Name of Student Marks Grade Pass/Fail

.
1. Anubhav 93 A1 PASS
2. Helene 85 A2 PASS
3. Paul 83 A2 PASS
4. Pierre 99 A1 PASS
Assignment 12: Describe the procedure of using Macro on Ms-
Word. Create a Macro using Keyboard in Ms Word.

How to create a Macro in MS Word?

Step 1: Click View in Microsoft Word 2010 menu, and click Macros > Record
Macro in Quick Access Toolbar.

Step 2: When you click on Record Macro, you get the Record Macro dialog box
popping up. It looks like below.

There are four areas in the Record Macro dialog box, Macro name, Assign Macro
to, Store Macro in and Description.
The first thing is to give your new Macro a name. Macro name is set Macro1 or
Macro2 etc by default. But it is not descriptive for what we want our macro to do. So
we should call our macro a specified name, which can clearly show what the macro
can do. For example, if you want to create a macro to change text font in Word
document, you can name it FontChange.
In the section Assign Macro to, you can give the choice either Button or Keyboard for
the way to record and run macro.

Store macro in points out which Word document the macro will apply to. When you
choose All Documents (Normal.dotm), the macro you are going to record will be
available to all the new Word documents created in future. While you choose MS
Word (document), it will be only used in this Word document.

In Description part, you are free to set anything you like. So if there is something you
cannot describe macro in other parts, write them in this part.

Step 3: Click OK in Record Macro dialog to begin recording a macro.

Step 4: When you return to your Word document, you would find your mouse
pointer becomes different.
Tips: If you have chosen “Button” in Step 2 “Assign Macro to” section, now
click View, and point to Macros down arrow, you can see Stop Recording and Pause
Recording options. The macro being recorded can be easily stopped or paused with
them.

Step 5: After you have done what you want to record, click Stop Recording. Now a
macro for Word 2010 document has been successfully created.

How to run Macro in Word document?

1. Open Word document you would like to do something with Macro on document
quickly.

2. Click View – Macros.

3. Macros dialog appears, and several available Macros are listed in the dialog box.

4. Select part of Word document you want macro applies to, and choose the
appropriate macro in Macros dialog. Then click Run button at the top right side.

Macro using keyboard in Ms Word: (Empl0yees’ salaries in diff. depts.)

Department: Sales

S.No Name of Employee Salary HRA DA Gross Salary

.
1. Yvette 100000 30000 20000 150000
2. Paul 120000 36000 24000 180000
3. Pierre 300000 90000 60000 450000
4. Pauline 150000 45000 30000 225000
5. Akanksha 110000 33000 22000 165000
6. Kunal 200000 60000 40000 300000

Department: Human Resource

S.No Name of Employee Salary HRA DA Gross Salary

 .
1. Ali 150000 45000 30000 225000
2. Nargis 110000 33000 22000 165000
3. Helene 300000 90000 60000 450000
4. Betty 120000 36000 24000 180000
5. Denis 100000 30000 20000 150000
6. Lola 200000 60000 40000 300000

Department: Finance

S.No Name of Employee Salary HRA DA Gross Salary

.
1. Belle 200000 60000 40000 300000
2. Snow white 120000 36000 24000 180000
3. Cinderella 110000 33000 22000 165000
4. Rapunzel 150000 45000 30000 225000
5. Elsa 300000 90000 60000 450000
6. Anna 100000 30000 20000 150000

Department: Marketing

S.No Name of Employee Salary HRA DA Gross Salary

.
1. Moana 120000 36000 24000 180000
2. Elena 300000 60000 40000 300000
3. Amber 100000 30000 20000 150000
4. Sophia 150000 45000 30000 225000
5. Jack 110000 33000 22000 165000
6. Hans 300000 90000 60000 450000

Department: Production

S.No Name of Employee Salary HRA DA Gross Salary

.
1. Kristoff 110000 33000 22000 165000
2. Olaf 100000 30000 20000 150000
3. John 300000 90000 60000 450000
4. Joanne 120000 36000 24000 180000
5. Tom 200000 60000 40000 300000
6. Jerry 150000 45000 30000 225000
Assignment 13: Make the time table of your class. It should
consist of timings, days, room no, section, subject teacher and
class coordinator.

Maharaja Surajmal Institute

Department of Commerce

Time Table (First Shift) Dec, 2020

B.Com (H) First Semester

Class Coordinator: Dr. Vijeta Banwari

Days & 09:00 to 10:15 to 11:30 to B 01:00 to 02:15 to

Time 10:00 11:15 12:30 02:00 03:15
Monday R
ME FA MPOB BC
Tuesday ME CA FA CAL CAL
E
Wednesday FA CA MPOB BC
Thursday ME FA FA A CA
Friday CA ME BC CAL CAL
Saturday MPOB BC MPOB K ME

Subject Teachers

Subject Name Room No.

MPOB Ms. Anchal Dabas 10
BC Dr. Arti Bahuguna 11
FA Ms. Preeti Bedi 12
ME Dr. Vijeta Banwari 13
CA Dr. Amit Chaudhary 14
CA Lab Mr. Sundeep & Ms. Vinita 15

Steps taken in this Assignment:

1. Open MS word.

2. Using Central alignment, type the institution name, name of

the department (if any), Time table, also the month and the
year.

3. Insert a table as per your requirements using the table option

in insert menu.

4. Type the name of the class coordinator on the top left of the
table.

5. Type the days vertically and timings horizontally.

6. Type the necessary data.

5. For break, select all 6 columns, remove the border, type one
letter in one line and use central alignment.

6. For the content, any font style, font size, colour can be taken
as per your choice.

8. Insert a separate table containing subject, name of the

teachers and the respective room no.s.
Assignment 14: Draw a flowchart to input two numbers from
user and display the larger of the two numbers.Anubhav roy

Start

Input a,b

a>b
YES NO
Output - a Output - b
A flowchart or flow chart usually shows steps of the task, process, or workflow.
Microsoft Word provides many predefined SmartArt templates that you can use to
make a flowchart, including visually appealing basic flowchart templates with
pictures. However, if you have a process with a tangled flow or you need a custom
layout, you can build a complex flowchart in Word using rectangular, diamond,
round, and other box types.

Steps to be followed to make a flowchart on MS word:

1. On the Insert tab, in the Illustrations group, click Shapes:

2. On the Shapes list, in the bottom, choose New Drawing Canvas:

Word adds the new drawing canvas to your flow chart:

Draw the flowchart blocks

3. On the Shapes list, in the Flowchart group, select the block you want to add:

4. To add text to the selected shape, just double-click in it and enter the text.

Connect the flowchart blocks by connectors

5. To connect shapes, do the following:

 On the Insert tab, in the Illustrations group, click in the Shapes list and then
select one of the connectors in the Lines group:
  Select the beginning point on the border of the first shape (source) and the
ending point on the edge of the second shape (target):

Top-to-down flowcharts are perfect for the Portrait page orientation in Microsoft
word. For the Landscape page orientation or the PowerPoint presentation, the
preferred layout is left-to-right. Sometimes left-to-right flow diagrams with delimited
borders of organization unit activities are called Swimlane diagrams or Swimlane
flowcharts.

MS
 EXCEL
ASSIGNMENTS

Submitted by: Anubhav Roy

Couse: B.com Hons.

Batch: 2020-2023

Assignment 1: What is MS Excel. Explain Ribbon & toolbars in

Excel. (2-3 pages)

MS-Excel and its features:

MS-Excel is the most commonly known spreadsheet software. It is part of the MS-Office
suite, and runs on Microsoft Windows, and Mac OS X operating systems. In addition to MS-
Excel, MS-Office suite contains other software like MS-Word, MS-PowerPoint and MS-
Access. MS- Excel is GUI-based software. MS-Excel includes tools for analyzing, managing,
and sharing information, which helps during the decision making process. The spreadsheet
in MS-Excel may contain charts, text, and other objects. Some of the important features of
MS-Excel are as follows:

 It allows organization, tabulation, search, and exploration of data of large sizes.

 Based on the values entered in different cells in the spreadsheet, formulas can be
defined, which automatically perform calculations.
  It allows the design of professionally looking charts with 3-D effects, shadowing, and
transparency.

 The tables can be easily created, formatted, expanded, and referred to within
formulas.

 The data can be filtered and sorted.

 PivotTable views enable you to quickly re-orient your data to help you answer
multiple questions.

 Formatting of spreadsheet allows changing the font size, font color, and font style.

 A function library consists of various function groups like financial, logical, math &
trignometry etc. from which you can apply long and complex formulas.

 Conditional formatting can be applied to discover patterns and to highlight trends in

the data.

What is a spreadsheet? A spreadsheet is a matrix of rows and columns, similar to an

accounting notebook (ledger). A spreadsheet program is primarily used for mathematical
calculations. A spreadsheet program is often used to prepare budgets, financial projections,
billing, and other reports arranged in rows and columns. An electronic spreadsheet provides
more flexibility, speed, and accuracy in comparison to a manually maintained spreadsheet.
For example, if you change the numbers in a spreadsheet, you do not have to perform the
calculations again. The spreadsheet does it for you. The spreadsheet program also provides
tools for creating graphs, inserting pictures and chart, analyzing the data etc.
What is a Ribbon?:
The Ribbon of MS-Excel has the Office button and eight Tabs, namely, Home, Insert, Page
Layout, Formulas, Data, Review, View, and Add–Ins. Each tab further consists of the
groups, and the groups contain icons. Icons are pictorial representations for a command.
The tabs in the Ribbon are self- explanatory; for example, if you want to do a page setup for
the worksheet, click on the Page Layout tab. The groups and icons related to Page Layout
are displayed. Select the appropriate command. The different tabs in MS-Excel and the
groups within them are as follows:
 Home: Clipboard, Font, Alignment, Number, Styles, Cells, Editing
 Insert: Tables, Illustrations, Charts, Links, Text
 Page Layout: Themes, Page Setup, Scale to Fit, Sheet Options, Arrange
 Formulas: Function Library, Defined Names, Formula Auditing, Calculation
 Data: Get External Data, Connections, Sort & Filter, Data Tools, Outline
 Review: Proofing, Comments, Changes
 View: Workbook Views, Show/Hide, Zoom, Window, Macros
Excel toolbar (also called Quick Access Toolbar) is presented to get access to various
commands to perform the operations. It is presented with an option to add or delete
commands to it to access them quickly.

 Quick access toolbar is universal, and access is possible on any tab like Home,
Insert, Review, and References, etc. It is independent of the tab that we are working
simultaneously.
 It contains the various options used frequently to enhance the speed of working in
excel sheets.
 Along with the quick access toolbar, there is another toolbar such as Formula Bar,
Headings, and Gridlines in excel under the show or hide a group of ‘View’ tab. simply
selecting and deselecting the checkmark shows or hides this toolbar.
 Format toolbar, drawing toolbar, chart toolbar, and standard toolbar presented in the
earlier version of Excel 2003 are modified into the Home tab and Insert tab in the
later versions of Excel 2007 and more.
 The customize option is there to have access to the full list of toolbars.

Assignment 2: Make a marksheet of your 12th class using MS Excel having

fields Serial No, Subjects, Marks, Total Marks, Percentage and Grades.
Find % of student and apply nested if statements to find grades in each
subject.
Assignment 3: Make a marksheet of 10 students of B.
Com/BBA of your college having fields S.No, Name of
the Student, Marks in 5 Subjects and perform the
following operations:

i) Sort the records in ascending order of total marks

ii) Sort the records in descending order of names
iii) Find the minimum marks and replace it by the text
“put more efforts”
iv) Apply what if statement to find Pass/Fail.
v) Do conditional formatting with the following
specifications: Greater than, Less than, Equal To,
Between.
Assignment 4: Make a timetable of your class and format it.
Assignment 5: Prepare a shopping mall bill/invoice with
columns Serial No, Item Name, Rate, Discount, Amount, GST,
Grand Total, savings.
Assignment 6: A company pays a monthly salary
to its employees which consists of Basic Salary,
Allowance and Deductions: (A) HRA is 30% of
basic salary (B) DA is 20% of basic salary
(C)Calculate the following:

i) Gross Salary = Basic Salary + HRA + DA

ii) Net Salary = Gross Salary – Tax
iii) Basic Salary < 2 lakhs: No Tax
2 lakhs < Basic Salary < 5 lakhs: 10% Tax
Basic Salary > 5 lakhs: 25% Tax
Assignment 7: Make a monthly/yearly sale of a company
having 5-salesman. Draw column and pie chart.
Assignment 8: Prepare the rate list of Mother Dairy fruits and vegetables:
i) Sort the table in decreasing order of rate list
ii) Find total of all the rates
iii) Check the spelling and grammar in the existing document. Use the
replace option in Find to replace each instance of same word.
iv) Draw charts.
Assignment 9: Create a record consisting of the
following field: -
1. Customer Name
2. Account Number
3. Principle Deposited
4. Rate of Interest
5. Time

a) Find the Simple Interest.

b) Calculate the Amount.
c) Each Customer Should Earn Simple Interest of Rs
5000,
d) Calculate the Principal Amount that a customer
should deposit.
e) Fixing the Value of Interest to Rs 10,000 by
Modification in the Rate of Interest.
Assignment 10: Use of Mathematical functions, Statistical functions, date
and time function, Text (String) functions& Logical functions.

The solution for assignment 10 is present in the MS Excel File attached.

Assignment 11: Create the Pivot table for Fruits and vegetables for
ABC.Ltd
 MS
POWERPOINT
ASSIGNMENTS

Name: Anubhav Roy

Course: B.com Hons.

 Batch: 2020-2023

Assignment 1: What do you understand by MS-PowerPoint?

What are the qualities of a good PowerPoint presentation.

Microsoft PowerPoint is a powerful presentation software developed

by Microsoft. It is a standard component of the company's Microsoft
Office suite software, and is bundled together with Word, Excel and
other Office productivity tools.

The program uses slides to convey information rich in multimedia and is

used to create complex business presentations, simple educational
outlines and much more.

Some of the important features of MS-PowerPoint are as follows:

 A consistent style in a presentation can be adopted by using a

template or Slide Master.

 Interactive presentations can be made with a system of links and

buttons to move to the next slide; and a full set of hyperlinks that
function like a nested website, where the user chooses options. 
Background effects can be included in the slides.

 The entrance, emphasis, and exit of elements on a slide itself are

controlled using Custom Animations.

 Transitions, or movements between slides can be animated in a variety

of ways.

Qualities of a good PowerPoint Presentation:

1. Visually appealing
2. Concise (Avoid lengthy slides)
3. Consistent
4. Limited transitions/animations
5. Clarity
6. Use of graphs, text, etc.
Assignment 2: Explain Components of a PowerPoint window.

Quick Access Toolbar:

This bar located at the top-left corner of the window. It is a group of commonly used
commands which makes easy to execute certain procedures. Mostly it contains Save, Undo,
Redo, Run Slide commands, etc. You can customize this toolbar to your need

Title Bar

Title Bar is the upper portion of the PowerPoint window. It shows Quick Access Toolbar, the
name of the opened file along with the name of the program, sign-in, ribbon display,
maximize, minimize, and close buttons.

Control buttons:

They are small buttons located in the upper right part of the window. It allows to minimize,
maximize the size of the window, and close the current document.
Ribbon

The Ribbon is the second section of the PowerPoint window. It consist of the following
components.

 Menus − They located at the top section below the title bar and contain groups of
related commands i.e. File, Home, Insert, Design, Transitions, Animation, Slide
Show, Review, View, Help menus.
 Groups − Groups are the combination of organized related commands. Each
group name appears below the group section.
 Commands − They are the predefined instructions of the executable program. It
exists in the form of Icons in the ribbon, e.g a group of Slide which contains new
slide, layout, reset, section, etc.
File Tab

In the File tab, you can open the Backstage view which allows you to access the basic
commands in PowerPoint i.e. create a new presentation, open existing ones, save
presentation, print option, share, export and many other options.

Slide Area

Slide area – It is the area where the slide or document is going to work. It allows updating,
editing and adding, deleting content, inserting images, shapes to the selected sheet. It has a
series of panels such as notes and zoom, which simplify the work.

Slide sheet – It is the sheet that shows you a scheme with a title and work area. Besides
that, it allows you to visualize a thumbnail of the created slide

Help

In previous versions, it appeared an icon above, next to the title bar that offered you general
information about functions and powerpoint aspects. In the most recent versions, it is
included in the menu bar with the name of Help. selecting the Help menu and click on “?”. It
will open the PowerPoint help window where you can browse from. The second help is a
search bar with a light bulb icon that tells me (tell me). You can also makes search for a
particular command.

Zoom Panel

This panel allows you to manipulate the percentage (%) of vision of the page currently being
worked on. You can decrease or increase the zoom factor by the zoom-out symbol
(represented by minus -), zoom-in (sum symbol +) respectively.

The maximum zoom-in is 400% and minimus is 10% in PowerPoint.

Slide Views Buttons

They are the four buttons left to the Zoom control contains a series of icons. It allows you to
switch among the PowerPoint views.

Normal view − This shows normal view of the presentation with the slide sheet on the right
and slide thumbnails to the left. This view allows you to select the working slide and also
rearrange them.

Slide Sorter view − It displays all the slides in a tabular form. This view allows you to arrange
the slides only.

Reading View − This window will allow you to read the slide carefully. However, you cannot
perform any editing.

Slide Show − This displays/runs all the slides along with animations, sounds that you have
given to the presentation.

Status bar:

It is a bar located in the lower area of ​the powerpoint document window that shows
information related to the current page such as the slide number.

Notes Section:

This panel allows you to add an opinion on the slide that is activated for those who are in
charge of modifying this document. It is not displayed during the presentation. It can observe
and take into consideration your message.

Assignement 3: Create a power point presentation on any topic

of your choice. Apply different transition and animation styles
to all the slides.
Submitted by: Kartikay Bhatia