Row and column grouping in Google Sheets - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to group rows 2 to 5 in Google Sheets.

Google Sheets

Select rows 2 to 5, then click [1] > Group rows.

Drag options to blanks, or click blank then click option'

AFormat

BData

CInsert

DView

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing Format or Insert instead of Data menu.

Trying to group columns instead of rows.

In Google Sheets, grouping rows is done via the Data menu.

2fill in blank

medium

Complete the code to group columns B to D in Google Sheets.

Google Sheets

Select columns B to D, then click Data > Group [1].

Drag options to blanks, or click blank then click option'

Arows

Bsheets

Ccells

Dcolumns

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting 'Group rows' instead of 'Group columns'.

Trying to group sheets or cells.

To group columns, you select 'Group columns' under the Data menu.

3fill in blank

hard

Fix the error in the code to ungroup rows 3 to 6.

Google Sheets

Select rows 3 to 6, then click [1] > Ungroup rows.

Drag options to blanks, or click blank then click option'

AData

BInsert

CFormat

DView

Attempts:

3 left

💡 Hint

Common Mistakes

Trying to ungroup from Format or Insert menus.

Confusing ungrouping rows with ungrouping columns.

Ungrouping rows is done under the Data menu, same as grouping.

4fill in blank

hard

Fill both blanks to create a shortcut for grouping rows in Google Sheets.

Google Sheets

Press [1] + [2] + Right Arrow to group selected rows quickly.

Drag options to blanks, or click blank then click option'

AAlt

BShift

CCtrl

DCmd

Attempts:

3 left

💡 Hint

Common Mistakes

Using Ctrl instead of Alt for grouping rows.

Using Cmd which is for Mac shortcuts.

The shortcut to group rows is Alt + Shift + Right Arrow on Windows/Linux.

5fill in blank

hard

Fill all three blanks to write a formula that counts visible rows after grouping and hiding in Google Sheets.

Google Sheets

=SUBTOTAL([1], [2]:[3])

Drag options to blanks, or click blank then click option'

A103

BA2

CA100

D9

Attempts:

3 left

💡 Hint

Common Mistakes

Using function 9 which sums instead of counts.

Selecting wrong range that includes headers or empty cells.

Function 103 in SUBTOTAL counts visible non-empty cells, ignoring hidden rows. Range A2:A100 covers the data.

Practice

1. What is the main purpose of grouping rows or columns in Google Sheets?

easy

A. To sort data alphabetically

B. To change the color of cells automatically

C. To hide or show related rows or columns easily

D. To create charts from selected data

Solution

1. Step 1: Understand grouping function

   Grouping in Google Sheets is used to organize rows or columns so you can hide or show them quickly.

2. Step 2: Identify the main purpose

   The main purpose is to make large data easier to manage by collapsing or expanding related rows or columns.

3. Final Answer:

   To hide or show related rows or columns easily -> Option C

4. Quick Check:

   Grouping = Hide/Show rows or columns [OK]

Hint: Grouping hides or shows rows/columns quickly [OK]

Common Mistakes:

• Thinking grouping changes cell colors
• Confusing grouping with sorting
• Assuming grouping creates charts

2. Which of the following is the correct way to group columns in Google Sheets?

easy

A. Select columns, then go to Data > Group columns

B. Select columns, then press Ctrl + C

C. Select columns, then right-click and choose Delete columns

D. Select columns, then go to Insert > Chart

Solution

1. Step 1: Identify grouping method

   To group columns, you select the columns you want to group first.

2. Step 2: Use the Data menu

   Then use the Data menu and choose Group columns to create the group.

3. Final Answer:

   Select columns, then go to Data > Group columns -> Option A

4. Quick Check:

   Data > Group columns = Correct grouping method [OK]

Hint: Use Data menu > Group columns after selecting columns [OK]

Common Mistakes:

• Pressing Ctrl + C copies instead of grouping
• Deleting columns instead of grouping
• Trying to insert charts to group

3. You grouped rows 5 to 8 in a sheet. What happens when you click the minus (-) sign next to the group?

medium

A. Rows 5 to 8 are copied to another sheet

B. Rows 5 to 8 are hidden from view

C. Rows 5 to 8 are deleted permanently

D. Rows 5 to 8 are sorted alphabetically

Solution

1. Step 1: Understand the minus sign function

   The minus (-) sign on a group collapses the group, hiding the grouped rows.

2. Step 2: Identify the effect on rows 5 to 8

   Clicking minus hides rows 5 to 8 from view but does not delete or move them.

3. Final Answer:

   Rows 5 to 8 are hidden from view -> Option B

4. Quick Check:

   Minus sign = Hide grouped rows [OK]

Hint: Minus sign hides grouped rows or columns [OK]

Common Mistakes:

• Thinking rows get deleted
• Assuming rows are copied elsewhere
• Confusing hiding with sorting

4. You tried to group columns B to D but the group option is greyed out. What is the most likely reason?

medium

A. You have not selected the columns properly

B. Grouping is not available for columns

C. You need to delete the columns first

D. You must insert a chart before grouping

Solution

1. Step 1: Check selection of columns

   The group option is only active when you select the columns you want to group.

2. Step 2: Understand why option is greyed out

   If the option is greyed out, it usually means no columns or incorrect columns are selected.

3. Final Answer:

   You have not selected the columns properly -> Option A

4. Quick Check:

   Proper selection = Group option enabled [OK]

Hint: Always select columns before grouping [OK]

Common Mistakes:

• Thinking grouping is not for columns
• Trying to delete columns to group
• Inserting charts before grouping

5. You have grouped rows 2 to 6 and rows 7 to 10 separately. How can you create a bigger group that includes both groups (rows 2 to 10) so you can collapse all at once?

hard

A. Delete the smaller groups and group rows 2 to 10 once

B. You cannot group groups together in Google Sheets

C. Use the filter option instead of grouping

D. Select rows 2 to 10 and group them again to create a nested group

Solution

1. Step 1: Understand nested grouping

   Google Sheets allows nested groups by grouping a larger range that includes smaller groups.

2. Step 2: Apply grouping to rows 2 to 10

   Select rows 2 to 10 and group them again to create a bigger group that contains the smaller ones.

3. Final Answer:

   Select rows 2 to 10 and group them again to create a nested group -> Option D

4. Quick Check:

   Nested groups = Group bigger range [OK]

Hint: Group bigger range to nest smaller groups [OK]

Common Mistakes:

• Deleting smaller groups unnecessarily
• Confusing filters with grouping
• Believing nested groups are not possible