Excel 2000 Module 4
Formatting Worksheets
The
major benefits of using Microsoft Excel 2000 include the ability
to organize data in row-and-column format and then perform calculations
on specific rows, columns, and cells. Excel provides dozens
of ways to format labels and values in a worksheet to provide
a more attractive design and layout.
Start
<Excel>
Click <File>, <New>
Click <Sheet1>
Rename <Sheet1>
to <M4Ex>
Practice M4Ex
Using AutoFormat
With the AutoFormat feature, you can format the data in your worksheets using a professionally designed template.
Select Range A1:F8
Click <Format> <AutoFormat>
Select Classic 2 format Click <OK>
Formatting Numbers
Most of the data that you use in Excel is numeric. You can select one of Excel's options for formatting numbers. These options automatically insert and delete symbols and digits to reflect the format you choose.
By default, all data you enter is formatted with the General option, which shows the data exactly as you enter it.
You can choose from the following formats, organiszed by category :
General, Number, Currency,
Accounting, Date, Time,
Percentage, Fraction, Scientific,
Text, Special, Custom.
Click Cell A2
Use Today Function to enter the date
Format the date to dd/mm
Click <Format> <Cells>
Click <Number> tab Click <Date>
Select Type list Click <OK>
Select Range B4:F8
Click <Format> <Cells>
Click <Number> tab Click <Currency><$>
Click Decimal places down arrow
Select <0> Click <OK>
Alternatively
Click <$> button Click <,> button
Click <Decrease Decimal> button
Aligning Cell Contents
You can change the alignment relative to the edges of the cells. You can align horizontally or vertically with the option of the orientation in degrees.
Select Range A4:A8
Click <Format> <Cells>
Click <Alignment> tab
Select <Horizontal> arrow <Left (indent)>
Select <Vertical> arrow <Bottom>
Formatting Text
You can change the font and font size for selected headings, labels, and values. A font is the general appearance of text, numbers, and other character symbils. Excel's default font is 10-point Arial. A point is 1/72 inch. So a 10 point font means about 1/6 inch high. The Font tab of the Format Cells dialog box contains options to change the font, the style and the point size of a cell entry.
Select Cell A2 (Today Date)
Click <Bold> button
Select Range A3:F3
Click <Center> Click <Bold>
Right Click, Select <Format Cells>
Click <Font> tab Select Font style list
Click <Arial>
Select Size list Click <12>
Click <Color> Select Red Click <OK>
Select Range A4:A8
Click <Bold> button
Right Click, Select <Format Cells>
Click <Alignment> tab
Select <left (Indent)> list
Type 1 at Indent box Click <OK>
Adding Borders
Adding borders to a cell or a range of cells can enhance the visual appeal of your worksheet, make it easire to read, and highligh particular data. You can put a border around the cell, a range of cells, or an entire worksheet.
Select Range B8:F8
Click <Border> button
Click <Thick Outline> button
A menu of border line styles and locations
Select Range A3:E3
Right Click, Select <Format Cells>
Click <Border> tab
Select <second line (right)> Line Style list
Click Blue
Click <Border> section to apply on
selected lines which is below only
Click <OK>
Adding Shading
You can add shading and patterns to a cell or a range of cells to set off the selection. Shading can be a shade of gray or a colour.
Select Range B8:F8
Click <Format> <Cells>
Click <Patterns> tab Click Yellow
Merging Cells
Merging cells combines two or more cells into a single cell so that the text or value within the cell can be formatted more easily.
Select Range A1:F1
Click <Merge And Center>
Select Range A1:F1
Click <Format> <Cells>
Click Horizontal list Click <Centre>
Click Vertical list Click <Centre>
Select <Wrap Text> at the Text control
Select <Merge Cells> at the Text control
Click <OK>
Creating and Applying Conditional Formats
You can control how data appears in Excel worksheets by applying conditional formats, which are rules you create to determine how data appears depending on the value of the cell, e.g. set any numeric entry betwen 1500 and 2500 appears in Green.
Select Range B4:E4
Click <Format> <Conditional Formatting>
Click <between>
Type 1500 at the far left side
Type 2500 at the far right side
Click <OK>
The minimum and maximum value for the condition is set.
Click <Format> button
Click <Color> arrow for Green
Click <Bold> for Font Style list
Click <OK>
Click <File> <Save>
Click <File> <Close>
Practice Exercise 1 : M4: Page 13
Click <Sheet2>
Rename <Sheet2>
to <M4Ex1>
Click
<File>
<Save>
Click <File> <Close>
Click <File> <Exit>
Practice Exercise 2
<New>
Workbook
Click
<File>
<Save As>
Excel2000
Project 1
at
<My Document>
<Save>
Practise
International
Sales for international currency formatting,
borders and shading.
Click
<File>
<Save>
Click <File> <Close>
Click <File> <Exit>
Edwin
Koh : We
completed on the New
Knowledge and Skills in
Excel
2000 Module 4.
