Short Answer 1 Grandma\'s Best Chocolate Cakespreadsheet, the formula 83 84 85-8

Question

Short Answer 1 Grandma's Best Chocolate Cakespreadsheet, the formula 83 84 85-86 87 has been 11. (1 point) In Grandma's Best chocolate cake entered into cell 88. Please explain (briefly) the most logical reason why the addition appears to be incorrect 7 Milk 12. (1 point) The formula -B2.$C$2.D$9 $D10 is in cell F10 of your Excel worksheet. What formula would result if you copied this formula from cell F10 into cell Hll on your worksheet? 13. (1 point) What value would result if you copy this formula from cell F10 into cell A1 of your spreadsheet. 2 Item Price Quantity Quantity Quantity Quantity Total Value Total Value Total Value Total Value 556 1,044 19.314 4,690 161,304S 116,820 3 234S 29 S 29 455 4 454 $2,345 S 156.464 S 185,284 3445 S 44 14. (2 points) The worksheet above lists orders for June by item number including the price for the item and weekly order quantities. Write an Excel f alculate the total value of item 234 for sales in week 1 (price quantity). Write ormula in cell 63 to ied down the column to determine the total value for each mula such that it can be cop for corresponding item for item for each corresponding week week 1 and across the row to determine the total value for the

Explanation / Answer

11) In excel we cannot add cell values using simple +(math addition operator) because excel has its own inbuilt function to perform addition, ie =SUM(B3:B7), this will generate the correct result as 6, and not via + operator which we generally use for addition.

12) The formula will be when copied from cell F10 into cell H11 is:- D3+$C$2+F$9+$D11

13) The formula will be:- #REF!+$C$2+#REF!+$D1

Please let me know in case of any clarifications required. Thanks!

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

---

---

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