On the Shopping List sheet, check all the formulas. Cells to check are filled with the light
Fantastic news! We've Found the answer you've been seeking!
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.
- The formula in cell B2 uses the wrong function.
- The formulas in cells A9:23 reference a named range that doesn't exist. There is more than one correct way to fix this problem using the cell range A2:15 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
- 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:23. Hint. Notice that cell H8 is named Tax.
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: