Now onward this blog in updated on www.pakistantravelz.com so please visit said site to learn more

Now you can remove background of your picture without using Photoshop and any other professional softwares. Yes its possible now. just goto remove.bg site ...upload your picture ..click on remove background. here you are....

Seventh Lesson Of Ms-Excel (Insert)

Row allows adjustment of the row height including an auto fit feature. It also allows hiding of rows

Column allows you to change column width manually or withy auto fit it also slows gliding of column

Sheet allows the renaming hiding (and un hiding) of the worksheet

Auto format apply Excel’s own specialized formatting to your selected cells

Conditional formatting applies formatting to cells based on conditions you specify

Style allows you to modifying create formatting styles for your worksheet

Number allows you to choose how to display numerical values for example as currency dates or percentages

Border allows the selected cell to be given a variety or borders

Protections allows the worksheet to be locked and /or hidden

Alignment text can be rotated wrapped and aligned vertically or

Font allows changes to font style size and other formatting option

Pattern allows the selected cells to be given a variety of colors and / or patterns

Seventh Lesson Of Ms-Excel (Insert)

Row allows adjustment of the row height including an auto fit feature. It also allows hiding of rows

Column allows you to change column width manually or withy auto fit it also slows gliding of column

Sheet allows the renaming hiding (and un hiding) of the worksheet

Auto format apply Excel’s own specialized formatting to your selected cells

Conditional formatting applies formatting to cells based on conditions you specify

Style allows you to modifying create formatting styles for your worksheet

Number allows you to choose how to display numerical values for example as currency dates or percentages

Using The Help Topic Pane

F1

Display the Help window if the Assistant is turned off (if the Assistant is turned on, F1 displays the Assistant balloon).

F6

Switch between the Help topic and the Contents, Answer Wizard, Index pane

TAB

Select the next hidden text or hyperlink, or Show All or Hide All at the top of a topic

SHIFT+TAB

Select the previous hidden text or hyperlink, or the Browser View button at the top of a Microsoft Office Web site article

ENTER

Perform the action for the selected Show All, Hide All, hidden text, or hyperlink

ALT+O

Display the Options menu to access any Help toolbar command

ALT+O, and then press T

Hide or show the pane with the Contents, Answer Wizard, and Index tabs

ALT+O, and then press B

Display the previously viewed topic

ALT+O, and then press F

Display the next topic in a previously displayed sequence of topics

ALT+O, and then press H

Return to the specified home page

ALT+O, and then press S

Stop the Help window from opening a Help topic (useful if you want to stop a Web page from downloading)

ALT+O, and then press I

Open the Internet Options dialog box for Microsoft Internet Explorer, where you can change accessibility settings

ALT+O, and then press R

Refresh the topic (useful if you have linked to a Web page)

ALT+O, and then press P

Print all topics in a book or a selected topic only

ALT+F4

Close the Help window

Resize & Move Menus, Toolbarsm, Task Panes

1. Press ALT to select the Menu Bar.
2. Press CTRL+TAB repeatedly to select the Toolbar or Task Pane you want.
3. Do one of the following:

Resize a Tool Bar

1. 1. In the toolbar, press CTRL+SPACE to display the Toolbar Options menu.
   2. Select the Size command, and then press ENTER.
   3. Use the arrow keys to resize the toolbar. Press CTRL+ the arrow keys to resize one pixel at a time
   4. Move The Toolbar
   1. In the toolbar, press CTRL+SPACE to display the Toolbar Options menu.
   2. Select the Move command, and then press ENTER.
   3. Use the arrow keys to position the toolbar. Press CTRL+ the arrow keys to move one pixel at a time. To undock the toolbar, press DOWN ARROW repeatedly. To dock the toolbar vertically on the left or right side, press LEFT ARROW or RIGHT ARROW respectively when the toolbar is all the way to the left or right side.

   Resize Task Pane

   1. In the task pane, press CTRL+SPACE to display a menu of additional commands.
   2. Use the DOWN ARROW key to select the Size command, and then press ENTER.
   3. Use the arrow keys to resize the task pane. Use CTRL+ the arrow keys to resize by one pixel at a time.

   Move a Task Pane

   1. In the task pane, press CTRL+SPACE to display a menu of additional commands.
   2. Use the DOWN ARROW key to select the Move command, and then press ENTER.
   3. Use the arrow keys to position the task pane. Use CTRL+ the arrow keys to move one pixel at a time.
2. When you are finished moving or resizing, press ESC.

Sixth Lesson of Ms-Excel

Spelling check the spelling in your workbook using this feature

Auto correct excel will automatically correct command typing errors. You can set option from

Share workbook allows multiple rests to use your worksheet. Simultaneously. Useful if your document is stored on network

Protection protect your worksheets or entire workbook with password and other features

Track changes allows you to highlight revisions your worksheet

Auditing us the auditing tools to check the structure of any formulas you

Customize allows you to customize toolbars menus and key board commands

