Spreadsheet

In this section We cover

What is Spreadsheet?

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
  • Excel forms part of the Microsoft Office suite of software.
  • Microsoft Excel has the basic features of all spreadsheets,[7] using a grid of cells arranged in numbered rows and letter-named columns to organize data manipulations like arithmetic operations.
  • It has a battery of supplied functions to answer statistical, engineering and financial needs. In addition, it can display data as line graphs, histograms and charts, and with a very limited three-dimensional graphical display.
  • It allows sectioning of data to view its dependencies on various factors for different perspectives (using pivot tables and the scenario manager).

It has a programming aspect, Visual Basic for Applications, allowing the user to employ a wide variety of numerical methods, for example, for solving differential equations of mathematical physics, and then reporting the results back to the spreadsheet..