Page Layout Data Menu excel

Page Layout Menu:-

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

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

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

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 size of the work sheet page where you want to type the data.

Print Area:-                         To select the print area of your work sheet which you want print on paper.

Breaks:-                               To insert the break for shifting the data in new page.

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

Back Ground:-                   To set the color of the page you type the data.

Print Title:-                          To set the top row to repeat at each page and left column repeat at each page.

Gird Line:-                           Show all cell lines.

Headings:-                          Show or hide the column headings and row numbers to  each sheet.

 Data Menu:-     

 Refresh all:-                        To refresh all the external links and put new inserted data in the sheet.

Connections:-                    To set all the created connections.

Properties:-                        To set the external links properties.

Edit link:-                             To change the given links addresses.

Sort:-                                     To sort the cell data lowest to largest or reverse.

Filter:-                                   To set filter on the data easy to watch particular data.

Text to Column:-              To set the simple text line in the column data.

Remove Duplicates:-       To remove the duplicate values from selected column area.

Data Validation:-             To Set the validation options on  given area, if you enter wrong data in that area excel alerts you.

Circle Invalid data:-         To set the circle on invalid inserted data in  the given range.(if the validation option applied).

Clear Circle:-                       To remove the given circles from the invalid entered data.

Consolidation:-                                 To consolidate or combine to different columns for watch the difference.

Analysis:-                            To distingious the difference between two data s.

Scenario Manager:-        To create a scenario of the given data.

Goal seek:-                         To set target and set changing cell address and achieve the goal.

Group:-                                                To set data in groups.

Auto outline:-                    To set automatically outline on the groups.

Un group:-                          Clear groups if given.

Clear outlines:-                  Remove the outlines from groups.

Subtotal:-                            To set the sub total of all given data.

Show detail :-                    To show the detail of groups.

Hide Detail:-                       To hide the detail of grouping data.

Insert Menu excel

Insert Menu:-

Insert Pivot table:-        To insert the pivot table in the sheet for calculation on special conditions.

Insert pivot chart:-        To insert the pivot chart to watch the value changing in graph type bars.

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

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

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

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

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

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

Column:-                             To insert the graph in the sheet as type of column.

Line:-                                     To insert the graph in the sheet as type of line.

Pie:-                                       To insert the graph in the sheet as the type of pie.

Bar:-                                      To insert the graph in the sheet as the type of bar.

Area:-                                   To insert the graph in the sheet as the type of area.

S cater:-                                To insert the graph in the sheet as the type of scatter.

Win/loss:-                           To insert single cell graph of win or loss type line graph.

Other charts:-                    To insert the other types of graphs in the sheet.

Text Box:-                            To insert the text box in the worksheet.

Header:-                              Insert header at top of the each sheet for example page number workbook name etc.

Footer:-                                                Insert footer at bottom of the each sheet for example page number workbook name etc..

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

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

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

Object:-                                                To insert external object in the sheet.

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

Symbol:-                              To insert any symbol in the work sheet.

Home Menu execl

Home Menu:-

Cute:-                                    To transfer high lighted cell value at new cell position.

Copy:-                                   To make duplicate of the cell value.

Paste:-                                  To display the cuted or copied cell values at new cell position.

Format:-                              To paste only format of the copied cell.

No Border:-                        Paste only value of the copied cell without borders.

Transpose:-                        Paste vertically copied values as horizontally.

Paste as link:-                    Paste with link of the copied cell if it changes this will automatically changed.

Paste as hyper link:-       Paste external link of the excel file at here.

As Picture:-                         Paste the value as picture not the value or data.

Format Painter:-              Set same format to next selected cell.

Font:-                                    Set the font face style of the cell data.

Bold (B):-                             Set cell data Bold.

Italic(I):-                               Set cell data as Italic.

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

Double underline:-           Set the cell data double underlined.

Size:-                                     Fix the cell data size in the work book.

Increase font:-                  Increase Continuously size of the cell data.

Decrease Font:-                Decrease Continuously size of the fonts inserted in cell.

Clear Formatting:-            Remove given format from the text of the cell.

Fill color:-                             To fill colors in the current cell.

All Borders:-                       To set borders around the cell.

Font Color:-                        Change the text color inserted in cell.

Top align:-                          Set Text of the cell at top of the cell area.

Middle Align:-                    Set text of the cell at middle of the cell area.

Bottom Align:-                  Set data at the bottom of the cell area.

Align text left:-                  Set data of cell at left side of cell area.

Align text right:-               Set data of the cell at right side of the cell area.

Align Center:-                    Set data of the cell at center of the cell area.

Decrease Indent:-            Remove left blank spaces from the cell area.

Increase Indent:-              Increase the left side blank spaces in the cell area.

Wrap text:-                         Set long entered data in that cell by wrap it into multiply lines.

