a. Worksheet Creation & Management.
b. Present Your Data Convincingly.
c. Build & Modify Table Confidently.
1. <New> Workbook, <Save as> Excel2000 Project 1 at the <My Documents> folder.
2. Sheet Tab : (Sheet1) renames (Sales)
| .Region.. | January | February | . March |
| North . | $10,800 | $21,500 | $37,550 |
| East | $22,100 | $24,050 | $27,890 |
| South | $10,111 | $13,400 | $20,800 |
| West | $13,270 | $15,670 | $19,850 |
| Total |
| Total Sales | ................................................................ |
| Average Sales | |
| Highest Sales | |
| Lowest Sales | |
| Commission |
|
| Commission Sales |
Excel's
Built-in Functions - eg. Total (=sum), Highest (=max).
Commission Sales = Total Sales multiplied the Commission.
3.
<File>
<Save> Excel2000
Project 1
at
<My Documents> folder.
Register
free email 
at sg.yahoo.com 
or
at mail.yahoo.com
attach workbook(s)
to Internet Mail.
mail.yahoo.com
id: elpexcel? password: excel20004. At your
yahoo internet mail system or mail.yahoo.com, attach Excel2000
Project 1.xls
file from <My Documents> folder.
a. Write (Compose)
a letter
To
: elpexcel?@yahoo.com.sg
Subject : My
Excel2000 Project 1
Cc : elpexcel4@yahoo.com.sg
Bcc. :
b. File Attachment (Add/Delete Attachments) document(s)
Step
1 : Browse for
Excel2000
Project 1.xls,
Open
Step 2 : Attach File
Step 3 : Done
c. Send your
email 
.
5. Are you able to receive your attached files (Check Mail)?
6. Are you able to download your attached files to save your harddisk (save as) or open your attached files (open) and save to your Excel 2000?
