Multiple choice technology

When a cell contains more than_____ characters, the extra characters gets truncated when we do more or copy sheet.

  1. 255

  2. 50

  3. 100

  4. 80

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Excel versions before 2007, cells had a 255-character limit. When copying or moving sheets between workbooks, any cell content exceeding 255 characters would be truncated. This was a known limitation of the older Excel binary file format. Excel 2007+ with the XML-based .xlsx format supports 32,767 characters per cell.