## A22.0004 Computers in Principle and Practice

## Assignment 7

# Excel #1

## Due:

Monday, Dec. 7th, 1998 (sec 1-2)

Tuesday, Dec. 8th, 1998 (sec 3-5)

## Assignment 7

You have gone into business selling your newsletter. For the
first 26 weeks, here are the weekly figures
for the expenses in producing the newsletter and the number of
newsletters that you have sold.

Using Microsoft Excel, make a spreadsheet whose values
look like this. You can change the formatting to your pleasing,
but try to make the spreadsheet look nice. HOWEVER, and this is
the important thing, all of the cells in the Profit column should
have formulas, and not numerical entries. Further, you should
use functions from the function wizard for the Total Profit, Maximum
Profit, and Maximum Loss values.

Print out the spreadsheet twice. First, print out the values.
Then, print out the formulas. This can be done as follows: Under
"Tools," "Options," with the "View"
tab, click on "Formulas" under the "Window Options"
so that when you print out the sheet (using "Print"
under the "File" menu), you print out the Formulas and
not the values.

Finally, publish your spreadsheet on the **World Wide Web**
through your IS account. Call the web page "`assign7.html`"
and put a link to it on your "`index.html`" page.
Use the Excel Internet Wizard to make your page, but make certain
that it includes your name, and other identifying information.

Note that you sold your newsletter at $1 per copy through the
12^{th} week, but then raised the price to $1.25. Also,
note that your profit per week is the number of copies that you
sold, times the price per copy, minus your expenses that week.

If you are clever, you will use copy and paste to transfer
the values from the table to Excel. The values have been separated
by tabs, and so should be easy to paste into an Excel spreadsheet.
(On a Mac, or with certain browsers, you may need to save the file of figures as a text file, and then
use Excel to open the text file---be sure to say "All file
types"---designating tabs as delimiters.)