SPREADSHEETTOEPASSINGEN
Inhoudsopgave
Spreadsheettoepassingen.............................................................................................................................. 1
Introductie 1..........................................................................................................................................................3
Kolombreedte aanpassen..................................................................................................................................3
tekst uitlijnen.....................................................................................................................................................3
cellen opmaken (dialoogvenster)......................................................................................................................3
vulgreep.............................................................................................................................................................3
getallen of tekst.................................................................................................................................................4
rekenen..............................................................................................................................................................4
eenvoudige formules (som, min, max, gemiddelde)........................................................................................4
aantal-functies...................................................................................................................................................4
Introductie 2..........................................................................................................................................................4
absolute en relatieve adressen.........................................................................................................................4
bereiknamen.....................................................................................................................................................4
getalopmaak......................................................................................................................................................5
aangepaste getalnotities...................................................................................................................................5
opmaak..............................................................................................................................................................6
Introductie 3..........................................................................................................................................................6
opmaak kopiëren...............................................................................................................................................6
afdrukken..........................................................................................................................................................6
titels blokkeren (al werkende in je bestand).....................................................................................................6
Beheer van lijsten 1...............................................................................................................................................7
Tabellen.............................................................................................................................................................7
sorteren.............................................................................................................................................................7
filteren...............................................................................................................................................................7
gefilterde lijsten.................................................................................................................................................7
opmerkingen.....................................................................................................................................................8
gegevensvalidatie..............................................................................................................................................8
ongeldige gegevens...........................................................................................................................................8
beheer van lijsten 2...............................................................................................................................................8
draaitabellen (Pivot charts/samenvattingsrapport)..........................................................................................8
gegevens interpreteren.....................................................................................................................................9
waarden samenvatten als.................................................................................................................................9
handmatig groeperen........................................................................................................................................9
automatisch groeperen.....................................................................................................................................9
draaigrafieken...................................................................................................................................................9
rapporten..........................................................................................................................................................9
Grafieken 1............................................................................................................................................................9
grafieken maken en wijzigen.............................................................................................................................9
Grafieken 2..........................................................................................................................................................10
grafiekgebied veranderen...............................................................................................................................10
illustraties........................................................................................................................................................10
1
, assen................................................................................................................................................................10
as opmaken.....................................................................................................................................................11
gegevensreeksen.............................................................................................................................................11
foutbalken.......................................................................................................................................................11
Uitbreiding 1.......................................................................................................................................................11
syntaxregels.....................................................................................................................................................11
uitbreiding 2........................................................................................................................................................11
als-functie........................................................................................................................................................12
alsen-functie....................................................................................................................................................12
alsof-functie.....................................................................................................................................................12
alsals-functie....................................................................................................................................................12
verticaal zoeken...............................................................................................................................................12
voorwaardelijke opmaak.................................................................................................................................12
uitbreiding 3........................................................................................................................................................12
datums.............................................................................................................................................................12
koppelen van werkbladen...............................................................................................................................13
2
Inhoudsopgave
Spreadsheettoepassingen.............................................................................................................................. 1
Introductie 1..........................................................................................................................................................3
Kolombreedte aanpassen..................................................................................................................................3
tekst uitlijnen.....................................................................................................................................................3
cellen opmaken (dialoogvenster)......................................................................................................................3
vulgreep.............................................................................................................................................................3
getallen of tekst.................................................................................................................................................4
rekenen..............................................................................................................................................................4
eenvoudige formules (som, min, max, gemiddelde)........................................................................................4
aantal-functies...................................................................................................................................................4
Introductie 2..........................................................................................................................................................4
absolute en relatieve adressen.........................................................................................................................4
bereiknamen.....................................................................................................................................................4
getalopmaak......................................................................................................................................................5
aangepaste getalnotities...................................................................................................................................5
opmaak..............................................................................................................................................................6
Introductie 3..........................................................................................................................................................6
opmaak kopiëren...............................................................................................................................................6
afdrukken..........................................................................................................................................................6
titels blokkeren (al werkende in je bestand).....................................................................................................6
Beheer van lijsten 1...............................................................................................................................................7
Tabellen.............................................................................................................................................................7
sorteren.............................................................................................................................................................7
filteren...............................................................................................................................................................7
gefilterde lijsten.................................................................................................................................................7
opmerkingen.....................................................................................................................................................8
gegevensvalidatie..............................................................................................................................................8
ongeldige gegevens...........................................................................................................................................8
beheer van lijsten 2...............................................................................................................................................8
draaitabellen (Pivot charts/samenvattingsrapport)..........................................................................................8
gegevens interpreteren.....................................................................................................................................9
waarden samenvatten als.................................................................................................................................9
handmatig groeperen........................................................................................................................................9
automatisch groeperen.....................................................................................................................................9
draaigrafieken...................................................................................................................................................9
rapporten..........................................................................................................................................................9
Grafieken 1............................................................................................................................................................9
grafieken maken en wijzigen.............................................................................................................................9
Grafieken 2..........................................................................................................................................................10
grafiekgebied veranderen...............................................................................................................................10
illustraties........................................................................................................................................................10
1
, assen................................................................................................................................................................10
as opmaken.....................................................................................................................................................11
gegevensreeksen.............................................................................................................................................11
foutbalken.......................................................................................................................................................11
Uitbreiding 1.......................................................................................................................................................11
syntaxregels.....................................................................................................................................................11
uitbreiding 2........................................................................................................................................................11
als-functie........................................................................................................................................................12
alsen-functie....................................................................................................................................................12
alsof-functie.....................................................................................................................................................12
alsals-functie....................................................................................................................................................12
verticaal zoeken...............................................................................................................................................12
voorwaardelijke opmaak.................................................................................................................................12
uitbreiding 3........................................................................................................................................................12
datums.............................................................................................................................................................12
koppelen van werkbladen...............................................................................................................................13
2
