Uitgewerkte oefeningen ms excel in de praktijk

OEFENINGEN MS EXCEL
OEFENING 1 (pagina 9)




C2:C10 -> =B2*1,01
D2:D10 -> =C2*1,01
E2:E10 -> =D2*1,01
F2:F10 -> =E2*1,01
G2:G10 -> =F2*1,01
H2:H10 -> =G2*1,01
I2:I10 -> =H2*1,01

OEFENING 3 (pagina 10)




C2:C3 -> =B2/$B$4
C4 -> =SOM(C2;C3)
H2:H3 -> =(G2-F2)/F2

OEFENING 4 (pagina 10)




B4 -> =-(B3-B2)/B2

OEFENING 5 (pagina 11)




B2 -> =(B3/B4)*100

OEFENING 6 (pagina 11)




Voor de 21% -> verkopen (kolom A) delen door 1,21
12% -> verkopen delen door 1,12
6% -> verkopen delen door 1,06


OEFENING 7 (pagina 11)

, A5 -> =$B$2*(1+$B$1)
B5:E5 -> =A$5*(1+$B$1)

OEFENING 8 (pagina 11)




B4:B8 -> =$B$1*$A4
F4:K4 -> =$F$1*F$3
F7:K7 -> =$F$1*F$3

OEFENING 9 (pagina 12)




B2:F2 -> =B$1*1,06
B3:F3 -> =B$1*1,12
B4:F4 -> =B$1*1,21
H2:L2 -> =B$1*$A$2
H3:L3 -> =B$1*$A$3
H4:L4 -> =B$1*$A$4

OEFENING 10 (pagina 12)




B3:F3 -> =B2-(B2*$H$2)
B4:F4 -> =B3-(B3*$H$3)
C6 -> =MIN(B4:F4)
C7 -> =MAX(B4:F4)
C8 -> =GEMIDDELDE(B4:F4)




OEFENING 11 (pagina 13)