Total number of rows in a worksheet of MS Excel 2007:
A1048575
B1048576
C1048577
D1048578
Answer:
B. 1048576
Read Explanation:
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)