Merge cells in Google Sheets - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

What happens when you merge cells in Google Sheets?

You select cells A1, B1, and C1 and merge them into one cell. What is the value shown in the merged cell?

A The value of the top-left cell (A1) is shown

B The value of the bottom-right cell (C1) is shown

C The merged cell is empty regardless of original values

D The values of all cells are combined and shown

💡 Hint

Think about which cell's content Google Sheets keeps when merging.

When you merge cells, Google Sheets keeps the value from the top-left cell only. Other cells' values are discarded.

📊 Formula Result

intermediate

What is the result of merging cells with formulas?

Cells A1 and B1 contain formulas: A1 has =SUM(1,2) and B1 has =SUM(3,4). You merge A1 and B1. What is the value shown in the merged cell?

A 10, sum of both formulas' results

B 3, the result of A1's formula

C 7, the result of B1's formula

D An error because formulas conflict

💡 Hint

Remember which cell's content is kept after merging.

Only the top-left cell's formula result is kept after merging. The other cell's formula is discarded.

❓ Function Choice

advanced

Which function can you use to combine text from multiple cells without merging?

You want to show combined text from cells A1 and B1 in one cell, but without merging cells. Which function should you use?

A =COMBINE(A1,B1)

B =MERGE(A1,B1)

C =JOIN(A1:B1)

D =CONCATENATE(A1,B1)

💡 Hint

Think about functions that join text strings.

=CONCATENATE() joins text from multiple cells into one string without merging cells.

🎯 Scenario

advanced

You merged cells A1:C1 but want to sort the data in the original columns. What happens?

After merging cells A1, B1, and C1 into one cell, you try to sort the sheet by column B. What will happen?

A Sorting will fail with an error about merged cells

B Sorting will work normally, keeping merged cells intact

C Sorting will unmerge the cells automatically

D Sorting will ignore merged cells and sort only unmerged rows

💡 Hint

Think about how merged cells affect sorting in Google Sheets.

Google Sheets does not allow sorting ranges that include merged cells. It shows an error.

❓ data_analysis

expert

How many cells are counted in a merged range for a formula?

You merged cells A1 through A5 into one cell. You use the formula =COUNTA(A1:A5). What is the result?

A 0, because merged cells are ignored by COUNTA

B 5, counting all original cells in the range

C 1, because merged cells count as one cell

D An error, because COUNTA cannot handle merged cells

💡 Hint

Think about how formulas treat merged cells as ranges.

Formulas treat a merged range as a single cell. COUNTA(A1:A5) returns 1 if the merged cell contains data.