FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which key do you press to group two or more nonadjacent worksheets?
A
CTRL
B
SHIFT
C
ALT
D
None of the above
Explanation: 

Detailed explanation-1: -Press and hold down the Ctrl key, and click the worksheet tabs you want to group. Tip: If you want to group consecutive worksheets, click the first worksheet tab in the range, press and hold the Shift key, and click the last worksheet tab in the range.

Detailed explanation-2: -2) To group non adjacent worksheets, select the first worksheet and then hold down the Ctrl key while you select the other worksheets.

Detailed explanation-3: -To group non-adjacent worksheets, first click the sheet tab of the first sheet to be in the group. Hold down the Control key, and then click the next sheet to be in the group. Keep the CTRL key down and continue to click on the sheets you wish to be in the group.

Detailed explanation-4: -When you hold the Control key down (Command on the Mac), and click another worksheet tab the active worksheet and clicked worksheet will be selected. You can select as many additional worksheets as you like.

There is 1 question to complete.