FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -The correct answer is the Formula bar. Among the options, the formula bar appears at the top of a worksheet in MS Excel. It is located directly above the spreadsheet. Excel formula bar is a special toolbar at the top of the Excel worksheet window.

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: -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-4: -Enter Data from the Formula Bar And once you are done with the value that you want to enter; you can click on the enter button that is on the left side of the formula bar. There’s also a button to cancel the data entry or you can press the escape key.

Detailed explanation-5: -A formula bar is a bar below the ribbon and above the working area of the worksheet (as seen in the image below). Whenever you select a cell that has a formula, that formula is shown in the formula bar. And many Excel users prefer to type the formulas directly in the formula bar instead of the cell.