USING MICROSOFT EXCEL
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: -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-4: -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-5: -1. If we want to fill in the numbers 1 through 10 in column A, we need to select cell A2 and move the cursor to the lower right corner of cell A2. At this point, the cursor will change into a tiny solid black cross.