Spreadsheet
modelling
Samenvatting 2
, Inhoudsopgave
H1 Module 2 – Tentamen 2 ...........................................................................................................................................................................................................3
1.1 Datums & datum functies .....................................................................................................................................................................................................3
1.2 Dagen tussen 2 datums........................................................................................................................................................................................................ 4
1.3 Tijd tussen 2 tijdstippen & tijd afronden ......................................................................................................................................................................... 7
1.4 Datum & tijd opmaken ...........................................................................................................................................................................................................8
H2 Tekstopmaak............................................................................................................................................................................................................................... 11
2.1 Tekst naar kolommen............................................................................................................................................................................................................ 11
2.2 Tekst extraheren (eruit halen).........................................................................................................................................................................................12
Formule overzicht..........................................................................................................................................................................................................................15
modelling
Samenvatting 2
, Inhoudsopgave
H1 Module 2 – Tentamen 2 ...........................................................................................................................................................................................................3
1.1 Datums & datum functies .....................................................................................................................................................................................................3
1.2 Dagen tussen 2 datums........................................................................................................................................................................................................ 4
1.3 Tijd tussen 2 tijdstippen & tijd afronden ......................................................................................................................................................................... 7
1.4 Datum & tijd opmaken ...........................................................................................................................................................................................................8
H2 Tekstopmaak............................................................................................................................................................................................................................... 11
2.1 Tekst naar kolommen............................................................................................................................................................................................................ 11
2.2 Tekst extraheren (eruit halen).........................................................................................................................................................................................12
Formule overzicht..........................................................................................................................................................................................................................15
