{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Sort Dialog Box-1","Sort Dialog Box-2","Data Tab-1","SORTBY Function","INDEX Function","VBA-1","VBA-2"],"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":"Sort Dialog Box-1","index":0,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Use of Sort Dialog Box",null,null,null,null,null,null,">> Do Yourself >>"]
[]
[null,"Product Category","Quantity","Order",null,null,null,null,"Product Category","Quantity","Order"]
[null,"Toys",40,4,null,null,null,null,"Electonics",30,1]
[null,"Furniture",10,3,null,null,null,null,"Cloth",20,2]
[null,"Cloth",20,2,null,null,null,null,"Furniture",10,3]
[null,"Electonics",30,1,null,null,null,null,"Toys",40,4]

{"sheet":"Sort Dialog Box-2","index":1,"n_rows":6,"n_cols":18,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,13,1,17]]}
[]
[null,"Use of Sort Dialog Box",null,null,null,null,null,null,null,null,null,null,null,">> Do Yourself >>"]
[]
[null,"Product Category","Toys","Furniture","Cloth","Electronics",null,null,null,null,null,null,null,"Product Category","Electronics","Cloth","Furniture","Toys"]
[null,"Quantity",40,10,20,30,null,null,null,null,null,null,null,"Quantity",30,20,10,40]
[null,"Order",4,3,2,1,null,null,null,null,null,null,null,"Order",1,2,3,4]

{"sheet":"Data Tab-1","index":2,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Use of Data Tab",null,null,null,null,null,null,">> Do Yourself>>"]
[]
[null,"Product Category","Quantity","Order",null,null,null,null,"Product Category","Quantity","Order"]
[null,"Toys",40,4,null,null,null,null,"Electonics",30,1]
[null,"Furniture",10,3,null,null,null,null,"Cloth",20,2]
[null,"Cloth",20,2,null,null,null,null,"Furniture",10,3]
[null,"Electonics",30,1,null,null,null,null,"Toys",40,4]

{"sheet":"SORTBY Function","index":3,"n_rows":8,"n_cols":17,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,15,1,16]]}
[]
[null,"Use of SORTBY Function",null,null,null,null,null,null,null,null,null,null,null,null,null,"Use of SORTBY Function"]
[]
[null,"Product Category","Quantity",null,"Product Category","Quantity",null,null,null,null,null,null,null,null,null,"Product Category","Quantity"]
[null,"Electonics",30,null,{"$f":"_xlfn.SORTBY($B$5:$C$8,ROW(B5:B8),-1)","v":"Toys"},40,null,null,null,null,null,null,null,null,null,"Electonics",30]
[null,"Cloth",20,null,"Furniture",10,null,null,null,null,null,null,null,null,null,"Cloth",20]
[null,"Furniture",10,null,"Cloth",20,null,null,null,null,null,null,null,null,null,"Furniture",10]
[null,"Toys",40,null,"Electonics",30,null,null,null,null,null,null,null,null,null,"Toys",40]

{"sheet":"INDEX Function","index":4,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,14,1,15]]}
[]
[null,"Use of INDEX Function",null,null,null,null,null,null,null,null,null,null,null,null,">> Do Yourself >>"]
[]
[null,"Product Category","Quantity",null,"Product Category","Quantity",null,null,null,null,null,null,null,null,"Product Category","Quantity"]
[null,"Electonics",30,null,{"$f":"INDEX($B$5:$C$8,ROWS(B5:$B$8),COLUMNS($B$5:B5))","v":"Toys"},{"$f":"INDEX($B$5:$C$8,ROWS($B5:C$8),COLUMNS($B$5:C5))","v":40},null,null,null,null,null,null,null,null,"Electonics",30]
[null,"Cloth",20,null,{"$f":"INDEX($B$5:$C$8,ROWS(B6:$B$8),COLUMNS($B$5:B6))","v":"Furniture"},{"$f":"INDEX($B$5:$C$8,ROWS($B6:C$8),COLUMNS($B$5:C6))","v":10},null,null,null,null,null,null,null,null,"Cloth",20]
[null,"Furniture",10,null,{"$f":"INDEX($B$5:$C$8,ROWS(B7:$B$8),COLUMNS($B$5:B7))","v":"Cloth"},{"$f":"INDEX($B$5:$C$8,ROWS($B7:C$8),COLUMNS($B$5:C7))","v":20},null,null,null,null,null,null,null,null,"Furniture",10]
[null,"Toys",40,null,{"$f":"INDEX($B$5:$C$8,ROWS(B8:$B$8),COLUMNS($B$5:B8))","v":"Electonics"},{"$f":"INDEX($B$5:$C$8,ROWS($B8:C$8),COLUMNS($B$5:C8))","v":30},null,null,null,null,null,null,null,null,"Toys",40]

{"sheet":"VBA-1","index":5,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":false,"merged":[[13,10,13,11],[1,14,1,15],[1,1,1,2]]}
[]
[null,"Use of VBA",null,null,null,null,null,null,null,null,null,null,null,null,"Use of VBA"]
[]
[null,"Product Category","Quantity",null,null,null,null,null,null,null,null,null,null,null,"Product Category","Quantity"]
[null,"Toys",40,null,null,null,null,null,null,null,null,null,null,null,"Electonics",30]
[null,"Furniture",10,null,null,null,null,null,null,null,null,null,null,null,"Cloth",20]
[null,"Cloth",20,null,null,null,null,null,null,null,null,null,null,null,"Furniture",10]
[null,"Electonics",30,null,null,null,null,null,null,null,null,null,null,null,"Toys",40]

{"sheet":"VBA-2","index":6,"n_rows":5,"n_cols":18,"rows_kept":5,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,13,1,17]]}
[]
[null,"Use of VBA",null,null,null,null,null,null,null,null,null,null,null,">> Do Yourself >>"]
[]
[null,"Product Category","Toys","Furniture","Cloth","Electronics",null,null,null,null,null,null,null,"Product Category","Electronics","Cloth","Furniture","Toys"]
[null,"Quantity",40,10,20,30,null,null,null,null,null,null,null,"Quantity",30,20,10,40]