A formula in cell Z10 references values found in cells A1,B1,and C1.The cursor is situated in cell Z10.Clicking Excel's Trace Precedents button creates blue arrows pointing from cell ____ to all of the other cells mentioned above.
A) A1
B) B1
C) C1
D) Z10

Question

Quizplus · Accepted Answer

The Trace Precedents feature in Excel shows arrows from cells that provide data to the selected cell. Since Z10 is the cell with the formula referencing A1, B1, and C1, the arrows would point from A1, B1, and C1 to Z10, indicating that Z10 is dependent on these cells.

A Formula in Cell Z10 References Values Found in Cells