Excel Activity 03

Post date: Sep 23, 2016 1:01:09 PM

I will be able to:

• • Plan multiple meals

  • Research nutritional information on various foods.

  • Construct a table to best display your data

  • Set up the table to interpret and display your data.

Fast Food Fun

This project you will investigate the nutritional value of your favorite fast foods. You will then put this information into an Excel spreadsheet and then evaluate your food choices.First, you need to decide which fast food restaurant you will visit. Then plan three meals with a sandwich, salad or another main dish, a side dish (French fries, fruit, etc.), a drink, and a dessert. Your three meals are Breakfast, Lunch, and Dinner.You can also evaluate one or more of their combo meals. In a Google search type the name of the restaurant and nutrition. Put this information on your fast food worksheet. Many companies are required to publish the nutritional facts about their food online, on the packaging, and even on the menu. For each item on your menu, record the total calories and the calories from fat as well as the sodium, carbohydrates, and sugar. When you have all of your information on your worksheet open up an Excel spreadsheet. 1. In cell B1 write calories. In cell C1 write calories from fat, D 1 –sodium, E1 – carbs, F1 – sugar.

2. In cell A 2 write your first food choice. In cell A3 write your next food choice. Continue down column A listing all of your foods. Add to your listing the location your food came from.

5. Click on the cell below your last calorie entry. Go to formula –autosum—then press enter to see how many total calories are in the total meals. Do the same with the other columns.

6. Insert a header and put Activity 3 Your name.

7. Create a column chart that will show the calories and calories from fat from your food choices. Be sure to highlight only the foods, calories, and calories from fat before you insert the chart.