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.