CHANDIGARH UNIVERSITY

Institute of Distance and Online Learning

Course Development Committee

Prof. (Dr.) R.S.Bawa

Pro Chancellor, Chandigarh University, Gharuan, Punjab
Advisors
Prof. (Dr.) Bharat Bhushan, Director – IGNOU
Prof. (Dr.) Majulika Srivastava, Director – CIQA, IGNOU
Programme Coordinators & Editing Team
Master of Business Administration (MBA) Bachelor of Business Administration (BBA)
Coordinator – Dr. Rupali Arora Coordinator – Dr. Simran Jewandah
Master of Computer Applications (MCA) Bachelor of Computer Applications (BCA)
Coordinator – Dr. Raju Kumar Coordinator – Dr. Manisha Malhotra
Master of Commerce (M.Com.) Bachelor of Commerce (B.Com.)
Coordinator – Dr. Aman Jindal Coordinator – Dr. Minakshi Garg
Master of Arts (Psychology) Bachelor of Science (Travel &TourismManagement)
Coordinator – Dr. Samerjeet Kaur Master Coordinator – Dr. Shikha Sharma
of Arts (English) Bachelor of Arts (General)
Coordinator – Dr. Ashita Chadha Coordinator – Ms. Neeraj Gohlan

Academic and Administrative Management

Prof. (Dr.) R. M. Bhagat Prof. (Dr.) S.S. Sehgal
Executive Director – Sciences Registrar

Prof. (Dr.) Manaswini Acharya Prof. (Dr.) Gurpreet Singh Executive Director –
Liberal Arts Director – IDOL

© No part of this publication should be reproduced, stored in a retrieval system, or transmitted in any form or by
any means, electronic, mechanical, photocopying, recording and/or otherwise without the prior written
permission of the authors and the publisher.

SLM SPECIALLY PREPARED FOR

CU IDOL STUDENTS

Printed and Published by:

TeamLease EdtechLimited
www.teamleaseedtech.com
CONTACT NO:01133002345

For: CHANDIGARH UNIVERSITY

Institute of Distance and Online Learning

OFFICE AUTOMATION LAB

Course Code: 21BCA105 Credit: 4

Course Objectives:

1. To provide knowledge of text formatting.

2. To make students familiar with data representation ways.
3. To equip students with ways of text representation.

EXPERIMENT 1 ADDING TEXT, EDITING TEXT,

FINDING AND REPLACING TEXT, FORMATTING
TEXT, CHARACTER/LINE/PARAGRAPH SPACING,
WORKING WITH STYLES AND TEXT
INDENTATION.
1. Adding text

1. Go to the Startmenu
2. Click on the Microsoft Word icon to open the Microsoft Word
3. Click on the blank document
4. A blinking cursor or insertion point will appear in the text area below the
ribbon 5. Now, start typing and the words will appear on the screen in the text
area
*In below screen added text
Office Automation LAB

2. Editing text
 1.Select the text you want to replace.
• To select a single word, double-click it.
• To select a line, click to the left of it.

*below screen select word LAB

2. Enter the new word.

*below screen edited LAB to Practical

3. Finding And Replacing Text

1. Find
1.Click the Home tab

2.Click the Editing icon and then click the Find command. The Find and Replace dialog
box appears.
3.Click in the Find What text box

4.Type a word or phrase to find.

2.Replace
1. Click the Editing icon and then click the Replace command. The Find and
Replacedialog box appears.
2. Enter your new text in the Replace box.
3. Select Find Next until you come to the word you want to update.

4. Choose Replace. To update all instances at once, choose Replace All.

5. To specify only upper or lowercase in your search, select More > Matchcase.

Word Practical is Replaced with LAB

4. Formatting Text

1. Select the text want to format.

2. Select an option to change the font, font size, font colour, or make the text bold, italics,
or underline.
5. Character/Line/Paragraph Spacing

1. Select the text want to format.

2.On the

Home tab, click the Line and Paragraph pacing command. A drop-down menu will
appear.

3. Move the mouse over the various options. A live preview of the line spacing will appear
in the document. Select the line spacing you want to use.
 4.The line spacing will change in the document.
*Text is appearing in the middle of the screen after changing the alignment

6. Working With Styles And Text Indentation

