TUTORIAL1curso basicofechatelefonoluzaguatotalexcelJan-1230.00 20.00 50.00 Feb-1235.00 10.00 27.00 72.00 Mar-1240.00 15.00 55.00 Apr-1230.00 18.00 20.00 68.00 May-1220.00 20.00 40.00 Jun-1232.00 21.00 53.00 #recibos653suma187.00 83.00 68.00 max40.00 20.00 27.00 min20.00 10.00 20.00 promedio31.17 16.60 11.33
Hoja2ILDEFONSOJUAN PABLONICOLASMARIA
Hoja3241015354820307061230451058164060140102050751751224609021014287010524516328012028018369013531520401001503502244110165385244812018042026521301954552856140210490306015022552532641602405603468170255595367218027063038761902856654080200300700
Hoja7500300SUMA800500200RESTA300300300MULTIPLICACION90000100010DIVISION100
Hoja8promedios67.58164matematicasidiomacienciassociales89.75CARLOS608010030JUAN78799077MATEO90406066LUCY100809089
PROMEDIOS Y GRAFICOS
Hoja9ANACARLOSFLORJUANAMARIAMAVINSUSANA
ORDENAR NOMBRES
Hoja102002225096VALOR MINIMO23004010040014077700150588910067677890386524VALOR MAXIMO700
MEDIANA77.5
MODA2
Hoja11$ 100.00$ 700.00$ 800.00$ 900.00SUMA TOTAL$ 600.00$ 755.00$ 900.00$ 88.00$ 456.00$ 788.00$ 456.00$ 900.00$ 800.00$ 478.00$ 876.00$ 2,167.00$ 11,764.00
CONVERSION DE NUMERO A DOLARES
Hoja12FECHATELEFONOLUZAGUASUMA TOTALJan-13$ 400.00$ 100.00$ 500.00Feb-13$ 300.00$ 400.00$ 30.00$ 730.00Mar-13$ 100.00$ 900.00$ 1,000.00Apr-13$ 200.00$ 500.00$ 20.00$ 720.00May-13$ 150.00$ 600.00$ 750.00Jun-13$ 190.00$ 400.00$ 60.00$ 650.00$ 4,350.00#DE RECIBOS663#SUMA TOTAL$ 1,340.00$ 2,900.00$ 110.00RECIBO MAS ALTO$ 400.00$ 900.00$ 60.00RECIBO MAS BAJO$ 100.00$ 100.00$ 20.00
GASTOS Y PRESUPUESTOS DE DON LUIS
Hoja1
Hoja4
Hoja5
BUSCADOR DE DATOS
Hoja6fecha inicialfecha finalaosmesesdias7/5/7011/26/15454212/3/5011/28/15657892403910/3/8211/29/1533397121108/6/8511/30/153036311073
Hoja13ARTICULOPRECIO DE VENTACOSTE TOTALBENEFICIOIMPUESTOR5T5256,458 12,564 243,894 51,218 L98I125,456 25,654 99,802 20,958 8IU7156,458 25,412 131,046 27,520 8IJU456,125 15,458 440,667 92,540 K8I9125,879 45,269 80,610 16,928 99JU456,878 12,564 444,314 93,306 67HY325,654 26,548 299,106 62,812 PP09658,944 54,872 604,072 126,855
Hoja14
nombreyapellidomariomenesescampolyacamposrodrigueaclaudiapayarescastillogustavogutierresvergara
nombre
Hoja15nombrefecha de nacimientopeso(Kg)lina Campo7/26/0423abhan lamadrit8/7/0035jesus carransa4/12/0133natalia soto6/23/0125juan jimenes3/1/0023victor gomez7/5/0034