Thursday, November 1, 2007

How to type the formula on the Formula Bar

How to type the formula on the Formula Bar

- Type your formula here, the answer will display automatically

How to use Font Color button at the toolbars

How to use Font Color button at the toolbars

- To change the font color to the selected area

How to use Fill Color button at the toolbars

How to use Fill Color button at the toolbars

- To fill the color to the selected are


How to use Borders button at the toolbars

How to use Borders button at the toolbars

- Select the object whose line or border you want to remove. On the Drawing toolbar, click the arrow next to Line Color, and then click No Line.

How to use Increase Indent button at the toolbars

How to use Increase Indent button at the toolbars

- To view the increase indent at selected area

How to use Decrease Indent button at the toolbars

How to use Decrease Indent button at the toolbars

- To view the decrease indent at selected area


How to use Decrease Decimal button at the toolbars

How to use Decrease Decimal button at the toolbars

- To view the decrease decimal at selected area

How to use Increase Decimal button at the toolbars

How to use Increase Decimal button at the toolbars

- To view the increase decimal at selected area

How to use Comma Style button at the toolbars

How to use Comma Style button at the toolbars

- To view the comma style at selected area


How to use Percent Style button at the toolbars

How to use Percent Style button at the toolbars

- To view the percent style at selected area

How to use Currency Style button at the toolbars

How to use Currency Style button at the toolbars

-To view the currency style at selected area

How to use the Merge and Center button at the toolbars

How to use the Merge and Center button at the toolbars

- To merge and center the selected area


How to use Align Right button at the toolbars

How to use Align Right button at the toolbars

- To set the alignment right

How to use Align Center button at the toolbars

How to use Align Center button at the toolbars

- To set the alignment center

How to use Align Left button at the toolbars

How to use Align Left button at the toolbars

- To set the alignment left


How to use Underline button at the toolbars

How to use Underline button at the toolbars

- To underline the selected area

How to use Italic button at the toolbars

How to use Italic button at the toolbars

- To change the font style to italic

How to use Bold button at the toolbars

How to use Bold button at the toolbars

- To bold the font style


How to use Size button at the toolbars

How to use Size button at the toolbars

- To change the size of word

How to use Font button at the toolbars

How to use Font button at the toolbars

- To change the font

How to use Help button at the toolbars

How to use Help button at the toolbars

- To using the Microsoft excel help


How to use Zoom button at the toolbars

How to use Zoom button at the toolbars

- To view the book-sheet either larger or smaller

How to use Drawing button at the toolbars

How to use Drawing button at the toolbars

- To draw the line, shape and others on the sheet

How to use Chart Wizard button at the toolbars

How to use Chart Wizard button at the toolbars

- To insert chart by using wizard


How to use Sort Descending button at the toolbars

How to use Sort Descending button at the toolbars

- Sorting the selected area by descending

How to use Sort Ascending button at the toolbars

How to use Sort Ascending button at the toolbars

- Sorting the selected area by ascending

How to use Function button at the toolbars

How to use Function button at the toolbars

- To paste the function


How to use Auto-sum button at the toolbars

How to use Auto-sum button at the toolbars

- Automatically calculate the selected area

How to use Insert Hyperlink button at the toolbars

How to use Insert Hyperlink button at the toolbars

- To insert a hyperlink to other place or sheet

How to use Undo button at the toolbars

How to use Undo button at the toolbars

- To redo recent actions one at a time


How to use Undo button at the toolbars

How to use Undo button at the toolbars

- To undo recent actions one at a time

How to use Paste button at the toolbars

How to use Paste button at the toolbars

- To paste the area that you had copy

How to use Copy button at the toolbars

How to use Copy button at the toolbars

- To copy the selected area


How to use Cut button at the toolbars

How to use Cut button at the toolbars

- To cut the selected area

How to use Spelling button at the toolbars

How to use Spelling button at the toolbars

- To check the spelling

How to use Print Preview button at the toolbars

How to use Print Preview button at the toolbars

- To preview the document that want to print


How to use Print button at the toolbars

How to use Print button at the toolbars

- To print the file

How to use Save button at the toolbars

How to use Save button at the toolbars

- To save the file

How to use Open button at the toolbars

How to use Open button at the toolbars

- To open the existing file


How to use New button at the toolbars

How to use New button at the toolbars

- Create a new blank excel file

How to use Excel Help

How to use Excel Help

a)-Press F1 or choose help, type your question in the box, and click search

b)-The answer will display

How to insert Word Art

How to insert Word Art

-It is same with Microsoft word


How to use the Drawing

How to use the Drawing

a)-You can draw auto-shapes that you like

b)-Choose one auto shapes that you want

c)-The result is like below


How to change a type of chart

How to change a type of chart

a)-Changing a existing chart, right click your mouse, click Chart Type

b)-Change the column chart to pie chart, click ok

c)-The result is like below

How to paste a function

How to paste a function

a)-Click the paste function on toolbar, a dialog box will display

b)-You can choose the function in the function category