answersLogoWhite

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.

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

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.


Used to find which cells are refrenced in a formula?

The "Trace Precedents" feature in Excel is used to identify the cells that are referenced in a specific formula. By using this feature, you can visualize the relationship between different cells in a spreadsheet and understand the source of data being used in a particular calculation. This helps in tracking the flow of information and ensuring the accuracy of your calculations.


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.


Can a court depart from precedents?

Yes.


What is another word for antecedents?

precedents


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.