Office Automation Tools Lab
SL NAME OF THE EXPERIMENTS Signature
NO SECTION-A
1. Creating the documents with special effects like
underline, bold, different size, different font and
different color.
2. Creating Paragraphs Inserting Date & Time,
Pictures, Bullets & Numbering , indentation etc. in
MS-Word.
3. Formatting features of MS-Word.-it includes paper-size,
margins, header and footer, page no. and creation of
table options.(Time Table).
4. Creation of mail merge for sending the new year wish to your class.
5. Creating Worksheets in Excel, Inserting, Deleting,
Copying, Moving worksheets in Excel Usage of
formulas, Built-in functions in Excel.(Monthly
income and expenditure statement.)
6. Graph-Plotting facilities in MS Excel.(Display
student results using excel charts.)
7. Writing conditional expressions (using IF) and
Using logical functions (AND, OR, NOT) Using lookup and
reference functions (Arithmetic functions, logical functions, text
functions).
OMT – Lab Manual Page 1
, 8 Data Validations : Specifying a valid range of values
for a cell, Specifying a list of valid values for a cell,
Specifying custom validations based on formula for
a cell, Sorting and Filtering Data facility in MS
Excel.(Employees of a company)
9. Creating a presentation in PowerPoint- Inserting /
Deleting slides in PowerPoint.
10. Creation of Slide transition and Editing special effects in
PowerPoint.
11. Creating of Inserting sound and picture in PowerPoint.
SECTION-B
1. Write the procedure to create a personal Letter.(with
proper format).
2. Write the procedure to create a resume.(with proper format).
3. Write the procedure to create a letter head of a company.(with
proper format
4. Write the procedure to create a cover page of a
project report.(with proper format).
5. Write the procedure to create a macros in word.
6. Create a Visiting Card of your college using page
size as follows
i)Page width=”3.2” ii)Page height=”2.2” And use different font
styles, sizes, alignments
7. Creation of Inserting chart and organization chart in
PowerPoint.( Eight salesmen sell three
products for a week.)
8. Write the procedure to store the data and calculate
total and percentage of the following details for 10
Students.(In Ms Access)
OMT – Lab Manual Page 2
, 9. Write the procedure to store the data and calculate
total and percentage of the following details for 10
Students. Generate marks card.( In Ms Access )
10. Create a report containing pay details of employees
of a company.( In Ms Access).
11. Creation of slides using SMARTART in PowerPoint
OMT – Lab Manual Page 3
, 1. Creating the documents with Special effects like underline, bold, different size,
different font and different color.
Procedure:
1. Open MS Office-MS Word – File – New - Type the heading
2. Type the topic heading-Bold, increase the size using font tools.
3. Type a paragraph on the above mentioned topic
4. To insert go to Insert- Picture-From file- and browse for the required picture/file-then click
Insert
5. Format the text by changing the font size and color by selecting the required text and chose font
size, style and color in the formatting tool bar below the menu.
OUTPUT
OMT – Lab Manual Page 4
SL NAME OF THE EXPERIMENTS Signature
NO SECTION-A
1. Creating the documents with special effects like
underline, bold, different size, different font and
different color.
2. Creating Paragraphs Inserting Date & Time,
Pictures, Bullets & Numbering , indentation etc. in
MS-Word.
3. Formatting features of MS-Word.-it includes paper-size,
margins, header and footer, page no. and creation of
table options.(Time Table).
4. Creation of mail merge for sending the new year wish to your class.
5. Creating Worksheets in Excel, Inserting, Deleting,
Copying, Moving worksheets in Excel Usage of
formulas, Built-in functions in Excel.(Monthly
income and expenditure statement.)
6. Graph-Plotting facilities in MS Excel.(Display
student results using excel charts.)
7. Writing conditional expressions (using IF) and
Using logical functions (AND, OR, NOT) Using lookup and
reference functions (Arithmetic functions, logical functions, text
functions).
OMT – Lab Manual Page 1
, 8 Data Validations : Specifying a valid range of values
for a cell, Specifying a list of valid values for a cell,
Specifying custom validations based on formula for
a cell, Sorting and Filtering Data facility in MS
Excel.(Employees of a company)
9. Creating a presentation in PowerPoint- Inserting /
Deleting slides in PowerPoint.
10. Creation of Slide transition and Editing special effects in
PowerPoint.
11. Creating of Inserting sound and picture in PowerPoint.
SECTION-B
1. Write the procedure to create a personal Letter.(with
proper format).
2. Write the procedure to create a resume.(with proper format).
3. Write the procedure to create a letter head of a company.(with
proper format
4. Write the procedure to create a cover page of a
project report.(with proper format).
5. Write the procedure to create a macros in word.
6. Create a Visiting Card of your college using page
size as follows
i)Page width=”3.2” ii)Page height=”2.2” And use different font
styles, sizes, alignments
7. Creation of Inserting chart and organization chart in
PowerPoint.( Eight salesmen sell three
products for a week.)
8. Write the procedure to store the data and calculate
total and percentage of the following details for 10
Students.(In Ms Access)
OMT – Lab Manual Page 2
, 9. Write the procedure to store the data and calculate
total and percentage of the following details for 10
Students. Generate marks card.( In Ms Access )
10. Create a report containing pay details of employees
of a company.( In Ms Access).
11. Creation of slides using SMARTART in PowerPoint
OMT – Lab Manual Page 3
, 1. Creating the documents with Special effects like underline, bold, different size,
different font and different color.
Procedure:
1. Open MS Office-MS Word – File – New - Type the heading
2. Type the topic heading-Bold, increase the size using font tools.
3. Type a paragraph on the above mentioned topic
4. To insert go to Insert- Picture-From file- and browse for the required picture/file-then click
Insert
5. Format the text by changing the font size and color by selecting the required text and chose font
size, style and color in the formatting tool bar below the menu.
OUTPUT
OMT – Lab Manual Page 4
