Microsoft Excel 2021365 - Beginner to Advanced - Aligning Text and Numbers

The video tutorial covers the basics of cell alignment in Excel, explaining how numbers, text, and dates are aligned by default. It introduces the alignment tools available in the Home ribbon, detailing how to adjust horizontal and vertical alignment. The tutorial also explores text orientation, indentation, wrap text, and merge cell functionalities. Additionally, it highlights advanced alignment options, including shrink to fit, providing a comprehensive guide to managing cell content in Excel.

In Excel, where is text aligned by default when entered into a cell?

• Right side of the cell

• Top of the cell

• Left side of the cell

• Center of the cell

Which alignment tool would you use to align text to the middle of a cell vertically?

• Left align

• Center align

• Middle align

• Top align

What is the default vertical alignment for text in Excel cells?

• Top

• Middle

• Bottom

• Center

What does the text orientation tool in Excel allow you to do?

• Add text shadow

• Rotate text

• Change text font

• Change text color

How can you add a manual line break within a cell in Excel?

• Pressing Ctrl + Enter

• Pressing Enter

• Pressing Alt + Enter

• Pressing Shift + Enter

What does the 'Wrap Text' feature do in Excel?

• Wraps text into multiple lines

• Increases font size

• Changes text color

• Aligns text to the right

What is the purpose of the 'Merge and Center' feature in Excel?

• To merge cells and align text to the left

• To merge cells and center the text

• To merge cells and change text color

• To merge cells and align text to the right

Which option would you use to merge cells without centering the text?

• Merge and Center

• Merge Across

• Merge Cells

• Unmerge Cells

What happens when you use the 'Shrink to Fit' option in Excel?

• Text is wrapped into multiple lines

• Text is shrunk to fit the cell width

• Text is aligned to the center

• Text is bolded

Which alignment option is not available directly on the Excel ribbon?

• Middle Align

• Merge and Center

• Wrap Text

• Shrink to Fit