Microsoft Office

# Formulas tab in Excel

Formulas-tab-in-excel : A formula is entered into a cell. It performs a calculation of some type and returns a result, which is displayed in the cell. Formulas in Excel always begin with an equal sign (=). Click the Formulas tab in Excel and you will find the button needed to make a formula entry in Excel workbook.

There are four groups appear on the Formula tab :

1. Function Library
2. Defined Names
3. Formula Auditing
4. Calculation

#### Function Library

As per the name this contains the bizarre of functions to be used in the worksheet like Logical functions, Text functions, Date & Time functions etc.

##### Insert Function (Shift+F3)

Use the Insert Function to make a job much easier. The Insert function guides you through the process and explains each function as well as each argument within a function. It works with the formula in the current cell.

##### Auto Sum

Auto Sum is used to total a range of numeric cells. Your total will appear after the selected cells.

##### Recently Used

Recently used option shows the recently used functions. By using this option, you can quickly choose from functions you recently used.

##### Financial

Financial functions perform common business calculations. By this option you can add financial function  to your worksheet.

##### Logical

Logical functions are used when we want to check whether a given condition is true or false. By this option, you can add different types of logical functions to your worksheet.

##### Text

With text functions you can use text string in formulas. You can also change the case of the string, find out the length of a text string or you can join two strings etc. By this option, you can add text functions to your worksheet.

##### Date & Time

With date and time functions you can analyse and work or calculate with date and time values in formulas.

##### Lookup&Reference

By using this option, you can add lookup and reference functions to your worksheet.

##### Maths & Trigonometry

Excel include many math and trigonometry functions. Mathematical functions are used to perform wide variety of simple or complex calculations, such as totally the value for a range of cells, rounding of a number etc. By this option you can add a math and trigonometry function to your worksheet.

##### More Functions

In this option, you can browse more functions from categories like statical, engineering, web or OLAP cube functions.

#### Defined Names

This group of commands is used to take use of Name Manager which that are used in the functions and formulas in the worksheet.

##### Name Manager (Ctrl+F3)

By using this option, you can create, edit, delete, and find all the names used in the workbook. Names can be useful in formulas as substitutes for cell references.

##### Define Name

By using this option, we can define and apply names.

##### Use in Formula

By using this option, you can choose a name used in your workbook and insert it into the current formula.

##### Create from Selection (Ctrl+Shift+F3)

This option automatically generates name from the selected cells.

#### Formula Auditing

This group contains the commands related to formula auditing like showing, checking and evaluating the formulas etc.

##### Trace Precedents

This option shows arrows that indicate which cells affect the value of the currently selected cells.

##### Trace Dependents

This option shows arrows that indicate which cells are affected by the value of the currently selected cells.

##### Remove Arrows

By this option, you can remove the arrows drawn by Trace Precedents or Trace Dependents.

##### Show Formulas (Ctrl+`)

This option displays the formula in each cell instead of the resulting value.

##### Error Checking

By using this option, you can check for common error that occurs when using formulas.

##### Evaluate Formula

This option debug a complex formula evaluating each part of the formula individually. Stepping through the formula part by part can help you verify it’s calculating correctly.

##### Watch Window

Add cells to the Watch Window list to keep an eye on their values as you update other parts of the sheet.

The watch Window stays on top so you can watch these cells even you are working on other sheets.

#### Calculation

This contains the commands who take part in the calculation in the worksheet and provide the calculate options.

##### Calculation Options

By this option, you can choose to calculate formulas automatically or manually.

If you make a change that affects a value, Excel will automatically recalculate it.

##### Calculate Now (F9)

By this option, you can calculate the entire workbook now.

##### Calculate Sheet (Shift+F9)

By using this option, you can calculate the active sheet now. 