Micro Soft Excel

Micro Soft Excel 2007/10

Micro soft excel is used for mathematical operations and calculations. An excel is combination of different work book, and a work book is combination of different work sheets, a work sheet have different row and columns which make cells.

Title bar:-                             This bar show the Work book name.

Menu bar:-                         This bar show different menus as files menu, home menu, insert menu,page layout menu etc.

Formatting bar:-                Show different formats of the cell, data.

Formula Bar:-                    Contain value of the current cell.

Name Box:-                        Contain the address of the current cell.

Open:-                                  To open a stored work book from hard disk.

Save:-                                   To store a created work book in the memory.

Save as:-                              To store created work book with an other name in the memory.

Close:-                                  To close the opend created work book.

Print:-                                   To make a hard copy of the created work book on paper via printer.

Quick Print:-                       To print quickly and don’t ask for options of printing.

Print Preview:-                  Show the preview of the created work book how it look on paper.

Prepare:-                             To set the created work book additional options properties and also set code on it.

Send:-                                   To send created work book to external devices as below

                                Email:-  send as email to any person.

                                fax:-      send as the fax on any fax machine.

Publish:-                              Publish it on the network other computers.

View Menu

View Menu:-

Print Layout:-    View the document as it will appears on the paper via printer machine.

Full Screen Reading:- View the document on full screen.

Web Layout:-     View the document as it would look as web page.

Outline:-              View the document as an outline.

Draft:-                  View the document as draft as quickly edit the text.

Ruler:-                   View the scale top and side of the document as measure the line and area typing.

Grid lines:-           Turn on the grid lines to which you can align objects in the document.

Document Map:-Allow you to navigate a long document through a small pictures of the pages.

Zoom:-                 Set the zoom level of the document.

100%:-                  Zoom the document as 100% normal document.

One Page:-         Zoom the document so that an entire page fits in the window.

Two Pages:-       Zoom the document so that two pages fit in the window.

Page Width:-     Zoom the document so that width of the page matches width of the window.

New Window:-  Open new window contain the view of the document.

Arrange all:-       Tile open program windows side by side on the screen.

Split:-                    Divide current window in two parts so that you can watch different sections of the document at same time.

Synchronous Scrolling:- Two Documents scroll same time.

Switch to Window:-        Jump on the next opend document.

Macros:-              To store set of options in one macro for easily run on other documents.

Mailings Menu

Mailings Menu:-

Envelopes:-                         To set addresses on the envelopes for your postage.

Labels:-                                                To make informative labels for the products.

Start mail merge:-           To set the data base of the peoples where you send the information letters etc.

Select Recipients:-            Chose the list of people you intend to send the letters.

Edit Recipients list:-         Make changes to the list of peoples and decide that which of these should reviewe your letters.

Address Block:-                 You specify the formation and location, and word will replace it with original addresses from your recipient list you have chosen.

Greeting lines:-                 To insert a greeting line such as dear sir, for any particular person in the document.

Insert Merge Fields:-       Add any field from your recipient list to the document such as name, home address, phone number or any other field name.

Rules:-                                  Specify  rules to decision making ability to the mail merge.

Match Fields:-                   Match field allows you  to tell word the meaning of different fields in your recipient list.

Update Labels:-                If You are creating labels update all the labels in the document to use information from the recipient list.

Preview Results:-              Replace the merge fields in your document with actual data from your recipient list so you can see what it look like.

Find Recipient:-                 To find any name from the recipient list.

Auto check for Errors:-   Specify how to handle errors that occur when completing the mail merge.

Finish & merge:-               Complete the mail merge.

Review Menu:-

Spelling and Grammar:-                To check the spelling and grammar of typed text if mistakes than correct it.

Research:-                           To research about any topic from dictionary or other source.

Thesaurus:-                        Suggest other words with similar meanings.

Translate:-                          To Translate typed text with an other language.

Set Language:-                 To Set language for typing the text in word.

Word Count:-                    To count the Lines, Pages, words, Blanks Spaces etc of typed document.

New Comment:-               Insert the comment(Detail) in the document at any place.

Delete:-                                                Remove the given comment.

Next:-                   To jump on next comment.

Previous:-            To jump on the next given comment.

Track Changes:- Track all changes made in the document including inserting, deletion, formatting also.

Baloons:-             Chose how to show changes in the document.

Final show Markup:- Choose how to view the proposed changes in the document.

Show Markup:-                Choose what kind of the mark up to show in the document.

Reviewing Pane:-Show revisions in a separate window.

Accept:-               Accept change and move to next change.

Reject:-                 Reject the current change and move to next change.

Previous:-            Go to previous change.

Next:-                   Go to next change.

Compare:-          compare or combine multiple versions of the document.

Protect Document:-        Set serate code on the document.

Reference Menu

Reference Menu:-

Table of Contents:-          To insert the index of the typed document called table of contents at last or first page.  

Add Text:-                            To add text level in the table of contents.

Update Table:-                    To update the index if new entries are made in the document.

Insert Foot note:-               To insert a note at the foot of the document if required.

Next Note:-                         To insert an other note at foot of the page in the document.

Insert End Note:-               To insert a last note at the end of the document if necessary.

Show Notes:-                     Display all inserted notes in the document.

Insert Citation:-                                To insert the book or journal or artical reference where you get information for the preparation of the document.

Style:-                                 To set the style of the document as horror or funny or entertainment or etc.

Bibliography:-                   To add the bibliography, which list all the source cited in the document.

