Question

The trace dependence in auditing
shows
ऑडिटिंग में ट्रेस डिपेंडेंस प्रदर्शित करता है
Select one:
a. Which cells are used in current
formula
वर्तमान फ़ॉर्मूले में किन सेल्स का उपयोग किया
गया है
b. In which formula the current cell
is used
वर्तमान सेल का उपयोग किस फ़ॉर्मूले में किया
गया है
C. None
कोई भी नहीं
d. Which cells are used in this
formula and in which formula this
cell is used
वर्तमान फ़ॉर्मूले में किन सेल्स का उपयोग किया
गया है और वर्तमान सेल का उपयोग किस
फ़ॉर्मूले में किया गया है​

Answer 1

Answer:

Trace Dependents is an Excel auditing tool that shows the cells that are affected by an active cell by displaying arrows linking the related cells to the active cell. ... Go to Formulas tab > Formulas Auditing > Trace Dependents. Click on the Trace Dependents button to see the cells that are affected by the active cell.

Explanation:

Answer 2

Answer:

The trace dependence in auditing shows which cells are used in current

formula.

Thus, the correct option is A.

Explanation:

• Excel has a command called trace dependant.
• It refers to the cells or groups of cells that rely on or are impacted by the selected cell/current cell.
• It is an auditing tool that displays the aforementioned information by displaying arrows and connecting the cells to the active cell.
• Trace Dependents are cells or groups of cells that are influenced by the chosen cell.
• Excel displays blue arrows that connect the cells that are connected to the current cell when you use the formula auditing tool.
• An Excel spreadsheet may have several formulae, and comprehending the link between the cells would be difficult if Excel's Trace Precedents and Trace Dependents tools were not available.

#SPJ2