How many characters can a single cell in Microsoft Excel contain?
2021
How many characters can a single cell in Microsoft Excel contain?
Answer: C. 32767 — CONCEPTSpreadsheet applications define separate limits for cell content, column width, row count, and other worksheet features. To answer a limit question,…
- A.
256
- B.
1024
- C.
32767
- D.
65535
Attempted by 1 students.
Show answer & explanation
Correct answer: C
CONCEPT
Spreadsheet applications define separate limits for cell content, column width, row count, and other worksheet features.
To answer a limit question, identify the exact feature being asked about and match it to the documented specification.
APPLICATION
The feature in the stem is the total number of characters stored in one cell.
Microsoft’s Excel specifications list this maximum as 32,767 characters.
Among the offered values, 32,767 matches that specification.
CROSS-CHECK
256 and 1,024 are below the documented capacity; a cell can contain more characters than either value.
65,535 is above the documented capacity and therefore cannot be the maximum text stored in one cell.
Therefore, a single Excel cell can contain up to 32,767 characters.