Office Update To keep up-to-date with security updates,fixes, and improvements,

Question

Office Update To keep up-to-date with security updates,fixes, and improvements, choose Check for Updaes 13 A III his question has 5 parts Calories Eaten Daily NOTE: If you choose foods you would actually eat you will get meaningful results FITA FORLULA THAT CALCLATES THE FoOD SERVING UM SERVINGS CALORIESFod TOTAL CALORIES EATEN tarting in 8, ENTER THE OF SERVINGS YOU WOULD EAT NACKS.1Fyou dont eat the food, e Almonds ·Put·formuliathat weaklate calories ealen by mulepying NUM CAL by chesen [nothing is entered in col F for that food) the cell in Cal G MUST show a blank at NOTE not amo]. Copy the formula mom G8 te the range ChGSSEVERY cel' in G8G59MST in H8, writ.forwula to asplay the TOTAL calories eaten for the isted in col snom what Faed Group did you eat e calories?

Explanation / Answer

1. The total calories eaten can be calculated as the summation of all values in the G coloumn. The formula is: =SUM(G3:Gn), where Gn refers to the last row, i.e., nth row of G coloumn.

3. The formula for this problem will be: =F8*G8. Now to display blank instead of zero, you should have to do this following trick. Go to the cell with 0. right click on it. select the Format Cells. In the Format Cells dialog box, click Custom from the Category list box under the Number tab, and then enter General;General;;@ into the Type text box. Then type Ok.

Another method is to type the following function =IF((F8*G8)=0," ",(F8*G8)) in G8, then copy the formula till G9. In this method you will have a formula for every row in G.

4.

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.