banner

© 2004-19 ict4u.net

Spreadsheets

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.

Resources
Title Description
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
Epsom Travel exercise Exercise that brings together formatting, calculations and charts
Holiday bookings Excel workbook for the Epsom Travel Exercise