1. To underline the text do as follow

1. Select the desired text.
2. Click on the “U” button in the ribbon. (if it doesn’t exist, click the “Home” tab on the
ribbon, and you will find it in the “Font” group).
2. Changing the size of the font (the text):
1. Select the desired text.
2. Move the mouse cursor towards the mini toolbar, and it will become active. If the
mini toolbar doesn’t appear, right click inside the selected area, and it will appear.
3. Clicking the “A” buttons repeatedly will make the font gradually bigger or smaller.
4. Font to a specific size can be set by opening the drop down menu, and choosing the
desired size. The numbers in the menu represent the font size by pixel units.

3. Applying the font type:

1. Select the desired text.
2. Open the fontsdrop down menu in the mini toolbar, and choose the font

type.
4. Applying colour to the text
1. Select the desired text
2. Click the small arrow next to the A button in the mini toolbar.
An array of colors appears. Choose one by clicking it.
3. Cancel the selection by clicking somewhere, to see the color on the white
background.

5. First-line indent
1. Put the cursor anywhere in the paragraph.
2. On the Home tab, right-click the Normal style, and choose Modify.

3. Select Format, and then choose Paragraph.

4. On the Indents and Spacing tab, under Indentation, select First line.
 5. Select OK.

EXPERIMENT 2 WORKING WITH PAGE LAYOUT,

PAGE SETUP I.E. SETTING MARGINS, CHANGING
PAGE SIZE, CHANGING PAGE ORIENTATION AND
APPLYING PAGE BACKGROUND.
1. Setting Margins
1.Open the Word document in which want to set the margin
2. Click on Layouttab

3.Select the desired margin measurements

For custom margins below option can be selected

2. Changing page size

1.Open the Word document to change page size

2.Click on Layouttab

3.In Page Setupgroup click the Size command

4.Paper size menu will appear
 5.With a left click select the desired paper size
6.To customize page size click the 'More Paper Sizes' option

3 Changing page orientation

1.Open the Word document to change page size

2.Click on Layouttab

3.In Page Setup group click the Orientationcommand

4.It displays two options, Portraitand Landscape

 5.Select the desired page orientation

4 Applying page background

1.Open the Word document
2.Go to design tab

3.Go to Page Background group

4.Select Watermark Option

5.Go to Custom Watermark

6.Select a picture for picture water mark
EXPERIMENTS 3WRITE A C PROGRAM TO
PERFORM POST AND PRE-INCREMENT, POST AND
PRE-DECREMENT OPERATIONS.
1. Write a C program to perform post and pre-increment

#include<stdio.h>
#include<conio.h>

int main()
{
int i;
i = 10;

printf("C program to perform post and pre-increment");

printf("\n\nNumber is :- %d", i);

++i;

printf("\n\nNumber after pre increment by 1 :- %d", i);

printf("\n");

i++;

printf("\nNumber after post increment by 1 :- %d", i);

printf("\n");
return 0;
}
Output:
2. Write a C program to perform post and pre-decrement operations

#include<stdio.h>
#include<conio.h>

int main()
{
inti;
i = 10;

printf("C program to perform post and pre-decrement");

printf("\n\nNumber is :- %d", i);

--i;

printf("\n\nNumber after pre decrement by 1 :- %d", i);

printf("\n");

i--;

printf("\nNumber after post decrement by 1 :- %d", i);

printf("\n");
return 0;
}
Output:

EXPERIMENT 4 CREATING AND WORKING WITH

TABLE OF CONTENT.
1. Creating and working with table of content.

1. Select each chapter in document and apply Heading Styles to them. Mark up the
section headers so that Word can recognize them.

2. Go to Ribbon >Home >Styles. Select the text and apply headings for all the
text you want to include in the table of contents.

3. Place
the cursor on the specific position where want the table of content to appear in
document. This is commonly somewhere at the beginning of the document.

4. Go to Ribbon >References >Table of Contents. Choose from one

of the two automatic types available. The only difference between the two is the heading
of "Contents" or "Table of Contents" at the top

5. Word scans the document and uses the heading styles to construct the order of the
sections and subsections and their page numbers.
 6. Table of Contents that has been created automatically is updatable. Update the table if
