‘‘That the man of God may be competent, equipped for every good work’

 Timothy 3:17 ESV

Mundesley  Free  Church.
Home About Questions Warm ups  Your Queries Info Quizzes Games Melissa Page Email Lesson Pictures Print Labels Security

Spread Sheets.

Spreadsheets have replaced paper-based systems throughout the business world. Although they were first developed for accounting or bookkeeping tasks, they now are used extensively in any context where tabular lists are built, sorted, and shared.

Spreadsheet software is an interactive computer app for the organization, analysis and storage of data in tabular form.

The app operates on data entered in cells of a table.

Do you have spreadsheet software? If not click here to download some free office software from the Apache Software Foundation, who provide software products for the public good. The software is as good as Microsoft equivalents but has less features. Ask for help if you are not sure how to proceed.

If you have spreadsheet software installed then click here for a usage tutorial…...

Each cell may contain:

  1. Numeric data
  2. Letter or word data
  3. the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheet users can adjust any stored value and observe the effects on calculated values. This makes the spreadsheet useful for "what-if" analysis since many cases can be rapidly investigated without manual recalculation.

In this picture of a spreadsheet the value in the Interest column with a value of £500.00 is cell D2.

The cell with £7,095.34 is E4.

=(B2/100)*C2 is an example of a formula acting on data in cells B2 and C2.