جاوا اسکریپت غیر فعال است برای تجربه بهتر، قبل از ادامه، جاوا اسکریپت را در مرورگر خود فعال کنید.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser .
آموزش کامل Excel 2003 -EN
[h=2]Text and Cell Alignments
[h=3]Challenge!
Open your Monthly Budget file.
Center the text horizontally in Column A and Row 2.
Apply a distributed vertical text alignment to Row 2.
Save your document.
Use the text control and text orientation features so that you are familiar with them.
Close the document without saving any of the formatting from the text control and text orientation features.
[h=2]Formatting Numbers [h=3]Introduction[h=4]By the end of this lesson, learners should be able to:
Format the display of numbers
Format the display of percentages
[h=2]Formatting Numbers
[h=2]Formatting Numbers
[h=5]To Format the Appearance of Numbers in a Cell:
Select a cell or range of cells.
Choose Format
Cells from the menu bar.Format Cells from the shortcut menu.)
The Format Cells dialog box opens.
Click the Number tab.
Click Number in the Category drop-down list.
Use the
Decimal places scroll bar to select the number of decimal places (e.g., 2 would display 13.50, 3 would display 13.500).
Click the Use 1000 Separator box if you want commas (1,000) inserted in the number.
Use the Negative numbers drop-down list to indicate how numbers less than zero are to be displayed.
[h=2]Formatting Numbers date can be formatted in many different ways in Excel 2003. Here are a few ways it can appear:
[h=2]Formatting Numbers
[h=5]To Format the Appearance of a Date in a Cell:
Select a cell or range of cells.
Choose Format
Cells from the menu bar.
The Format Cells dialog box opens.
Click Date in the Category drop-down list.
Select the desired date format from the Type drop-down list.
[h=2]Formatting Numbers time can be formatted in many different ways in Excel 2003. Here are a few ways it can appear:
[h=2]Formatting Numbers
[h=5]To Format the Appearance of Time in a Cell:
Select the range of cells you want to format.
Choose Format
Cells from the menu bar.
The Format Cells dialog box opens.
Click Time in the Category drop-down list.
Select the desired time format from the Type drop-down list.
[h=2]Formatting Numbers percentage . For
[h=2]Formatting Numbers
[h=5]To Express Numbers as a Percentage in a Spreadsheet:
Select a cell or range of cells.
Choose Format
Cells from the menu bar.
The Format Cells dialog box opens.
Click Percentage in the Category drop-down list.
Define the Decimal Places that will appear to the right of each number.
[h=2]Formatting Numbers
[h=3]Challenge!
Open your Monthly Budget file.
Format the numbers in the spreadsheet as Currency without the $ symbol.
Fill the formula from B19 to C19 through N19. This text
will appear in cell 19 of
Columns D through N because expenses have not been entered for those columns yet.
Select Row 19 and format the numbers as a percent with no decimal places.
An Example:
Save and close the document.
[h=2]Applying Font, Color and Borders to Cells
[h=3]Introduction[h=4]By the end of this lesson, learners should be able to:
[h=2]Applying Font, Color and Borders to Cells Typeface , or the style of the letter; Size Color of the letter. The default font in a spreadsheet is Arial 10 points , but the typeface and size can be changed easily.
[h=2]Applying Font, Color and Borders to Cells Typeface , or the style of theSize of the letter; and Color of the letter. The default font in a spreadsheet is Arial 10 points , but the typeface and size can be changed easily.
[h=2]Applying Font, Color and Borders to Cells
[h=5]Selecting a Font Typeface:
The amount of typefaces available for use varies
depending on the software installed on your computer.
[h=2]Applying Font, Color and Borders to Cells
[h=5]To Apply a Typeface to Information in a Cell:
Select a cell or range of cells.
Click on the down arrow to the right of the Font Name list box on the Formatting toolbar.
A drop-down list of available fonts appears.
Click on the Typeface of your choice.
The selection list closes and the new font is applied to the selected cells.
[h=2]Applying Font, Color and Borders to Cells
[h=3]Change font type, size and color (continued) [h=5]To Apply a Font Size to Information in a Cell:
The "Font Size" list varies from typeface to typeface. The Arial font sizes, for example, are 8, 9, 10, 11, 12, 14, 16, 18, 20, 22, 24, 26, 28, 36, 48, 72.
Select a cell or range of cells.
Click on the down arrow to the right of the font size list box on the Formatting toolbar.
A drop down list of available font sizes appears.
Click on the Font Size of your choice.
The selection list closes and the new font size is applied to the selected cells.
[h=2]Applying Font, Color and Borders to Cells
[h=3]Change font type, size and color (continued) [h=5]To Apply Color to Information in Cells:
Select a cell or range of cells.
Click on the down arrow to the right of the font color list box.
A drop-down list of available colors appear.
Click on the color of your choice.
The selection list closes and the new font color is applied to the selected cells.
[h=2]Applying Font, Color and Borders to Cells Bold , italics , and/orunderline font style attributes to any text or numbers in cells.
[h=2]Applying Font, Color and Borders to Cells
[h=5]To Select a Font Style:
Select a cell or range of cells.
Click on any of the following options on the Formatting toolbar.
Bold button (Ctrl + B).
Italics button (Ctrl + I).
Underline button (Ctrl + U).The attribute(s) selected (bold , italics , or underline ) are applied to the font.
The
Bold ,
Italics , and
Underline buttons on the
Formatting toolbar are like toggle switches. Click once to turn it on, click again to turn it off.
