USING MICROSOFT EXCEL
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Fill Handle
|
|
|
Fill Select
|
|
|
Fill Copy
|
|
|
None of the above
|
Detailed explanation-1: -Fill handle is a feature to extend (and fill) a series of numbers, dates, or even text to a desired number of cells in Excel. In the active cell of the spreadsheet, the fill handle is a small black box at the bottom right corner, as shown in the image.
Detailed explanation-2: -Whenever you need to get a series of values in the adjacent cells, just click on the Excel fill handle to see a small black cross and drag it vertically or horizontally. As you release the mouse button, you will see the selected cells filled with the values depending on the pattern you specify.
Detailed explanation-3: -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. When you hover over the fill handle box, the mouse pointer will change to a black plus sign.
Detailed explanation-4: -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.