A formula in cell Z10 references values found in cells A1,B1,and C1.The cursor is situated in cell C1.Clicking Excel's Trace Dependents button creates red arrows pointing from cell ____.
A) A1
B) B1
C) C1
D) Z10

Question

Quizplus · Accepted Answer

DTrace Dependents shows which cells depend on the currently selected cell. Since the cursor is in C1, it will show arrows from C1 to any cells that depend on it, which includes Z10. A1 and B1 are not directly affected by the action because the cursor is not in those cells.

A Formula in Cell Z10 References Values Found in Cells