Ask Question

Which scenario would best be resolved using precedent cell tracers? Leon opens an Excel spreadsheet and notices that someone types the wrong formula in cell D12. Leon needs to know which other cells use the contents in D12. Leon opens an Excel spreadsheet and notices a formula in cell D12. He wants to know which other cells in different workbooks use that formula. Leon opens an Excel spreadsheet and notices an error in the formula. The formula is very complex, and Leon cannot find the cells that are identifiers in the formula. Leon opens an Excel spreadsheet and sees a Pivot Table. He notices an error in the formula in one of the cells. The formula is very complex, and Leon cannot find the cells that are identifiers in the formula.

+1
Answers (1)
  1. 2 May, 13:16
    0
    I'd go with (C) Leon opens an Excel spreadsheet and notices an error in the formula. The formula is very complex, and Leon cannot find the cells that are identifiers in the formula.

    A precedent cell is a cell that is referred to by a formula in another cell. You can use tracers or trace precedents to check and locate precedents for a cell that contains a formula. Precedents affect the active cell’s value.
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “Which scenario would best be resolved using precedent cell tracers? Leon opens an Excel spreadsheet and notices that someone types the ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers