Page 250 - CITS - Computer Software Application -TT
P. 250
COMPUTER SOFTWARE APPLICATION - CITS
• Simply, choose a cell (G22), and then visit the Trace Dependents feature from the Formulas tab.
Finally, you will see the arrows from the cell (G11) to other cells indicating the cells that are dependent on the
value of the selected cell.
Remove Arrows
After inserting arrows using the above features, you can also delete them by utilizing the Remove Arrows option.
• Start with, selecting the cell (C11) and clicking the
Remove Arrows option from the Formulas tab.
• Within a blink of an eye, the arrows will be removed.
It’s that simple.
Show Formulas
Show Formulas in Excel is a helpful tool that allows you to view the actual formulas within cells instead of their
calculated results. This feature offers transparency into complex calculations, aiding in formula debugging and
verification.
• While the worksheet is open, visit the Formulas tab and press the Show Formulas option
237
CITS : IT&ITES - Computer Software Application - Lesson 63 - 77
