USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
You cannot use the fill handle to copy a formula with an external reference indicator.
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Which of the following is true when you copy and paste formulas using the fill handle? The AutoFill Options button lets you fill cells with specific elements of the copied cell.
Detailed explanation-2: -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-3: -With Auto Fill, dragging the fill handle on a cell copies the cell’s contents or continues a series of data into adjacent cells.
There is 1 question to complete.