The correct answer is: C. From Edit menu choose Move or Copy then select (new book) from To Book list and click OK.
To move a sheet from one workbook into a new book, follow these steps:
- Open the workbook that contains the sheet you want to move.
- On the Sheet tab, in the Move or Copy group, click Move or Copy.
- In the Move or Copy dialog box, do the following:
- In the To book list, select the book that you want to move the sheet to.
- If you want to create a copy of the sheet, select the Create a copy check box.
- Click OK.
The sheet is moved to the new book.
Option A is incorrect because it does not select the new book from the To Book list.
Option B is incorrect because it does not select the new book from the To Book list.
Option D is incorrect because it is not a valid option.