libro lugo 2 luguito

9
venta de frutas del primer semestre columna 50 56 53.2 60 67.2 63.84 45 50.4 47.88 80 89.6 85.12 20 22.4 21.28 60 67.2 63.84 50 56 53.2 30 33.6 31.92 ganancias anulales de cereales enero febrero mar fresa manzana melocoton naranja pera piña platano uva 1 2 3 4 5 0 200 400 600 800 1000 Chart Title

Upload: sebastian-valencia

Post on 06-Sep-2015

24 views

Category:

Documents


0 download

DESCRIPTION

trabajo de excel tablas y formulas

TRANSCRIPT

CONTAR.SIventa de frutas del primer tremestresemestrecolumnaenerofebreromarzoabrilmayojuniototalpeso k/gpesosivap.v.pfresa505653.258.5255.59463.9331337.24711.5505.8706580.939304586.809954maximomanzana6067.263.8470.22466.712876.71972404.696521.68679.8901536108.782424576788.6725781761126.67511melocoton4550.447.8852.66850.034657.53979303.522392.1637.397019101.98352304739.38054204minimonaranja8089.685.1293.63288.9504102.29296539.595360.9485.63582477.70173184563.33755584258.19638pera2022.421.2823.40822.237625.57324134.898841.65222.58308635.61329376258.19637976pia6067.263.8470.22466.712876.71972404.696522.4971.271648155.403463681126.67511168platano505653.258.5255.59463.9331337.24710.87293.40497746.94479632340.34977332uva3033.631.9235.11233.356438.35986202.348262.16437.072241669.931558656507.003800256

ganancias anulales de cereales

producto1semestre2semestretotal anualimpuestostotal finalavena$ 120,000$ 243,500$ 363,500$ 363,500$ 1,090,500centeno$ 330,000$ 220,365$ 550,365$ 550,365$ 1,651,095maiz$ 604,258$ 7,256,241$ 7,860,499$ 7,860,499$ 23,581,497soja$ 8,954,0237,524,000$ 16,478,023$ 22,410,111$ 55,366,157trigo$ 2,547,220$ 1,254,000$ 3,801,220$ 3,801,239$ 11,403,679totales$ 12,555,501$ 16,498,106$ 29,053,607$ 34,985,714$ 93,092,928impuesto$ 4,519,980.365939318.1610459298.5212594857.19552$ 33,513,45436%$ 219,699,311nombre sexopesoABCangel sorianoM66angel sorianoM66damia lescano M98damia lescano M98fabian peredaM65fabian peredaM65fernando marquezM102fernando marquezM102jose vitaleM75jose vitaleM75juan troncosoM81juan troncosoM81mauricio mosqueraM80mauricio mosqueraM80miirta tolosaF70miirta tolosaF70monica colmenaresF53monica colmenaresF53patricia escalante F56patricia escalante F56pedro rolon M79pedro rolon M79ruben martinezM110ruben martinezM110PERONAS QUE PASAN MAS DE 70 KG7LA CANTIDAD DE HOMBRES ES9MEDICAMENTOSCATEGORIAMEDICAMENTO POR CATEGORIABISOLVONJARABENOVEMINACOMPRIMIDOCATEGORIATOTALTALIPECTINCOMPRIMIDOINYECTABLE2VITAMINA B INYECTABLECOMPROMIDO3ARBILARJARABEJARABE2REDOXONCOMPRIMIDOINSULINAINYECTABLEALUMNO MATEMATICASESPAOLFRANCESnota mayor de 95 en matematicas4CARLOS989794nota mayor de 88 en espaol5ANDRES746586nota mayor de 93 en frances 2MARTIN858887nota mayor de 95 en matematicas y espaol7DIEGO9710098cuantos alumnos sacaron menos de 100 en espaol y Frances 17SEBASTIAN979993ROBERTO798267RICARDO878279KARINA929490CARINA969589

Hoja2Valor de ventaPlazoAbonoDescuento 1Descuento 22,800,000308400001400008400005,200,00045260000026000015600004,600,00040230000023000013800003,900,0003019500001950001170000EstudianteGradoSexoAproboResultadoAna11FSINO PRESTA SERVICIO MILITARCarlos10MNONO PRESTA SERVICIO MILITARDiana11FSINO PRESTA SERVICIO MILITARIvan11MSIPRESTA SERVICIO MILITAREstudianteNota 1Nota 2Nota 3Nota FinalResultadoJuan3.23.62.23.00REGULARHugo4.14.23.53.93BUENOandres2.842.63.13BUENOCarlos4.22.52.12.93DEFICIENTEvioletta3.41.43.82.87DEFICIENTEmarcela2.323.42.57DEFICIENTEMarisol43.543.83BUENOcarolina3.84.83.84.13SOBRESALIENTE

Hoja3