FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Answer. 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. The Insert Function button is always available, but the other two formula-editing buttons appear only while you are entering or editing data in a cell.

Detailed explanation-2: -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.

Detailed explanation-3: -The formula bar contains a text box to enter formulas and a drop-down where you can select functions when building formulas. If you select a member in a grid, member selection is activated on the formula bar. The formula bar is displayed below the toolbar so you can easily access its functionality.

Detailed explanation-4: -Alternatively called a formula box, the formula bar is a section in Microsoft Excel and other spreadsheet applications. It shows the contents of the current cell and lets you create and view formulas. The two pictures below are examples of what the formula bar looks like in Microsoft Excel.

Detailed explanation-5: -Formula Bar: The Formula Bar displays any formula or function set up for the selected cell.