{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","Group","Context Menu","Ribbon","Column Width","Shortcut","VBA","Expand","Collapse Rows"],"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":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Scores of Mid-Term Test"]
[]
[null,"ID","Name","English","Maths","Social Science","Total"]
[null,1,"Marilyn",38,24,28,{"$f":"D5+E5+F5","v":90}]
[null,2,"John",41,24,32,{"$f":"D6+E6+F6","v":97}]
[null,3,"Joseph",33,39,45,117]
[null,4,"Daniel",35,36,25,96]
[null,5,"Anthony",31,30,43,104]
[null,6,"Tim",25,21,46,92]
[null,7,"Steven",50,21,29,100]
[null,8,"Paul",28,40,31,99]
[null,9,"George",50,37,48,135]
[null,10,"Ronald",32,31,29,92]

{"sheet":"Group","index":1,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,10,1,15]]}
[]
[null,"Using Group Feature",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Name","English","Maths","Social Science","Total",null,null,null,"ID","Name","English","Maths","Social Science","Total"]
[null,1,"Marilyn",38,24,28,{"$f":"D5+E5+F5","v":90},null,null,null,1,"Marilyn",38,24,28,{"$f":"M5+N5+O5","v":90}]
[null,2,"John",41,24,32,{"$f":"D6+E6+F6","v":97},null,null,null,2,"John",41,24,32,{"$f":"M6+N6+O6","v":97}]
[null,3,"Joseph",33,39,45,117,null,null,null,3,"Joseph",33,39,45,117]
[null,4,"Daniel",35,36,25,96,null,null,null,4,"Daniel",35,36,25,96]
[null,5,"Anthony",31,30,43,104,null,null,null,5,"Anthony",31,30,43,104]
[null,6,"Tim",25,21,46,92,null,null,null,6,"Tim",25,21,46,92]
[null,7,"Steven",50,21,29,100,null,null,null,7,"Steven",50,21,29,100]
[null,8,"Paul",28,40,31,99,null,null,null,8,"Paul",28,40,31,99]
[null,9,"George",50,37,48,135,null,null,null,9,"George",50,37,48,135]
[null,10,"Ronald",32,31,29,92,null,null,null,10,"Ronald",32,31,29,92]

{"sheet":"Context Menu","index":2,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,9,1,14]]}
[]
[null,"Utilizing Context Menu",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Name","English","Maths","Social Science","Total",null,null,"ID","Name","English","Maths","Social Science","Total"]
[null,1,"Marilyn",38,24,28,{"$f":"D5+E5+F5","v":90},null,null,1,"Marilyn",38,24,28,{"$f":"L5+M5+N5","v":90}]
[null,2,"John",41,24,32,{"$f":"D6+E6+F6","v":97},null,null,2,"John",41,24,32,{"$f":"L6+M6+N6","v":97}]
[null,3,"Joseph",33,39,45,117,null,null,3,"Joseph",33,39,45,117]
[null,4,"Daniel",35,36,25,96,null,null,4,"Daniel",35,36,25,96]
[null,5,"Anthony",31,30,43,104,null,null,5,"Anthony",31,30,43,104]
[null,6,"Tim",25,21,46,92,null,null,6,"Tim",25,21,46,92]
[null,7,"Steven",50,21,29,100,null,null,7,"Steven",50,21,29,100]
[null,8,"Paul",28,40,31,99,null,null,8,"Paul",28,40,31,99]
[null,9,"George",50,37,48,135,null,null,9,"George",50,37,48,135]
[null,10,"Ronald",32,31,29,92,null,null,10,"Ronald",32,31,29,92]

{"sheet":"Ribbon","index":3,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,9,1,14]]}
[]
[null,"Using Ribbon",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Name","English","Maths","Social Science","Total",null,null,"ID","Name","English","Maths","Social Science","Total"]
[null,1,"Marilyn",38,24,28,{"$f":"D5+E5+F5","v":90},null,null,1,"Marilyn",38,24,28,{"$f":"L5+M5+N5","v":90}]
[null,2,"John",41,24,32,{"$f":"D6+E6+F6","v":97},null,null,2,"John",41,24,32,{"$f":"L6+M6+N6","v":97}]
[null,3,"Joseph",33,39,45,117,null,null,3,"Joseph",33,39,45,117]
[null,4,"Daniel",35,36,25,96,null,null,4,"Daniel",35,36,25,96]
[null,5,"Anthony",31,30,43,104,null,null,5,"Anthony",31,30,43,104]
[null,6,"Tim",25,21,46,92,null,null,6,"Tim",25,21,46,92]
[null,7,"Steven",50,21,29,100,null,null,7,"Steven",50,21,29,100]
[null,8,"Paul",28,40,31,99,null,null,8,"Paul",28,40,31,99]
[null,9,"George",50,37,48,135,null,null,9,"George",50,37,48,135]
[null,10,"Ronald",32,31,29,92,null,null,10,"Ronald",32,31,29,92]

{"sheet":"Column Width","index":4,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,9,1,14]]}
[]
[null,"Setting Column Width",null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Name","English","Maths","Social Science","Total",null,null,"ID","Name","English","Maths","Social Science","Total"]
[null,1,"Marilyn",38,24,28,{"$f":"D5+E5+F5","v":90},null,null,1,"Marilyn",38,24,28,{"$f":"L5+M5+N5","v":90}]
[null,2,"John",41,24,32,{"$f":"D6+E6+F6","v":97},null,null,2,"John",41,24,32,{"$f":"L6+M6+N6","v":97}]
[null,3,"Joseph",33,39,45,117,null,null,3,"Joseph",33,39,45,117]
[null,4,"Daniel",35,36,25,96,null,null,4,"Daniel",35,36,25,96]
[null,5,"Anthony",31,30,43,104,null,null,5,"Anthony",31,30,43,104]
[null,6,"Tim",25,21,46,92,null,null,6,"Tim",25,21,46,92]
[null,7,"Steven",50,21,29,100,null,null,7,"Steven",50,21,29,100]
[null,8,"Paul",28,40,31,99,null,null,8,"Paul",28,40,31,99]
[null,9,"George",50,37,48,135,null,null,9,"George",50,37,48,135]
[null,10,"Ronald",32,31,29,92,null,null,10,"Ronald",32,31,29,92]

{"sheet":"Shortcut","index":5,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,10,1,15]]}
[]
[null,"Applying Keyboard Shortcut",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Name","English","Maths","Social Science","Total",null,null,null,"ID","Name","English","Maths","Social Science","Total"]
[null,1,"Marilyn",38,24,28,{"$f":"D5+E5+F5","v":90},null,null,null,1,"Marilyn",38,24,28,{"$f":"M5+N5+O5","v":90}]
[null,2,"John",41,24,32,{"$f":"D6+E6+F6","v":97},null,null,null,2,"John",41,24,32,{"$f":"M6+N6+O6","v":97}]
[null,3,"Joseph",33,39,45,117,null,null,null,3,"Joseph",33,39,45,117]
[null,4,"Daniel",35,36,25,96,null,null,null,4,"Daniel",35,36,25,96]
[null,5,"Anthony",31,30,43,104,null,null,null,5,"Anthony",31,30,43,104]
[null,6,"Tim",25,21,46,92,null,null,null,6,"Tim",25,21,46,92]
[null,7,"Steven",50,21,29,100,null,null,null,7,"Steven",50,21,29,100]
[null,8,"Paul",28,40,31,99,null,null,null,8,"Paul",28,40,31,99]
[null,9,"George",50,37,48,135,null,null,null,9,"George",50,37,48,135]
[null,10,"Ronald",32,31,29,92,null,null,null,10,"Ronald",32,31,29,92]

{"sheet":"VBA","index":6,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,10,1,15]]}
[]
[null,"Employing VBA Code",null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"ID","Name","English","Maths","Social Science","Total",null,null,null,"ID","Name","English","Maths","Social Science","Total"]
[null,1,"Marilyn",38,24,28,{"$f":"D5+E5+F5","v":90},null,null,null,1,"Marilyn",38,24,28,{"$f":"M5+N5+O5","v":90}]
[null,2,"John",41,24,32,{"$f":"D6+E6+F6","v":97},null,null,null,2,"John",41,24,32,{"$f":"M6+N6+O6","v":97}]
[null,3,"Joseph",33,39,45,117,null,null,null,3,"Joseph",33,39,45,117]
[null,4,"Daniel",35,36,25,96,null,null,null,4,"Daniel",35,36,25,96]
[null,5,"Anthony",31,30,43,104,null,null,null,5,"Anthony",31,30,43,104]
[null,6,"Tim",25,21,46,92,null,null,null,6,"Tim",25,21,46,92]
[null,7,"Steven",50,21,29,100,null,null,null,7,"Steven",50,21,29,100]
[null,8,"Paul",28,40,31,99,null,null,null,8,"Paul",28,40,31,99]
[null,9,"George",50,37,48,135,null,null,null,9,"George",50,37,48,135]
[null,10,"Ronald",32,31,29,92,null,null,null,10,"Ronald",32,31,29,92]

