FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Show Formulas option on the Excel ribbon In your Excel worksheet, go to the Formulas tab > Formula Auditing group and click the Show Formulas button. Microsoft Excel displays formulas in cells instead of their results right away. To get the calculated values back, click the Show Formulas button again to toggle it off.

Detailed explanation-2: -The formulas bar, sometimes called fx bar, displays text or number data in active or current cells, formulas in an active cell or range of cells in place of a selected data series in an Excel chart.

Detailed explanation-3: -Formula bar displays the content of the active cell in Excel. An active cell refers to a cell in Excel spreadsheet that is currently selected by clicking mouse pointer or keyboard keys. Remember only one cell can be an active cell at a time. An active cell is bounded by a heavy border around it.

Detailed explanation-4: -The formula bar in Excel is located next to the name box and above the worksheet area. It displays the data stored in the active cell. The formula bar is used to view, enter, and edit values and formulas in cells. A spreadsheet formula is a mathematical equation that will calculate a result.