20 Unknown Facts about Excel
Updated: Oct 25, 2021
Father of Excel is CHARLES SIMONYI.
Excel was founded in 1985.
Excel mainly had 2 main components which are graphical Multiplan spreadsheets and charting applications.
The PIVOT TABLE feature was not initially launched by Microsoft, but by Lotus calling it IMPOV in 1991
A cell in a spread sheet can have up to 32767 characters.
In excel you can undo the last 100 actions.
LOTIS 1-2-3 was replaced by Microsoft Excel as an industry standard spreadsheet in 1993.
It is not possible to name a worksheet ‘History’ in EXCEL.
Up to 4,000,000,000 formulas can depend on a single cell in EXCEL.
You can enter up to 127 range/ criteria pairs in the SUMIFS formula
The earliest date allowed for calculations in EXCEL is January 1st 1900.
In an excel worksheet you can use up to 512 fonts.
Excel is written in more than 30,000,000 lines of code.
The maximum number of worksheets in a workbook in EXCEL is limited only by available memory.
Microsoft office was first released by MAC
There are more than 500 keyboard shortcuts in EXCEL.
If you need 1 second to fill 1 cell in a worksheet, it will take you 545 years to complete the whole sheet.
MULIPLAN was the original name of EXCEL in 1982
16%of the entire world population uses MS office.
88% of the EXCEL workbooks have errors.