USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To ungroup worksheets, right-click one of the selected sheet tabs, and click ____
|
|
Ungroup Sheets
|
|
|
sheets
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Ungroup all worksheets When you’ve made all the changes, you can ungroup the worksheets. Right-click any worksheet tab in the group. Click Ungroup Sheets. Tip: To ungroup all worksheets, you can also click any worksheet tab outside the group.
Detailed explanation-2: -To ungroup, select the rows or columns, and then on the Data tab, in the Outline group, click Ungroup and select Ungroup Rows or Ungroup Columns.
Detailed explanation-3: -Right-click on any worksheet tab in the group. When the menu pops up, select “Ungroup Sheets” to separate each sheet so they’re no longer grouped.
There is 1 question to complete.