MS Excel
When you copy a formula

Excel edits cell references in the newly copied formula
Excel adjusts absolute cell references
Excel doesn’t adjust relative cell references
Excel erases the original copy of the formula

ANSWER DOWNLOAD EXAMIANS APP

MS Excel
You can move a sheet from one workbook into new book by

None of the listed here
From Edit menu choose Move or Copy then select (new book) from To Book list and click OK
From Edit menu choose Move of Copy then choose (Move to end) and click OK
From Edit menu choose Move or Copy sheet, mark the Create a ccopy and Click OK

ANSWER DOWNLOAD EXAMIANS APP