Sesión 13
TEMA: Referencias absolutas
2= A3*$C$2
3= A3*$D$2
4= A3*$E$2
5= A3*$F$2
6= A3*$G$2
7= A3*$H$2
8= A3*$I$2
9= A3*$J$2
10= A3*$K$2
TABLA DEL 2
11=A4*$B$2
12=A4*$C$2
13=A4*$D$2
14=A4*$E$2
15=A4*$F$2
16=A4*$G$2
17=A4*$H$2
18=A4*$I$2
19=A4*$J$2
20=A4*$K$2
TABLA DEL 3
21=A5*$B$2
22=A5*$C$2
23=A5*$D$2
24=A5*$E$2
25=A5*$F$2
26=A5*$G$2
27=A5*$H$2
28=A5*$I$2
29=A5*$J$2
30=A5*$K$2
TABLA DEL 4
31=A6*$B$2
32=A6*$C$2
33=A6*$D$2
34=A6*$E$2
35=A6*$F$2
36=A6*$G$2
37=A6*$H$2
38=A6*$I$2
39=A6*$J$2
40=A6*$K$2
TABLA DEL 5
41=A7*$B$2
42=A7*$C$2
43=A7*$D$2
44=A7*$E$2
45=A7*$F$2
46=A7*$G$2
47=A7*$H$2
48=A7*$I$2
49=A7*$J$2
50=A7*$K$2
TABLA DEL 6
51=A8*$B$2
52=A8*$C$2
53=A8*$D$2
54=A8*$E$2
55=A8*$F$2
56=A8*$G$2
57=A8*$H$2
58=A8*$I$2
59=A8*$J$2
60=A8*$K$2
TABLA DEL 7
61=A9*$B$2
62=A9*$C$2
63=A9*$D$2
64=A9*$E$2
65=A9*$F$2
66=A9*$G$2
67=A9*$H$2
68=A9*$I$2
69=A9*$J$2
70= A9*$K$2
TABLA DEL 8
71=A10*$B$2
72=A10*$C$2
73=A10*$D$2
74= A10*$E$2
75=A10*$F$2
76=A10*$G$2
77=A10*$H$2
78=A10*$I$2
79=A10*$J$2
80=A10*$K$2
TABLAS DEL 9
81=A11*$B$2
82=A11*$C$2
83=A11*$D$2
84=A11*$E$2
85=A11*$F$2
86=A11*$G$2
87=A11*$H$2
88=A11*$I$2
89=A11*$J$2
90=A11*$K$2
TABLA DEL 10
91=A12*$B$2
92=A12*$C$2
93=A12*$D$2
94 =A12*$E$2
95=A12*$F$2
96=A12*$G$2
97=A12*$H$2
98=A12*$I$2
99=A12*$J$2
100=A12*$K$2
TABLA DEL 1
1= A3*$B$22= A3*$C$2
3= A3*$D$2
4= A3*$E$2
5= A3*$F$2
6= A3*$G$2
7= A3*$H$2
8= A3*$I$2
9= A3*$J$2
10= A3*$K$2
TABLA DEL 2
11=A4*$B$2
12=A4*$C$2
13=A4*$D$2
14=A4*$E$2
15=A4*$F$2
16=A4*$G$2
17=A4*$H$2
18=A4*$I$2
19=A4*$J$2
20=A4*$K$2
TABLA DEL 3
21=A5*$B$2
22=A5*$C$2
23=A5*$D$2
24=A5*$E$2
25=A5*$F$2
26=A5*$G$2
27=A5*$H$2
28=A5*$I$2
29=A5*$J$2
30=A5*$K$2
TABLA DEL 4
31=A6*$B$2
32=A6*$C$2
33=A6*$D$2
34=A6*$E$2
35=A6*$F$2
36=A6*$G$2
37=A6*$H$2
38=A6*$I$2
39=A6*$J$2
40=A6*$K$2
TABLA DEL 5
41=A7*$B$2
42=A7*$C$2
43=A7*$D$2
44=A7*$E$2
45=A7*$F$2
46=A7*$G$2
47=A7*$H$2
48=A7*$I$2
49=A7*$J$2
50=A7*$K$2
TABLA DEL 6
51=A8*$B$2
52=A8*$C$2
53=A8*$D$2
54=A8*$E$2
55=A8*$F$2
56=A8*$G$2
57=A8*$H$2
58=A8*$I$2
59=A8*$J$2
60=A8*$K$2
TABLA DEL 7
61=A9*$B$2
62=A9*$C$2
63=A9*$D$2
64=A9*$E$2
65=A9*$F$2
66=A9*$G$2
67=A9*$H$2
68=A9*$I$2
69=A9*$J$2
70= A9*$K$2
TABLA DEL 8
71=A10*$B$2
72=A10*$C$2
73=A10*$D$2
74= A10*$E$2
75=A10*$F$2
76=A10*$G$2
77=A10*$H$2
78=A10*$I$2
79=A10*$J$2
80=A10*$K$2
TABLAS DEL 9
81=A11*$B$2
82=A11*$C$2
83=A11*$D$2
84=A11*$E$2
85=A11*$F$2
86=A11*$G$2
87=A11*$H$2
88=A11*$I$2
89=A11*$J$2
90=A11*$K$2
TABLA DEL 10
91=A12*$B$2
92=A12*$C$2
93=A12*$D$2
94 =A12*$E$2
95=A12*$F$2
96=A12*$G$2
97=A12*$H$2
98=A12*$I$2
99=A12*$J$2
100=A12*$K$2
SUM
= SUMA(C4:F4)
AVERAGE= PROMEDIO(C5:H5)
=PROMEDIO (Y5: AA5)
=AB5*0,80
=AD5*0,20
=AD5+E5
IF
=SI (M3=>7;"APRUEBA";"REPRUEBA")
COUNT= CONTAR(L3:L13)
ROUND=REDONDEAR(L3;O)
COUNT IF= CONTAR SI (N3:N13;"APRUEBA")
=SUM(C3:F3)
=SUM(C4:F4)
=SUM(C5:F5)
=AVERAGE(C3:F3)
=AVERAGE(C4:F4)
=AVERAGE(C5:F5)
=H3*0,80
=H4*0,80
=H5*0.80
=J3*0,20
=J4*0,20
=J5*0,20
=I3+K3
=I4+K4
=I5+K5
=ROUND(L3;0)
=ROUND(L4;0)
=ROUND(L5;0)
=IF(M3>=7;"APRUEBA";"REPRUEBA")
=IF(M4>=7;"APRUEBA";"REPRUEBA")
=IF(M5>=7;"APRUEBA";"REPRUEBA")
=MAX(L3:L5)
=MIN(L3:L5)
=COUNT(L3:L5)
= COUNT IF(N3:N5;"APRUEBA")
SUMA= SUM (C4:F4)
PROMEDIO= AVERAGE(C5:H5)
80%=AB5*0,80
20%= AD5*0,20
NQ%=AD5+E5
REDONDEO= ROUND(L3;0)
NOTA MAXIMA= MAX (L3:L13)
NOTA MINIMA= MIN (L3:L13)
CONTAR ? NOTAS= COUNT IF : CONTAR SI ( N3:N13; "APRUEBA)
Comentarios
Publicar un comentario