ejercicio de excel 9 (alumnos)

Upload: dennise-bello

Post on 26-Feb-2018

218 views

Category:

Documents


0 download

TRANSCRIPT

  • 7/25/2019 Ejercicio de Excel 9 (Alumnos)

    1/5

    CAATEGORIA CURSO PRECIO

    1 MS-WINDOWS S/.1,600.00

    2MS-WORD S/.3,200.00

    3 MS-EXCEL S/.4,800.00

    4AUTOCAD S/.6,400.00

  • 7/25/2019 Ejercicio de Excel 9 (Alumnos)

    2/5

    CODIGO ALUMNO CATEGORIA CURSO PRECIO

    A0001 Cana!" La#$! %#$!na 1 MS-WINDOWS S/.1,600.00

    A0002 C&'(!) R#"*+ S+a 3 MS-EXCEL S/.4,800.00

    A0003 Pa+$#n C! Ea 2 MS-WORD S/.3,200.00

    A0004 P!!) G++ C#"#an 4 AUTOCAD S/.6,400.00

    A000 R+!" Cana#+ L5*#a 1 MS-WINDOWS S/.1,600.00

    A0006 San*&!) aa" R+$#na 4 AUTOCAD S/.6,400.00A0007 S5a!) P!a*! Saa 3 MS-EXCEL S/.4,800.00

    A0008 T+!" C&a(!) %a(#! 2 MS-WORD S/.3,200.00

    A000 !a! S++ Ma#"!a 4 AUTOCAD S/.6,400.00

    A0010 !#" Aa L5#" 1 MS-WINDOWS S/.1,600.00

    TOTAL 3,600.00

  • 7/25/2019 Ejercicio de Excel 9 (Alumnos)

    3/5

    9ORAS TOTAL

    20 :32,000.00

    30 :144,000.00

    1 :48,000.00

    80 :12,000.00

    1 :24,000.00

    20 :128,000.0030 :72,000.00

    1 :48,000.00

    20 :6,000.00

    30 :48,000.00

    27:1,12,000.00

  • 7/25/2019 Ejercicio de Excel 9 (Alumnos)

    4/5

    CODIGO;

    ALUMNO;

    CURSO;

    PRECIO;

    N< 9ORAS;

    TOTAL;

    CODIGO ALUMNO CATEGORIA CURSO PRECIO

    A0001 Cana!" La#$! %#$!na 1 MS-WINDOWS S/.1,600.00

    A0002 C&'(!) R#"*+ S+a 3 MS-EXCEL S/.4,800.00

    A0003 Pa+$#n C! Ea 2 MS-WORD S/.3,200.00A0004 P!!) G++ C#"#an 4 AUTOCAD S/.6,400.00

    A000 R+!" Cana#+ L5*#a 1 MS-WINDOWS S/.1,600.00

    A0006 San*&!) aa" R+$#na 4 AUTOCAD S/.6,400.00

    A0007 S5a!) P!a*! Saa 3 MS-EXCEL S/.4,800.00

    A0008 T+!" C&a(!) %a(#! 2 MS-WORD S/.3,200.00

    A000 !a! S++ Ma#"!a 4 AUTOCAD S/.6,400.00

    A0010 !#" Aa L5#" 1 MS-WINDOWS S/.1,600.00

    TOTAL 3,600.00

  • 7/25/2019 Ejercicio de Excel 9 (Alumnos)

    5/5

    9ORAS TOTAL

    20 :32,000.00

    30 :144,000.00

    1 :48,000.0080 :12,000.00

    1 :24,000.00

    20 :128,000.00

    30 :72,000.00

    1 :48,000.00

    20 :6,000.00

    30 :48,000.00

    27:1,12,000.00