Excel 1.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Excel 1.xlsx as PDF for free.
More details
- Words: 139
- Pages: 2
Legajo
nombre 1 Juan 2 Maria 3 Jose 4 Mario 5 Cecilia 6 Laura 7 Juana 8 Walter 9 Mariana 10 Pablo 11 Diana 12 Fernanda 13 Monica 14 Mauricio 15 Marco 16 Leticia
EMPRESA DE EJEMPLO Apellido Seccion Sueldo Acumulado Gomez mkt 2500 2500 Perez adm 3600 6100 Diaz vta 4500 10600 Peralta vta 5000 15600 Gonzalez vta 3900 19500 Ruiz mkt 2600 22100 Almiron mkt 3000 25100 Lopez vta 4500 29600 Garcia adm 7000 36600 Robles mkt 2500 39100 Perez adm 3600 42700 Gomez adm 8500 51200 Gonzales vta 4500 55700 Sellanes mkt 5000 60700 Baez adm 7800 68500 Gimenez mkt 9000 77500
Total: Promedio: Max Sueldo: Min Sueldo: Cantidad:
77500 4843.75 9000 2500 16
SUMAR RESTA PROMEDIO MAXIMO VALOR MINIMO VALOR CONTAR CANTIDAD DE CELDAS
"=SUMA(SELECCIONAR CELDAS)" "=(CELDA-CELDA)" "=PROMEDIO(SELECCIONAR CELDAS)" "=MAX(SELECCIONAR CELDAS)" "MIN(SELECCIONAR CELDAS)" "CONTARA(SELECCIONAR CELDAS)"
nombre 1 Juan 2 Maria 3 Jose 4 Mario 5 Cecilia 6 Laura 7 Juana 8 Walter 9 Mariana 10 Pablo 11 Diana 12 Fernanda 13 Monica 14 Mauricio 15 Marco 16 Leticia
EMPRESA DE EJEMPLO Apellido Seccion Sueldo Acumulado Gomez mkt 2500 2500 Perez adm 3600 6100 Diaz vta 4500 10600 Peralta vta 5000 15600 Gonzalez vta 3900 19500 Ruiz mkt 2600 22100 Almiron mkt 3000 25100 Lopez vta 4500 29600 Garcia adm 7000 36600 Robles mkt 2500 39100 Perez adm 3600 42700 Gomez adm 8500 51200 Gonzales vta 4500 55700 Sellanes mkt 5000 60700 Baez adm 7800 68500 Gimenez mkt 9000 77500
Total: Promedio: Max Sueldo: Min Sueldo: Cantidad:
77500 4843.75 9000 2500 16
SUMAR RESTA PROMEDIO MAXIMO VALOR MINIMO VALOR CONTAR CANTIDAD DE CELDAS
"=SUMA(SELECCIONAR CELDAS)" "=(CELDA-CELDA)" "=PROMEDIO(SELECCIONAR CELDAS)" "=MAX(SELECCIONAR CELDAS)" "MIN(SELECCIONAR CELDAS)" "CONTARA(SELECCIONAR CELDAS)"
Related Documents
Excel
November 2019 4
Excel
November 2019 5
Excel
October 2019 18
Excel
May 2020 7
Excel
November 2019 21
Excel
May 2020 8More Documents from ""
Excel 1.xlsx
October 2019 12
3ero Tp Word.docx
October 2019 18
1er Trabajo Word
October 2019 12
2do Tp Word.docx
October 2019 14
8vo Tp Word.docx
October 2019 13