Page 251 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

Immediately, all the cells with formulas will represent the formulas inside the cells.

Error Checking (Includes Error Checking, Trace Error, Circular References)
Sometimes while applying formulas, you will get errors like
#DIV/0!, #VALUE!, #NAME? Errors. To check why it’s happening you can visit Error Checking option from the
Formula tab.

• Select a cell (E5), and hit the Error Checking option from the Formulas tab.
• Now, you can click the Help on this Error option to check in detail about the error.

238

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77