MS Office (MS Word, MS Excel & PowerPoint) Chapter of Computer PDF PGDCA Course

DEEPAK SIR
0
MS Office (MS Word, MS Excel & PowerPoint) Chapter of Computer PDF PGDCA Course




MS WORD

MS WORD

INTRODUCTION: -

MS-word 2007 is a powerful tool to create professional looking of a document. MS-Word is currently

one of the most commonly used applications. It is a part of MS-office package and it supports number of activities like writing words making sentences, paragraphs and so on. It is also called as electronic word processor in which we can create a document file which can be easily formatted as per the requirement of user by using available options.

  • It provides solution to many problems in the field of office automation. In MS-word had 2 windows
  • namely application window and document window. The document window is one in which we use
  • to write a document whereas application window is the frame of document window.

WHAT’S NEW IN WORD 2007: -

Word 2007 presents a new user-interface which is quite different than previous version of word. This section will provide you with some basic information about the new look and features available in word 2007 in order to help you get started.

THE RIBBON: -

Upon launching word 2007 for the first time the most noticeable change you will notice is Microsoft’s replacement of the traditional toolbars and menus with the ribbon. The word 2007 ribbon is a bar across the top of the window that contains tabbed pages of commands and icons/buttons. It replaces the previous version menu bar and drop-down menus. The ribbon is designed to help you quickly find the commands that you need to complete a task. The ribbon is divided into seven tabs by default, and each tab is a selection of groups that show related items together. Command buttons in each group carry out a command or display a menu of commands.

THE MICROSOFT OFFICE BUTTON: -

The Microsoft office button has replaced the file menu in earlier version of word. By clicking on this button, you are presented with the command previously found in the file menu of word 2003, including new, open, save, save as, print and close. 

MINI TOOLBAR: -

The mini toolbar pops up whenever text is selected. This new feature provides easy access to the most commonly used formatting commands in word. The toolbar will also appear word when you right-click on a selection of text.

QUICK ACCESS TOOLBAR: -

The quick access toolbar is a customizable toolbar which contains shortcuts for commonly used tools. You have the ability to add and remove the toolbar buttons based on your personal preferences.

FILE FORMAT: -

The Microsoft office suite applications now use a new file format as the default file format. Documents created in word 2007 will use a file extension of. Docx. Based on xml, this format uses the ZIP file container, which is compressed and up to 75% smaller than previous office file format.

TO START MS WORD: -

START → ALL PROGRAME → MS OFFICE → MICROSOFT OFFICE WORD 2007 → CLICK.

Or

START→SEARCH → TYPE “WINWORD” → Ok.

FILE TAB: -

The file tab is the first tab in the MS-word which contains the option like save, save as, open, recent, close, print & exit.

SAVE (ctrl + s): -

Before saving a document, the file exist in temporary memory for the permanent storage you must save the document on your hard disc so that MS-word provide two options to save a file i.e., save & save as. When you save the document for the first time you can select save option, where save as dialog box we can choose the location and type the name of the file. Save as option is used for saving an existing file.

OPEN (ctrl + o): -

This option is used to open an existing file in a computer memory.

CLOSE: -

This option is used to close an opened document.

INFO: -

This option is used to view the information about the opened document.

NEW: -

When you start MS-word it opens a new document for your work to start a new document. Select new option from the file tab than select blank document than create.

PRINT (ctrl + p): -

This option is used to print a document i.e., convert soft copy to hard copy.

HOME TAB: -

The home tab contains the group like clipboard group, font, paragraph styles, editing.

CLIPBOARD: -

Clipboard is one area which is store cut and copied information. There are 24 copied or cut data are stored.

CUT: -

This option allows cut the selected data.


COPY: -

  • This option allows copying the selected data.PASTE: -
  • This option allows pasting the clipboard data or cutted or copied data.

FORMATE PAINTER (CTRL + SHIFT + C): -

This option allows copying formatting from one place to another place.


FONT GROUP: -

This option use to change the format of data like to change the font name, color, style and effects. To show font dialog box click its right corner arrow mark, insert the font dialog box there are several options.


FONT NAME: -

There are list of fonts are available choose any one of font name inside its list box as per your choice by default font name is CALIBRI (body).


FONT STYLE: -

here we can change the style of font into bold, italic, underline etc.


MS Excel

MS-excel are spread sheet software developed by the Microsoft Corporation. MS-excel are a part of MS-office package.it performs all the basic function of a spread sheet. All type of mathematical and logical calculations is easily performed in Ms-excel.


SPREAD SHEET: -

Spread sheet is defined as a large sheet containing a matrix of row and column. This spread sheet is use to write down the numbers and calculate them easily.


ELECTRONIC SPREAD SHEET: -

Electronic spread sheet is the software programme that allow you to create a spread sheet, enter and edit the data into them and perform the calculation of data. Electronic spread sheet is similar to the manual spread sheet, but it is operated by an electronic media.


ADVANTAGE OF ELECTRONIC SPREAD SHEET: -

  • Large volume of data can be handling easily.
  • Calculations are almost error free and many built in function do the complex calculation.
  • Chart can be performing for graphical representation of data for understanding easily.
  • Automatically recalculation can be possible in electronic spread sheet.

FEATURES OF SPREAD SHEET: -

DATA BASE: -

it is a collection of related records arranged in an organised manner. It can be created with in a spread sheet or can be take in from external sources. A record is a combination of number of fields. Each field has a heading called field name.


WORKSHEET: -

It is a sheet made up of row and column or collection of cells. The work sheet can be opened, closed, edit, printed. By default, there are 3 sheets are opened in a workbook. The work sheet can be named like file.


WORKBOOK: -

It is a collection of many work sheets. A workbook contains up to 255 work sheets.


ROW: -

A row is a horizontal block of cells that runs through the entire width of the worksheet. A work sheet can have up to 1,048,576 numbers of rows which are named as 1, 2, and 3......so on.


COLUMN: -

A column is a vertical block of cells that runs through the entire length of the worksheet. Work sheets have maximum 16,384 numbers of columns which are named as A, B, c.......so on.


CELL: -

A cell is the intersection of row and column. When you select a cell by clicking it with the mouse, or moving to it using the keyboard, it becomes the active cell.


FORMULA BAR: -

The formula bar displays the constant value or formula used in the active cell.


NAME BOX: -

It displays the address or name of the selected cell.


RANGE: -

Range is a rectangular group of cells. The smallest range is a single cell. A range contain cell from single sheet or can included cells from adjacent sheet. The range of cell is separated by colon sign.


APPLICATION OF SPREADSHEET: -

  • Budgeting and forecasting.
  • Scientific research.
  • Financial accounting.
  • Income tax and sales tax application.
  • Annual report
  • Sales and purchase application or in business application

Note PDF View

PDF Download Link

More Links

Disclaimer 

The content of Computer, Commerce, Reasoning, provided for the educational purpose. This is the study materials for the Commerce & other students. These books, Notes PDF, Article are authorized by own publications, we provide Article/PDF for educational purpose. Any copyright climb please mail to the ‘DeepakPathasala’ official email response as soon as possible.

Post a Comment

0Comments
Post a Comment (0)

#buttons=(Accept !) #days=(20)

Our website uses cookies to enhance your experience. Learn More
Accept !