Assigned: 03/31/06
Due: 04/05/06 at the start of class (time will only be available in class on 3/31)
Remember: late penalties are heavy
Assignment:
Imagine that you have been asked to create the spreadsheet shown on the attached page. Note that formulas are required in all cells except for the basic info that cannot be calculated. Print the Spreadsheet. Also, answer the question below by doing simple “what-if” analysis (answers can be handwritten on the print out of your spreadsheet or on the assignment sheet).
Turn In:
1) Print Out of Spreadsheet
2) Disk
3) Answer to Question below
Details:
1) The spreadsheet should be formatted as shown, including title, headings, totals, etc. The title should be centered across the first nine columns (using Merge and Center), and be 18 point, Bold. Grams and Calories should be bold and underlined (and merged and centered over the appropriate columns). Other headings are regular text. Border lines should be included as shown.
2) Type your actual name where the example says “Your Name”.
3) Grams of protein, fat and carbohydrates need to be typed in as numbers. Formatting should be used to control the number of digits after the decimal point.
4) The total grams must be calculated using formulas. Formatting should be used to control the number of digits after the decimal point.
5) Calories for protein, fat, and carbohydrates must be calculated – a gram of protein is four calories, a gram of fat is nine calories, and a gram of carbohydrates is four calories. Formatting should be used to control the number of digits after the decimal point.
6) The total calories must be calculated using formulas. Formatting should be used to control the number of digits after the decimal point.
7) Calories per gram and percent of calories from fat must be calculated using formulas. Formatting should be used to control the number of digits after the decimal point, and to show the percent as a percent.
8) Max, Median, Mean, and Min must be calculated using formulas. Format as shown.
9) Make sure that the whole spreadsheet prints on one page. Adjust under Page Setup if necessary
Questions:
1) If a different kind of milk were included with 2.0 grams of fat instead of 4, what all would change in the spreadsheet? (exactly which cells will change & what are the new values?)
(You do not have to save or print the spreadsheet with the new values)