Limits | MCQs

Explanation

A cell can contain 32,767 number of characters.

**** 

 At the same time, the Formula bar can show all 32,767 symbols.

The maximum length of a formula is 8,192 characters in Excel 2007

RY19012023

Explanation

The maximum number of rows in MS Excel is 1,048,576, starting from row 1.

Excel has a maximum of 16,384 columns, labeled from A to XFD.

Explanation

In older versions of Excel (up to 2003), a worksheet contains 256 columns.

Newer versions have expanded this limit to 16,384 columns.

A single worksheet in Excel contains 65,536 rows.