DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
shows the name of the workbook currently working on
|
|
|
shows the name of the worksheet currently working on
|
|
|
shows the name of cell or range currently working on
|
|
|
None of the above
|
Detailed explanation-1: -In Microsoft Excel, the Name Box displays the cell that is currently selected in the spreadsheet. It is located to the left of the formula bar. If a name is defined for a cell that is selected, the Name Box displays the name of the cell. You can use the Name Box to define a name for a selected cell, as well.
Detailed explanation-2: -The name box is the box at left end of the formula bar that identifies the selected cell, chart item, or drawing object. 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: -A Name Box is a tool that shows the active cell address. For example, if you have selected cell C1, this Name Box will show the active cell address as C1.
Detailed explanation-4: -Excel Formula Bar is a thin bar below the ribbon that displays the selected cell’s content and displays the cell address of the selected cell on the left side. You can also enter a value into the cell from the formula bar.
Detailed explanation-5: -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.