Microsoft-Excel 2007 Study Material Day-twenty four

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.