USES OF SPREADSHEET

Uses of Spreadsheet

Uses of Spreadsheet

Introduction

Spreadsheets are a convenient tool for automating calculations. It carries out many of the calculations in tabular form particularly in the areas of mathematics, accounting, and statistics. Using mathematical formulas in spreadsheet allows us to represent the relationship between different parameters of a complete system and solve many computational problems that could be manipulated only by means of programming previously. Mathematical modelling is also made possible by spreadsheet software. The first programming languages were designed to process and output data in the form of paintings which can be practiced on the tool of printer. Programming techniques have evolved since then, and the data can be represented more effectively in the computer memory rather than sequentially on a sheet of paper. Spreadsheet software is designed to make general calculations based on spatial relationships between the data. A well defined entry point causes the execution of the first instruction and follows all instructions in sequence. In a spreadsheet, a set of cells and spatial logical relationships between them is defined. In the first spreadsheet, these relations were in two dimensions, represented by a grid. Over time, additional features have emerged as the organization of independent but leaves that can be logically connected to each other in an embryo of the third dimension.

Spreadsheets offer the most advanced operations such as rotation or transposition matrix data and can present the data sets graphically. The cells of a spreadsheet are the functional equivalents as variables in imperative programming. The cells can contain formulas that contain a set of instructions that calculate their value from other variables in the spreadsheet, or from external variables (like the date or time). Spreadsheets use the concepts of relative and absolute references to facilitate editing and understanding of the formulas. In general, the spreadsheets automatically update the cell values that depend on a parameter that has changed. The initial spreadsheet tools used simplistic strategies such as updating cells in order. Most of the modern spreadsheets can calculate the mathematical query by the construction of a tree of dependency between cells. Most of the concepts encountered in imperative programming can be found in the world of spreadsheets. For example, the route loops is represented by an indexed salary of a table cell, and an infinite loop can be obtained by referencing each other two cells (cyclic dependency tree). Most spreadsheet programs accept cyclic references, whose execution can be controlled by the user or the program itself.

Discussion

Types of Spreadsheets

“An electronic spreadsheet” is software that works to manipulate and analyze numbers and formulas in rows and columns. This allows you to organize numerical data so that it can manipulate sets classified by divisions (rows and columns) and apply those using formulas and diverse operations. This tool can also transform the data to graphics or make a colourful presentation of the results of operations. Spreadsheets can be applied in the solution of problems in the fields of business, science, engineering and ...