Cell alignment and wrapping in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

📊 Formula Result

intermediate

Effect of Wrap Text on Cell Height

You enter the text "Hello world! This is a test." in cell A1. You enable Wrap Text for A1 and set the column width narrow enough so the text wraps into two lines. What happens to the height of cell A1?

A The cell height increases to fit the wrapped text on two lines.

B The cell height decreases to fit the wrapped text.

C The cell height stays the same as before wrapping.

D The cell height becomes zero and the text is hidden.

💡 Hint

Think about how Excel shows all text when wrapping is on.

When Wrap Text is enabled, Excel adjusts the cell height automatically to show all lines of wrapped text. So the height increases to fit the text on multiple lines.

❓ Function Choice

intermediate

Choosing Alignment for Centered Text

You want to center the text horizontally and vertically inside a cell in Excel. Which combination of alignment settings should you choose?

A Horizontal: Center, Vertical: Center

B Horizontal: Left (Indent), Vertical: Bottom

C Horizontal: Right, Vertical: Top

D Horizontal: Justify, Vertical: Distributed

💡 Hint

Center means text is in the middle horizontally and vertically.

Setting Horizontal alignment to Center and Vertical alignment to Center places the text exactly in the middle of the cell both ways.

🎯 Scenario

advanced

Preventing Text Overflow in Adjacent Cells

You have a long text in cell A1 that spills over into cell B1, which already contains data. You want to keep the full text visible in A1 without overwriting B1's content. What should you do?

A Set A1's horizontal alignment to Left and vertical alignment to Bottom.

B Clear the content of B1 to allow overflow from A1.

C Enable Wrap Text in A1 so the text fits inside A1's width and height.

D Reduce the font size in B1 to make room for A1's text.

💡 Hint

Think about how to keep text inside its own cell without hiding it.

Enabling Wrap Text in A1 forces the text to stay inside A1 by wrapping onto multiple lines, so it does not overflow into B1.

📊 Formula Result

advanced

Result of Vertical Alignment on Multi-line Text

Cell A1 has Wrap Text enabled and contains multiple lines of text. The cell height is larger than needed for the text. If you set Vertical Alignment to Top, what will you see?

A The text is hidden because the cell height is too large.

B The text is centered vertically in the cell.

C The text is aligned at the bottom of the cell, leaving empty space above.

D The text is aligned at the top of the cell, leaving empty space below.

💡 Hint

Vertical alignment controls where text sits inside the cell vertically.

With Vertical Alignment set to Top, the wrapped text stays at the top of the cell, and any extra space is below the text.

❓ data_analysis

expert

Analyzing Effects of Mixed Alignment and Wrap Text

You have a table where some cells have Wrap Text enabled and vertical alignment set to Bottom, while others have Wrap Text disabled and vertical alignment set to Center. Which statement is true about the visual appearance of these cells?

A All cells show text centered vertically regardless of Wrap Text setting.

B Cells with Wrap Text and Bottom alignment show text at the bottom with multiple lines; cells without Wrap Text and Center alignment show single-line text centered vertically.

C Cells without Wrap Text always show text at the top, ignoring vertical alignment.

D Wrap Text disables vertical alignment settings, so all wrapped cells align top by default.

💡 Hint

Consider how Wrap Text and vertical alignment interact visually.

Wrap Text allows multiple lines and vertical alignment controls where text sits vertically. Bottom alignment places wrapped text at the bottom; no wrap with Center alignment centers single-line text vertically.