{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["CARATULA","Ejercicios"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"CARATULA","index":0,"n_rows":36,"n_cols":1,"rows_kept":36,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
{"$rows_empty":17}
["Año       :          “Año de la Consolidación del Mar de Grau”"]
[]
[]
["Curso :  "]
[]
[]
["Unidad : "]
[]
["Nombre del Tutor:"]
[]
["Nombres y apellidos del participante:"]
[]
["Empresa/ actividad:"]
[]
["Cargo :"]
[]
["Sede: SENATI…."]
[]
["Fecha  : "]

{"sheet":"Ejercicios","index":1,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[[9,2,9,4]],"flags":["formulas_cached_only"]}
["Ejercicio"]
["- En esta práctica aplicar la función BUSCARV."]
["- Debe escribir un código válido (según tabla Ventas)"]
["- Para obtener el nombre del empleado indique la fórmula: =BUSCARV(I12,A12:E23,2)",{"$nulls":7},"Emplear la función BUSCARV"]
["- Resuelva los demas ejercicios.",{"$nulls":7},"=BUSCARV(VALOR_BUSCADO;TABLA;COLUMNA;[ORDENADO])"]
[]
[]
[]
[null,"VENTAS"]
[null,null,"MONTOS DE VENTAS",{"$nulls":4},"Reporte de Ventas:"]
["CODIGO","EMPLEADO","ENERO","FEBRERO","MARZO"]
["C-001","ALIAGA, JUAN",3000,3200,3500,null,null,"Código"]
["C-002","ALVAREZ, VICTOR",2063,2200,2650,null,null,"Empleado"]
["C-003","BALSERA, MANUEL",1300,1500,2603,null,null,"Montos de Ventas"]
["C-004","BEDIA, SERGIO",1250,1300,2302,null,null,"Enero",null,null,null,"Aquí debes emplear BUSCARV"]
["C-005","CASTILLO, ELVIS",1800,2000,2400,null,null,"Febrero",null,null,null,"Aquí debes emplear BUSCARV"]
["C-006","FLOREZ, MARIA ELENA",3000,2500,2600,null,null,"Marzo",null,null,null,"Aquí debes emplear BUSCARV"]
["C-007","HERNANDEZ,  SANDRO ",2060,2300,2520]
["C-008","HUAMAN, ADRIAN",2500,2300,2500,null,null,"Monto Total",null,null,null,"Aquí debes emplear SUMA"]
["C-009","JUAREZ, PAOLA CECILIA",4200,4500,5200]
["C-010","LAZARTE, HENRY",2300,2500,2650]
["C-011","NAJARRO, HUMBERTO",3510,3800,4300]
["C-012","VILLEGAS, MARTHA",1500,2000,2300]