Excel File Edit View Insert Format Tools Data Window Help Acoto T1P1 Insert Page
ID: 3726252 • Letter: E
Question
Excel File Edit View Insert Format Tools Data Window Help Acoto T1P1 Insert Page Layout Formulas Data eview View Wrap Tex Merge & Career. $ . % , 400400 Conditional F , Formatting as ice Update To keep up-to-date with security updates, ixes, and improvements, choose Check for Updates L M This question has 5 parts Calories Eaten Daily NOTE: If you choose foods you would actually eat you will get meaningful results from these calculations SERVING NUM SERVINGS CALORIES Fod TOTAL CALORIES EATEN EATEN e Group 2. IN COLF starting in FR,ENTER THE NUMBER OF SERVINGS OF EACH FOOD YOU WOULD EAT tN A TYPICAL DAY t include ALL 3 MEALS PLUS SNACKS, you don't eat the food, eg Almonds, 3, Put a formula in G8 that will calculate calories eaten by multiphying NUM CAL by RVINGS PER DAY eaten. NOTE: Write the formula so that If a food has not been chosen [nothing is entered in col F for that foodthe cell in Col G MUST show a blank [not a zero). Copy the formula from G8 to the range G9:G59. EVERY cell in G8:G59 MUST have a formula 4.In H8, write a formula to display the TOTAL calories eaten for the GROUP listed in col D H timn the same group letter appears i.. row of colu n, the formula in column H of that ow would display the total for that group. For exampleonce you copy your formula from HS to 9: HS9 the cells la,H19,H20 etc would all be displaying the same number that is, TOTAL calories for Grains 5. From what Food Group did you eat the most calories? Find the largest number Of calories eaten for any food Group [ con what food is on that row? CANTAL nor Quest i Intro 2 aust " QUEST"Quest + 5 7 G HExplanation / Answer
1. The total calories eaten can be calculated as: =SUM(G8:G59).
3. =IF((F8*E8)=0," ",(F8*E8)) will print the desired results. It can be copied till G59, so that each row in G can show a formula and can display blank instead of 0.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.