What is Microsoft Excel?define it.

what is Microsoft excel? explain it briefly with few words?applications of excel.

Allaboina
25 May
8019 Views
12 Answers

SL

Sree
19 Jul

Excel is a commercial spreadsheet application produced and distributed by Microsoft for Microsoft windows and Mac OS.It features the ability to perform basic calculations,use graphing tools,create pivot tables and create macros. Developer: Microsoft Operating system:Microsoft Windows Type:spreadsheet Data storage and communication: Number of rows and columns: Versions of excel upto 7.0 had a limitation in the size of their data sets of 16k rows.Versions 8.0 through 11.0 could handle 64k rows and 256 columns.Version 12.0 can handle 1M rows and 16384 columns. File Formats: Microsoft Excel up until 2007 version used a proprietary binary file format called excel binary file format(.XLS) as its primary format.Excel 2007 uses office open XML as its primary file format,an XML_based format that followed after a previous XML-based format called &ldquo;XML Spreadsheet&rdquo; first introduced in excel2002. Although supporting and encouraging the use of new XML-based formats as replacements,excel 2007 remained backwards-compatible with the traditional,binary formats.In addition,most versions of Microsoft excel can read CSV,DBF,SYLK,DIF and other legacy formats.The file formats were mainly from DOS-based programs. Binary: Openoffice.org&nbsp;&nbsp;has created documentation of the excel format.Since Microsoft made the excel binary format specification available to freely download. XML spreadsheet: The XML spreadsheet format introduced in excel 2002 is a simple XML based format missing advanced features like storage of VBA macros.Though the intended file extension for this format is .xml,the program also correctly handles XML files with .XLS extension.This feature is widely used by third-party applications to offer&nbsp;&nbsp;&ldquo;export to excel&rdquo; capabilities without implementing binary file format. &nbsp;

Cancel

Excel is a commercial spreadsheet application produced and distributed by Microsoft for Microsoft windows and Mac OS.It features the ability to perform basic calculations,use graphing tools,create pivot tables and create macros.
Developer: Microsoft
Operating system:Microsoft Windows
Type:spreadsheet
Data storage and communication:
Number of rows and columns:
Versions of excel upto 7.0 had a limitation in the size of their data sets of 16k rows.Versions 8.0 through 11.0 could handle 64k rows and 256 columns.Version 12.0 can handle 1M rows and 16384 columns.
File Formats:
Microsoft Excel up until 2007 version used a proprietary binary file format called excel binary file format(.XLS) as its primary format.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 excel2002.
Although supporting and encouraging the use of new XML-based formats as replacements,excel 2007 remained backwards-compatible with the traditional,binary formats.In addition,most versions of Microsoft excel can read CSV,DBF,SYLK,DIF and other legacy formats.The file formats were mainly from DOS-based programs.
Binary:
Openoffice.org has created documentation of the excel format.Since Microsoft made the excel binary format specification available to freely download.
XML spreadsheet:
The XML spreadsheet format introduced in excel 2002 is a simple XML based format missing advanced features like storage of VBA macros.Though the intended file extension for this format is .xml,the program also correctly handles XML files with .XLS extension.This feature is widely used by third-party applications to offer “export to excel” capabilities without implementing binary file format.

0 Comments
Share

0

Other Related Discussions