Question

Total number of rows in a worksheet of MS Excel 2007:

• A. 1048575
• B. 1048576
• C. 1048577
• D. 1048578

Answer 1

Answer:

B. 1048576

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
• A small group of cells is defined as a Cell Range (Example : A1......A9)