what is name box in MS Excel?Explain with example.(2 Marks)
Answers
Explanation:
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. ... If you type Z100 into the Name Box, the active cell will move to that address.
Answer: The Name box usually shows the address of the "active cell" on the sheet.
Explanation:
In Excel, the title field refers to the input field immediately to the left of the formula bar.
Another use of the Name Box is to quickly navigate to any range in the sheet. If you enter Z100 in the Name Box, the active cell will move to that address. If you enter A1:A10 in the Name field, that range will be selected.
In Microsoft Excel, the name field displays the cell that is currently selected in the table. If a name is defined for the selected cell, the name of the cell is displayed in the Name field. You can also use the Name field to define a name for the selected cell.
The Name field in Excel is located on the left side of the Excel window. Used to name a table or any cell. For all normal cells, the name defaults to the row character and column number, for example, cell A1. However, we can check it by clicking on the cell. It will appear as A1 in the Name field, but we can type in any cell name, press "Enter" and refer to the cell with the name we put in the Name field.
#SPJ6