Merge and center:-         To merge high lighted cells into one cell and set there data at center of the cell.

Number Format:-            To Set the format of the cell as decimal numbers.

Account Number:-           To set the cell format as accounting number format.

Percent Style:-                   To Set the cell value as percent style data.

Comma Style:-                  To Set the cell value as comma style digits separated by commas.

Increase Decimal:-           To Increase step by step decimal places in the given digit in cell.

Decrease Decimal:-          To decrease step by step decimal places from the given digits.

Conditional formatting:-                                                                                                                                                        Set the condition of the selected rank of the cells.

High light cell rules:-        To set rules for selected cell range.

Greater Than:-                  If the value is greater than give condition show the different color in selected range of cells.

Less Than:-                         If the value is less than give condition show the different color in selected range of cells.

Between:-                           If the value is between give condition show the different color in selected range of cells.

Text that contain:-          If the cell contain given text change the color of the selected range.

A Date accruing:-             If the cell contain the date you mentioned than change the color or selected range.

Duplicate values:-              If the values are duplicate in the given range change the color of that range.

Top 10 items:-                    To show the different color of cells from the list which are top 10 valued.

Top 10 %:-                           Show the top ten percentage cells from the list of cells.

Bottom 10 items:-            Show the bottom ten valued cells from the list.

Bottom 10%:-                    Show the bottom ten percentage valued cells from the list.

Above Average:-              Show the above averaged cells from the list of cells.

Bellow Average:-              Show the bellow averaged cells from the list of sells.

More rules:-                       Set more rules about your selection.

Data Bars:-                         Show the rules in data bars.

Color Scale:-                       Show the rules in colored scales.

Icon Sets:-                           Show the given rules in icons style sets at cells.

Clear Rules:-                       To remove the given rules from the list.

Manage rules:-                 Design new rules by your self.

Format as table:-             Design the data list as the tables.

Insert Cell:-                         To insert a cell between the give data.

Insert sheet row:-            To insert a blank row between the given list of values.

Insert sheet column:-     To insert a blank column between the given list of values.

Delete cell:-                         To remove the cell  from the given list of values.

Delete sheet row:-           To remove the row from the given list of values.

Delete sheet column:-    To remove the column from given list of values.

Format :-                             To set the format of the cell.

Row Height:-                      Show the height of the current rows.

Auto fit row height:-        To fit the height of the row as the contents width is long.

Column Width:-                To set the current column width.

Auto fit column width:- To set automatically width of the column as the data long in it.

Default width:-                 Show the default width of the columns.

Hide and un hide:-            Hide or show the rows and columns.

Organize sheet:-               To set the sheet options.

Rename Sheet:-                To change the name of the current sheet.

Move or copy sheet:-     To move the sheet at end of other sheets or create a duplicate copy of the current sheet.

Tab Colors:-                        Set the colors of the tab.

Protection:-                        Set the code on the data.

Protect sheet:-                  Set the code on the sheet.

Lock cell:-                             To lock the current sheet cell.

Format cell:-                       change the cell format as you need.

Auto sum:-                         Automatically add all above or left rang of the values.

Sum:-                                    To add the given range of the cell data.

Average:-                            To calculate the average of given range of the data.

Count numbers:-              To count the number of the cells which have the data.

Max:-                                    To pick up the maximum number from the list of the data.

Min:-                                     To pick up the minimum number from the list of the data.

More Functions:-             To show the more functions about values.

Fill:-                                        To fill the same number in the selected range of the cells.

Down:-                                 To fill same number in down selected cells.

Left:-                                     To fill same number in left selected cells.

Right:-                                  To fill same number in right selected cells.

Up:-                                       To fill same number in up selected cells.

Across work sheet:-        Set data across the worksheet.

Series:-                                 Set the series of numbers natural, even or odd or specify by user.

Justify:-                                To adjust the data in the cell.

Clear:-                                   Remove content from the sheet.

Clear all:-                             Remove all contents and format etc.

Clear content:-                  Remove only contents not the format nor any thing in cell.

Clear comment:-              Remove only comment from the specific cell.

Clear hyper link:-              Remove hyperlink from the current cell.

Sort A to Z:                          Set the series of the data a to z or lowest to highest or reverse.

Costume sort:-                  Set the series of the data specify condition by user.

Filter:-                                   Set filter on the data for easy to watch them with conditions.

Clear filter:-                        Remove the given filter from the data.

Find:-                                    Search the specify data from the range of the data.

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

Go to:-                                   To jump on particular place or or cell address.

Goto formula:-                 Jump on formula given cell.

Goto Comment:-              Jump on comments.

Goto constant:-                Jump on the constants.

Goto data validations:-  Jump on the valid condition given data cells.

Select object:-                    Highlight given object.

Selection pane:-                  Open the selection pane window have entered objects names in the sheet.

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.