DAV INSTITUTE OF

MANAGEMENT

MS OFFICE
LAB FILE

Submitted To:Mrs. Pooja Gour

Submitted By: DIPYENDU
Class: BCA (1st SEM)
Registration No:2211030394
S.NO. Exercise Sign.
1. MS OFFICE
2. MS WORD
3. ASSIGNMENT-1
4. ASSIGNMENT-2
5. ASSIGNMENT-3
6. ASSIGNMENT-4
7. MS EXCEL
8. ASSIGNMENT-1
9. ASSIGNMENT-2
10. ASSIGNMENT-3
11. ASSIGNMENT-4
12. ASSIGNMENT-5
13. ASSIGNMENT-6
14. ASSIGNMENT-7
15. ASSIGNMENT-8
16. ASSIGNMENT-9
17. ASSIGNMENT-10
18. ASSIGNMENT-11
19. ASSIGNMENT-12
20. ASSIGNMENT-13

INDEX
21. ASSIGNMENT-14
 MS OFFICE
What is MS Office?
Microsoft Office or Microsoft Office System is a collection of
computer programs made by Microsoft. The programs are created for
all users.

Why we use MS Office?

Using Microsoft office can allow your business to keep everything
filed in a neat and orderly fashion to speed things up. Microsoft
Office can be used to type letters and envelopes, create spread sheets,
make labels, and produce presentations for your home or office.

Sub Parts:-
• MS Word

Microsoft Word is a graphical word-processing program that users

can type with. The purpose of the MS Word is to allow the users to
type, edit and save documents.

• MS Excel
Microsoft Excel is a spreadsheet application developed by Microsoft
for Microsoft Windows. It features calculation, graphing tools, pivot
tables.
• MS PowerPoint

Microsoft PowerPoint is a slide show presentation program. It

features making of presentations and presenting your data in an
attractive manner.
 MS WORD
Word Processor is a Software package that enables you to create, edit,
print and save documents for future retrieval and reference. Creating a
document involves typing by using a keyboard and saving it. Editing
a document involves correcting the spelling mistakes, if any, deleting
or moving words sentences or paragraphs.

COMPONENTS OF MS WORD:-

(a) Title Bar

The title bar displays the name of the currently active word document.
Like other WINDOWS applications, it can be used to alter the size
and location of the word window.

(b) Tool Bars

Word has a number of tool bars that help you perform task faster and
with great ease. Two of the most commonly tool bars are the
formatting tool bar and the standard tool bar. These two toolbars are
displayed just below the title bar.
(c) Ruler Bar
The Ruler Bar allows you to format the vertical alignment of text in a
document.
(d) Status Bar

The Status Bar displays information about the currently active

document. This includes the page number that you are working, the
column and line number of the cursor position and so on.

(d) Scroll Bar

The Scroll Bar helps you scroll the content or body of document. You
can do so by moving the elevator button along the scroll bar.

(e) Workspace

The Workspace is the areas in the document window you enter/type

the text of your document.

(f) Main Menu

The main menu further displays a sub menu. Some of the options are
highlighted options and some of them appear as faded options. At any
time, only highlighted options can be executed, faded options are not
applicable. You may not that any option faded under present situation
may become highlighted under different situations.
 ASSIGNMENT- 1
Write a paragraph on yourself.

1. Nouns are in Bold Letters.

2. Red colour on the school and college name.

3. Underline the digit words.

4. Hobbies are in the bold italic.

5. Paragraph in Roman New language and The Title in Bold

Arial black.

6. Font size of paragraph is (12) and Title is (20).

7. Centre align the Paragraph.

8. Right align the date.

9. Left align the Place.

10. Apply superscript to your course name. Ex: th

11. Apply subscript to your Address.

12. Paragraph keep it in the box.

 MY SELF
My name is Sahil Bhatia. I live in Faridabad. I am pursing BCA (1 st Sem) from DAVIM. I passed

out 12th class from Vidya Niketan School. My father’s name is Mr Parvesh Bhatia. He is a

business man (confectionary shop). My mother’s name is Rekha Bhatia. She is a house wife. I am