Insert Caption:-                 To set name to insert item , picture, shape etc

Insert Table of figures:-     To insert an other index of figures or pictures is called table of figures.

Update Table:-                  To update new entries in the table of figure.

Cross reference:-              To set reference between the table of figures with original item.

Page Layout

Page Layout:-

Themes:-             To set the font face style, back ground, color combination etc from this option.

Colors:-                                To Set the color scheme of the document.

Font:-                    To set the font face style of the document.

Effects:-               To set the object or buttons effects from this option.

Margins:-            To set the top, bottom, left and right blank space in the page called margins.

Page orientation:- To set the landscape or portrait orientation of the page.

Size:-                     To set the page size of your document where you want to type the data.

Column:-             To set data in columns as in news papers.

Breaks:-               To insert the page or column breaks for shifting the data in new page or columns.

Line numbers:- To Insert line numbers on in front of each typed line.

Hyphenation:-   To set hyphenations at line paragraphs or pages to show the continuity of the topic.

Water Mark:-    To set the ghosted text in the page called water mark it is also called hidden message.

Page color:-        To set the color of the page you type the text.

Page Borders:-  To set the page borders around the page and section and paragraph borders around the paragraph.

Indents:-              To set the left blanks spaces of the paragraph.

Spacing:-             To set the before and after blank spaces of the paragraph.

Position:-             To set the position of the inserted object or shape or picture or any item in the document as left, right.

Bring to front:-  Bring backward item to front of other items.

Send to back:-   Send front item to back to others.

Text wrapping:-                To set text around the item or shape or set item behind the text.

Align:-                   To set the alignment of the item inserted in the document.

Group:-                                To set the shapes or items in the groups.

Rotate:-               To rotate any shape or item at any particular angle.

Insert Menu

Insert Menu:-

Cover Page:-      To insert the cover page in your typed document.

Blank Page:-      To insert the blank page in any position of the typed document where ever you want.

Page Break:-      To insert the page break in the document.

Table:-                  To insert the text in rows and columns called the table.

Draw table:-       To draw particular cells in the document with draw table command.

Picture:-               To insert the picture in the document from gallery or memory as the need of the topic.

Clips art:-             To insert the Cartoons clips in the document or any type of clips.

Shape:-                                To insert the geometrical shapes in the document.

Smart Art Button:- To insert  the designed buttons in the document.

Chart:-                  To insert the graph in the document which compare two or more valued data in bars.

Hyper Link:-        To connect the two or more documents with link.

Book Mark:-       Set Book Marks in the document.

Cross reference:-Set the reference between headings or topics or pictures with this option.

Header:-              Set header at top of the each page for example page number document name or date etc.

Footer:-                                To set footer at bottom of each page in the document as page number path of document an name etc.

Page No.             To insert page number only else where you want in document.

Text Box:-            To insert text box in the typed document where it is necessary.

Quick Parts:-      To insert prepared parts called quick parts in the document.

Word Art:-          To insert designed words in your document.

Drop Cap:-          To drop a letter of initial word in two or more line in the document for its attraction.

Signature line:- To insert a signature line in the document for the signature use only.

Date and time:- To insert the date and time in the document as the need of the document.

Object:-                                To insert external object in the document.

Equation:-           To insert the mathematical equation in the document.

Symbol:-              To insert any type of symbol in the document.

Home Menu

Home Menu:-

Cute:-    To transfer high lighted text at new cursor position.

Copy:-   To make duplicate of the typed text.

Paste:-  To display the cuted or copied text at new cursor position.

Bold (B):-             Set Text Bold.

Italic(I):-               Set Text as Italic.

Under Line(U):- Set the text as under lined.

Subscript:-          To show the text down to line.

Supper Script:-  To Show the Text over the line.

Change Case:-   Set the Text as small alphabetical or capital alphabetical.

Sentence Case:- To Set first letter of the typed text upper case renaming lower case.

Upper Case:- Set all Typed text in capital alpha-bate.

Capitalize Each word:- Set each word’s first letter capital.

Toggle Case:- Set text as reverse to seted text.

Font:-    Set the font face style.

Font Size:- Fix the font size in the document.

Grow font:-        Increase Continuously size of the fonts.

Shrink Font:- Decrease Continuously size of the fonts.

Clear Formatting:-            Remove given format from the text.

Bullets:- Set the symbol in front of the text called bullets.

Numbering:- Insert number in front of the each paragraph.

Multi Level List:- To insert the multi level numbering list in the paragraphs.

Decrease indent:- Remove one step back indent.

Increase indent:- Increase one step forward indents.

Sort:- To make the alphabetical order of the Paragraphs or names A to Z or revers.

Show/Hide:- Show or hide the hyphenation symbols.

Align Text Left:-                Set the alignment of the text from left.

Align Text Right:- Set the alignment of the text from Right.

Center:- Set the alignment of the text at Center.

Justify:- Set the text alignment as justified to both sides.

Border:- Set border around the paragraph.

Line spacing:- Set the space between line wider or tight.

Normal:- To Display the document as normal document.

No Spacing:-      Set the document without spaces.

Heading:- Set the text as heading of any topic.

Tittle:- Set the tittle of any topic in the document.

Sub Title :-           Set the subtitle of the topic.

Change Style:- To Change the font style of the document.

Style Set:- Set the style of the document.

Font:- Set the font style of the document.

Find:- Search any topic or name or word from the typed text.

Replace:- To change the finded word with an other word.

Select Object:- High light the inserted object.

Select Text with similar formatting:- High light text having similar formats.