Which option describes how to copy a worksheet to a new workbook by using Move or Copy and creating a copy?

Which option describes how to copy a worksheet to a new workbook by using Move or Copy and creating a copy?

• A. Move or Copy, To book: (new book), Create a copy.
• B. Save As to a new workbook.
• C. Copy and paste into a new workbook.
• D. New Workbook button in Quick Access Toolbar.

Answer: (C)

Copying a worksheet into a new workbook is about duplicating that sheet into a separate file rather than saving the entire current workbook. In this set of options, describing the action as “Copy and paste into a new workbook” best captures how you would transfer just that sheet into a brand-new file by copying the sheet (its data, formatting, and formulas) and pasting it into the new workbook. The other choices don’t describe placing a single worksheet into a new file on their own: Save As would duplicate the whole workbook, not just one sheet; the New Workbook button creates a blank file, which doesn’t bring over any data by itself. If you were using Move or Copy in Excel, you’d typically choose to create a copy and place it in a new book, but among the given options, copying and pasting into a new workbook is the most direct description of that outcome.

Copying a worksheet into a new workbook is about duplicating that sheet into a separate file rather than saving the entire current workbook. In this set of options, describing the action as “Copy and paste into a new workbook” best captures how you would transfer just that sheet into a brand-new file by copying the sheet (its data, formatting, and formulas) and pasting it into the new workbook. The other choices don’t describe placing a single worksheet into a new file on their own: Save As would duplicate the whole workbook, not just one sheet; the New Workbook button creates a blank file, which doesn’t bring over any data by itself. If you were using Move or Copy in Excel, you’d typically choose to create a copy and place it in a new book, but among the given options, copying and pasting into a new workbook is the most direct description of that outcome.