DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following keys can be pressed while dragging a worksheet to another location in the workbook to copy it?
|
|
Shift
|
|
|
Enter
|
|
|
Control
|
|
|
Spacebar
|
Explanation:
Detailed explanation-1: -Press CTRL and drag the worksheet tab to the tab location you want.
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: -Press SCROLL LOCK, and then hold down CTRL while you press the LEFT ARROW or RIGHT ARROW key. Press SCROLL LOCK, and then simultaneously hold down CTRL and an arrow key to quickly move through large areas of your worksheet.
There is 1 question to complete.