Excel Merged Cells and Alternatives Quiz

What is a common issue encountered when using merged cells in Excel?

• They automatically change the font size.

• They make the spreadsheet look cluttered.

• They can cause errors when sorting data.

• They prevent the use of formulas.

Why do merged cells create problems in Excel?

• They are not compatible with Excel's grid system.

• They increase the file size significantly.

• They require additional software to function.

• They are not supported in older versions of Excel.

What is the alternative method to merging cells that maintains Excel's grid integrity?

• Cell Fusion

• Grid Alignment

• Vertical Merge

• Center Across Selection

Which of the following is a limitation of the 'Center Across Selection' method?

• It requires a special plugin.

• It cannot be used with numbers.

• It only works for vertical alignment.

• It only works for horizontal alignment.

What is the main advantage of using 'Center Across Selection' over merged cells?

• It allows for more colorful spreadsheets.

• It is compatible with all spreadsheet software.

• It automatically updates data in real-time.

• It avoids the problems associated with merged cells.