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.
Sunday, 8 January 2017
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
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
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
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.
Subscribe to:
Comments (Atom)