USING MICROSOFT EXCEL
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: -The Formula Bar is the area at the top of the Excel window, just below the ribbon area or the Formatting toolbar, depending on your version of Excel. The Formula Bar has two parts: at the left is the Name Box, and to the right is the contents of the currently selected cell.
Detailed explanation-4: -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-5: -The correct answer is the Formula bar. The formula bar displays the content of the active cell in MS Excel. The formula bar can be used to edit the content of any cell and can be expanded to show multiple lines for the same formula.