Ms Excel Key Points

MICROSOFT EXCEL

KEY POINTS:

·      Total Cells = 17,179,869,184

·      Total Columns = 16,384 or XFD

·      Total Rows = 1,048,576

·      Total Characters In A Cell = 65,535

·      Formula Character Length = 8,192

·      Column Width = 8.43 Characters(0 to 255)

·      Row Height = 12.75 Points (0 to 409)

·      Total Function Arguments = 255

·      Total Formula Nesting Levels = 64

·      Maximum Array References = Unlimited

·      Total Pivot Table Columns = 16,384

·      Total Pivot Table Rows = 1,048,576

·      Total Pivot Table Fields = 16,384

·      Total Unique Pivot Table Items = 1,048,576

·      ODBC = Open Database Connectivity

·      OLE DB = Object Linking Embedding Database

·      .txt files are ‘TAB’ delimited

·      .csv files are ‘COMMA’ delimited