Susan Fuschetto
CIS 101 Intro. to Computer Information Systems
Excel Project 2 - Formulas, Functions, Formatting, and Web Queries
This lab assignment is from the Excel 2007,
Complete Concepts and Techniques lab book.
- Read and do the Formulas, Functions,
Formatting, and Web Queries tutorial, pages
EX 81 - 141. Skip pages 142 - 143, E-mailing a Workbook from
within Excel. Make sure you do the Save and Quit Excel steps
on the bottom of page 143.
-
Type
the following in empty cells below the chart, say cells A18 - A20:
- CIS 101 Excel Project
2
- Class Meeting Day and Time
(example: Friday 9:00 AM)
- Your name
- Printouts 1 - 2: Check your work. When you are done
with the tutorial your printouts should look like the following figures:
- 2-71 on page
EX 134
- 2-74 on page EX 136
- Printout 3: print the Portfolio
Summary worksheet which contains the Web Query. The printout
should look similar, but not exactly like figure 2-1 (b) on page EX
83. Please keep in mind that the stock quote data is updated
about every 20 minutes during the business day when the New York Stock
Exchange is open. The figure in your book was taken a long
time ago and your data will be different. That's OK.
Please remember to print preview this worksheet and change the
settings to landscape and scaling as "fit to 1 page" in order to
conserve paper. Hint: Office button, Print, Print
Preview, Page
Setup.
- Save your file one last time.
- Submit your homework for grading:
Traditional students: Turn
in the three printouts listed above.
Staple the printouts together with the
formulas page as the last page. I will take points off if the
homework is not stapled.
Online students: Upload
the Silver Dollars Stock Club Portfolio Summary workbook file to the
Excel Project 2 assignment in TalonNet.
Be sure to submit/turn in the lab assignment by the
due date.
Last update:
11/06/09 |
