USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is the most efficient way of repeating a formula in multiple rows?
|
|
Copying and pasting the formula in each cell.
|
|
|
Dragging the Fill Handle downwards.
|
|
|
Rewriting the formula in each cell.
|
|
|
Cutting and pasting the formula in each cell.
|
Explanation:
Detailed explanation-1: -Select the rows into which you want to copy the original row or rows. Right-click the selection, and then click “Insert Copied Cells.” Excel inserts the repeated data into the new rows, moving the existing rows down.
Detailed explanation-2: -You can also press Ctrl+D to fill the formula down in a column. First select the cell that has the formula you want to fill, then select the cells underneath it, and then press Ctrl+D. You can also press Ctrl+R to fill the formula to the right in a row.
Detailed explanation-3: -To use the fill handle to enter data following a custom pattern, start the pattern by entering data in at least two cells. Then, select those cells, and drag the fill handle to repeat the pattern.
There is 1 question to complete.