USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously?
|
|
copy using the Quick Access toolbar
|
|
|
copy form the Home Ribbon
|
|
|
copy using the fill handle
|
|
|
copy method from shortcut menu
|
Explanation:
Detailed explanation-1: -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-2: -Enter the formula view mode by pressing the Ctrl + ‘ shortcut, or by using any other method described in How to show formulas in Excel. Select all the cells with the formulas you want to copy or move. Press Ctrl + C to copy the formulas, or Ctrl + X to cut them.
Detailed explanation-3: -If you’re copying cell content to adjacent cells, you can click and drag the fill handle (the small square in the lower-right corner of the selected cell).
There is 1 question to complete.