Introduction to Excel

Last updated 28 days ago

Excel History

Excel was released in 1987. During this period, data management was a huge challenge in industry. We know companies, banks, govt. offices used to maintain data either in big registers or files. Major problems related to data handling were:  Data Storage  Data Transfer  Calculations  Reports

To overcome this problem Excel became a very good solution in industry. Excel is similar to register or notebook. We have to look it very differently.

 Like in register, We used to prepare index like tabular form structure (rows & column). Similarly excel has rows & columns structure. Register can have Max Rows – 100 Max Col- 100 Excel can have Max Rows – 1048576 (As shown Below) Max Col - 16384 (XFD is the 16384th column in excel)

Like in Register we have multiple page (100, 200, 300) Similarly Excel we can have unlimited worksheet depending upon memory .  What is Workbook? Ans:- Workbook is a collection of one or more spreadsheets, also called worksheets, in a single file.  What is Worksheet? Ans:- A Worksheet is a collection of cells organized in rows and columns. Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.