DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
[collections]
|
|
|
[set]
|
|
|
[group]
|
|
|
None of the above
|
Detailed explanation-1: -When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets.
Detailed explanation-2: -How do you tell if worksheets are grouped in Excel? There are two visual signs of grouped worksheets in Excel: The sheet tabs in a group have a white background; the sheet tabs outside the group appear in gray. The word Group is added to the name of the workbook; as soon as the worksheets are ungrouped, it disappears.
Detailed explanation-3: -You can quickly perform tasks on multiple worksheets at the same time by grouping worksheets together. If you group a set of worksheets, any changes you make on one worksheet are made in all the other worksheets in the group in the exact same location on the worksheets.