{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Data Set","Copy Paste","CTRL + Enter","CTRL + D","AutoFill","Non-Adjacent","Excel Table","Excel Table (2)","VBA Code","Practice Sheet"],"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":"Data Set","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Sample Data Set"]
[]
[null,"Student Name","Marks in Part 1","Marks in Part 2"]
[null,"Jack",68,72]
[null,"Andrew",65,70]
[null,"Susane",75,80]
[null,"Christie",62,66]
[null,"Tom",71,73]
[null,"Rebecca",80,82]

{"sheet":"Copy Paste","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Utilization of Copy and Paste Command"]
[]
[null,"Student Name","Marks in Part 1","Marks in Part 2","Total"]
[null,"Jack",68,72,{"$f":"SUM(C5:D5)","v":140}]
[null,"Andrew",65,70,{"$f":"SUM(C6:D6)","v":135}]
[null,"Susane",75,80,155]
[null,"Christie",62,66,128]
[null,"Tom",71,73,144]
[null,"Rebecca",80,82,162]

{"sheet":"CTRL + Enter","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Pressing of CTRL + Enter Keys"]
[]
[null,"Student Name","Marks in Part 1","Marks in Part 2","Total"]
[null,"Jack",68,72,{"$f":"SUM(C5:D5)","v":140}]
[null,"Andrew",65,70,135]
[null,"Susane",75,80,155]
[null,"Christie",62,66,128]
[null,"Tom",71,73,144]
[null,"Rebecca",80,82,162]

{"sheet":"CTRL + D","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Pressing of CTRL + D Keys"]
[]
[null,"Student Name","Marks in Part 1","Marks in Part 2","Total"]
[null,"Jack",68,72,{"$f":"SUM(C5:D5)","v":140}]
[null,"Andrew",65,70,{"$f":"SUM(C6:D6)","v":135}]
[null,"Susane",75,80,155]
[null,"Christie",62,66,128]
[null,"Tom",71,73,144]
[null,"Rebecca",80,82,162]

{"sheet":"AutoFill","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Implementation of AutoFill Feature"]
[]
[null,"Student Name","Marks in Part 1","Marks in Part 2","Total"]
[null,"Jack",68,72,{"$f":"SUM(C5:D5)","v":140}]
[null,"Andrew",65,70,{"$f":"SUM(C6:D6)","v":135}]
[null,"Susane",75,80,155]
[null,"Christie",62,66,128]
[null,"Tom",71,73,144]
[null,"Rebecca",80,82,162]

{"sheet":"Non-Adjacent","index":5,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Copying of Formula to Non-Adjacent Cells"]
[]
[null,"Student Name","Marks in Part 1","Marks in Part 2","Total"]
[null,"Jack",68,72,{"$f":"SUM(C5:D5)","v":140}]
[null,"Andrew",65,70]
[null,"Susane",75,80,{"$f":"SUM(C7:D7)","v":155}]
[null,"Christie",62,66]
[null,"Tom",71,73,{"$f":"SUM(C9:D9)","v":144}]
[null,"Rebecca",80,82,{"$f":"SUM(C10:D10)","v":162}]

{"sheet":"Excel Table","index":6,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Insertion of Excel Table"]
[]
[null,"Student Name","Marks in Part 1","Marks in Part 2","Total"]
[null,"Jack",68,72,{"$f":"SUM(Table1[[#This Row],[Marks in Part 1]:[Marks in Part 2]])","v":140}]
[null,"Andrew",65,70,{"$f":"SUM(Table1[[#This Row],[Marks in Part 1]:[Marks in Part 2]])","v":135}]
[null,"Susane",75,80,{"$f":"SUM(Table1[[#This Row],[Marks in Part 1]:[Marks in Part 2]])","v":155}]
[null,"Christie",62,66,{"$f":"SUM(Table1[[#This Row],[Marks in Part 1]:[Marks in Part 2]])","v":128}]
[null,"Tom",71,73,{"$f":"SUM(Table1[[#This Row],[Marks in Part 1]:[Marks in Part 2]])","v":144}]
[null,"Rebecca",80,82,{"$f":"SUM(Table1[[#This Row],[Marks in Part 1]:[Marks in Part 2]])","v":162}]

{"sheet":"Excel Table (2)","index":7,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Insertion of Excel Table"]
[]
[null,"Student Name","Marks in Part 1","Marks in Part 2","Total"]
[null,"Jack",68,72]
[null,"Andrew",65,70]
[null,"Susane",75,80]
[null,"Christie",62,66]
[null,"Tom",71,73]
[null,"Rebecca",80,82]

{"sheet":"VBA Code","index":8,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Application of VBA Code"]
[]
[null,"Student Name","Marks in Part 1","Marks in Part 2","Total"]
[null,"Jack",68,72,{"$f":"SUM(C5:D5)","v":140}]
[null,"Andrew",65,70,{"$f":"SUM(C6:D6)","v":135}]
[null,"Susane",75,80,155]
[null,"Christie",62,66,128]
[null,"Tom",71,73,144]
[null,"Rebecca",80,82,162]

{"sheet":"Practice Sheet","index":9,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"<<< Practice Yourself >>>"]
[]
[null,"Student Name","Marks in Part 1","Marks in Part 2"]
[null,"Jack",68,72]
[null,"Andrew",65,70]
[null,"Susane",75,80]
[null,"Christie",62,66]
[null,"Tom",71,73]
[null,"Rebecca",80,82]