Experiment 9: Demonstration and practice on Microsoft Word, Power Point,

Microsoft Excel

AIM: To know about all the Microsoft Office and Practice with them.

INTRODUCTION TO MS-OFFICE

Microsoft office is a set of inter related desk top applications ,servers and
services, collectively refers to as an office suit for the micro soft windows and
MAC OSX operating systems .

MS WORD:

Microsoft Word is a word processing software package. we can use it to type

letters, reports, and other documents. In Word 2007, how a window displays
depends on the size of your window, the size of Your monitor and the resolution
to which your monitor is set. Resolution determines how much information your
computer monitor can display.
STARTING MS WORD:

Two ways of starting MSWORD:-

Double click on Microsoft word icon on the
desktop.
Click on start ->All Apps->ms office -
>ms word.

The Microsoft Button:

In the upper-left corner of the Word 2007 window is the Microsoft Office
button. When you click the button, a menu appears. You can use the menu to
create a new file, open an existing file, save a file, and perform many other
tasks.
The Quick Access Toolbar:

The Quick Access toolbar provides you with access to commands you
frequently use. By default Save, Undo, and Redo appear on the Quick Access
toolbar. You can use Saves your file, Undo to rollback an action you have taken,
and Redo to reapply an action you have rolled back.

The Ribbon:

We use the Ribbon to issue commands. The Ribbon is located near the top of the
screen, below the Quick Access toolbar. At the top of the Ribbon are several tabs;
clicking a tab displays several related command groups. Within each group are
related command buttons. You click buttons to issue commands or to access menus
and dialog boxes.

The Ruler:
We can use the ruler to change the format of your document quickly.
The Text Area:

You type your document in the text area. The blinking vertical line in the upper-left
corner of the text area is the cursor.

The Status Bar:

The Status bar

appears at the very bottom of your window and provides such information as the
current page and the number of words in your document.

Using Latex and Word to create project certificate. Features to be covered:-

Formatting
Fonts in word, Drop Cap in word, Applying Text effects, Using Character
Spacing, Borders and Colors, Inserting Header and Footer, Using Date and Time
option in both LaTeX and Word.
Font:
Character Spacing

The font formatting options that you can configure on the Font tab in the Font
dialog box influence the appearance of the individual characters in your text. Word
2007 offers two styles of drop caps. The first, and more common, begins the
paragraph with a large letter that spills down into the text. Thus, the drop cap
displaces the first few lines of the paragraph. The second style places the large first
letter in the margin adjacent to the paragraph.
Add an effect to text:
Select the text that you want to add an effect to.
On the Home tab, in the Font group, click Text Effect.

Click the effect that you want.

For more choices, point to Outline, Shadow, Reflection, or Glow, and then click
the effect that you want to add.
Remove an effect from text
Select the text that you want to remove an effect from.
On the Home tab, in the Font group, click Clear Formatting.
If you want to add a graphic or text at the top or the bottom of your document,
you need to add a header or footer. You can quickly add a header or a footer
from the galleries, or you can add a custom header or footer.
You can use these same steps to add a header or footer without page numbers.
Add a header or footer from the gallery
On the Insert tab, in the Header & Footer group, click Header or Footer.

Click the header or footer that you want to add to your document.
To return to the body of your document, click Close Header and Footer on the
Design tab (under Header & Footer Tools).

Assignment:
Design a RESUME using Microsoft Office MS node.
AIM:To maintain a PowerPoint presentation with some specifications

Home:

Clipboard:
1. To copy contents and to paste it at multiple locations.
2. To cut contents and to paste it at multiple locations.
3. To copy format styles and to paste it at single location.
Slide Layout:
1. On the format menu, click slide layout.
2. On the slides tab in normal view, select the slides; you want to apply a layout
too.
3. In the slide layout task pane, point to layout you and then click it.
4. A new slide can also be inserted within the task pane. Point the layout you want
the slide to have, click the arrow and then click the insert new slide. Font:
1. To change font style, size, case etc.
2. To enrich the text.
3. To change the text and back ground color. Paragraph:
1. To add bullets and numbers to points.
2. To add space left and right of a paragraph.
3. To change the alignment of a paragraph.
4. To change the space in paragraph.
Auto shapes:
1. Select the auto shape that has the text you want to position.
2. Double-click the selection rectangle of the auto shape or text box and then click
the text box tab in the format dialog box.

3. In the text anchor point box, click the position you want the text to start in.

Lines and Arrows:

1. In Microsoft power point, double click the chart.
2. Double click the chart item you want to change.
3. On the patterns tab, do one or both of the following.
4. To change the colors, patterns or lines, select the options you want.
5. To specify a fill effect, click fill effect and then select the options you want on
the gradient, text patterns or picture tabs.
Insert:

