 |
Excel Assignment 3
Assignment Due Midnight Dec 12
Are you seeing the power within
Excel? One of the powerful features of spreadsheets is the ability
to predict. What would your house payment be if you purchased a
$80,000 house with $20,000 down at 5% interest? What if you paid
$10,000 as the down payment? What about that car offer that offers
either 0% interest or $3,000 off the asking price? Which is the
better offer? Before spreadsheets this involved time consuming
calculations by hand or trusting the salesman. Now, using the
powerful function features, it can take less than a couple of minutes.
For full credit, this program is
due midnight, December 12. Note: no late submissions accepted.
Prepare for your Excel test Dec
13-15.
|
Files Saved |
Submit the files created from the
following sections as attachments to your instructor using the
Assignment Option with WebCT. (See the
instructions for Header)* |
|
1 |
- Complete Project 3 of the
Microsoft Excel 2002 book. (See FIGURE 3-1 on page E 3.05 for
example of completed Project 3 worksheet). Include a
header on the printout*. Show
formulas for the printout**.
|
|
2 |
- Complete In the Lab 1:
Tamiami Medical Supply Seen-Year Financial Plan on
pages E 3.69-72 of the Microsoft Excel 2002 book. Name the
Goal Seek file Tamiami Medical Supply Goal Seek
(The answer for the Goal Seek should be
45.85%.) Include a header on the printout*.
Show formulas for the printout**.
|
|
(2) |
- Complete Web Feature:
Creating Static and Dynamic Web Pages Using Excel on EW
1.01 - EW 1.15 of the Microsoft Excel 2002 book. See FIGURE
1a, 1b and 1c on page EW 1.02 -EW 1.03 for an example of
completed Web pages (Quick Lube Static Web Page.htm and Quick
Lube Dynamic Web Page.htm). Download the
Quick Lube.xls workbook before you start this exercise.
Do not email the files to your instructor.
|
|
3 attachments |
*Header
Instructions:
Click View on the
Menu Bar and select the option Header and Footer.
Click the Custom Header button in the
Header/Footer dialog box. Click inside the Left Section
box and click the Filename button (it looks like a
page with the Excel logo on it). Next, click inside the
Center Section box, and then click the Date
button (it looks like two calendar pages). Finally, click inside
the Right Section box and type your name.
Click OK.
**Showing
Formulas:
After each time your print, hold
down the Ctrl + ` (which is the symbol just above
the Tab key). Excel will display the formulas you used in your
document. After it does this, click File on the
Menu Bar, and choose Page Setup. Click the
Landscape radio button under Orientation, and choose the
Fit To: radio button under Scaling. Click the
Print button in the upper right-hand corner. Hold
down Crtl + ` to remove the formulas from view.
Note:
- Type the header on your
worksheet as instructed.
- Save all the files on your
disk first before you email your instructor.
- Browse the files on your disk
and select/attach 3 files to your email.
- Type "Your section #,
Assignment 9, Your Name" in the Subject.
Files to be submitted as
attachments:
-
Awesome Intranets (Formula
View) with
Awesome Intranets 3-D Pie Chart as sheet 2.
-
Tamiami Medical Supply (Formula
View) with
Tamiami Medical Supply 3-D Column Chart as sheet 2.
-
Tamiami Medical Supply Goal Seek
|
|
|
|
