DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Name Box
|
|
|
Formula Bar
|
|
|
Active Cell
|
|
|
Groups
|
Detailed explanation-1: -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-2: -The correct answer is the Formula bar. The formula bar displays the content of the active cell in MS Excel.
Detailed explanation-3: -Each cell is identified on a worksheet by its reference, the column letter and row number that intersect at the cell’s location. This cell is in column D and row 5, so it is cell D5. The column always comes first in a cell reference.
Detailed explanation-4: -In Excel, the Name Box refers to an input box directly to the left of the formula bar. The Name Box normally displays the address of the “active cell” on the worksheet. You can also use the name box to quickly create a named range. Another use for the Name Box is to navigate quickly to any range in a worksheet.
Detailed explanation-5: -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.