A spreadsheet is a piece of software that is used to display and process data in a structured way.
Most often, they are used to process numbers, but they can be used for text, dates and all sorts of other data.
Spreadsheets are very common in business, as they are excellent for handling data such as sales, engineering or financial data.
On the screen, the working area of a spreadsheet looks like a grid. Each rectangle within the
grid is called a 'cell'.
Cells are identified by their Column and Row position within the grid.
Formulas are used to perform calculations automatically on the data which has been entered.
Salesmen, teachers, scientists, market researchers and engineers use spreadsheets.
|Understanding spreadsheets||Parts of a Spreadsheet Presentation|
|Simpsons Activity||Simpsons Activity|
|Understanding spreadsheets||The basics - Worksheet|
|Chocolate brownies||Brownies Task sheet|
|Cell Referencing||Cell referencing exercises|
|Superhumans||Superhumans Task Sheet|
|If Function||How to use the IF function|
|If Function Exercises||If Function Exercises|
|A Good Breakfast||A Good Breakfast task sheet|
|Duffys Diner Exercise||Using basic formulas to create a spreadsheet to analyse profitability of a sandwich shop|
|Duffys Diner Workbook||Excel workbook for use with Duffys Diner|
|Heathrow Weather Exercise||Import Data, reformat and use functions to analyse weather data|
|Heathrow Weather Data||Data file for the Heathrow Weather Exercise|
|Level 2 Exercises Set 1||Simple arithmetic calculations, if function, formatting and charts|
|Level 2 Exercises Set 2||Simple arithmetic calculations, if function, formatting and charts|
|Epsom Travel exercise||Exercise that brings together formatting, calculations and charts|
|Holiday bookings||Excel workbook for the Epsom Travel Exercise|
|Custom Formatting Helpsheet||How to setup and use custom formatting|
|Using find, match and vlookup||Finding Data|
|Practicing absolute cell references||Finding Data|
|Working with strings||Identifying parts of a string and placing the results in separate cells|
|Working with strings - Instructions||Instructions for use with Working with Films Top 10 Films workbook.|