Page 125 - Excle-En-V3

Figure 181: All the worksheets that have been added

Then click OK, and the following figure will appear after the addition has been
automatically done:

Figure 182: The result of applying the Consolidate tool to more than three worksheets

23 - Formula Auditing

It can be difficult to verify the accuracy of formulas or find the source of an error
if the formula uses precedent or dependent cells:

Precedent cells: These are cells referenced by a formula in another cell. For
example, if cell D10 contains the formula =B5, then cell B5 is a precedent cell for cell
D10.

117 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024