Name Box 
displays the current
active cell
which is where you cursor is currently located. You can type in a new
cell address,
and press the Enter key, and Excel will immediately move you to that location.
Formula bar 
displays the constant value (a number or text), or formula in the active cell.