USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
The name of the cell is determined by the name of the row and the column intersecting, such as A8
|
|
|
The rectangular shaped area on a worksheet that is created by the intersection of columns and rows
|
|
|
the black symbol in the lower right corner of an active cell. Clicking & dragging it can copy cell contents or duplicate the cell contents
|
|
|
adds the values in a function or set of cells (also, AutoSum)
|
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: -You can quickly copy formulas into adjacent cells by using the fill handle. When you drag the handle to other cells, Excel will show different results for each cell.
Detailed explanation-3: -If you double click the bottom right corner of a cell, Excel will copy the data in that cell down until it hits the last adjacent cell with data in it. So below if you double click on the bottom right corner (2), the formula (1) will copy down to the last cell in column E.
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.