Grouping and outlining in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of grouping rows or columns in Excel?

Grouping helps you organize and hide or show related rows or columns easily, making large spreadsheets simpler to read and manage.

beginner

How do you create a group for rows in Excel?

Select the rows you want to group, then go to the Data tab and click on 'Group'. This will add a collapsible outline for those rows.

beginner

What do the outline symbols (like plus and minus signs) do in Excel's grouping feature?

They let you expand (show) or collapse (hide) the grouped rows or columns with one click.

intermediate

What is the difference between grouping and subtotal outlining in Excel?

Grouping is manual and lets you choose any rows or columns to group. Subtotal outlining automatically groups data based on summary calculations like sums.

beginner

How can you remove a group in Excel?

Select the grouped rows or columns, then go to Data tab and click 'Ungroup'. This removes the outline and shows all data.

What happens when you collapse a group in Excel?

A The grouped rows or columns are deleted

B The grouped rows or columns are hidden

C The grouped rows or columns are copied

D Nothing happens

Collapsing a group hides the grouped rows or columns but does not delete or copy them.

Where do you find the option to group rows or columns in Excel?

A Data tab

B Insert tab

C Home tab

D View tab

The Group option is located under the Data tab in Excel.

What symbol usually indicates a collapsed group in Excel?

A Star (*)

B Minus sign (-)

C Check mark (✓)

D Plus sign (+)

A plus sign (+) shows that the group is collapsed and can be expanded.

Which feature automatically creates groups based on summary calculations?

A Manual grouping

B Filter

C Subtotal outlining

D Freeze panes

Subtotal outlining automatically groups data based on summary calculations like sums or averages.

How do you remove grouping from a set of rows or columns?

A Use the Ungroup option under Data tab

B Use the Sort option

C Hide the rows or columns

D Delete the rows or columns

Ungroup removes the grouping and shows all rows or columns.

Explain how grouping rows or columns can help you manage a large Excel spreadsheet.

Think about how you might tidy up a messy desk by putting similar papers in folders.

Describe the steps to create and then remove a group in Excel.

Remember the Data tab is where grouping controls live.