The Excel Formula Bar
The formula bar displays the contents of the active cell as it is, or was entered. The formula bar can be used to edit a cells content easily.
When entering data into a cell in Excel your entry can be confirmed using either the Enter key or the green tick on the formula bar. To cancel an entry, for example a mistake in a formula, press the Esc key or the red X on the Formula bar.
The Formula bar also contains the Insert Function button used to guide the user through the creation of mathematical formulae.
The name box display different information depending on the current operation. It usually identifies the active cell in a spreadsheet. It can also be used to navigate the spreadsheet by entering a cell reference into the name box and pressing Enter.