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