{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Go To Special","COUNTBLANK","COUNTIF","Conditional Formatting","ISBLANK","FIND","FILTER","First_Blank_1","First_Blank_VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Go To Special","index":0,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Go To Special Dialogue Box "]
[]
[null,"Student","Monday","Tuesday","Wednesday"]
[null,"John","Present",null,"Present"]
[null,"Lisa",null,"Present"]
[null,"Chris","Present","Present"]
[null,"Tony",null,"Present","Present"]
[null,"Jessica",null,null,"Present"]

{"sheet":"COUNTBLANK","index":1,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[10,1,10,2],[1,6,1,9],[10,6,10,7]]}
[]
[null,"Use of COUNTBLANK Function",null,null,null,null,"Practice Yourself"]
[]
[null,"Student","Monday","Tuesday","Wednesday",null,"Student","Monday","Tuesday","Wednesday"]
[null,"John","Present",null,"Present",null,"John","Present",null,"Present"]
[null,"Lisa",null,"Present",null,null,"Lisa",null,"Present"]
[null,"Chris","Present","Present",null,null,"Chris","Present","Present"]
[null,"Tony",null,"Present","Present",null,"Tony",null,"Present","Present"]
[null,"Jessica",null,null,"Present",null,"Jessica",null,null,"Present"]
[]
[null,"Number of Blank Cells",null,{"$f":"COUNTBLANK(B4:E9)","v":7},null,null,"Number of Blank Cells"]

{"sheet":"COUNTIF","index":2,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[10,1,10,2],[1,6,1,9],[10,6,10,7]]}
[]
[null,"Use of COUNTIF Function",null,null,null,null,"Practice Yourself"]
[]
[null,"Student","Monday","Tuesday","Wednesday",null,"Student","Monday","Tuesday","Wednesday"]
[null,"John","Present",null,"Present",null,"John","Present",null,"Present"]
[null,"Lisa",null,"Present",null,null,"Lisa",null,"Present"]
[null,"Chris","Present","Present",null,null,"Chris","Present","Present"]
[null,"Tony",null,"Present","Present",null,"Tony",null,"Present","Present"]
[null,"Jessica",null,null,"Present",null,"Jessica",null,null,"Present"]
[]
[null,"Number of Blank Cells",null,{"$f":"COUNTIF(B4:E9,\"\")","v":7},null,null,"Number of Blank Cells"]

{"sheet":"Conditional Formatting","index":3,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Apply Conditional Formatting",null,null,null,null,"Practice Yourself"]
[]
[null,"Student","Monday","Tuesday","Wednesday",null,"Student","Monday","Tuesday","Wednesday"]
[null,"John","Present",null,"Present",null,"John","Present",null,"Present"]
[null,"Lisa",null,"Present",null,null,"Lisa",null,"Present"]
[null,"Chris","Present","Present",null,null,"Chris","Present","Present"]
[null,"Tony",null,"Present","Present",null,"Tony",null,"Present","Present"]
[null,"Jessica",null,null,"Present",null,"Jessica",null,null,"Present"]

{"sheet":"ISBLANK","index":4,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Use of ISBLANK Function",null,null,null,"Practice Yourself"]
[]
[null,"Student","Monday","Result",null,"Student","Monday","Result"]
[null,"John","Present",{"$f":"ISBLANK(C5)","v":false},null,"John","Present",{"$f":"ISBLANK(G5)","v":false}]
[null,"Lisa",null,{"$f":"ISBLANK(C6)","v":true},null,"Lisa",null,{"$f":"ISBLANK(G6)","v":true}]
[null,"Chris","Present",false,null,"Chris","Present",false]
[null,"Tony",null,true,null,"Tony",null,true]
[null,"Jessica",null,true,null,"Jessica",null,true]

{"sheet":"FIND","index":5,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Find Option"]
[]
[null,"Student","Monday","Tuesday","Wednesday"]
[null,"John","Present",null,"Present"]
[null,"Lisa",null,"Present"]
[null,"Chris","Present","Present"]
[null,"Tony",null,"Present","Present"]
[null,"Jessica",null,null,"Present"]

{"sheet":"FILTER","index":6,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Apply Filter Option",null,null,null,null,"Practice Yourself"]
[]
[null,"Student","Monday","Tuesday","Wednesday",null,"Student","Monday","Tuesday","Wednesday"]
[null,"John","Present",null,"Present",null,"John","Present",null,"Present"]
[null,"Lisa",null,"Present",null,null,"Lisa",null,"Present"]
[null,"Chris","Present","Present",null,null,"Chris","Present","Present"]
[null,"Tony",null,"Present","Present",null,"Tony",null,"Present","Present"]
[null,"Jessica",null,null,"Present",null,"Jessica",null,null,"Present"]

{"sheet":"First_Blank_1","index":7,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2],[8,4,8,5],[1,8,1,9],[8,11,8,12]]}
[]
[null,"Find First Blank Cell",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Student","Marks",null,null,null,null,null,"Student","Marks"]
[null,"John",80,null,null,null,null,null,"John",80]
[null,"Lisa",85,null,null,null,null,null,"Lisa",85]
[null,"Chris",84,null,null,null,null,null,"Chris",84]
[null,"Tony",null,null,null,null,null,null,"Tony"]
[null,"Jessica",82,null,"First Blank  Cell",null,{"$f":"MIN(IF(C4:C15=\"\",ROW(C4:C15)))","v":8},null,"Jessica",82,null,"First Blank  Cell"]
[null,"Ethan",88,null,null,null,null,null,"Ethan",88]
[null,"Natasha",92,null,null,null,null,null,"Natasha",92]
[null,"Roy",null,null,null,null,null,null,"Roy"]
[null,"Emma",null,null,null,null,null,null,"Emma"]
[null,"Robert",75,null,null,null,null,null,"Robert",75]
[null,"Ava",79,null,null,null,null,null,"Ava",79]

{"sheet":"First_Blank_VBA","index":8,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"USE of VBA "]
[]
[null,"Student","Marks"]
[null,"John",80]
[null,"Lisa",85]
[null,"Chris",84]
[null,"Tony"]
[null,"Jessica",82]
[null,"Ethan",88]
[null,"Natasha",92]
[null,"Roy"]
[null,"Emma"]
[null,"Robert",75]
[null,"Ava",79]