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 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-3: -When a formula is entered into a cell, it also appears in the Formula bar. To see a formula, select a cell, and it will appear in the formula bar.

Detailed explanation-4: -The Excel Workbook Window. Menu Bar. The Menu Bar at the top of the screen gives you access to different commands that are used for such tasks as opening and closing files, printing documents, formatting data, and other operations.

Detailed explanation-5: -Excel showing formula instead of result could be an output of enabling Show Formulas feature. Chances are you didn’t enable it intentionally and you are facing it accidentally. If it is so, you will not get a display of results rather you will see Excel formulas only.