FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
the small green square in the lower right corner of the active cell
A
border
B
fill handle
C
edge
D
None of the above
Explanation: 

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: -The shortcut is called the fill handle, and it’s a little green square that appears in the bottom-right corner of a selected cell or range of cells. To use the fill handle, simply select the cell or range of cells that contains the formula that you want to copy.

Detailed explanation-3: -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-4: -To use the fill handle, move your mouse pointer to the right bottom corner of the cell; it will change into a tiny + (cross) sign. Drag the cross sign, and if Excel recognizes the pattern, it will autofill the cells with the updated data.

Detailed explanation-5: -The mark is used to resize the table comprising the data, though resizing automatically occurs when data are added to a cell immediately below or to the right of the table. Before making changes to eliminate the mark, you might want to consider any advantages a table offers.

There is 1 question to complete.