Topic 10-Spreadsheets

Topic 10-Spreadsheets

1. Spreadsheets display data in a neat way but perform calculations automatically

2. Data is referenced by column numbers and row numbers (eg. D11)

3. Data in a cell may be text, numbers, dates, times, currency, logical values, errors or even graphics

4. Several sheets can be used in workbooks and these can interact with eachother

5. Rows of data can be sorted into alphabetical or numerical order

6. Data can be represented as charts, such as bar, column, pie and line charts