learning cooking. My mother has inspired me much. I am punctual and dedicated. I try to learn

more and more by studying hard. I pray to God daily. I am very responsible and honest in my

personal conduct as well. My hobbies are playing badminton, listening music. My parents have

always taught me to be straightforward and bold. I believe behind the success of any man there is

great ever role by his parents. I myself feel lucky in that sense, being socialized under the shade

and guidance of the most respected and loved fellows.

Place: Faridabad
 ASSIGNMENT-2

Exercise 2:- PARAGRAPH

1. Apply 6 width border to this page.

2. Apply 1.5 line spacing.

3. Insert Header and write your name.

4. Insert Footer and write the current date.

BCA COURSE
DAV Institute Of Management provides BCA Course. BCA stands for Bachelor
of Computer Applications. BCA is a three – year undergraduate course which
deals with information technology and computer applications. The course
imparts knowledge about different computer applications and how to solve and
address the problems which arise from a computer and its applications. The
course includes subjects such as core programming languages Java and C++,
data structure, networking and others. BCA provides various opportunities to
the students who wish to pursue their career in IT and software.
The course is divided into six semesters and because of its popularity, it is
available both as a regular degree and distance learning. Candidates can choose
as per their interests and capabilities.
BCA Course Highlights:

• Career Options – Teacher and Lecturer

Computer Programmer
Software Developer

Marketing Manager

Business Consultant

Computer Systems Analyst

Finance Manager

Computer Support Specialist

Service Support Specialist

Other courses at DAVIM are as follows:


 BBA
 BBACAM
 BBA11
 MCA etc.
 ASSIGNMENT-3
Exercise 3: Make your Resume

RESUME

SAHIL BHATIA

Address: 2F/28 near lakhani dharamshala

Faridabad (Haryana)

Pin code- 121001

Email Id- [email protected]

Mob.: +91- 8802205665

CAREER OBJECTIVE:

I want to be a good professional and leading person in future who can achieve any target to
success at any position. This rise to a level in organization with growth momentum given to it my
best efforts.
ACADEMIC QUALIFICATION:

Education Institute University/Board Year of passing

Pursuing DAV Institute MDU, Rohtak 2023
(BCA) of management
12th Vidya Niketan CBSE Board 2020
school
10th Vidya Niketan CBSE Board 2018
school

COMPUTER PROFICIENCY

Basic knowledge of computer

 MS-Office- MS Word, MS- Power point and MS- Excel.

 Tally

KEY SKILLS

 Punctual

 Discipline
AND ACTIVITIES INTERESTS

 Craft work
 Playing badminton
 Reading books

PERSONAL DETAILS:

Father’s Name Mr. Parvesh Bhatia

Date of Birth 05 October 2003

Gender Male

Permanent Address 2F/28 nit Faridabad

Near lakhani dharamshala

Marital status Single

Language known Hindi, English

Nationality Indian
DECLARATION:

I hereby declare and accept that all the information given above by me is true and correct to the
best of my knowledge.

Date: 10/01/2023

Place: 2F/28 NIT Faridabad

 ASSIGNMENT - 4

Type a paragraph and perform the following task.

a) Make initial letter of the first paragraph big (i.e. that covers

3 lines) and change it 60 size, Arial Black font.

b) Make five lists of numbering.

c) Make the five list of bullets having hand symbol.

d) Keep a footnote to any one of the words of the first

paragraph.

e) Centralize the heading of your document.

 Operating System (OS) –

O perating System is an interface between the user and the hardware and

enables the interaction of a computer’s hardware and software. Also, an

operating system is a software1 which performs all the basic tasks like file
management, memory management, storage management, process management,
handling input and output, and controlling peripheral devices such as disk drives
and printers
.

Functions of Operating System:

1. Device Management
2. File Management
3. Memory Management
4. Process Management
5. Store Management

Types of Operating System:

• Batch operating system
• Multi-tasking/ time-sharing operating system
• Real time operating system
• Distributed operating system
• Network operating system

MS Excel
Software developed and manufactured by Microsoft Corporation that
allows users to organize, format, and calculate data with formulas
using a spreadsheet system broken up by rows and columns. It is a
spreadsheet application developed by Microsoft for Microsoft
Windows. It features calculation, graphing tools, pivot tables.

