FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Name Box: The name box appears to the left of the formula bar and displays the name of the current cell. Unless you define a cell or range of cells with a specific name, the name box will display the cell reference of the active cell.

Detailed explanation-2: -The Name Box displays the cell reference of the active cell. The Name Box can also be used to assign names to cells or ranges of cells.

Detailed explanation-3: -What is Name Box in Excel? The Name Box in Excel is located on the left side of the Excel window. It is used to give a name to a table or any cell. For any normal cells, by default, the name is the row character and the column number, such as cell A1.

Detailed explanation-4: -A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.

Detailed explanation-5: -To link a text box to a cell, have the text box selected, click in the Formula Bar and press = and then click the cell to link to and press Enter – see Figure 02.