DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Destination area
|
|
|
Source area
|
|
|
Relative reference
|
|
|
Fill handle
|
Detailed explanation-1: -Fill Handle: The fill handle is the small bold square in the bottom right corner of a cell that can be used to copy (fill) data to adjacent cells in the same row or column.
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. If a name is defined for a cell that is selected, the Name Box displays the name of the cell.
Detailed explanation-3: -The fill handle is the small black square in the bottom right corner of the selection. To autofill, drag the fill handle up or down. Excel will automatically fill in the cells with the correct information.
Detailed explanation-4: -You can quickly copy formulas into adjacent cells by using the fill handle. When you drag the handle to other cells, Excel will show different results for each cell.
Detailed explanation-5: -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.