Options allows you to change general, viewing and editing settings for your

Sort allows you to sort selected information (into alphabetical order for example)

Validation allows you to restrict what kind of information is entered into a cell

Table creates a table of data set by values and formulas

Template wizard creates a template and database form and excel workbook

Group and out line enables you to group columns or rows together and create outlines of more worksheet

Get external date this allows you to bring information from other kinds of files into your kinds of files into your worksheet

Auto correct common spelling and typing mistakes can be automatically corrected for you to save time. For example incorrect use of the caps lock key and the capitulations choose the auto correct command from the tools menu.

Hyperlink

Hyperlinks a hyperlink can be useful if you ‘d like to insert links to specific Internet sites in your worksheet. Select the text you’d like to link chooses the hyperlink command from the inset menu type in the address of an Internet site in the top box and press ok. Back in the worksheet if you move your mou8se pointer over your mouse pointer over your hyperlink text the cursor will change from and arrow to a hand. Click once on the text to follow the link.

Fifth Lesson of Ms-Excel

Cell inserted the number of cells rows or columns you have selected

Rows inserted the number of rows that have been selected

Worksheet inserted a new worksheet to the left of the selected worksheet

Page break inserts a page break above the select cell to divided printed pages

Function provides a list of categories functions and a brief description of and brief description of what they do

Name allows you to describe and refer to a cell or range of cells with a unique name

Columns inserted the number of columns that have been selected

Chart step you through creating a chart or graph on worksheet

Picture inserts a picture. Clip art, auto shape or word art in to your worksheet

Map creates geographical map based on selected data. Drag the mouse over worksheet data to create the map

Object inserts an object created in another reapplication into your worksheet such as a graphic word document or media clip

Comment allows you to mark and active cell or type in a comment about that cell

Hyperlink inserts a link that can be click on to open another document or an Internet page

Display and use of Task Pane

F6

Move to a task pane from another pane in the program window. (You may need to press F6 more than once.)

Note If pressing F6 doesn't display the task pane you want, try pressing ALT to place focus on the menu bar, and then pressing CTRL+TAB to move to the task pane. In addition, if you open a dialog box from the Reveal Formatting task pane, the focus may be in your document after you close the dialog box, rather than in the task pane. You can use F6 or CTRL+TAB to return to the task pane.

CTRL+TAB

When a menu or toolbar is active, move to a task pane. (You may need to press CTRL+TAB more than once.)

TAB or SHIFT+TAB

When a task pane is active, select the next or previous option in the task pane.

CTRL+DOWN ARROW

Display the full set of commands on the task pane menu.

DOWN ARROW or UP ARROW

Move among choices in a selected submenu; move among certain options in a group of options.

SPACEBAR or ENTER

Open the selected menu, or perform the action assigned to the selected button.

SHIFT+F10

Open a shortcut menu; open a drop-down menu for the selected gallery item.

HOME or END

When a menu or submenu is visible, select the first or last command on the menu or submenu.

PAGE UP or PAGE DOWN

Scroll up or down in the selected gallery list.

CTRL+HOME or CTRL+END

Move to the top or bottom of the selected gallery list.

About Head & Footer in Ms-Excel

Header and footers a header is piece of text, which appears at the top of every page, you print from your worksheet. a footer is text appearing at the bottom of an page. Use the headers and footers command on the view menu to make your own headers and footers the header and footer toolbar will appear on your screen allowing you to insert auto text (preset options such as page numbers dates and the name of your file) and to flick through all the headers and footers on your pages. To check now they will look on the printed pages go to the file menu and choose print preview.

Third Lesson Of Ms-Excel

Normal simplified view of the page. The default view for entering editing and formatting
Page break preview A view that allows editing and display the worksheet as it will be printed
Tool bars present a menu of all the toolbars that are available. Use this feature to add or remove toolbars from your screen
Header and footer allow you to create and modify headers and footers for your worksheet
Full screen displays your worksheet work sheet worksheet without the title bar main menu and status bar so more text appears on screen
Formula bar shows or hides the formula bar at the top of your screen , the formula bar display your cell reference and contents of select of selected cells

Comments show a list of any comments that have been inserted into a worksheet

Custom views creates different views of a worksheet that you define for displaying and printing

Zoom zoom in on a worksheet to made it appear larger zoom out to make it appear smaller

Thirld Lesson Of Ms-Excel

Undo undoes your last action can usually be used to undo numerous action

Repeat. Repeats your last action

Cut Removes tromp selected cells and allows it to be pasted to another location

Clear Gives options to delete the contents. Format or components of the selected cells.

Copy copies selected cells. Copy rather than having to re-enter cells. Charts can also be copied.

Copy copies selected cells. Copy rather than having to re-enter cells. Charts can also be copied.

Paste as hyperlink pastes your data as a hyperlink which can be clicked on to jump you to another document or Internet page

Fill Copies the contents of the top or left most cell into the other selected cells.