computo para puntos.xlsx

Upload: daniel-reyes

Post on 14-Oct-2015

44 views

Category:

Documents


0 download

TRANSCRIPT

Hoja1

alumnosfisicamatematicasquimicafilosofiapromedioBONT1010899.25DELI910598.25JUAN CARLOS 510546LUNA 9108109.25MANUEL1010101010SONIA910978.75MIGUEL10101099.75PROMEDIO8.8571428571107.85714285718.28571428578.75PROMEDIO GENERAL1.26530612241.42857142861.12244897961.18367346941.25MIN.510541.25MAX.1010101010

&G&G

PROMEDIO PROMEDIO GENERALFUNCION SI SACA< 6 APRUEBA COLOR VERDE FUNCION SI< REPRUEBA COLOR ROJOSACAR MAXIMO Y MINIMOORDENAR LOS NOMBRES ALFABETICAMENTE SACAR lA GRAFICA DE BARRA DE PROMEDIO Y ETIQUETAR CADA PUNTO DE LA GRAFICA

Hoja2PROFESIONMUJERESHOMBRETOTALDLARENFERMERO700500$1,200.00$16,800.00SECRETARIO300600$900.00$12,600.00INGENIERO300300$600.00$8,400.00OFICIAL140200$340.00$4,760.00PROFESOR500600$1,100.00$15,400.00PUBLISISTA400700$1,100.00$15,400.00JUEZ500900$1,400.00$19,600.00DOCTOR400700$1,100.00$15,400.00TOTAL32404500$7,740.00$108,360.00PROMEDIO405500$1,720.00$24,080.00

MEDIA COTADA688.5950$1,720.00$24,080.00

FUNCION SI >1000 VERDE FUNCION SI < 1000 MORADOSACAR SUMATORIA SACAR PROMEDIO MEDIA. ACOT.

Hoja3DECIMALBINARIOHEXADECIMALOCTAL11112102230113340100445001015560001106670000111778000010008109000001001911100000001010A12111011B13121100C14131101D15141110E16151111F1716100001020171000111211810010122200

DECIMAL A BINARIO BINARIO A HEXADECIMALHEXADECIMAL A ACTAL.

Hoja4