2.2 cervantes juancarlos exa practico excel
TRANSCRIPT
Hoja1SUMA PRODUCTOPRECIOTELEVISIN$4,000.00STEREO$2,500CELDAS$3,000BICICLETA1,800RANGOS DE CELDAS$24,100.00COMPUTADORA$5,000CELULAR$7,000TABLET$500IMPRESORA$3,300SUMAR.SIVENDEDORMESVENTASJUANENERO$6,583.00VENDEDOR:JUANALBERTOENERO$6,536.00VENTAS:20259VALERIAENERO$7,017.00JUANFEBRERO$6,245.00MES:FEBREROALBERTOFEBRERO$6,573.00VENTAS:19399VALERIAFEBRERO$6,581.00JUANMARZO$7,431.00ALBERTOMARZO$7,057.00VALERIAMARZO$8,797.00CONTAR$2,679.005ABC$2,933.00DEF$1,104.00GHIJKL$1,227.00MNO$4,569.00CONTAR.SIPRODUCTOCOLORCAMISABLANCONEGRO3PANTALONAZULZAPATOSCAFCINTURON NEGROCORBATAGRISCAMISANEGROPANTALONNEGROPROMEDIOMATEMATICAS8.5ESPAOL9FISICA8QUIMICA7.5PROMEDIO8.4142857143INFORMATICA8HISTORIA8.6GEOGRAFIA9.3 PROMEDIO.SISUCURSALMESINGRESOSEGRESOSPROMEDIO.SINORTEENERO$84,462.00$52,829.0067562.6666666667SURENERO$86,917.00$41,424.00ESTEENERO$58,445.00$51,625.00OESTEENERO$87,225.00$37,675.00NORTEFEBRERO$64,170.00$96,280.00SURFEBRERO$53,760.00$51,534.00ESTEFEBRERO$52,260.00$52,723.00OESTEFEBRERO$52,425.00$36,312.00NORTEMARZO$63,038.00$37,453.00SURMARZO$86,791.00$50,249.00ESTEMARZO$88,458.00$41,379.00OESTEMARZO$65,018.00$40,566.00 MAX8338125173MAX1278149814296167969889394546631896MIN1448522055MIN3623355456878689899010024SUBTOTALES255552.15092534573581951MANEJO DE GRAFICASSUCURSALMESINGRESOSEGRESOSNORTEENERO$84,462.00$52,829.00SURENERO$86,917.00$41,424.00ESTEENERO$58,445.00$51,625.00OESTEENERO$87,225.00$37,675.00NORTEFEBRERO$64,170.00$96,280.00SURFEBRERO$53,760.00$51,534.00ESTEFEBRERO$52,260.00$52,723.00OESTEFEBRERO$52,425.00$36,312.00NORTEMARZO$63,038.00$37,453.00SURMARZO$86,791.00$50,249.00ESTEMARZO$88,458.00$41,379.00OESTEMARZO$65,018.00$40,566.00
Hoja2
Hoja3