a. Worksheet Creation & Management.
b. Present Your Data Convincingly.
c. Build & Modify Table Confidently.
1. <New> Workbook, <Save as> Excel2000 Final Project at the <My Documents> folder.
2.
Header
:
(Left) - Excel2000
Final Project
(Right) - Page
#
Footer
: (Left)
- Prepared by My
Name
(Right) - System
Date & Time
3. Sheet Tab : (Sheet1) renames (Sales)
.................... ..... ...... .. . | .Alpha....... | Beta | .....Charlie |
Michael | $1,456.23 | $345.23 | $2,511.76 |
John | $875.56 | $656.90 | $345.00 |
David | $2,068.30 | $345.00 | $1,168.34 |
Total |
a) Present Column Chart from the Chart Wizard to the Management on Alpha, Beta, Charlie Sales.
*Column Chart : shows changes over time and also compares values.
b) Present Column Chart from the Chart Wizard to the Management on Beta sales for John and David only.
4. Sheet Tab : (Sheet2) renames (Sales Summary)
Average Sales | ................................................................ |
Highest Sales | |
Lowest Sales | |
G-50 Dec Commission % |
|
G-50 Dec Commission Sales |
|
G-100 Dec Commission % | |
G-300 Dec Commission % | |
G-400 Dec Results |
True | False | IF Function (Test) |
10% | 8% | G-100 Dec Sales is more than $80,000 |
8% | 12% | G-300 Dec Sales is less than $120,000 |
Good | Bad | G-400 Dec Sales is more than $35,000 |
5. Sheet Tab : (Sheet3) renames (Cost) Practise Aces Manufacturer computation.
6. Print
Preview. Adjust Margins (Top :
1.5", Bottom 1.5"). Close Preview.
7.
<File>
<Save> Excel2000
Final Project
at
<My Documents> folder.
What is File Attachment in email?
8. At your
yahoo internet mail system at
mail.yahoo.com, attach
Excel2000
Final Project.xls
file
from <My Documents> folder.
Register free email at sg.yahoo.com or at mail.yahoo.com attach workbook(s) to Internet Mail.
a. Write (Compose)
a letter
To
: elpexcel?@yahoo.com.sg
Subject : My
Excel2000 Final Project
Cc : elpexcel4@yahoo.com.sg
Bcc. :
b. File Attachment (Add/Delete Attachments) document(s)
Step
1 : Browse for
Excel2000
Final Project.xls,
Open
Step 2 : Attach File
Step 3 : Done
c. Send your
email .
9. Are you able to receive your attached files (Check Mail)?
10. 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?