Hyperlink:
1. Select the text or object that you want to represent the hyperlink.
2. Click insert hyperlink.
3. Under link to, click place in this document.
Insert Images:
1. Click where you want to insert the picture.
2. On the drawing tool bar, click insert picture.
3. Locate the folder that contains the picture that you want to insert, and then click
the picture file.

Clip Art:
1. On the insert menu, point to structure and then click clipart.
2. in the clipart task pane, in the search for box, type a word or phrase that
describes the clip, you want to type in all or same of the file menus of the clip.

3. in the results box, click the clip to insert it.

Audio Video Objects:
1. On the slide show menu, click setup show. Under performance check box. If
your computer has their capability, office PowerPoint will attempt to use it.

2. Animation performance will be much better with a video card that has
Microsoft direct 3D.
Table:
1. On the standard tool bar, click insert table.
2. Print to select the numbers of rows and columns you want and then click.

Chart:
1. Click the slide where you want to place the embedded object.
2. On the insert menu, click chart.
3. Click a cell on the data sheet and then type the information you want.

Assignment:
Prepare any experiment with power point presentation. Using all features?

AIM: Introduction to MS-Excel

Introduction to MS-Excel

Excel is a computerized spreadsheet, which is an important business tool that

helps you report and analyze information. Excel stores spreadsheets in
documents called workbooks. Each workbook is made up of individual
worksheets, or sheets. Because all sorts of calculations can be made in the Excel
spreadsheet, it is much more flexible than a paper spreadsheet. The Excel
window has some basic components, such as an Active cell, Column headings, a
Formula bar, a Name box, the mouse pointer, Row headings, Sheet tabs, a Task
Pane, Tab scrolling buttons and Toolbars.
Sample Worksheet:

Excel worksheets and Workbooks:

When you set up calculations in a worksheet, if an entry is changed in a cell, the
spreadsheet will automatically update any calculated values that were based on
that entry. When you open Excel, by default it will open a blank workbook with
three blank worksheets. When you save a workbook, you have a Save As option
that can save the spreadsheet to earlier versions of Excel or to Quattro Pro,
Lotus 123 formats, dBase formats, and even to a comma or tab-delimited text
file.
Identify Excel Components:

Navigate within Worksheets:

To navigate within a workbook, you use the arrow keys, Page Up, Page
Down, or the Ctrl key in combination with the arrow keys to make larger
movements. The most direct means of navigation is with your mouse.
Scroll bars are provided and work as they do in all Windows
applications.To move to other Worksheets, you can:

1. Click their tab with the mouse.

2. Use the Ctrl key with the Page Up and Page Down keys to move sequentially
up or down through the worksheets.

If you are familiar with Microsoft Access, you will find the tab scrolling buttons
for moving between worksheets to be similar to record browsing on an Access
form or datasheet.

Developing a Worksheet:

Determine the
worksheet’s purpose.
Enter the data and
formulas.
Test the worksheet and make any necessary edits /
corrections. Document the worksheet and improve
appearance.
Save and print the complete worksheet.
Entering data into worksheet:
To enter data, first make the cell in which you want to enter the data
active by clicking it. Enter the data (text, formulas, dates, etc.) into
the active cell. Use the Alt+Enter key combination to enter text on
multiple lines within the same cell. Use TAB key, arrow keys, or
ENTER key to navigate among the cells.
Entering formulas:
A formula is a mathematical expression that
calculates a value. In Excel, formulas always begin
with an equal sign(=).
A formula can consist of one or more arithmetic operators.
The order of precedence is a set of predefined rules that Excel follows to calculate
a formula.

Resize worksheet rows and columns:

There are a number of methods for altering row height and column width using the
mouse or menus:

Click the dividing line on the column or row, and drag the dividing line to
change the width of the column or Height of the row Double-click the border of
a column heading, and the column will increase in width to match the length of
the longest entry in the column Widths are expressed either in terms of the
number of characters or the number of screen pixels.

Insert worksheets rows and columns:

You can insert one or many additional rows or columns within a worksheet with
just a few steps using the mouse or menu options. You can insert individual cells
within a row or column and then choose how to displace the existing cells. You
can click the Insert menu and then select row or column, or right click on a row or
column heading or a selection of cells and then choose Insert from the shortcut
menu.
Delete worksheets rows and columns:
To delete and clear cells, rows, or columns, you can use the Edit menu, or right
click on a heading or a selection of cells and choose Delete from the shortcut
menu. Clearing, as opposed to deleting, does not alter the structure of the
worksheet or shift unclear data cells. What can be confusing about this process is
that you can use the Delete key to clear cells, but it does not remove them from
the worksheet as you might expect.
Assignment:
Create student marks list in excel sheet?