Thursday 3 January 2013

01-Introduction to Microsoft Excel 2007-2010

Microsoft Excel is part of Microsoft office suit. Its a spread-sheet program. Which contains different sheets, made of rows and columns.
Microsoft Excel Contains :

  1. 16384 Columns
  2. 1048576 Rows
  3. Cells= 17179869184 ( Multiplication of rows and columns, i.e. 16384x1048576)
  4. Excel file is knows as one "Workbook" ( not as worksheet)
  5. All columns have name starting from A,B,C,D.....Z,AA,AB....AZ,BA,BB,BC...BZ....XFD(Last column)
  6. All rows have number starting from 1 to 1048576
  7. All cells have cell name or commonly known as cell address: ColumnName With Row Number, for e.g. A1, C5....D78 likewise.
  8. Extension of Excel 2007 and Excel 2010 file is *.xlsx
  9. Previously it was *.xls with Excel 97 to Excel 2003.
  10. There were 256 columns and 65536 rows in Excel 2003, and total 1677216 cells in Excel 2003.

No comments:

Post a Comment