Asked by Charlotte Laprarie on May 26, 2024

verifed

Verified

Which of the following methods copies an existing worksheet within the same workbook?

A) Drag its sheet tab to a new location.
B) Press and hold CTRL and drag its sheet tab to a new location.
C) Press and hold SHIFT and drag its sheet tab to a new location.
D) Press and hold ALT and drag its sheet tab to a new location.

CTRL

A control key on a computer keyboard that, when pressed in conjunction with other keys, executes specific commands.

Worksheet

A single page or sheet in a spreadsheet application, such as Microsoft Excel, used for organizing, calculating, and analyzing data.

Sheet Tab

A component of spreadsheet software that allows users to navigate between multiple sheets within a workbook.

  • Understand worksheet manipulation techniques including copying and renaming worksheets.
verifed

Verified Answer

EC
Eutimio CantuMay 29, 2024
Final Answer :
B
Explanation :
Pressing and holding CTRL while dragging the sheet tab creates a duplicate of the existing worksheet within the same workbook. Option A simply moves the worksheet, while options C and D do not have any effect.