Which steps copy the Salaries worksheet to a new workbook?

Which steps copy the Salaries worksheet to a new workbook?

• A. File > Save As and save to new workbook.
• B. Right-click Salaries sheet tab, Move or Copy..., In To book list select (new book), Create a copy, OK.
• C. Insert > Worksheet > Copy.
• D. Home tab, Copy, but no.

Answer: (B)

Copying a worksheet to another workbook is done through the sheet tab’s Move or Copy command. Right-click the Salaries tab, choose Move or Copy…, in To book select (new book), check Create a copy, and click OK. This creates a new workbook containing a copy of the Salaries worksheet while leaving the original workbook intact. The other options don’t achieve this: saving with Save As affects the whole workbook, not just a single sheet; Insert > Worksheet > Copy isn’t a standard way to copy a sheet to a different workbook; and Copy on the Home tab copies cells within the same workbook rather than creating a new workbook with a separate sheet.

Copying a worksheet to another workbook is done through the sheet tab’s Move or Copy command. Right-click the Salaries tab, choose Move or Copy…, in To book select (new book), check Create a copy, and click OK. This creates a new workbook containing a copy of the Salaries worksheet while leaving the original workbook intact. The other options don’t achieve this: saving with Save As affects the whole workbook, not just a single sheet; Insert > Worksheet > Copy isn’t a standard way to copy a sheet to a different workbook; and Copy on the Home tab copies cells within the same workbook rather than creating a new workbook with a separate sheet.