tp excel seance 1

7/23/2019 TP Excel Seance 1

1/13

A B C A+B A-B (A+B)*C

10 5 20 15.00 5.00 75.00

11 4 10 15.00 7.00 105.00

23 6 10 29.00 17.00 493.00

20 70 6 90.00 -50.00 -4,500.00

20 11 2 31.00 9.00 279.00

11 10 6 21.00 1.00 21.00

20 20 9 40.00 0.00 0.00

6 11 8 17.00 -5.00 -85.00


2/13

(A-B)/C (A+B)/(B+C) A*B+C

0.25 0.60 70.00

0.70 1.07 54.00

1.70 1.81 148.00

-8.33 1.18 1,406.00

4.50 2.38 222.00

0.17 1.31 116.00

0.00 1.38 409.00

-0.63 0.89 74.00


3/13

Article Quantit disponible Porcentage

B1 200 12.05%

B2 250 15.06%

B3 430 25.90%

B4 120 7.23%

B5 240 14.46%

B6 320 19.28%B7 100 6.02%

Total 1660


4/13

Valeur

10

11

10

12

14

12

17

11

12

13

15

14

2

1913


5/13

Somme 185

Moyenne 12.33

Ecarttye 3.79

Ma! 19

M"n 2

#om$re &e 'aleur 15#om$re &e 'aleur (u)r"eur * 13 5

Somme &e 'aleur (u)r"eur * 12 105


6/13

Article Quantit disponible cision

B1 200 +ancer la comman&e

B2 250 r"en

B3 430 r"en

B4 120 +ancer la comman&e

B5 240 r"en

B6 100 +ancer la comman&eB7 100 +ancer la comman&e

Seu"l 220

)c"("on "l aut lancer la comman&e lor(/ue la /uant"t) &"(on"$lee(t "n)r"eure au (eu"l


7/13

Tau! &aumentat"on 5%

#om Sala"re actuel Sala"re ar( aumenatat"on

B"ll 8500 8925

uont 10500 11025

urant 7500 7875

ean 7600 7980o$( 23000 24150


8/13

!e" Quantit Pri#$nitaire %ontant &' %ontant 'A

23 30 34.00 1,020.00 199.92

24 10 15.00 150.00 29.40

25 15 10.00 150.00 29.40

26 12 20.00 240.00 47.04

'otal ''C


9/13

%ontant ''C 'au# de 'A

1,219.92 19.60%

179.40

179.40

287.04

1,865.76


10/13

%atires %at ,n"o roit co

%o.enneCoecient 2

E(telle 4 6 13 13 7.92

+aurent 11 7 12 12 10.46

Mat"eu 17 9 11 11 12.85

M"cel 7 8 11 11 8.77Mur"elle 6 11 12 12 9.46

T"ery 15 12 11 13 13.23

n tudiant est ad3is si sa 3o.enne est suprieure ou

!gi3e des tudes

Ad3ission 10


11/13

dcision %o.enne

ourn) 7.92

&m"( 10.46

&m"( 12.85

ourn) 8.77ourn) 9.46

&m"( 13.23

gale 4 1


12/13

5 7acture '8'A9 &' 'au# !e3ise %3ontant !e3ise

1 125,000 10% 12,500

2 90,000 10% 9,000

3 112,000 10% 11,200

4 55,000 2% 1,100

5 100,000 10% 10,000

6 40,000 2% 800

Condition de re3isen accor&e une rem"(e &e 10% (" le total :T e(t (u)r"eur * 75000, ("non ce(t 2%

Condition de re3ise

:000 10; 2;


13/13

%o.enne Appreciation

12 ((e; B"en

10

tp excel seance 1

Documents