Ejercicio de Excel

7/21/2019 Ejercicio de Excel

http://slidepdf.com/reader/full/ejercicio-de-excel-56da91d399dab 1/40

1 1 EXCEL EXCEL 2007 EXCEL 2007 10/28/20151 2 EXCEL EXCEL 2008 EXCEL 2007 10/29/20151 3 EXCEL EXCEL 2009 EXCEL 2007 10/30/20151 4 EXCEL EXCEL 2010 EXCEL 2007 10/31/20151 5 EXCEL EXCEL 2011 EXCEL 2007 11/1/2015

Conclusion: Que Con el Controlador de relleno, Nor ir!e "ara rellenar de una ce



10/28/201510/28/201510/28/201510/28/201510/28/2015

lda a otra con el #is#o contenido o consecuti!a#ente con la $ecla %Control&



EXCEL 2007EXCEL 2007EXCEL 2007EXCEL 2007EXCEL 2007



2350 9'3( 143 ( 789

89 17522582

937 785' 7' ) 43'9

8'1 3487

207 12000

5*111111119*'''''''7



CRECIMIENTO NATURAL = TASA DE NATALIDAD - TASA

C+EC-EN$. N$+L E L +EN$NTASA AÑO 1915 AÑO 1950 AÑO 1960 AÑO 1970

N$L 35*1 25*5 22*7 20*9-.+$L 15*5 9 8*' 8*4C+EC-EN$. N$+L 19*' 1'*5 14*1 12*5



DE MORTALIDAD

AÑO 1980 AÑO 1990

25*5 21*48 8*'

17*5 12*8



CANTIDAD PRODUCTO PRECIO UNITARIO PRECIO TOTAL

2 LECE+. 5 107 C+E$ 12 84

9 +E- 10 905 -+C.+ 8 40





PROVINCIA HABITANTES

ca"ital ederal 29'097' 200 14804*88

uenos ire 12582321 307571 40*908'714937

Cata#arca 2'5571 1009'7 2*'302752384

Cordo6a 27'417' 1'87'' 1'*3787492741Corrientes 795021 88199 9*01394573'3

Caco 838303 99'33 8*41390904'2

Cu6ut 35'587 224'8' 1*5870459219

Entre +ios 10228'5 78781 12*983'508803

or#osa 4043'7 720'' 5*'110'48572

ulu 513992 53219 9*'580544542

La "a#"a 2'0034 143440 1*812841'0'2

La +io;a 220729 89'80 2*4'12957181

-endo<a 1414058 148827 9*501353921-isiones 789'77 29801 2'*4983389819

SUPERFICIE KM2 DENSIDAD hab/Km2



LIBRERÍA "EL ESTUDIANTE"

Artic!# D$#cri%ci& S'tt(! I)( Tt(!+1 o#a 10 = 1*50 = 15*00 = 3*15 = 18*15

+2 La"i< 20 = 2*25 = 45*00 = 9*45 = 54*45+3 iro#e 145 = 3*40 = 493*00 = 103*53 = 59'*53+4 Cuaderno 15 = 10*50 = 157*50 = 33*08 = 190*58

1 co#"letar los codi>os de articulo co#o serie, in>resando +1 lue>o arrastre d2 calcular el $.$L #ulti"licando la cantidad !endda "or el "recio unitario3 calcular el ? #ulti"licando el su6total "or 21@4 calcular el $.$L su#ando el su6total ( el ?

