In this article, we will learn What is Formula Tab in Microsoft Excel & It's Uses.
We use the Formula tab to insert functions, define names, create name ranges, review formulas. In ribbon, Formulas tab has very important and most useful functions to make dynamic reports.
Formula tab is divided among 5 groups
Function Library
Insert Function - (Shift + F3). Drop-Down. Displays the "Insert Function" dialog box allowing you to search for a particular function or display the list of functions by category.
AutoSum - Button with Drop-Down. The button inserts the Sum formula into the cell calculating the sum of the cells directly above. The drop-down contains the commands: Sum. Average, Count Numbers, Max, Min or More Functions. Exactly the same command can be found on the Home Tab.
Recently Used - Drop-Down. Provides quick access to the 10 functions you recently used.
Financial - Drop-Down. Provides quick access to all the functions in the Financial category.
Logical - Drop-Down. Provides quick access to all the functions in the Logical category.
Text - Drop-Down. Provides quick access to all the functions in the Text category.
Date & Time - Drop-Down. Provides quick access to all the functions in the Date & Time category
Lookup & Reference - Drop-Down. Provides quick access to all the functions in the Lookup & Reference category.
Math & Trig - Drop-Down. Provides quick access to all the functions in the Maths & Trigonometry category.
More Functions - Drop-Down. Displays a drop-down providing access to the Statistical, Engineering, Cube, Information, Compatibility and Web categories.
Defined Names
Name Manager - Displays the Name Manager dialog box.
Define Name - Button with Drop-Down. The button displays the "New Name" dialog box . The drop-down contains the commands: Define Names and Apply Names. The Define Names allows you to create workbook and worksheet level named ranges and displays the "New Name" dialog box. The Apply Names displays the "Apply Names" dialog box.
Use in Formula - Drop-Down. The drop-down contains a list of all the named ranges in the workbook (25 with scrolling) and Paste Names. The Paste Names command displays the "Paste Name" dialog box.
Create from Selection - Displays the "Create Names from selection" dialog box. This enables you to name a selected range of cells using a row or column title that you've entered.
Formula Auditing
Trace Precedents - Displays arrows that indicate what cells affect the value of the currently selected cell.
Trace Dependents - Displays arrows that indicate what cells are affected by the value in the currently selected cell.
Remove Arrows - Button with Drop-Down. The button removes all the arrows drawn by the trace precedents and trace dependents. The drop-down contains the commands: Remove Arrows, Remove Precedent Arrows and Remove Dependent Arrows.
Show Formulas - (Ctrl + '). Toggles the display of the formulas rather than the result.
Error Checking - Button with Drop-Down. The button displays the "Error Checking" dialog box. The drop-down contains the commands: Error Checking, Trace Error and Circular References. The Circular References extension will only be enabled when the active workbook contains at least one circular reference.
Evaluate Formula - Displays the "Evaluate Formula" dialog box. This allows you to step through a formula calculation.
Watch Window - Displays the Watch Window. Allows you to view the contents of cells and their results as you make changes.
Calculation
Calculation Options - Drop-Down. The drop-down lets you quickly change the calculation setting in the active workbook between Manual, Automatic and Automatic except for Data Tables. This setting is in fact an application setting. For more information please refer to the Calculation page.
Calculate Now - (F9). Provides a shortcut to the (Excel Options)(Calculation tab, "Calc Now"). This option no longer appears on the Excel Options dialog box.
Calculate Sheet - (Shift + F9). Provides a shortcut to the (Excel Options)(Calculation tab, "Calc Sheet"). This option no longer appears on the Excel Options dialog box.
Solutions
This group is only displayed if you have the Euro Currency Tools add-in loaded.
Euro Conversion - Launch the Euro Conversion Wizard.
Euro Formatting - Apply Euro formatting to the selected cells.
Quick Conversion - Perform quick conversions.
Hope this article about What is Formula Tab in Microsoft Excel & Its use is explanatory. Find more articles on calculating values and related Excel formulas here. If you liked our blogs, share them with your friends on Facebook. And also you can follow us on Twitter and Facebook. We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write to us at info@exceltip.com.
Useful Articles :
10+ Creative Advanced Excel Charts to Rock Your Dashboard : These creative charts can make you stand apart from the crowd. These charts can be used for different types of reports. Your dashboard will be more expressive than ever.
How to Save and Use an Excel Chart Template : It is important to save chart templates for repetitive charts to save time and energy. To save chart templates in excel follow these steps.
Best Charts in Excel and How To Use Them : These are some of the best charts that Excel provides. You should know how to use these charts and how they are interpreted. The line, column and pie chart are some common and but effective charts that have been used since the inception of the charts in excel. But Excel has more charts to explore.
Excel Sparklines : The Tiny Charts in Cell : These small charts reside in the cells of Excel. They are new to excel and not much explored. There are three types of Excel Sparkline charts in Excel. These 3 have sub categories, let's explore them.
Change Chart Data as Per Selected Cell : To change data as we select different cells we use worksheet events of Excel VBA. We change the data source of the chart as we change the selection or the cell. Here's how you do it.
Popular Articles :
50 Excel Shortcuts to Increase Your Productivity : Get faster at your tasks in Excel. These shortcuts will help you increase your work efficiency in Excel.
How to use the VLOOKUP Function in Excel : This is one of the most used and popular functions of excel that is used to lookup a value from different ranges and sheets.
How to use the IF Function in Excel : The IF statement in Excel checks the condition and returns a specific value if the condition is TRUE or returns another specific value if FALSE.
How to use the SUMIF Function in Excel : This is another dashboard essential function. This helps you sum up values on specific conditions.
How to use the COUNTIF Function in Excel : Count values with conditions using this amazing function. You don't need to filter your data to count specific values. Countif function is essential to prepare your dashboard.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
for the life of me, I CANNOT find the defined names box on the formulas ribbon of excel 365, so I can't change the name of the range. Where is it???????
awesome