FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -What is a formula bar in Excel? Excel formula bar is a special toolbar at the top of the Excel worksheet window, labeled with function symbol (fx). You can use it to enter a new formula or copy an existing one.

Detailed explanation-2: -The Formula Bar displays the contents of the active cell. The contents of the active cell appear in the Formula Bar, and the active cell address is displayed in the Name box at the left end of the Formula Bar.

Detailed explanation-3: -The formula bar is a toolbar that appears at the top of our worksheet, below the Ribbon in our workbook. 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-4: -If you can not see the formula bar when you open Excel, it must be hidden and you need to change the setting to show it. Below are the steps to show the formula bar: Click the View tab. In the Show group, check the Formula bar option.

Detailed explanation-5: -The formula bar shows the formula. That’s what it’s there for. You can edit the formula, select the whole contents of the formula bar and then hit F9. That will evaluate the formula in the formula bar and you will see the result of the formula there.