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: -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-3: -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-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: -On the active worksheet, select the cell or range in which you want to edit existing or enter new data. In the active cell, type new data or edit the existing data, and then press Enter or Tab to move the selection to the next cell. The changes are applied to all the worksheets that you selected.