you change the heading styles, rearrange the contents, or change the text. Also, update it if
you make any changes to the content that affects the page numbers.
7. To create a manual table, go to References >Table of Contents > Click the dropdown
to reveal the option for Manual Table.

EXPERIMENT 5 INSERTING PAGE NUMBERS,

HEADERS AND FOOTERS, FOOTNOTE, ENDNOTE,
DATE AND TIME, PICTURES, OBJECTS, SHAPES
ETC.
1 Inserting page numbers
 1.Open the MS word document

2. Go to Insert > Page Number.

3.Choose the desired option from the drop-down

4. Choose a location.
5. Select an alignment style.

2 Headers and footers

1.Open the MS word document

2. Go to Insert.
3.Choose header or footer option
4.Choose the header style you want to use.

5.Add or change text for the header or footer.

6. Select Close Header and Footer or press Esc to exit.

3 Footnote, endnote

1. Click on the place to add footnote or endnote for reference.

2.Click on the References tab
3. Select Insert Endnote.

4. Enter the desired content in the footnote or endnote.

5. Return to your place in the document by double-clicking the number or symbol at
the beginning of the note.

4 Date and time

1.Open the MS word document

2.Go to Insert tab
3.Click on Date & Time

4.Select the desired format and click OK

5 Pictures

1.Go to Insert tab

2.Go to Illustrations group

3.Select Pictures
 4.Select a picture from system and click on Insert button

6 objects, shapes

1.Go to Insert tab

2.Go to Illustrations group

3.Click on Shapes

4.Select Desired shape

EXPERIMENT 6 CREATING CUSTOM LISTS, USING
AUTO FILL, FIND AND REPLACE AND EDITING
TEXT (CUT, COPY, PASTE AND PASTE SPECIAL).
1. Creating custom lists

1.Open Ms Excel
2.Go to File->Options

3.Go to Advanced -> Edit Custom Lists

4. To create custom list, type some list entries, and click Add.
5.Click on OK
Using auto fill
For indexing 1 to 10
1.Enter 1 into cell A1 and 2 into cell A2

2. Select cell A1 and cell A2 and drag the fill handle down. The fill handle is the little
green box at the lower right of a selected cell or selected range of cells.
3.Numbers will be filled automatically

Same for days of weeks

2. Find and replace and editing text

1.Go to Home->Editing

2.Select find & select

3.various options will be visible as per requirement

 User can
1.Replace all the text appeared in sheet
2.Replace single value
3.Find single value
4.Find all the values

3. Editing text (cut, copy, paste and paste special).

▪ 1. Go to File tab
2.Go to Options

3.Select advanced option

4 Under Cut, copy, and paste, select the down arrow for the setting to change.
Pasting within the same document When you paste content into the same document from
which you copied the content.
▪ Pasting between documents When you paste content that was copied from another Word
document.
▪ Pasting between documents when style definitions conflict When you paste content that
was copied from another Word document, and the style that is assigned to the copied text
is defined differently in the document where the text is being pasted.
▪ Pasting from other programs When you paste content that was copied from
another program, such as a browser.

5. There are options in each setting

Keep Source Formatting

Merge Formatting
Keep Text Only

6. Select OK.

4. Editing text (cut, copy, paste and paste special).

 Can also be done from Clipboard group
1.Go to Home tab

2.Select Clipboard group

EXPERIMENT 7 WORKING WITH FORMULAE AND

FUNCTIONS AND APPLYING CONDITIONAL
FORMATTING TO DATA.
1. For this experiment we will try to find total marks of a students appeared for
5 examination papers
 To find total marks obtained by each student
1.Added formula on desired sell

2. To find the marks between, greater than etc. using Conditional Formatting
1.Go to Home->Styles

2.Click on Conditional Formatting

3. We will try to find how many students got marks more 65

 4.Numbers obtained between 65 and 90

EXPERIMENT 8 WHAT-IF-ANALYSIS USING GOAL

SEEK, SCENARIOS AND SOLVER.
1. Goal Seek is a What-If Analysis tool that helps user to find the input value that results
in a target value that user wants. Goal Seek requires a formula that uses the input
value to give result in the target value.

We will use Goal Seek function to calculate marks of missing third

paper
1. Put some formula in total section on the basis of which marks will be

