USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
T
|
|
|
F
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Grouping worksheets will allow the user to make changes to several worksheets at once. The fill handle only allows you to copy formulas to several different cells. Any changes made to an Excel document can be tracked in a separate worksheet. The Subtotals command adds numbers in a designated column.
Detailed explanation-2: -Advantages of grouping worksheets in Excel Once the worksheets are grouped, you can enter the same data, make the same changes, write the same formulas and apply the same formatting to all the worksheets at once without having to switch through different sheets and edit each one individually.
Detailed explanation-3: -By clicking the sheet tabs at the bottom of the Excel window, you can quickly select one or more sheets. To enter or edit data on several worksheets at the same time, you can group worksheets by selecting multiple sheets. You can also format or print a selection of sheets at the same time.