DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Formula Bar
|
|
Ribbon
|
|
Quick Access Toolbar
|
|
Name Box
|
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.
Detailed explanation-2: -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.
Detailed explanation-3: -The active cell is the selected cell in which data is entered when you begin typing. Only one cell is active at a time. The active cell is the cell surrounded by a black border. Data can only be entered into the active cell.
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.
Detailed explanation-5: -Excel’s Name box lets you select cells or ranges by entering a reference or range name. The dropdown shows the range names in the workbook file. Enter a cell reference or select a range name from the dropdown to quickly access that area of the workbook.