0
Dependents are the cells that are used by formulas in other cells. Say you have the following formula in a cell B3:
=A2+C12-D10
Then the cells A2, C12 and D10 are the dependents of the formula in B3. The formula is using values that are in them. If you go to any of those cells, you use can use Trace Dependents to find the cells that depend on them 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 else can I help you with?
How to know in excel 2007 if the content in a cell has been used for formula some where else?
You go to Formula Auditing and use Trace Dependents. You can also select the cell and press the Ctrl and ] keys.
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 is Dependent in Excel?
A dependent is a cell that a formula depends on. The cells mentioned in a formula are its dependents.
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 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.
When was Co-Dependents Anonymous created?
Co-Dependents Anonymous was created in 1986.
On this year's income tax can you file dependents?
You can always file dependents on your income tax return, as long as you have dependents living in your home that you are responsible for supporting financially.
How do you spell plural of possessive form of dependants?
The possessive form of the plural noun dependents is dependents'.
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.
Which resource contains policy information as dependents?
The resource that contains policy information as dependents is likely to be an insurance policy, which typically outlines the coverage and details of dependents who are included in the policy. This information may include details such as the names, ages, and relationships of the dependents covered by the policy.
Is Texas state continuation available for aged out dependents?
Is Texas state continuation available for aged out dependents
