Fast+Food+Fun+Spreadsheet+Sample

= 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.