USING MICROSOFT EXCEL
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
When you need to copy a formula down adjacent cells in a relative manner, you should uses which feature of MS Excel?
|
|
Fill handle
|
|
|
Copy & paste special
|
|
|
Formula bar
|
|
|
Conditional formatting
|
Explanation:
Detailed explanation-1: -Click Home > Fill, and choose either Down, Right, Up, or Left. Keyboard shortcut: You can also press Ctrl+D to fill the formula down in a column, or Ctrl+R to fill the formula to the right in a row.
Detailed explanation-2: -If you’re copying cell content to adjacent cells in the same row or column, the fill handle is a good alternative to the copy and paste commands. Select the cell(s) containing the content you want to use, then hover the mouse over the lower-right corner of the cell so the fill handle appears.
There is 1 question to complete.