USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Flash fill
|
|
fill handle
|
|
formula bar
|
|
keyword
|
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 an Excel worksheet, each small rectangle or box is known as a cell. The active cell is the selected cell in which data is entered when you begin typing.
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: -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-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.