USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Drag
|
|
|
Fill Left
|
|
|
Fill Right
|
|
|
Fill Down
|
Detailed explanation-1: -Fill can be used to copy data either horizontally or vertically in a range. 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: -Use the Auto Fill feature to fill cells with data that follows a pattern or are based on data in other cells.
Detailed explanation-3: -Move cells by using Cut and Paste Select a cell or a cell range. or press Ctrl + X. Select a cell where you want to move the data. or press Ctrl + V.
Detailed explanation-4: -Tip: To move or copy a selection to a different worksheet or workbook, click another worksheet tab or switch to another workbook, and then select the upper-left cell of the paste area. or press Ctrl+V.