In Excel, the Name Box refers to an input box directly to the left of the formula bar. The Name Box normally displays the address of the "active cell" on the worksheet. You can also use the name box to quickly create a named range.
Another use for the Name Box is to navigate quickly to any range in a worksheet. If you type Z100 into the Name Box, the active cell will move to that address. If you type A1:A10 into the Name Box, that range will be selected.
Finally, if you have one or more named ranges in a workbook, the Name Box behaves like a drop down menu. You can select and navigate quickly to any name.