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 Fill Handle is the small green square located in the bottom right corner of your selection-be it one cell or a larger group of cells. Double-clicking the Fill Handle causes the selected text, formula, or data to be copied downward, with different behaviors resulting depending on the contents of the cell.
Detailed explanation-3: -Colored triangles that you might see in your worksheet The two colored triangles that can appear in a cell are green (formula error), and red (comment).
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: -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.