Question

What are Data Tools? in Microsoft office? (Topic: MS Excel Part-II)

Answer 1

Microsoft Excel has the basic features of all spreadsheets,[4] using a grid of cells arranged in numbered rows and letter-named columnsto 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).[5] 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,[6][7] and then reporting the results back to the spreadsheet. It also has a variety of interactive features allowing user interfaces that can completely hide the spreadsheet from the user, so the spreadsheet presents itself as a so-called application, or decision support system (DSS), via a custom-designed user interface, for example, a stock analyzer,[8] or in general, as a design tool that asks the user questions and provides answers and reports.[9][10][11] In a more elaborate realization, an Excel application can automatically poll external databases and measuring instruments using an update schedule,[12] analyze the results, make a Wordreport or PowerPoint slide show, and e-mail these presentations on a regular basis to a list of participants. Excel was not designed to be used as a database.[13]

Microsoft allows for a number of optional command-line switches to control the manner in which Excel starts.[14]

Answer 2

Data Collection and Analysis Tools. Quality Glossary Definition: Data collection and analysis tools. Data collection and analysis tools are defined as a series of charts, maps, and diagrams designed to collect, interpret, and present data for a wide range of applications and industries.