COMPONENTS OF MS EXCEL:-
( a) Workbook

Also called a spreadsheet, the workbook is a unique file created by

Excel.

(b) Title Bar

The title bar displays both the name of the application and the name
of the spreadsheet.
( C )Menu Bar

The menu bar displays all of the menus available for use in Excel.

The contents of any menu can be displayed by left-clicking the menu

name

(d) Tool Bar

Some commands in the menus have pictures or icons associated with

them. These pictures may also appear as shortcuts in the toolbar.

(e) Column Headings

Each Excel spreadsheet contains 256 columns. Each column is named

by a letter or combination of letters.

(f) Row Headings

Each Excel spreadsheet contains 256 columns. Each column is named

by a letter or combination of letters.

(g) Name Box

This shows the address of the current selection or active cell.

(h) Formula Bar

The formula bar displays information entered—or being entered as

you type—in the current or active cell. The contents of a cell can also
be edited in the formula bar.

(i) cell

A cell is an intersection of a column and row. Each cell has a unique

cell address.
(j) Navigation Buttons and Sheet Tabs

Navigation buttons allow you to move to another worksheet in an

Excel workbook. Sheet tabs separate a workbook into specific

worksheets. A workbook defaults to three worksheets.

 ASSIGNMENT - 1
Explain in diagram these options in excel-

a) Title Bar

b) Menu Bar

c) Status Bar

d) Ribbon

e) Row Header

f) Column Header

g) Cell

h) Formula Bar

i) Name Box
 Title bar

Ribbon

Menu
bar
Name Column
Box Formula Header
Bar

Row Header
Cell

Status Bar
 ASSIGNMENT - 2
S. NO. Product Name Price Units Sold

1 PENCIL BOX 65 55

2 CELLO BAL PEN 98 100

3 DIGITAL WATCH 190 35

4 CHARGER 500 100

5 NYKAA 400 60

6 SHYAM BOOKS 200 40

7 ADDIDAS SHOES 600 30

8 CD BOX 100 20

9 ISO BOOKS 400 25

10 CUSHION 300 40

Create a sheet with column heading S.No., Product Name,

Price and Units Sold.

Enter minimum 10Entries.

ASSIGNMENT - 3
 Create a sheet with column heading EMPID, EMPNAME,

BIRTHDATE, HIREDATE, SALARY.

EMPID EMPNAME BIRTHDAY DEPARTMENT HIREDAT SALARY

EMP Amit 09-01-1994 Sales 04-02-2016 2000

EMP Himanshu 03-02-1996 Sales 01-01-2018 4000

EMP Dheeraj 10-03-1998 HR 03-02-2019 5000

EMP Mohit 21-04-2000 Sales 07-03-2017 5000

EMP Sumit 15-05-2001 IT 05-02-2021 6000

EMP Rivaan 24-06-1997 Sales 10-01-2018 7000

EMP Dhanesh 27-07-1995 HR 05-02-2017 5000

EMP Yash 14-08-1999 IT 06-04-2020 8000

EMP Shivam 17-09-2000 IT 06-03-2017 6000

EMP Aman 16-12-1998 Sales 01-05-2019 7000

 ASSIGNMENT - 4
1. Create the sheet with the data.

2. Insert 2 rows before row 5 and insert 2 more entries.

3. Insert a Column before A and write the S.no.

4. Add another row above row 3, and select C1,C2 to E1, E2

and use “Merge and Centre” from toolbar, and now increase

the size of “ Books Store” to 16.

5. Select the column G, and select “Autofit cell width” from

format cells.

6. Change the font style and size of the headings to “Arial

Black” and “9” respectively.

 ASSIGNMENT - 5
1. Create sheet with the data.

2. Insert two rows before Row 1 and column before A.

3. Type “IT InfoTech Ltd” in B1 Increase the font size to 20.

Change the colour of the text to red.

4. Select cells B1 to F1and use Merge & Centre button from

the toolbar.

5. Type “Sale for Branch 1” in B2 Cell. Increase the font to

