0
What are the differences between trace precedents in Excel 2003 and Excel 2007?
Wiki User
∙ 14y ago
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.
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
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.
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 is trace precedents in Excel?
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.
What is the differences between a macromineral and a trace element?
the differences between a macromineral and a trace element is that their is no difference they both has something to do with the health
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 differences between meteors and comets?
comet is mainly ice, and so it leaves a trace as it gets close to the sun. meteors is not made of ice, but made of metal, solids, rocks, anything that doesn't melt easily and so it does not leave a trace or particles behind.
What is the Trace Error button in Excel?
Trace Error shows you the cells that are referenced by a formula that has an error. With a cell with an error highlighted, clicking on the Trace Error button will show arrows indicating links between cells which can help you trace the error. You can then check what cells are referenced and see can you find which one may be causing your error.
What are the main difference between mitochondrial and chloroplast DNA's?
The ribosomes of chloroplasts closely resemble bacterial ribosomes, while mitochondrial ribosomes show both similarities and differences that make their origin more difficult to trace.
What is the difference between a skiff of snow and a trace of snow?
They are the same
What is the difference between a trace fossil and mold fossil?
A trace fossil was an imprint left behind by an animal that hardens and turns to stone
What are the ratings and certificates for Without a Trace - 2002 Between the Cracks 1-4?
Without a Trace - 2002 Between the Cracks 1-4 is rated/received certificates of: Netherlands:6
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.
