Question

On theShopping Listsheet, check all the formulas. Cells to check are filled with the light orange color.Most of them need to be corrected. Many of the problems on this worksheet can be solved by creatingnamed ranges or using a name that already exists.

a.The formula in cellB2uses the wrong function.
b.The formulas in cellsA9:A23reference a named range that doesn’t exist. There is more than onecorrect way to fix this problem using the cell rangeA5:H18on thePlaces to Shopworksheet. Youcan create the named range referenced in the formulas, or you can change the function argumentsto reference the cell range instead.
c.The formula in cellH9results in the correct value. However, the workbook author copied thisformula to the remaining cells in the column and those values are definitely not correct! Fix theformula in cellH9and copy it to cellsH10:H23.Hint: Notice that cellH8is namedTax.

Answer 1

A. low annual cost-volume.

B. high cost per unit.

C. high annual cost-volume.

D. high annual usage.

E. low cost per unit.