{"sheet":"Expand","index":7,"n_rows":14,"n_cols":7,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Expanding Columns in Excel"]
[]
[null,"ID","Name","English","Maths","Social Science","Total"]
[null,1,"Marilyn",38,24,28,{"$f":"D5+E5+F5","v":90}]
[null,2,"John",41,24,32,{"$f":"D6+E6+F6","v":97}]
[null,3,"Joseph",33,39,45,117]
[null,4,"Daniel",35,36,25,96]
[null,5,"Anthony",31,30,43,104]
[null,6,"Tim",25,21,46,92]
[null,7,"Steven",50,21,29,100]
[null,8,"Paul",28,40,31,99]
[null,9,"George",50,37,48,135]
[null,10,"Ronald",32,31,29,92]

{"sheet":"Collapse Rows","index":8,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Collapsing Rows in Excel"]
[]
[null,"Products","Category","Customer ","Price"]
[null,"Banana","Fruit","John",100]
[null,"Banana","Fruit","Richard",125]
[null,"Banana","Fruit","Miller",225]
[null,"Apples Green","Fruit","Richard",150]
[null,"Apples Green","Fruit","John",175]
[null,"Orange","Fruit","John",300]
[null,"Mint ","Vegetables","Richard",25]
[null,"Mint ","Vegetables","Miller",55]
[null,"Corn","Vegetables","Miller",85]
[null,"Cauliflower","Vegetables","Sara",40]