Unit 4: spreadsheets and formulas

Unit 4: spreadsheets and formulas

1. Spreadsheets are for performing calculations and analysis.

2. Spreadsheets can perform complex mathematical functions and lots of data

   • When used correctly, spreadsheets make our lives much easier by doing maths and calculations for us

3. What apps are there?

   • Microsoft Exel is well known but expensive to by
   • Google sheets
     • Libreoffice ,'Calc', WPS Office and open office , calc are all free sreadsheet apps.

4. Sprwadsheets store data in a cell

   • A cell is a single rectangle in a spreadsheet. Its referenceis its column letter and row name
     • Formulas
       • Any value can be entered into any cell
         • Mathmatical formulas can be entered into a cell insted of a value
           • The formula will be evalulated and the result shown in the cell.
             • All formulas must start with an "=", otherwise they wont be evalukated.
               • They contain references to other cells insted of numbers
             • Any mathmatical calculation can be performed. Because the x and division symbol isnt on the keyboard, * and / are used intead but the addition and subtration symbols are the same

5. Formatting

   • conditional formatting
     • Average, Min, Max, sum, product
       • =IF(condition, value, value if false)