USING MICROSOFT EXCEL
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following is NOT a way to copy a formula down (or right)?
|
|
Fill handle
|
|
|
Fill button
|
|
|
Sort down
|
|
|
Control + D
|
Explanation:
Detailed explanation-1: -If you’re still having an issue with drag-to-fill, make sure your advanced options (File –> Options –> Advanced) have “Enable fill handle…” checked. You might also run into drag-to-fill issues if you’re filtering. Try removing all filters and dragging again.
Detailed explanation-2: -Solution Answer Copy-paste a formula Explanation we can insert formula Use function option…
There is 1 question to complete.