{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Select Range","COUNTBLANK","Sorting","VBA","LSI 1","LSI 2"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"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":"Select Range","index":0,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,8,1,9],[1,1,1,2]]}
[]
[null,"Selecting Whole Range",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Item","Price",null,null,null,null,null,"Item","Price"]
[null,"Lemon",0.54,null,null,null,null,null,"Lemon",0.54]
[null,"Orange",1.45,null,null,null,null,null,"Orange",1.45]
[null,"Apple",4.76,null,null,null,null,null,"Apple",4.76]
[null,"Avocado",2.62,null,null,null,null,null,"Avocado",2.62]
[]
[null,"Banana",1.28,null,null,null,null,null,"Banana",1.28]

{"sheet":"COUNTBLANK","index":1,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Using COUNTBLANK Function",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Item","Price","No. of Blank Cells",null,null,null,null,null,"Item","Price","No. of Blank Cells"]
[null,"Lemon",0.54,{"$f":"COUNTBLANK(B5:C5)","v":0},null,null,null,null,null,"Lemon",0.54]
[null,"Orange",1.45,{"$f":"COUNTBLANK(B6:C6)","v":0},null,null,null,null,null,"Orange",1.45]
[null,"Apple",4.76,0,null,null,null,null,null,"Apple",4.76]
[null,"Avocado",2.62,0,null,null,null,null,null,"Avocado",2.62]
[null,null,null,2]
[null,"Banana",1.28,0,null,null,null,null,null,"Banana",1.28]

{"sheet":"Sorting","index":2,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Sorting Data",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Item","Price",null,null,null,null,null,null,null,null,"Item","Price"]
[null,"Apple",4.76,null,null,null,null,null,null,null,null,"Apple",4.76]
[null,"Avocado",2.62,null,null,null,null,null,null,null,null,"Avocado",2.62]
[null,"Banana",1.28,null,null,null,null,null,null,null,null,"Banana",1.28]
[null,"Lemon",0.54,null,null,null,null,null,null,null,null,"Lemon",0.54]
[null,"Orange",1.45,null,null,null,null,null,null,null,null,"Orange",1.45]

{"sheet":"VBA","index":3,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Appying VBA Code",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Item","Price",null,null,null,null,null,null,"Item","Price"]
[null,"Lemon",0.54,null,null,null,null,null,null,"Lemon",0.54]
[null,"Orange",1.45,null,null,null,null,null,null,"Orange",1.45]
[null,"Apple",4.76,null,null,null,null,null,null,"Apple",4.76]
[null,"Avocado",2.62,null,null,null,null,null,null,"Avocado",2.62]
[]
[null,"Banana",1.28,null,null,null,null,null,null,"Banana",1.28]

{"sheet":"LSI 1","index":4,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[7,1,8,1],[7,2,8,2],[1,9,1,10],[7,9,8,9],[7,10,8,10]]}
[]
[null,"Excel Filter Not Working",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Item","Price",null,null,null,null,null,null,"Item","Price"]
[null,"Lemon",0.54,null,null,null,null,null,null,"Lemon",0.54]
[null,"Orange",1.45,null,null,null,null,null,null,"Orange",1.45]
[null,"Apple",4.76,null,null,null,null,null,null,"Apple",4.76]
[null,"Avocado",2.62,null,null,null,null,null,null,"Avocado",2.62]
[]
[null,"Banana",1.28,null,null,null,null,null,null,"Banana",1.28]

{"sheet":"LSI 2","index":5,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Excluding Blank Cells",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Item","Price",null,"Criteria Range",null,null,null,null,null,"Item","Price",null,"Criteria Range"]
[null,"Lemon",0.54,null,null,null,null,null,null,null,"Lemon",0.54]
[null,"Orange",1.45,null,{"$f":"C5<>\"\"","v":true},null,null,null,null,null,"Orange",1.45,null,{"$f":"L5<>\"\"","v":true}]
[null,"Apple",4.76,null,null,null,null,null,null,null,"Apple",4.76]
[null,"Avocado",2.62,null,null,null,null,null,null,null,"Avocado",2.62]
[null,"Raspberries",null,null,null,null,null,null,null,null,"Raspberries"]
[null,"Banana",1.28,null,null,null,null,null,null,null,"Banana",1.28]