18.

6. Change the colour of the text to green.

7. Select cells B2 to F2and use Merge & Centre button from

the toolbar.

8. Create a red colour border around B3 to F13.

9. Make the column headings bold

 ASSIGNMENT - 6
1. Create this table in MS Excel

2. Use Format cell option to add currency to wholesale price

and retail price columns.

3. Add another column “Percentage of buyers”, and add the

values.

4. Use Percentage option in format cells to convert these

entries to Percent.

5. Using Format cells, Change colour of all the rows with

Goods as “Notebook”.
 ASSIGNMENT - 7
1. Enter the following data into Excel.

Labels: January, February, March, April, May, June, July, August,

September, October, November, December.

2. Create Charts from the Data

Chart 1:

Create a Column chart that shows JUST the Average Temperature.

Make sure to include the labels on your chart

Name the chart "Average Temperature"

Chart 2:

Create a Chart that shows the JUST the Total Precipitation.

Make sure to include the labels on your chart

Create the Chart as its OWN page

Name the chart "Total Precipitation"

Format the chart with the colours, shape effects, and background fill

of your choice
 ASSIGNMENT - 8
1. Insert a 2D chart for item name, wholesale price and retail

price.

2. Change the border style and colour of the page.

3. Add title of the chart.

4. Change the colour of the chart wall.

5. Insert a 3D chart for the same data as given in above

question.

6. Insert a separate Pie chart for wholesale price and retail

price with item name.

S

ASSIGNMENT - 9
a) Calculate sales as per formula: Sales = Units*Price.

b) Calculate the total sales.

c) Calculate the average sales.

d) Find out the maximum price.

e) Find out the minimum price.

f) Find out the numeric cells in range A3 to F11. (Use

COUNT Function)

g) Find out non blank cells in range A3 to F11. (Use COUNT

A Function)

h) Find out blank cells in range A3 to F11. (Use

COUNTBLANK function)
a)

b)

c)
d)
 ASSIGNMENT - 10
1. Insert the data in spreadsheet with currency unit.

2. Calculate total salary from the given unit.

3. Calculate average expenditure.

4. Find out maximum expenditure.

5. Use condition result with if to find out if total expenditure

is more than savings.

6. Sort the expenditure in ascending order.

7. Calculate the product of house rent and stationery expense.

8. Find the minimum expenditure.

9. Round off the total sum of expenditure.

10. Make a pie chart to show the expenditures.

11. Make a bar graph to show total salary, savings and

expenditures.
 ASSIGNMENT - 11
1. Insert the data in spreadsheet.

2. Password protect the sheet by replacing the original file.

3. Remove the password from spreadsheet.

4. Define a range of cells from the spreadsheet by-

i) Select A1 TO C7 and create a database.

ii) Select the database range.

5. Sort the data in SN in descending order.

6. Sort the cost in ascending order.

7. Undo the sorting.

8. Find the subtotal of the expenditure and view the result in

all three different ways.

Password protecting:
Remove password:
Defining cells:

Sort the data in SN in descending order:

Sort the cost in ascending order:
Undo the sorting:
 ASSIGNMENT - 12
Q. Write a cover letter for job application using mail merge.

COVER LETTER

_____________
houseno.367 sector 56

Gurgaon

29-09-2017

Mr G. D. Sharma
Head Education department
MDU Rohtak
Dear Mam,

I am applying for the position of teacher, which was advertised on Oct. 4 with the career services
center at the MD University, Rohtak. The position seems to fit very well with my education,
experience and career interests.

According to the advertisement, your position requires excellent communication skills, computer
literacy and a MBA degree in business, economics or finance. I will be post graduating from DAVIM
with a MBA specialization in Software Developement. I am confident that I can perform the job
effectively.

If you would like to schedule an interview or otherwise discuss my interest in this position, please
call me at 976589432. I will be available at your convenience.
Thank you for your consideration.
Sincerely,
_________
 ASSIGNMENT - 13

Q. Make a PowerPoint presentation on MS Office including

MS Word, MS Excel and MS PowerPoint. Explain the topics

in detail.

Ans.