Printed from "Life in the Tech Lab" site

Fast Food Fun

[ Home ] [ Sample Spreadsheet ][ Rubric ]

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.

 

 

 

 

Web Weavers Education Page Copyright ©2000. Karen Work Richardson. Revised by Phil Biggs 2010

Site Upgrade Underway

So you like this new look? I have begun the work of updating this site to look cleaner, make it easier to read, and work much better on mobile devices. Do you like what you see? I'm open to suggestions; email me with ideas!

As I work on the site, you'll go back to the old style pages. Don't worry, all the links will continue to work just fine! You'll be able to follow my progress! Look for an updated Intro to Spreadsheets site soon!