UNITE 9 SPREADSHEET DEVELOPMENT Hussam Amin Purpose of

UNITE 9 SPREADSHEET DEVELOPMENT Hussam Amin

Purpose of Spreadsheets Storing Data A spreadsheet can store a small or large set of data within a system of cells, organized into rows and columns. A cell can contain a data value, or a calculation, such as sums or percentages. Presenting Data In Excel, users can choose form a wide range of options including bar charts, line charts, pie charts, scatter charts and bubble charts among many others. When you create a chart, you can configure display options such as colour and labelling. Gaining Insight Spreadsheets allow a high level of control over the data you present, so are often used in presentations and reports. Planning The insights gained from a spreadsheet can form the basis of future planning processes within your business. Within a spreadsheet, you can also carry out tests to estimate the impact of particular decisions on your business, using the existing data together with variable data items representing your potential choices. Decision Making It can help the user make decision quickly and easily, e. g. using the lottery winning spreadsheet the winner can see that it he has £ 50 000 left he can’t buy something more expensive than that or he will end in minuses.

Spreadsheet 1 Purpose and Uses (Stock Control)

Spreadsheet 1 (Stock Control)

Spreadsheet 2 Purpose and Uses (Lottery)

Spreadsheet 2 (Lottery)

Bibliography http: //smallbusiness. chron. com/purpose-using-spreadsheet-54262. html 19 th October 2015