**Formulas Tab :**

**Defined Names Group :**

By using names, you can make your formulas much easier to understand and maintain. You can define a name for a cell range, function, constant, or table. Once you adopt the practice of using names in your workbook, you can easily update, audit, and manage these names.

**Steps :**

- Type the Text
- Select the Cell
- Click on Formula Tab
- Then click on Define name
- Give the name to that data

**Formula Auditing Group :**

Formula auditing in Excel allows you to display the relationship between formulas and cells.

**Trace Precedents**: Show arrow that indicate what cells affect the value of the currently selected cell.

**Trace Dependent :**Show arrows that indicate what cell are affected by the value of the currently selected cell.

**Remove Arrows :**Remove the arrows drawn by trace Precedents or Trace Dependents.

**Show Formulas :**Display the formula in each cell instead of resulting value.

**Evaluate Formula :**Launch the Evaluate Formula dialog box to debug a formula by evaluating each part of the formula individually.

Follow @Sarvavasi.com