 |
Excel Assignment 2
Assignment Due Midnight Dec 5
We're going deeper into Excel.
I hope you are enjoying the journey. New topics include formulas,
smart tags, and formatting, We're a visual society. How your
documents look plays a role in how the information is received.
Pages of numbers often run together and the information is not absorbed
corrected unless you put some thought into how it is placed on the page.
Good luck!
For full credit, this program is
due midnight, December 5, according to the PJC time stamp on emails.
Computer ISPs vary so make sure you give yourself plenty of time to turn
it in. You can turn in the assignment up through December 12, but it will have a 10% penalty. No homework will be
accepted after Dec 12.
Note: I'm changing the method of
turning in your assignments to reduce some of the confusion. You
will see on your WebCT homepage a new icon entitled "Assignments."
Click on this. You'll see the second Excel Assignment which is a
duplicate of this page. Once you have completed your assignment, go
to your WebCT homepage. Click on Assignments. You'll see the
Excel Assignment 2. Follow the instructions to upload your files.
If you enter an email address, it will confirm you have submitted your
assignment (strongly recommended). One drawback. You
can only submit the assignment once. Make sure you have everything
ready before sending to me.
|
Files Saved |
Submit the files created from the following sections
as attachments to your instructor using the Assignment option within WEBCT: (See the instructions for Header)* |
|
1 |
- Complete Project 2 of the Microsoft Excel 2002 book. (See FIGURE 2-1
on page E 2.05 for example of completed Project 2 worksheet).
Include a header on the printout*.
Show formulas for the printout**.
- Name the second sheet Greenback
Stock Club Stock Quote. Include a header on the
printout*.
|
|
2 |
- Complete In the Lab 2: Emelynes Secret Emporium Monthly
Accounts Receivable Balance Sheet on pages E 2.71-74 of the Microsoft
Excel 2002 book. Name the second file Revised Emelynes Secret
Emporium. Include a header on the printout*. Show formulas for the printout**.
|
|
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 8, Your Name" in the
Subject.
Files to be submitted as attachments:
- Greenback
Stock Club (Formula
View) with Stock
Quotes Provided by MSN MoneyCentral Investor as sheet 2.
- Emelynes
Secret Emporium (Formula
View) with Emelyne's
Secret Emporium Bar Chart as sheet 2.
- Revised
Emelynes Secret Emporium (Bar
Chart)
| |
|
|
|
|