C(&ti*(*+$&*i*(

,r$ciU&it(ri



esde el contrlador de relleno



+ENTAS DEL DIA

COMESTIBLES ,ERUMERIA

DIAS CONTADO TAR.ETA CONTADO TAR.ETA1 / 0000 / 50000 / 25000 / 35089

2 / 83627 / 28797 / 7528 / 8167

3 / 63871 / 18967 / 051 / 268394 / 9189 / 99631 / 99336 / 7825

5 / 351 / 33336 / 21322 / 1693

' / 3853 / 69855 / 6569 / 28819

7 / 18237 / 23333 / 8195 / 82098 / 6297 / 2562 / 1307 / 8279

9 / 51797 / 20317 / 1978 / 7255210 / 79008 / 55910 / 1312 / 12857

11 / 91025 / 717 / 286 / 507912 / 299 / 23297 / 363 / 5596613 / 30392 / 93756 / 2180 / 72614 / 15982 / 8522 / 83568 / 6255

15 / 92822 / 23759 / 7995 / 30309TOTALES = 8,290*85 = 7,400*20 = ',14'*35 = 7,351*49



$.$LE,ANADERIA

CONTADO TAR.ETA CONTADO TAR.ETA / 5500 / 0000 = 905*00 = 1,250*89

/ 38000 / 65662 = 1,701*55 = 1,7'0*9'

/ 8937 / 85377 = 738*'9 = 1,312*93

/ 5896 / 57025 = 2,502*75 = 2,349*01

/ 5692 / 33031 = 1,118*05 = 901*81

/ 53938 / 61735 = 1,'70*51 = 1,'04*19

/ 53762 / 3281 = 1,5'2*04 = 1,493*'8

/ 5350 / 2266 = 1,188*47 = 8'2*77

/ 589 / 6890 = 1,421*14 = 1,'13*59

/ 258 / 2275 = 1,189*73 = 1,010*42

/ 2930 / 5915 = 1,233*18 = 1,'21*31/ 62658 / 81206 = 1,324*00 = 1,'14*'9

/ 39 / 2583 = 971*11 = 1,924*7'

/ 33301 / 855 = 1,449*51 = 2,338*22

/ 79785 / 85227 = 2,525*'0 = 1,503*95

= 7,0'4*13 = 8,411*49



TOTAL ,OR DIA

= 2,155*89

= 3,4'2*51

= 2,051*'2

= 4,851*7'

= 2,019*8'

= 3,274*70

= 3,055*72

= 2,051*24

= 3,034*73

= 2,200*15

= 2,854*49= 2,938*'9

= 2,895*87

= 3,787*73

= 4,029*55



N.+-E EL +-E+ E-E$+E

,$ri* i&4r$## E4r$## SALDOENE+. = 450,230,000 = 125,'00,000 = 324,'30,000E+E+. = 325,987,000 = 122,350,000 = 203,'37,000

-+A. = 125,'87,000 = 97,500,000 = 28,187,000+L = 98,700,000 = 84,900,000 = 13,800,000-B. = 85,230,000 = 42,300,000 = 42,930,000

N. = 45,890,000 = 35,400,000 = 10,490,000 Co#ision:

TOTAL DEL ,RIMER SEMESTRE = '23,'74,000

12 calcular el L. restando N+E. ) E+E.3 EL $.$L EL +-E+ E-E+$+E es la su#a de los saldos4 calcular la co#ision #ulti"licando el total del "ri#er se#estre "or ' @

Co#"letar la colu#na E+.. co#o serie cronolo>ica con !alor inicial ENERO



= 37,420,440

li#ite .UNIO



1& 2&NOTAS DE UN ALUMNO ro#edio na "ersona

7 4*5 8 '*5 ?iaticosiosDo

li#entosotoco"ias

"lantiar la o

MA &ci& MA

3735

'78'8

'78

MIN E:c$!

astosse#anal

En este artculo se descri6e la sintaFis de la Gr#ula el uso de la unciGn MA

La unciGn -N en EFcel nos de!uel!e el !alor #ni#o de un con;unto de !alore



CONTARSI

La unciGn C.N$+**C.NN$. en EFcel nos "er#ite contar los ele#entos de



CONTAR EN BLANCO

Esta unciGn "ertenece a la a#ilia de C.N$+ el resultado Jue a"orta "ro!ie



CONTARA



s tiene dia los si>uentes >astos:= 2*50= 4*50

= 15= 0*50

r#ula de >astos se#anal %todos los dias >asta lo #is#o&

112*5

en -icrosot EFcel*

* Los ar>u#entos de la unciGn -N "ueden ser los nI#eros, las celdas o los ra



un ran>o Jue cu#"len con los criterios deKnidos* Esta unciGn nos "er#ite es"e



e de contar el nI#ero de celdas Jue se encuentran en 6lanco dentro de un ran





>os Jue contienen los !alores Jue desea#os e!aluar*



ciKcar asta 127 criterios*



o de celdas*





Nro*N;'r$ , A%$!!i* S A%$!!i* #$: S$!* D Tr('(<(*# +(!r Di( S(!(ri S(!*

1 CLLE$N. -EN CCE. - = 750,000 30 = 25,000 = 750,000 = 37

2 C+$N -EN ?L.BE - = 1,200,000 30 = 40,000 = 1,200,000 = '0

N+E -EN -EN - = 850,000 30 = 28,333 = 850,000 = 42

3 LEN+. LC. L.+EA - = 850,000 30 = 28,333 = 850,000 = 42

5 .N * +.-M +.-M - = 850,000 30 = 28,333 = 850,000 = 42

6 L -* ?L.BE C.++E = 850,000 30 = 28,333 = 850,000 = 42

7 .+LEB E* -EN C.+. = 1,'00,000 30 = 53,333 = 1,'00,000 = 80

8 +BN * QN$. ++ - = 1,900,000 30 = '3,333 = 1,900,000 = 95

9 $EEL LC. +LL = 900,000 30 = 30,000 = 900,000 = 45

10 E?E+ L* -C. -.+EN. - = 750,000 30 = 25,000 = 750,000 = 37

11 EL-E+ * QE LN.N - = 750,000 30 = 25,000 = 750,000 = 3712 .-$L LLN C?E++ = 2,000,000 30 = '',''7 = 2,000,000 = 100

1 C+LB -.+EN. $E++EA = 1,200,000 30 = 40,000 = 1,200,000 = '0

13 N -* +?E+ E+NNEA = 1,200,000 30 = 40,000 = 1,200,000 = '0

15 C+L. * NE$+.A ++E$ - = 1,'00,000 30 = 53,333 = 1,'00,000 = 80

?alor #aFi#o del sueldo = 2,000,000 Nr *$ ;<$r$# $&

?alor #ini#o del sueldo = 750,000 Nr *$ ;'r$ $& !

?alor -ini#o "a>ar = '07,500

N.-N E $+.+E E L E-+E



C&#!t('7



T DESCUENTO T A ,A>AR

= 142,500 = '07,500

= 228,000 = 972,000

= 1'1,500 = '88,500

= 1'1,500 = '88,500

= 1'1,500 = '88,500

= 1'1,500 = '88,500

= 304,000 = 1,29',000

= 3'1,000 = 1,539,000

= 171,000 = 729,000

= 142,500 = '07,500

= 142,500 = '07,500 = 380,000 = 1,'20,000

= 228,000 = 972,000

= 228,000 = 972,000

= 304,000 = 1,29',000

,RESS





1 2 3 4 5 ' 7 8 9 10 11 12 1 =)

=500,000

=1,000,000

=1,500,000

=2,000,000

=2,500,000

1 2 3 4 5 ' 7 8 9 10 11 12 13 14= 0

= 500,000

= 1,000,000

= 1,500,000

= 2,000,000

= 2,500,000

= 1,000,000

= 1,500,000

= 2,000,000

= 2,500,000



1 2 3 4 5 ' 7 8 9 10 11 12 13 1

= 0

= 500,000

0*5 1 1*5 2 2*5 3 3*5 =)

=50,000

=100,000

=150,000

=200,000

=250,000

=300,000

= 37,500

= '0,000

= 42,500

= 42,500

= 42,500= 42,500

= 80,000

= 95,000

= 45,000

= 37,500

= 37,500

= 100,000

= '0,000

= '0,000= 80,000



14 15

ueldo

alario

5

alario

$* ECEN$.

$* +alario



4 15

90,000 = 15,000

144,000 = 24,000

102,000 = 17,000

102,000 = 17,000

102,000 = 17,000102,000 = 17,000

192,000 = 32,000

228,000 = 38,000

108,000 = 18,000

90,000 = 15,000

90,000 = 15,000

= 240,000 = 40,000

144,000 = 24,000

144,000 = 24,000192,000 = 32,000



E&c$#t( D$%(rt(;$&t(! Cc

C;$rci(!i?(&ci& ,rc$&t(<$

-anoacura 57*3@>ricultura 9*4@er!icios 21*9@-ineria 9*3@

otros 2*1@

57@

9@

22@

9@2@

E&c$#t( D$%(rt(;$&t(! Cc-anoacura >ricultura er!icios -ineria otros



R$!i4i&$# Cr$@$&t$#Cristianis#o 33*4@otras 29*5@slanis#o 17*7@ndianis#o 13*4@udais#o 5*4@

udais#o 0*3@

Cristianis#o

otras slanis#o ndianis#oudais#o

udais#o

0*0@

5*0@

10*0@

15*0@

20*0@

25*0@

30*0@

35*0@ 33*4@29*5@

17*7@

13*4@

5*4@

0*3@

Creyentes





Documents

Ejercicio de Excel