Question

On the Shopping List sheet, check all the formulas. Cells to check are filled with the light purple color. Most of them need to be corrected. Many of the problems on this worksheet can be solved by creating named ranges or using a name that already exists. a. The formula in cell B2 uses the wrong function. b. The formulas in cells A9:A23 reference a named range that doesn't exist. There is more than one correct way to fix this problem using the cell range A2:H15 on the Places to Shop worksheet. You can create the named range referenced in the formulas, or you can change the function arguments to reference the cell range instead. c. The formula in cell H9 results in the correct value. However, the workbook author copied this formula to the remaining cells in the column and those values are definitely not correct! Fix the formula in cell H9 and copy it to cells H10:H23. Hint: Notice that cell H8 is named Tax.

Answer 1

To fix the formulas on the Shopping List sheet, the student needs to correct the function in cell B2, create a named range or change the function arguments in cells A9:A23, and fix the formula in cell H9 and copy it to cells H10:H23.

Step-by-step explanation:

a. To correct the formula in cell B2, the student needs to use the correct function. They should check the nearby cells or the formula bar for the correct function and replace it in cell B2.

b. To fix the formulas in cells A9:A23 that reference a non-existent named range, the student has two options. They can create the named range using the cell range A2:H15 on the Places to Shop worksheet, or they can change the function arguments in the formulas to reference the cell range instead.

c. The formula in cell H9 results in the correct value. To fix the copied formulas in cells H10:H23, the student should copy the corrected formula from H9 and paste it into cells H10:H23.