Sample Spreadsheet

Entering Data and Formulas:

Set up your Excel spreadsheet like the one above.  You will enter the calories in column B and fat calories in column C. 

To figure out non-fat calories, write a formula to subtract the fat calories from the total calories. (HINT: =B2-C2)

To figure out the percentage of calories from fat, divide fat calories by calories. Format the cells in column E for percentage. (HINT: =C2/B2)

To figure out total calories, total fat calories, and total non-fat calories,  you can use the AutoSum button or write a formula.  To figure out the total percentage of fat, divide total calories by total fat calories.

Creating Charts:

You will create three charts for this project.  Click here for sample charts and directions.