DATABASE FUNDAMENTALS
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: -The reason this happened was because Excel was set to Manual Recalculation. To solve the problem, select any cell in the worksheet and press F9.
Detailed explanation-3: -Select the formula in the cell using the mouse, and press Ctrl + C to copy it. Select the destination cell, and press Ctl+V. This will paste the formula exactly, without changing the cell references, because the formula was copied as text.
There is 1 question to complete.