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.