{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Logical","IF Func.","COUNTIF","SUMIF","AVERAGEIF","Format ","VBA"],"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":"Logical","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Logical Operator"]
[]
[null,"Names","Marks","Status"]
[null,"James Smith",81,{"$f":"C5>80","v":true}]
[null,"Maria Garcia",79,{"$f":"C6>80","v":false}]
[null,"Maria Rodriguez",85,true]
[null,"Mary Smith",52,false]
[null,"David Smith",74,false]
[null,"Maria Hernandez",56,false]
[null,"James Johnson",89,true]

{"sheet":"IF Func.","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use the OR Function"]
[]
[null,"Names","Marks","Status"]
[null,"James Smith",81,{"$f":"IF(C5>80,\"Passed\",\"Failed\")","v":"Passed"}]
[null,"Maria Garcia",79,{"$f":"IF(C6>80,\"Passed\",\"Failed\")","v":"Failed"}]
[null,"Maria Rodriguez",85,"Passed"]
[null,"Mary Smith",52,"Failed"]
[null,"David Smith",74,"Failed"]
[null,"Maria Hernandez",56,"Failed"]
[null,"James Johnson",89,"Passed"]

{"sheet":"COUNTIF","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,1,12,2],[1,1,1,2]]}
[]
[null," Use the COUNTIF Function"]
[]
[null,"Names","Marks"]
[null,"James Smith",81]
[null,"Maria Garcia",79]
[null,"Maria Rodriguez",85]
[null,"Mary Smith",52]
[null,"David Smith",74]
[null,"Maria Hernandez",56]
[null,"James Johnson",89]
[]
[null,"Person Numbers Marks Greater Than 80",null,{"$f":"COUNTIF(C5:C11,\">\"&80)","v":3}]

{"sheet":"SUMIF","index":3,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null," Use the COUNTIF Function"]
[]
[null,"Names","Marks"]
[null,"Mathmatics",81]
[null,"Biology",79,null,"Sum If Marks > 60",{"$f":"SUMIF($C$5:$C$11,\">\"&60,$C$5:$C$11)","v":408}]
[null,"Physics",85]
[null,"History",52]
[null,"English",74]
[null,"Statistics",56]
[null,"Chemistry",89]

{"sheet":"AVERAGEIF","index":4,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,1,12,3],[1,1,1,4]]}
[]
[null," Use the COUNTIF Function"]
[]
[null,"Names","Term 1","Term 2","Average"]
[null,"Mathmatics",81,82,{"$f":"AVERAGE(C5,D5)","v":81.5}]
[null,"Biology",79,81,{"$f":"AVERAGE(C6,D6)","v":80}]
[null,"Physics",85,93,89]
[null,"History",52,45,48.5]
[null,"English",74,65,69.5]
[null,"Statistics",56,69,62.5]
[null,"Chemistry",89,78,83.5]
[]
[null,"Average if Average Marks > 80",null,null,{"$f":"AVERAGEIF(C5:C11,\">80\",D5:D11)","v":84.333333333333329}]

{"sheet":"Format ","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Names","Marks",null,"Names","Marks"]
[null,"James Smith",81,null,"James Smith",81]
[null,"Maria Garcia",79,null,"Maria Garcia",79]
[null,"Maria Rodriguez",85,null,"Maria Rodriguez",85]
[null,"Mary Smith",52,null,"Mary Smith",52]
[null,"David Smith",74,null,"David Smith",74]
[null,"Maria Hernandez",56,null,"Maria Hernandez",56]
[null,"James Johnson",89,null,"James Johnson",89]

{"sheet":"VBA","index":6,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"Names","Marks","Results"]
[null,"Mathmatics",81,"Passed"]
[null,"Biology",79]
[null,"Physics",85]
[null,"History",52,null,null,null,10]
[null,"English",74,null,null,null,30]
[null,"Statistics",56,null,null,null,10]
[null,"Chemistry",89,null,null,null,20]
[null,null,null,null,null,null,20]