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 :
- Function Library
- Defined Names
- Formula Auditing
- 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.
About more information Click here
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.
