Microsoft Office Tutorials and References
In Depth Information
Self study
8 In the Category list, click Date. Excel displays the date formats you can choose.
9 Select the fourth choice on the list, 3/14/01, and then click OK.
10 Highlight cells D2 and D3 and select Percentage from the Number Format drop-down
menu. Excel converts the numbers to percent and adds a percent sign. The following
table lists the number formats and explains each one.
FORMAT
DESCRIPTION
General
Use this format for cells with general numbers. Excel does not
change the format of the number.
Number
Use this format to display numbers. Excel lets you choose the
amount of decimal places and whether to use a separator for values
over 999, such as 1,000. You can also control the way Excel displays
negative numbers, such as displaying negative numbers in red.
Currency
Use this category to specify a currency symbol.
Accounting
Use this category to specify a currency symbol and align currency
symbols and decimal points.
Date
Use this category to display the contents of a cell as a date.
Time
Use this category to display the contents of a cell as time.
Percentage
Use this category to multiply the cell contents by 100 and display
the result with a percentage symbol.
Fraction
Use this category to display the number as a fraction.
Scientific
Use this category when you want to display the contents of a cell in
scientific notation.
Text
Use this category when you want to enter a text description
containing numbers or special characters. Excel treats the numbers
as text.
11 Click File > Save, and then click File > Exit.
Self study
Open excel03011 and make the following changes:
1
In the Day 1 Morning cell or B3, replace the contents by typing Meet friends for
breakfast at the hotel .
2
Click Undo on the Quick Access Toolbar to return the previous contents to the cell.
3
Select the Day 2 Afternoon cell.
4
Copy the cell by selecting it and clicking Home > Clipboard group > Copy.
5
Open the Clipboard task pane to see the selection on the Clipboard.
6
Select the Day 3 Afternoon cell or C7.
7
Click the selection in the Clipboard to paste it into the Day 3 Afternoon cell.
Search JabSto ::




Custom Search