calculated.
2.To apply goal seek function on 3rd paper
Go to Data->Forecast

3.Select Goal Seek

4.Apply it on total marks

 5. Marks will be calculated on the basis of a approx. marks given in “To value” textbox.
So “To value” is our target value on basis of which Goal seek function will be applied
on out calculation.

2. What-If-analysis using Scenarios and solver

1.Go to Data tab

2. Go to Data->Forecast

3.There is a Sales report

4.Need to changes the Actual values using Scenario Manager

5. Select Scenario Manager

6.Add new values

7.
 8.All the old values are replaced by new using Scenario values

EXPERIMENT 9 PIVOT TABLES AND DATA TABLES

(ONE AND TWO TABLE INPUT).
1. A pivot table is a table of statistics that summarizes the data of a more extensive
table (such as from a database, spread sheet, or business intelligence program).
In this experiment we import SQL data to Excel
1.Go to Data->Get External Data

2.Click on “From Other Sources”

3.Select “From SQL Server”

4.Type name and Login credentials of the Server
5.Select name of the Database-> Click on next

6.Select the table name and click on next

7.Click on Finish

8.Select “PivotTable Report”

 9.Select the columns

10.Data Imported from SQL server

2. Experiment for selection of multiple tables from import SQL data to Excel
1.Enable selection of multiple tables
2.Select the columns
EXPERIMENT 10 WORKING WITH CHARTS (2D
AND 3D).
1. In this experiment we will prepare 2D chart of yearly sales report and compare
target with actual sales

1.Go to Insert->Charts

2.Select “Insert column or bar chart“

3.Select “2-D Bar” option

4. “2-D Column” option

2. In this experiment we will prepare 3D chart of yearly sales report and compare
target with actual sales

1.Go to Insert -> Charts

2.Select “Insert column or bar chart “

3.Select “3-D Bar” option

4. “2-D Column” option

EXPERIMENT 11 CREATING AND FORMATTING
SLIDES IN A PRESENTATION.
1. We will create a PowerPoint presentation

1.Click on Office

2.Click on PowerPoint Presentation

3.Below screen will appear

4. Type text into title slide

5.To add more slides go to insert->New Slide

6.Select blank slide

7.To Change design go to Design

8.Select desired design
9.Select layout for other pages of presentation

10. Add Tables, Charts, Pictures, Graphs, Etc.

11.Added charts

12.To run PowerPoint Presentation go to “Slide Show”

EXPERIMENT 12CREATE A MASTER SLIDE WITH A
LOGO, FOOTER, AND FONT.
1. In this experiment we check how master slide can be added in PowerPoint Presentation

1.Open PowerPoint slides

2.Go to View

3.Select Slide Master from “Master Views” and master slides will

appear
4.Below is the Master Slider
 ∙ Added Title
∙ Footer
∙ Date
∙ Slide Number
5. Below is the Title Slide

6.Below is the Text Slide

7.Below is the Section Header Slide

8.To add common footer in all the slides go to Insert

9.Click on Header&Footer
 Given Header and Footer values will appear in all the slides

EXPERIMENT 13 PLACE A TEXT BOX IN THE TITLE

SLIDE WITH YOUR NAME.
1. To add a textbox in a slide

1.Open PowerPoint Slide

2.Go to Insert-> Text

3.Click on desired location where want to place textbox

4.Textbox will appear which can be resized

EXPERIMENT 14 INSERT TRANSITIONS FOR EACH

SLIDE.
1. Experiment to insert transition in PowerPoint

1.Open the PowerPoint slide

2.Go to Transition-> Transition to This Slide

3.

Select a transition to apply it to the selected slide. This will automatically preview the
transition.

4.To apply same transition in all the slides

Go to Timing->Apply To All

5.After selecting Apply To Allstart will appear on left side of all the
 slides
6.Apart from Apply To All ,sounds and different duration also can be added

EXPERIMENT 15 APPLYING VARIOUS EFFECTS

(CUSTOM ANIMATION AND TRANSITIONAL
EFFECTS) IN A PRESENTATION.
1. Experiment will show how animation and transitional effects can be added
in PowerPoint slides
1. Select the slide to add animation
2.Go to Animationtab

3.In Animationgroup select the type of animation