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: -The box located to the left side of the formula bar which addresses the selected cell or group of cells in the spreadsheet is called Name box.

Detailed explanation-4: -On the worksheet, click the shape or text box to which you want to link the cell contents. In the formula bar, type an equal sign (=). Click the worksheet cell that contains the data or text that you want to link to. Tip: You can also type the reference to the worksheet cell.

Detailed explanation-5: -You can use named cells or cell references to specify filter criteria and other field values in a query definition form. For example, if a worksheet cell contains an account code, you can insert a reference to that cell in a query definition instead of specifying the account code itself.