DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Cell pointer
|
|
Column marker
|
|
Fill handle
|
|
Formula bar
|
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: -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.
Detailed explanation-4: -To use the fill handle: Instead, you can use the fill handle to quickly copy and paste content to adjacent cells in the same row or column. Select the cell(s) containing the content you want to use. The fill handle will appear as a small square in the bottom-right corner of the selected cell(s).
Detailed explanation-5: -In Excel there is a green, flashy marker marking cells that are copied.