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.

Thirld Lesson Of Ms-Excel

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

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

Display and Use Windows in Ms-Word

ALT+TAB
Switch to the next window
ALT+SHIFT+TAB
Switch to the previous window
CTRL+W or CTRL+F4
Close the active window
CTRL+F5
Restore the size of the active window after you've maximized it
F6
Move to a task pane from another pane in the program window (clockwise direction). 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.
SHIFT+F6
Move to a pane from another pane in the program window (counterclockwise direction)
CTRL+F6
When more than one window is open, switch to the next window
CTRL+SHIFT+F6
Switch to the previous window
CTRL+F7
When a document window is not maximized, performs the Move command (on the Control menu for the window). Use the arrow keys to move the window, and, when finished, press ESC.
CTRL+F8
When a document window is not maximized, performs the Size command (on the Control menu for the window). Use the arrow keys to resize the window, and, when finished, press ESC.
CTRL+F9
Minimize a window to an icon (works only for some Microsoft Office programs)
CTRL+F10
Maximize or restore a selected window
PRINT SCREEN
Copy a picture of the screen to the Clipboard
ALT+PRINT SCREEN
Copy a picture of the selected window to the Clipboard

what u have to do afer mistake.

Undo if you make a mistake that you want to undo you can use the undo function on the Edit menu. For a quick keyboard shortcut for undo hold down the Ctrl key and press Z, if you didn’t mean to undo something, choose redo from the Edit menu.

Second Lesson Of Ms-Excel

Page setup adjusts the elaout of a document including magins, paper size and page orientation
Print presents the print dialog box, which allows document. You can print specicic pages and more then one copy at a time
Send to a quick way to transfer your document electronically by fax or email
Properties tells you the sixes of your file, when the document was created and last modified
Exit closes all open document as well as Microsoft word itself

Saving Documents

Saving document the may documents folder tsually the best place to save your documents. When saving your document make sure you use a name that will allows you to find it easily when you need to use it again, for example Kate smith letter 20 may doc.
Subfolders you can create subfolders inside’ My document when you save your document, choose my document the click on the new folder icon (see picture at right) in the save as dialog box. Give your folder a name. This allows you to organize your documents logically as you would inside a filling cabinet.

First Lesson Of Ms-Excel

New start a new document in a new window without quitting word

Open existing documents. Open directories and folders

Close the current window and document.

Save the current documents. The save as dialoge box only appears the first time you save your documents

Save as opens the Save as dialoge box lets you save the current documents

Save as HTML save documents in a format that is suitable for the Internet

Versions save multiple versions of the same document in one flew

Page setup adjusts the elaout of a document including magins, paper size and page orientation

Print presents the print dialog box, which allows document. You can print specicic pages and more then one copy at a time

Send to a quick way to transfer your document electronically by fax or email

Exit closes all open document as well as Microsoft word itself

Properties tells you the sixes of your file, when the document was created and last modified

Fifth Lesson of Ms-Excel

Spelling check the spelling in your workbook using this feature

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

Track changes allows you to highlight revisions your worksheet

Customize allows you to customize toolbars menus and key board commands

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

Table creates a table of data set by values and formulas

SORTED ORDER

DIR/ON By Name (Alphabetic A TO Z)

DIR/ON/P By Name (Alphabetic A To Z) with page wise

DIR/O-N/P By Name (Alphabetic A To Z) with page wise

DIR/OE/P By Extension (Alphabetic A To Z) with page wise

DIR/O-E/P By Extension (Alphabetic A To Z) with page wise

DIR/OS/P By Size (1.. 100…)(In Size Smaller First)

DIR/O-S/P By Size (In Size large First)

DIR/OD/P By Date (1980 To 2099)

DIR/O-D/P By Date (2099 To 1980)

Switch to another view

ALT+CTRL+P

Switch to print layout view

ALT+CTRL+O

Switch to outline view

ALT+CTRL+N

Switch to normal view

CTRL+\

Move between a master document and its subdocuments

Printing and previewing documents

CTRL+P
Print a document
ALT+CTRL+I
Switch in or out of print preview
Arrow keys
Move around the preview page when zoomed in
PAGE UP or PAGE DOWN
Move by one preview page when zoomed out
CTRL+HOME
Move to the first preview page when zoomed out
CTRL+END
Move to the last preview page when zoomed out

How i can change Formating with Keyboard in MS-WORD

CTRL+SHIFT+C
Copy formatting from text
CTRL+SHIFT+V
Apply copied formatting to text
CTRL+SHIFT+F
Change the font
CTRL+SHIFT+P
Change the font size
CTRL+SHIFT+>
Increase the font size
CTRL+SHIFT+<
Decrease the font size
CTRL+]
Increase the font size by 1 point
CTRL+[
Decrease the font size by 1 point
CTRL+D
Change the formatting of characters (Font command, Format menu)
SHIFT+F3
Change the case of letters
CTRL+SHIFT+A
Format letters as all capitals
CTRL+B
Apply bold formatting
CTRL+U
Apply an underline
CTRL+SHIFT+W
Underline words but not spaces
CTRL+SHIFT+D
Double-underline text
CTRL+SHIFT+H
Apply hidden text formatting
CTRL+I
Apply italic formatting
CTRL+SHIFT+K
Format letters as small capitals
CTRL+EQUAL SIGN
Apply subscript formatting (automatic spacing)
CTRL+SHIFT+PLUS SIGN
Apply superscript formatting (automatic spacing)
CTRL+SPACEBAR
Remove manual character formatting
CTRL+SHIFT+Q
Change the selection to the Symbol font

What is title bar?

Title bar is the top bar of the Window. Window title bar can contain the program and file name. This also contains the close, resize and minimize buttons.

How i can install my printer?

If you have printer, which has not been connected before, you will need to set it up on your computer to do this.

1. Click on the start menu button.
2. Choose setting then printers from the list
3. Double click on Add printer

This will start a step-by-step process to install your printer. If you were given a CD ROM or Floppy disks with your printer, you can use those to install it by following the printer manufacture’s instructions.