Topic 10:Spreadsheets

Topic 10:Spreadsheets

1. A spreadsheet application such as excel can store all its data in a single file.This is called a workbook.

   • A workbook is made up of one or more worksheets, A worksheet is a single tab in the spreadsheet workbook.

2. Cells

   • A cell reference always starts with a letter and ends with a number e.g. A5 or H28
   • A range of cells is a set of cells in a row or column
   • Data entered into cells can be different data types e.g. text, number, currency, date, percentage etc.
   • Each cell can contain:
     • Labels- any text in a cell describing the data in a row or column
     • Data- any values that are entered for the use of calculation
     • Formulas and functions- mathematical calculations carried out automatically

3. Formulas

   • Must start with an =
   • formulas perform calculation son the cell contents
   • formulas appear in the formula bar
   • The result of a formula is automatically recalculated every time the data on a spreadsheet changes
   • 4 main mathematical operations
     • + add
     • - substract
     • * multiply
     • / divide

4. Funtions

   • Must also start with an =
   • Functions are part of spreadsheet software. They are specialised calculations built in to the spreadsheet software
   • Function name describes what a function can do SUM, COUNT, AVERAGE, MIN, MAX, IF.
     • =SUM(D2:F7)

5. formatting

   • The content of a cell can be formatted
     • Font style, size, colour, border style, aligment, cell colour.
     • multiple cells can be merged into one cell
   • Cells are often formatted to reflect the data that is held I them. Data types include:
     • currency, number,