Using multiple worksheets makes it easier to group and summarize data. Describe features that can be applied by forming a worksheet group.

What will be an ideal response?

By forming a worksheet group, you can:
• Enter or edit data and formulas. Changes made to content in the active worksheet are also made in the same cells in all the worksheets in the group. You can also use the Find and Replace commands with a worksheet group.
• Apply formatting. Changes made to formatting in the active worksheet are also made to all the worksheets in the group, including changing row heights or column widths and applying conditional formatting.
• Insert or delete rows and columns. Changes made to the worksheet structure in the active worksheet are also made to all the worksheets in the group.
• Set the page layout options. Changes made to the page layout settings in one worksheet also apply to all the worksheets in the group, such as changing the orientation, scaling to fit, and inserting headers and footers.
• Apply view options. Changes made to the worksheet view such as zooming, showing and hiding worksheets, and so forth are also made to all the worksheets in the group.
• Print all the worksheets. You can print all of the worksheets in the worksheet group at the same time.