Plz answer ! 60 pts

healthy guidelines recommend limiting all sources of fat to 20 to 35 percent of your daily calories. fat has 9 calories per gram. based on a 2,000-calorie-a-day diet, this amounts to about 400 to 700 calories from fat per day. per meal (at three meals per day), calories from fat should be less than 233.

create an excel spreadsheet, create a 2-d column chart to compare the total calories and fat calories in each item of your meal:

select the data in columns a, c, and d and rows 1-6 (hint: hide column b before selecting the data).

title your chart as fat calories and non-fat calories in meal.

title your vertical axis as calories.

move the chart to the right, so your cell data is visible.

based on your chart, which food is highest in fat calories?

if your meal has fewer than 133 calories from fat, highlight c6 in yellow. if it has between 133 and 233 calories from fat, highlight c6 in green. if it has more than 233, highlight c6 in red.

in cell c7, insert an if function to determine whether your meal has an appropriate amount of calories from fat. (hint: use =if(c6< 233,"healthy","unhealthy") as your logic test). if the value is good, make the cell read "healthy." if the value is not within the range, make the cell read "unhealthy."