0
0
Excelspreadsheet~5 mins

Cell alignment and wrapping in Excel - Cheat Sheet & Quick Revision

Choose your learning style9 modes available
Recall & Review
beginner
What does cell alignment control in Excel?
Cell alignment controls how the content inside a cell is positioned horizontally and vertically, such as left, center, right, top, middle, or bottom.
Click to reveal answer
beginner
How do you wrap text in an Excel cell?
You can wrap text by selecting the cell, then clicking the 'Wrap Text' button on the Home tab. This makes the text break into multiple lines within the same cell.
Click to reveal answer
beginner
What happens if you don’t wrap text and the content is longer than the cell width?
If text is longer than the cell width and not wrapped, it will either overflow into adjacent empty cells or be cut off if the next cell has content.
Click to reveal answer
beginner
Name two ways to align text vertically in a cell.
You can align text vertically by choosing Top Align, Middle Align, or Bottom Align from the alignment options in the Home tab.
Click to reveal answer
beginner
Why is wrapping text useful in spreadsheets?
Wrapping text helps keep all the information visible inside a cell without changing the column width, making the sheet easier to read and look neat.
Click to reveal answer
Which button do you click to wrap text in Excel?
AWrap Text
BMerge Cells
CBold
DCenter Align
What is the default horizontal alignment for text in Excel cells?
ARight Align
BCenter Align
CLeft Align
DJustify
If you want text to appear at the bottom of a cell, which alignment should you choose?
ACenter Align
BMiddle Align
CTop Align
DBottom Align
What happens if you don’t wrap text and the next cell contains data?
AText is cut off at the cell boundary
BText overflows into the next cell
CText automatically wraps
DCell expands automatically
Which alignment option centers text horizontally in a cell?
ALeft Align
BCenter Align
CRight Align
DJustify
Explain how to align text both horizontally and vertically in an Excel cell.
Think about the Home tab and alignment buttons.
You got /3 concepts.
    Describe the benefits of using text wrapping in Excel cells.
    Consider what happens when text is too long for a cell.
    You got /3 concepts.