spreadsheets

spreadsheets

1. FUNCTIONS

   • SUM
     • adding two numbers together by =SUM(B3:C4)
   • PRODUCT
     • multiplying two or more numbers by =PRODUCT(c4:f12)
   • AVERAGE
     • =AVERAGER(A1:B7)
   • MIN
     • =MIN(A2:D12)
   • MAX
     • =MAX(A7:B14)

2. IF FUNCTION

   • THE IF FUNCTION OUTPUTS ONE OF TWO VALUES, DEPENDING ON WHETHER A CONDITION IS TRUE OR FALSE

3. FORMATTING

   • CELL WIDTH / HEIGHT
   • MERGE CELLS
   • TEXT / BACKGROUND COLOUR
   • BORDER

4. FORMULAS

   • FORMULAS ARE USED IN SPREADSHEETS TO MAKE CALCULATIONS
   • FORMULAS MUST START WITH AM = AND CAN USE REFERENCES TO OTHER CELLS
   • * AND / ARE USED TO MULTIPLY AND DIVIDE
   • SOME EXAMPLES ARE: =B1+C1 =B2-D4 =A2*B7 =B9/D2