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.

Question

Computers & Technology

Branson Donaldson

21 April, 10:37

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.

+3

Answers (1)

Know the Answer?

Ace Strickland · Answer 1

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.