DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Cell name box
|
|
|
Dialog box
|
|
|
Formula bar
|
|
|
Worksheet tab
|
Detailed explanation-1: -The correct answer is Name box. Name Box is a box in the input left in the left corner of the ribbon i.e. left to the formula bar. In each box, the name of the active sheet cell is shown and we can also search any cell by inserting the name of the cell in it. It can also be used to create a named range.
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: -Define a name for a cell or cell range on a worksheet Select the cell, range of cells, or nonadjacent selections that you want to name. Click the Name box at the left end of the formula bar.
Detailed explanation-4: -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. The first scenario in Excel is when we are working with Excel by mistake; we would press some other key from the keyboard.