Selecting Cells by Reference Chọn các ô theo tham chiếu
If a cell contains a formula, Excel defines the cell’s precedents as those cells that the formula refers to. For example, if cell A4 contains the formula = SUM(A1:A3), cells A1, A2, and A3 are the precedents of A4. A direct precedent is a cell referred to explicitly in the formula. In the preceding example, A1, A2, and A3 are direct precedents of A4. An indirect precedent is a cell referred to by a precedent. For example, if cell A1 contains the formula = B3*2, cell B3 is an indirect...