Susan Fuschetto
CIS 101 Intro. to Computer Information Systems
Excel Project 3 -
What-If Analysis, Charting, and Working with Large
Worksheets
This lab assignment is from the Excel 2007,
Complete Concepts and Techniques lab book.
- Read and do the
What-If Analysis, Charting, and Working with Large
Worksheets tutorial, pages
EX 161 - 228.
-
Type the following in empty cells below
the chart, say cells E18 - E20:
- CIS 101 Excel Project
3
- 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:
- 3-72 (a) on page
EX 219
- 3-72 (b) on page EX 219
- Printout 3: You will need to
print out a copy of your formulas. Please use the steps on
pages EX 135 - 137,
Displaying and Printing the Formulas Version of the Worksheet.
- 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 Campus Clothier Semiannual Financial Projection workbook file to the
Excel Project 3 assignment in TalonNet.
Be sure to submit/turn in the lab assignment by the
due date.
Last update:
08/02/07 |
