Advertize

Sunday, 8 January 2017

Attractive Personalties

There are few Personalties which could chang the minds of people's in these Benazir Bhutto is most popular and brave. She teach people's to live and fight for rights.

Some of them were

All of them she is most powerful fully prepared for fight against the violations of right of live independent. She made us strong 

Ideal personality

http://learnwindowsandoffice.blogspot.com/
Micro Soft Power Point
Micro soft point is used for creating the presentations for any topic, thesis or any interviews etc. It is combination of different slides and notes pages. You can display your ideas on the different slides.
Title bar:-                             Contains name of presentation.

File Menu:-                       

Open:-                                    To open the saved presentation.
Save:-                                     To store the created presentation.
Save as:-                                To store the saved presentation with an other name.
Close:-                                    To close the opened the presentation.
Info:-                                      Show all information about the presentation.
Print:-                                     To print the slide or notes on the paper via printer.
Save and send:-                    To save presentation and send to external device.
Help:-                                     To get help from power point for any topic.
Options:-                               To show and set the options of the power point.

Exit:-                                       To close the all opened presentations and exit from power point.
Home Menu:-
Cut:-                                       To transfer highlighted text, item, or any thing to an other cursor position.
Copy:-                                    To make duplicate of high lighted text, item or any thing in the slide in presentation.
Paste:-                                    To paste cuted or copied text to an other place.
Format painter:-   To set same format to selected text.
New slide:-                             To insert new slide in the presentation.
Layout:-                 To change the face of the slide.
Reset:-                                    To reset slide at same position.
Selection:-                              To set the sections for the presentations.
Font:-                                     To set font or text style of the slides.
Bold:-                                     To set the text bold of the slide.
Italic:-                                     To set the text italic of the slide.
Under line:-                           To set under line on the text in the slide.
Text shadow:-                       To set the shadow of the text inserted in the slide.
Strike through:-                    To set strike line middle in the text.
Font Size:-                              To set the size of the font.
Increase font Size:-               To increase slowly slowly size of the text.
Decrease font size:-              To reduce slowly slowly size of the text in the slide or notes in presentation.
Clear all formatting:-            To remove given formats from the slides.
Character Sacing:-                To set space between the given text.
Change case:-                       To change the case of fonts as lower alphabetically of upper alphabetical.
Font color:-                            To change the color of the text in the slides.
Bullets:-                  To insert the bullets symbols in the slides text.
Numbering:-                          To insert the numbering bullets in the slides.
Increase:-                               To increase the level of the bullets.
Decrease:-                              To reduce the level of the given bullets.
Align Left:-                            To set the alignment of the text left.
Right Align:-                          To set the alignment of the text right.
Text Direction:-                     To set the direction of the given text in the slide.
Convert to Smart art:-          To set the text in  the smart buttons.
Action button:-                     To set the action of the buttons in the slide.
Arrange:-                               To arrange objects in the slides as left,  right etc.
Quick style:-                          Chose a visual style of the shape or item or line.
Find:-                                      To search a word or line from the slides.
Replace:-                                To change the searched word or line to an other word or line.
Select:-                                   To high light text, title, item, object or all in the slides.

Review and View menu of excel

http://learnwindowsandoffice.blogspot.com/
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.
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.
Protect sheet:-                  To set code on the sheet.
Protect share work book:- To set code on the shared work book.
Allow users to edit ranges:- To permit the users to change in particular areas in the sheet if you are on the network of the computers.
Track Changes:-               To high light changes made in the sheet after saving first one.

View menu:-

Normal:-                              To show normal view of the sheet pages.
Page layout:-                     To show print page layout of the sheet pages.
Page break:-                      To show the pages braked sheet pages.
Costume view:-                 To user defined view.
Full screen show:-            Show sheet on full screen.
Ruler:-                                   Show the scale bar on the sheet page.
Gird lines:-                          Show the cell lines in the sheet.
Formula bar:-                    Show or hide the for formula bar.
Headings:-                          Show or hide the column names and row numbers from the active sheet.
Zoom:-                                 Show small or big sized cells.
Zoom to selection:-       Show sheet longer as the selection.
New window:-                  To set active work book in  new window.
Arrange all:-                       Show all opened work book on screen.
Freeze pane:-                     To freeze left side column or top row or any selection to watch large data headings.
Split:-                                    To decide screen in parts.
Hide:-                                    To hide the active work book.
Un hide:-                             Display hidden work book.
View side by side:-           Display opened work book side by side.
Synchronous scrolling:- Scroll two documents at same time with one scrolling bar.
Save work Space:-           To store only typed worksheet cell not full work book for saving the memory space.
Switch to Window:-        To jump on an other opened work book.

Marcos:-                              to record set of commands in one macro.

Page Layout Data Menu excel

http://learnwindowsandoffice.blogspot.com/
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

http://learnwindowsandoffice.blogspot.com/
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

http://learnwindowsandoffice.blogspot.com/
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.