16 Facts About Excel

1.

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

FactSnippet No. 1,252,046
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,252,047
3.

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

FactSnippet No. 1,252,048
4.

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

FactSnippet No. 1,252,049
5.

All versions of Excel, including Excel 2010 are capable of running an XLM macro, though Microsoft discourages their use.

FactSnippet No. 1,252,050
6.

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 Excel 2002.

FactSnippet No. 1,252,051
7.

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

FactSnippet No. 1,252,052
8.

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

FactSnippet No. 1,252,053
9.

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

FactSnippet No. 1,252,054
10.

Excel for the web is a free lightweight version of Microsoft Excel available as part of Office on the web, which includes web versions of Microsoft Word and Microsoft PowerPoint.

FactSnippet No. 1,252,055
11.

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

FactSnippet No. 1,252,056
12.

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,252,057
13.

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

FactSnippet No. 1,252,058
14.

Accuracy and convenience of statistical tools in 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,252,059
15.

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

FactSnippet No. 1,252,060
16.

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,252,061