FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -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. A spreadsheet formula is a mathematical equation that will calculate a result.

Detailed explanation-2: -Click the cell that contains the data that you want to edit, and then click anywhere in the formula bar. This starts Edit mode and positions the cursor in the formula bar at the location that you clicked. Click the cell that contains the data that you want to edit, and then press F2.

Detailed explanation-3: -Active Cell: The active cell is the cell in the spreadsheet that is currently selected for data entry. You can change which cell is the active cell by clicking the left mouse button once or using the arrow keys on the keyboard.

Detailed explanation-4: -The formula bar displays information entered in the current or active cell. The contents of a cell can also be edited in the formula bar. The formula bar gets activated as soon as you type an equal sign in any cell or click anywhere within the bar.

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