{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Use of Name Box","Applying ADDRESS Function","Using Special Charater","CELL and ADDRESS Functions","Use of Macros"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"Dataset","index":0,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Copying Cell Address"]
[]
[null,"Student ID","Math","English","Total "]
[null,22001,79,91,{"$f":"C5+D5","v":170}]
[null,22002,95,84,{"$f":"C6+D6","v":179}]
[null,22003,96,66,162]
[null,22004,92,67,159]
[null,22005,91,65,156]
[null,22006,70,91,161]

{"sheet":"Use of Name Box","index":1,"n_rows":10,"n_cols":18,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,11,1,17]]}
[]
[null,"Use of Name Box",null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Student ID","Math","English","Total ",null,"Total ","Cell Address",null,null,null,"Student ID","Math","English","Total ",null,"Total ","Cell Address"]
[null,22001,79,91,{"$f":"C5+D5","v":170},null,{"$f":"E5","v":170},"E5",null,null,null,22001,79,91,{"$f":"M5+N5","v":170},null,{"$f":"O5","v":170}]
[null,22002,95,84,{"$f":"C6+D6","v":179},null,{"$f":"E6","v":179},"E6",null,null,null,22002,95,84,{"$f":"M6+N6","v":179},null,{"$f":"O6","v":179}]
[null,22003,96,66,162,null,162,"E7",null,null,null,22003,96,66,162,null,162]
[null,22004,92,67,159,null,159,"E8",null,null,null,22004,92,67,159,null,159]
[null,22005,91,65,156,null,156,"E9",null,null,null,22005,91,65,156,null,156]
[null,22006,70,91,161,null,161,"E10",null,null,null,22006,70,91,161,null,161]

{"sheet":"Applying ADDRESS Function","index":2,"n_rows":10,"n_cols":19,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,12,1,18]]}
[]
[null,"Applying ADDRESS Function",null,null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Student ID","Math","English","Total ",null,"Total ","Cell Address",null,null,null,null,"Student ID","Math","English","Total ",null,"Total ","Cell Address"]
[null,22001,79,91,{"$f":"C5+D5","v":170},null,{"$f":"E5","v":170},{"$f":"ADDRESS(ROW(E5),COLUMN(E5),4)","v":"E5"},null,null,null,null,22001,79,91,{"$f":"N5+O5","v":170},null,{"$f":"P5","v":170}]
[null,22002,95,84,{"$f":"C6+D6","v":179},null,{"$f":"E6","v":179},{"$f":"ADDRESS(ROW(E6),COLUMN(E6),4)","v":"E6"},null,null,null,null,22002,95,84,{"$f":"N6+O6","v":179},null,{"$f":"P6","v":179}]
[null,22003,96,66,162,null,162,"E7",null,null,null,null,22003,96,66,162,null,162]
[null,22004,92,67,159,null,159,"E8",null,null,null,null,22004,92,67,159,null,159]
[null,22005,91,65,156,null,156,"E9",null,null,null,null,22005,91,65,156,null,156]
[null,22006,70,91,161,null,161,"E10",null,null,null,null,22006,70,91,161,null,161]

{"sheet":"Using Special Charater","index":3,"n_rows":10,"n_cols":19,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,12,1,18]]}
[]
[null,"Using Special Character ",null,null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Student ID","Math","English","Total ",null,"Total ","Cell Address",null,null,null,null,"Student ID","Math","English","Total ",null,"Total ","Cell Address"]
[null,22001,79,91,{"$f":"C5+D5","v":170},null,{"$f":"E5","v":170},"E5",null,null,null,null,22001,79,91,{"$f":"N5+O5","v":170},null,{"$f":"P5","v":170}]
[null,22002,95,84,{"$f":"C6+D6","v":179},null,{"$f":"E6","v":179},"E6",null,null,null,null,22002,95,84,{"$f":"N6+O6","v":179},null,{"$f":"P6","v":179}]
[null,22003,96,66,162,null,162,"E7",null,null,null,null,22003,96,66,162,null,162]
[null,22004,92,67,159,null,159,"E8",null,null,null,null,22004,92,67,159,null,159]
[null,22005,91,65,156,null,156,"E9",null,null,null,null,22005,91,65,156,null,156]
[null,22006,70,91,161,null,161,"E10",null,null,null,null,22006,70,91,161,null,161]

{"sheet":"CELL and ADDRESS Functions","index":4,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,11,1,16],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,15,4,15],[3,16,4,16],[1,1,1,6],[3,5,4,5],[3,6,4,6],[3,1,4,1],[3,2,4,2],[3,3,4,3]]}
[]
[null,"Employing CELL and ADDRESS Functions",null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Month","Cost","Profit",null,"Cell Address of Profit","Sales",null,null,null,null,"Month","Cost","Profit",null,"Cell Address of Profit","Sales"]
[]
[null,"January",2000,{"$f":"C6*20%","v":400},null,{"$f":"CELL(\"address\",D6)","v":"$D$6"},{"$f":"$D$6+C6","v":2400},null,null,null,null,"January",2000,{"$f":"M6*20%","v":400}]
[null,"February",2300,460,null,{"$f":"CELL(\"address\",D7)","v":"$D$7"},{"$f":"$D$7+C7","v":2760},null,null,null,null,"February",2300,460]
[null,"March",1800,360,null,{"$f":"CELL(\"address\",D8)","v":"$D$8"},{"$f":"$D$8+C8","v":2160},null,null,null,null,"March",1800,360]
[null,"April",2500,500,null,{"$f":"CELL(\"address\",D9)","v":"$D$9"},{"$f":"$D$9+C9","v":3000},null,null,null,null,"April",2500,500]
[null,"May",1600,320,null,{"$f":"CELL(\"address\",D10)","v":"$D$10"},{"$f":"$D$10+C10","v":1920},null,null,null,null,"May",1600,320]
[null,"June",2100,420,null,{"$f":"CELL(\"address\",D11)","v":"$D$11"},{"$f":"$D$11+C11","v":2520},null,null,null,null,"June",2100,420]

{"sheet":"Use of Macros","index":5,"n_rows":10,"n_cols":19,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,12,1,18]]}
[]
[null,"Use of Macros",null,null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"Student ID","Math","English","Total ",null,"Total ","Cell Address",null,null,null,null,"Student ID","Math","English","Total ",null,"Total ","Cell Address"]
[null,22001,79,91,{"$f":"C5+D5","v":170},null,{"$f":"E5","v":170},"$E$5",null,null,null,null,22001,79,91,{"$f":"N5+O5","v":170},null,{"$f":"P5","v":170}]
[null,22002,95,84,{"$f":"C6+D6","v":179},null,{"$f":"E6","v":179},"$E$6",null,null,null,null,22002,95,84,{"$f":"N6+O6","v":179},null,{"$f":"P6","v":179}]
[null,22003,96,66,162,null,162,"$E$7",null,null,null,null,22003,96,66,162,null,162]
[null,22004,92,67,159,null,159,"$E$8",null,null,null,null,22004,92,67,159,null,159]
[null,22005,91,65,156,null,156,"$E$9",null,null,null,null,22005,91,65,156,null,156]
[null,22006,70,91,161,null,161,"$E$10",null,null,null,null,22006,70,91,161,null,161]