|
|
|
CALCULE IN MICROSOFT EXCEL
Sa se evalueze prin calcul urmatoarea formula :
E = 
EVALUAREA FORMULE
Cu formule ascunse
a=
28
b=
10
E=
7,1
var1
7,1
var2
7,1
var3
7,1
Cu afisarea formulelor :
a=
28
b=
10
E=
=(4*a+3*b)/(2*b)
var1
=IF(b<>0;E;'ai gresit!')
var2
=IF(b<>0;SUM(4*a;3*b)/(2*b);'fals,mai incearca ')
var3
=IF(b<>0;SUM(PRODUCT(4;a);+PRODUCT(3;b))/PRODUCT(2*b);'ESTE INVALID')
NR.
DENUMIREA
UM
CANTITATE
PRET
VALOARE
CRT.
MATERIEI PRIME
INTRATA
IESITA
FINALA
UNITAR
DE INTRARE
DE IESIRE
FINALA
1
STOFA LANA
MP
155
27
128
18,96
2.938,80
511,92
2.426,88
2
DOC BUMBAC
MP
110
110
15,89
1.747,90
0,00
1.747,90
3
NASTURI METALICI
BUC
60
22
38
1,55
93,00
34,10
58,90
4
BANDA ELASTICA
ML
100
34
66
2,55
255,00
86,70
168,30
5
ATA ALBA BBC
BUC
10
1
9
1,45
14,50
1,45
13,05
6
ATA NEAGRA PVC
BUC
7
2
5
1,76
12,32
3,52
8,80
7
MATERIAL CAPTUSEALA
MP
100
45
55
2,8
280,00
126,00
154,00
8
CAPSE DUBLE
BUC
400
150
250
2,8
1.120,00
420,00
700,00
NR.
DENUMIREA
UM
CANTITATE
PRET
VALOARE
CRT.
MATERIEI PRIME
INTRATA
IESITA
FINALA
UNITAR
DE INTRARE
DE IESIRE
FINALA
1
STOFA LANA
MP
155
27
=D3-E3
18,96
=D3*G3
=E3*G3
=G3*F3
2
DOC BUMBAC
MP
110
=D4-E4
15,89
=D4*G4
=E4*G4
=G4*F4
3
NASTURI METALICI
BUC
60
22
=D5-E5
1,55
=D5*G5
=E5*G5
=G5*F5
4
BANDA ELASTICA
ML
100
34
=D6-E6
2,55
=D6*G6
=E6*G6
=G6*F6
5
ATA ALBA BBC
BUC
10
1
=D7-E7
1,45
=D7*G7
=E7*G7
=G7*F7
6
ATA NEAGRA PVC
BUC
7
2
=D8-E8
1,76
=D8*G8
=E8*G8
=G8*F8
7
MATERIAL CAPTUSEALA
MP
100
45
=D9-E9
2,8
=D9*G9
=E9*G9
=G9*F9
8
CAPSE DUBLE
BUC
400
150
=D10-E10
2,8
=D10*G10
=E10*G10
=G10*F10
PROBLEMA 6.
Sa se calculeze functia :
E
Cu formule ascunse
a=
16
b=
256
E=
29
E=
29
E=
29
E=
29
Cu afisarea formulelor :
a=
16
b=
256
E=
=(7*a+SQRT(SQRT(b)))/4
E=
=IF(b>=0;E;'ATENTIE,ESTE GRESIT!')
E=
=IF(b>=0;(7*a+b^(1/4))/4;'NU ARE SENS')
E=
=IF(b>=0;(7*a+POWER(b;1/4))/4;'FALS,MAI INCEARCA')
PROBLEMA 7.
NR.CRT
NUME SI PRENUME STUDENT
DISCIPLINA 1
DISCIPLINA 2
DISCIPLINA 3
DISCIPLINA 4
MEDIA
1
BENGESCU DAN
8
5
9
7
7,25
2
DAICU GRIGORE
4
10
10
10
AMANAT
3
ENESCU CATALINA
8
8
6
10
8,00
5
HANGANU PETRE
10
9
10
9
9,50
6
MOLDOVAN ALEXANDRA
7
4
8
10
AMANAT
7
NICULAITA DORINA
8
6
10
9
8,25
8
POPOVICI IOANA
7
8
5
6
6,50
9
RAICU BEATRICE
9
7
7
5
7,00
10
SANDU ELENA
6
7
5
9
6,75
11
TARTAGA RALUCA
5
6
8
5
6,00
12
UDREA FLORIAN
5
7
5
5
5,50
13
VITALI ROBERTA
5
6
8
5
6,00
NR
NUME SI PRENUME STUDENT
D1
D2
D3
D4
MEDIA
1
BENGESCU DAN
8
5
9
7
=IF(AND(C2>4;D2>4;E2>4;F2>4);AVERAGE(C2:F2);'AMANAT')
2
DAICU GRIGORE
4
10
10
10
=IF(AND(C3>4;D3>4;E3>4;F3>4);AVERAGE(C3:F3);'AMANAT')
3
ENESCU CATALINA
8
8
6
10
=IF(AND(C4>4;D4>4;E4>4;F4>4);AVERAGE(C4:F4);'AMANAT')
5
HANGANU PETRE
10
9
10
9
=IF(AND(C5>4;D5>4;E5>4;F5>4);AVERAGE(C5:F5);'AMANAT')
6
MOLDOVAN ALEXANDRA
7
4
8
10
=IF(AND(C6>4;D6>4;E6>4;F6>4);AVERAGE(C6:F6);'AMANAT')
7
NICULAITA DORINA
8
6
10
9
=IF(AND(C7>4;D7>4;E7>4;F7>4);AVERAGE(C7:F7);'AMANAT')
8
POPOVICI IOANA
7
8
5
6
=IF(AND(C8>4;D8>4;E8>4;F8>4);AVERAGE(C8:F8);'AMANAT')
9
RAICU BEATRICE
9
7
7
5
=IF(AND(C9>4;D9>4;E9>4;F9>4);AVERAGE(C9:F9);'AMANAT')
10
SANDU ELENA
6
7
5
9
=IF(AND(C10>4;D10>4;E10>4;F10>4);AVERAGE(C10:F10);'AMANAT')
11
TARTAGA RALUCA
5
6
8
5
=IF(AND(C11>4;D11>4;E11>4;F11>4);AVERAGE(C11:F11);'AMANAT')
12
UDREA FLORIAN
5
7
5
5
=IF(AND(C12>4;D12>4;E12>4;F12>4);AVERAGE(C12:F12);'AMANAT')
13
VITALI ROBERTA
5
6
8
5
=IF(AND(C13>4;D13>4;E13>4;F13>4);AVERAGE(C13:F13);'AMANAT')
PROBLEMA 8.
Graficul unei functii definite prin formula,se realizeaza prin generarea unei retele de puncte
Functia :
f (x) = 
e
, numita
Clopotul lui Gaus
NR.CRT
Y=
0,398942
1
-3
0,004432
2
-2,5
0,017528
3
-2
0,053991
4
-1,5
0,129518
5
-1
0,241971
6
-0,5
0,352065
7
0
0,398942
8
0,5
0,352065
9
1
0,241971
10
1,5
0,129518
11
2
0,053991
12
2,5
0,017528
13
3
0,004432
Reprezentarea grafica :
