207k views
4 votes
You can double-click a cell with a formula, and Excel will use Formula Seek to highlight the cells that provide data for the formula.

a) True
b) False

User Young Emil
by
8.5k points

1 Answer

2 votes

Final answer:

Double-clicking a cell with a formula in Excel enters the edit mode instead of showing relationships via 'Formula Seek', which is not an Excel feature. To see the source cells, one must use the 'Trace Precedents' feature.

Step-by-step explanation:

The statement is false. Double-clicking a cell with a formula does not utilize a function called 'Formula Seek'. Instead, Excel provides a feature known as Trace Precedents which can be used to highlight cells that feed information into a formula. When you double-click a cell that contains a formula in Excel, you will enter the edit mode, which allows you to see and modify the formula. To visually identify the cells that provide data to a selected formula, you have to use the 'Trace Precedents' button in the 'Formulas' tab on the Ribbon. This feature draws arrows to the cells that are directly referenced by the formula, making it easier to track the relationships between cells.

User LostInTheTrees
by
8.7k points