Question

Total number of columns in a work sheet of MS Excel 2003 :

• A. 254
• B. 255
• C. 256
• D. 257

Answer 1

Answer:

C. 256

Workspace

• The area below the formula bar is called a Workspace or Worksheet Area.
• The total number of rows in a work sheet     : 65536 (till MS Excel 2003)
• The total number of columns in a work sheet    : 256 (till MS Excel 2003)
• Total number of rows in a work sheet of MS Excel 2007  : 1048576
• Total number of columns in a work sheet of MS Excel 2007  : 16384
• Rows are numbered as 1, 2, 3.........1048576 
• In excel First row is called Row 1,  Second row is called Row 2 and So on.
• Columns are numbered as A , B, C, D etc.
• 26th column is called Z
• 27th column is called AA
• Area formed by intersection  of row and column is known as  : Cell
• Maximum number of characters a cell can hold  256