DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down SHIFT, and then drag the selected sheet along the row of sheet tabs.
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Select all the data in the worksheet. Keyboard shortcut: Press CTRL+Spacebar and then press Shift+Spacebar. Copy all the data on the sheet by pressing CTRL+C.
Detailed explanation-2: -Simply hold down the Ctrl key, then click and drag the sheet’s tab. When you release the mouse, Excel will create an exact copy of the sheet.
Detailed explanation-3: -To do this: Select File > Save As > Download a Copy. If Excel asks whether to open or save the workbook, select Save.
There is 1 question to complete.