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.
You will create three charts for this project. Click here for sample charts and directions.
|Web Weavers Education Page Copyright ©2000. Karen Work Richardson.|