0
Precedents are the cells that a formula uses. Say you have the following formula in a cell:
=A2+C12-D10
Then the cells A2, C12 and D10 are the precedents of the formula. The formula is using values that are in them. You use Trace Precedents to find those cells and highlight them on the Spreadsheet. If you are having a problem with formulas you can highlight the cells to be able to see which ones are being used. One way of doing it is to select the cell and then press the CTRL key and also the [ key. You can also use the Auditing toolbar to do it.
Wiki User
∙ 14y ago
Wiki User
∙ 8y agoWith the cell(s) selected, pressing Ctrl and the [ key will trace the direct precedents. Press shift too and you will get the precedents of those precedents of all precedents for the selected cell(s).
Add your answer:
Earn +20 pts
What are the differences between trace precedents in Excel 2003 and Excel 2007?
It works basicly the same way in both versions, but the commands are in different locations. The command is on the Formulas ribbon in Excel 2007 and the Tools - Formula Auditing menu in Excel 97-2003. See related links for an animated tutor of how to use trace precedents.
Which function allows the user to work backward from a formula in Excel?
You can use the Formula Auditng which includes the Evaluate facility and Trace Precedents, which would be useful.
What tool do you use to trace the relationship between the formulas in the cells of a worksheet?
You use the auditing tools, which include the trace precedents and trace dependents commands.
What allows you to check both the cells being referenced in a formula and the formulas that reference those cells?
You use a facility called formula auditing. You can then use Trace Precedents to see what cells are referenced by a formula. You use Trace Dependents to see which cells use the active cell. You can also press Ctrl and the [ key to trace precendents and Ctrl and the ] key to trace dependents.
What are the importance of precedents cases?
Precedents cases a case previously decided that serves as a legal guide for the resolution of subsequent cases.
What option button options lists error-checking option of an invalid formula to a cell?
In Excel 2007, on the Formulas ribbon, select the Error Checking option in the Formula Auditing section.
What is another word for antecedents?
precedents
Can a court depart from precedents?
Yes.
Another word for traditions is ........?
Precedents
What precedents were set by george washigton?
i dont no
Courts do not depart from precedents?
Lower courts do not department from precedents, they must follow the rulings of higher courts. Lateral courts have precedent that is not binding and does not have to be followed.
Use what to check which cells are referenced in the formula assigned to the active cell?
Pressing F2 will show the formula and the referenced cells in it will be colour-coded and highlighted. Pressing and holding the Ctrl key and then pressing the [ key will select the cells referenced in the formula.
