EJERCICIO 111EXCELEXCEL2007EXCEL 20073/11/153/11/1512EXCELEXCEL2008EXCEL 20073/12/153/11/1513EXCELEXCEL2009EXCEL 20073/13/153/11/1514EXCELEXCEL2010EXCEL 20073/14/153/11/1515EXCELEXCEL2011EXCEL 20073/15/153/11/15Conclusiones: Al aplicar el controlador de relleno sin ninguna tecla alterna,se modifica absolutamente cada celda. Eje: Excel 2007,Excel 2008,Excel 2009Y al aplicar contolador de relleno con Control,no se modifica las celdas.

EJERCICIO 2EXCEL2007EXCEL2007EXCEL2007EXCEL2007EXCEL2007EXCEL2007EXCEL2007EXCEL2007EXCEL2007EXCEL2007Conclusiones: Lo que se escribio en la celda A1, paso a las demas celdas seleccionadas desde la celda hasta el rango B5. Asi: A1:B5

EJERCICIO 3SUMA 2350134501433432389477732582RESTA93778567645698613287MULTIPLICACION 23123249962071183104DIVISION 4695.11111111113451523

EJERCICIO 4CRECIMIENTO NATURAL DE COLOMBIA TASAS200720082009201020112012NATALIDAD20.1619.8619.5717.7617.4917.23MORTALIDAD5.545.545.545.245.265.29CRECIMIENTO NATURAL 14.6214.3214.0312.5212.2311.94

EJERCICIO 5CANTIDADPRODUCTOPRECIO UNITARIOPRECIO TOTAL 56LAPICEROS890$ 49,84090CARPETAS710$ 63,90030RESMAS12450$ 373,50078MARCADOR1540$ 120,120

EJERCICIO 6ARTICULOSDESCRIPCIONCANTIDAD VENDIDAPRECIO UNITARIOSUBTOTALIVATOTALAR1BLOCK45$ 2,500$ 112,500$ 18,000$ 130,500AR2PORTAMINAS32$ 4,850$ 155,200$ 24,832$ 180,032AR3TINTA145$ 18,000$ 2,610,000$ 417,600$ 3,027,600AR4CUADERNO67$ 11,500$ 770,500$ 123,280$ 893,780

EJERCICIO 7VENTAS DEL DIATOTALESFERRETERIAPAPELERIAVARIOSDIASCONTADOTARJETACONTADOTARJETACONTADOTARJETACONTADOTARJETATOTAL POR DIA1$ 465,234$ 135,987$ 250,130$ 450,890$ 355,670$ 301,890$ 1,071,034$ 888,767$ 1,959,8012$ 846,345$ 287,970$ 375,280$ 816,370$ 480,236$ 656,620$ 1,701,861$ 1,760,960$ 3,462,8213$ 648,710$ 189,670$ 510,890$ 268,490$ 89,470$ 854,770$ 1,249,070$ 1,312,930$ 2,562,0004$ 918,930$ 996,410$ 994,460$ 782,350$ 589,360$ 570,250$ 2,502,750$ 2,349,010$ 4,851,7605$ 334,511$ 444,460$ 214,220$ 16,940$ 569,320$ 440,410$ 1,118,051$ 901,810$ 2,019,8616$ 485,340$ 698,550$ 635,690$ 288,190$ 549,480$ 617,450$ 1,670,510$ 1,604,190$ 3,274,7007$ 182,470$ 244,430$ 831,950$ 820,930$ 547,620$ 428,310$ 1,562,040$ 1,493,670$ 3,055,7108$ 629,370$ 253,620$ 14,540$ 382,790$ 545,030$ 226,360$ 1,188,940$ 862,770$ 2,051,7109$ 517,970$ 204,170$ 319,780$ 735,520$ 583,390$ 683,900$ 1,421,140$ 1,623,590$ 3,044,73010$ 790,080$ 559,100$ 141,320$ 128,570$ 258,330$ 322,750$ 1,189,730$ 1,010,420$ 2,200,15011$ 910,250$ 731,370$ 286,307$ 350,790$ 294,340$ 539,150$ 1,490,897$ 1,621,310$ 3,112,20712$ 233,990$ 242,970$ 463,430$ 559,660$ 626,580$ 812,060$ 1,324,000$ 1,614,690$ 2,938,69013$ 404,920$ 947,560$ 231,450$ 723,360$ 334,390$ 253,840$ 970,760$ 1,924,760$ 2,895,52014$ 159,820$ 852,320$ 845,680$ 632,550$ 444,130$ 843,350$ 1,449,630$ 2,328,220$ 3,777,85015$ 928,220$ 247,590$ 799,530$ 404,090$ 797,850$ 852,270$ 2,525,600$ 1,503,950$ 4,029,550TOTALES$ 8,456,160$ 7,036,177$ 6,914,657$ 7,361,490$ 7,065,196$ 8,403,380

EJERCICIO 8INFORME DEL PRIMER SEMESTREPERIODOINGRESOSEGRESOSSALDOENERO$ 2,323,325$ 897,778$ 1,425,547FEBRERO$ 3,423,423$ 678,787$ 2,744,636MARZO$ 1,567,676$ 698,097$ 869,579ABRIL$ 3,579,898$ 789,789$ 2,790,109MAYO$ 4,762,344$ 942,300$ 3,820,044JUNIO$ 3,768,788$ 835,400$ 2,933,388TOTAL DEL PRIMER TRIMESTRE$ 14,583,303

COMISION$ 874,998.18

EJERCICIO 9100.1745329252