19 Facts About Microsoft Excel

1.

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS.

FactSnippet No. 1,315,534
2.

Microsoft Excel has the basic features of all spreadsheets, using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations.

FactSnippet No. 1,315,535
3.

Windows version of Excel supports programming through Microsoft's Visual Basic for Applications, which is a dialect of Visual Basic.

FactSnippet No. 1,315,536
4.

From its first version Microsoft Excel supported end-user programming of macros and user-defined functions .

FactSnippet No. 1,315,537
5.

Microsoft Excel 2007 uses Office Open XML as its primary file format, an XML-based format that followed after a previous XML-based format called "XML Spreadsheet", first introduced in Microsoft Excel 2002.

FactSnippet No. 1,315,538
6.

XML Spreadsheet format introduced in Microsoft Excel 2002 is a simple, XML based format missing some more advanced features like storage of VBA macros.

FactSnippet No. 1,315,539
7.

The most common are Dynamic Data Exchange: although strongly deprecated by Microsoft Excel, this is a common method to send data between applications running on Windows, with official MS publications referring to it as "the protocol from hell".

FactSnippet No. 1,315,540
8.

Microsoft Excel Mobile is a spreadsheet program that can edit XLSX files.

FactSnippet No. 1,315,541
9.

In 2015, Microsoft Excel Mobile became available for Windows 10 and Windows 10 Mobile on Windows Store.

FactSnippet No. 1,315,542
10.

Microsoft Excel Viewer was a freeware program for Microsoft Windows for viewing and printing spreadsheet documents created by Excel.

FactSnippet No. 1,315,543
11.

Microsoft Excel's implementation involves conversions between binary and decimal representations, leading to accuracy that is on average better than one would expect from simple fifteen digit precision, but that can be worse.

FactSnippet No. 1,315,544
12.

Particularly in the arena of statistical functions, Microsoft Excel has been criticized for sacrificing accuracy for speed of calculation.

FactSnippet No. 1,315,545
13.

Accuracy and convenience of statistical tools in Microsoft Excel has been criticized, as mishandling missing data, as returning incorrect values due to inept handling of round-off and large numbers, as only selectively updating calculations on a spreadsheet when some cell values are changed, and as having a limited set of statistical tools.

FactSnippet No. 1,315,546
14.

Microsoft Excel originally marketed a spreadsheet program called Multiplan in 1982.

FactSnippet No. 1,315,547
15.

Microsoft Excel maintained its advantage with regular new releases, every two years or so.

FactSnippet No. 1,315,548
16.

Microsoft Excel belatedly took steps to prevent the misuse by adding the ability to disable macros completely, to enable macros when opening a workbook or to trust all macros signed using a trusted certificate.

FactSnippet No. 1,315,549
17.

Unlike Microsoft Word, there never was a DOS version of Excel.

FactSnippet No. 1,315,550
18.

Microsoft Excel became the first spreadsheet to allow the user to define the appearance of spreadsheets .

FactSnippet No. 1,315,551
19.

Microsoft Excel introduced auto-fill, the ability to drag and expand the selection box to automatically copy a cell or row contents to adjacent cells or rows, adjusting the copies intelligently by automatically incrementing cell references or contents.

FactSnippet No. 1,315,552