DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Tell me box
|
|
|
Name box
|
|
|
Formula bar
|
|
|
Quick access toolbar
|
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 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-3: -Detailed Solution 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-4: -Defined Names box on the formula bar This is best used for creating a workbook level name for a selected range. Define name from selection You can conveniently create names from existing row and column labels by using a selection of cells in the worksheet.
Detailed explanation-5: -Answer: false is the correct answer.