{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Ampersand","Concatenate","VBA","Data Validation","Sheet4","Converting Textbox to Cell"],"not_rendered":{"charts":0,"images":1,"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":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sales Report of ABC Company"]
[]
[null,"Sales Rep","Sales"]
[null,"John",2597]
[null,"Peter",2679]
[null,"Lewis",2040]
[null,"Ryan",2145]
[null,"Max",2512]
[null,"Samuels",2326]
[null,"Williams",2982]

{"sheet":"Ampersand","index":1,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Applying Ampersand Operator",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Sales Rep","Sales",null,null,null,null,null,null,null,null,"Sales Rep","Sales"]
[null,"John",2597,null,null,null,null,null,null,null,null,"John",2597]
[null,"Peter",2679,null,null,null,null,null,null,null,null,"Peter",2679]
[null,"Lewis",2040,null,null,null,null,null,null,null,null,"Lewis",2040]
[null,"Ryan",2145,null,null,null,null,null,null,null,null,"Ryan",2145]
[null,"Max",2512,null,null,null,null,null,null,null,null,"Max",2512]
[null,"Samuels",2326,null,null,null,null,null,null,null,null,"Samuels",2326]
[null,"Williams",2982,null,null,null,null,null,null,null,null,"Williams",2982]
[null,"Total",{"$f":"SUM(C5:C11)","v":17281},null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(M5:M11)","v":17281}]
[null,{"$f":"B12&\" \"&C12","v":"Total 17281"}]

{"sheet":"Concatenate","index":2,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Using CONCATENATE Function",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Sales Rep","Sales",null,null,null,null,null,null,null,null,"Sales Rep","Sales"]
[null,"John",2597,null,null,null,null,null,null,null,null,"John",2597]
[null,"Peter",2679,null,null,null,null,null,null,null,null,"Peter",2679]
[null,"Lewis",2040,null,null,null,null,null,null,null,null,"Lewis",2040]
[null,"Ryan",2145,null,null,null,null,null,null,null,null,"Ryan",2145]
[null,"Max",2512,null,null,null,null,null,null,null,null,"Max",2512]
[null,"Samuels",2326,null,null,null,null,null,null,null,null,"Samuels",2326]
[null,"Williams",2982,null,null,null,null,null,null,null,null,"Williams",2982]
[null,"Total",{"$f":"SUM(C5:C11)","v":17281},null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(M5:M11)","v":17281}]
[null,{"$f":"CONCATENATE(B12,\" \",C12)","v":"Total 17281"}]

{"sheet":"VBA","index":3,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Employing VBA Macros",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Sales Rep","Sales",null,null,null,null,null,null,null,null,"Sales Rep","Sales"]
[null,"John",2597,null,null,null,null,null,null,null,null,"John",2597]
[null,"Peter",2679,null,null,null,null,null,null,null,null,"Peter",2679]
[null,"Lewis",2040,null,null,null,null,null,null,null,null,"Lewis",2040]
[null,"Ryan",2145,null,null,null,null,null,null,null,null,"Ryan",2145]
[null,"Max",2512,null,null,null,null,null,null,null,null,"Max",2512]
[null,"Samuels",2326,null,null,null,null,null,null,null,null,"Samuels",2326]
[null,"Williams",2982,null,null,null,null,null,null,null,null,"Williams",2982]
[null,"Total",{"$f":"SUM(C5:C11)","v":17281},null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(M5:M11)","v":17281}]

{"sheet":"Data Validation","index":4,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Incorporating Data Validation Tool",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Student Name",null,null,null,null,null,null,null,null,null,"Student Name"]
[null,"David",null,null,null,null,null,null,null,null,null,"David"]
[null,"Output as TextBox",null,null,null,null,null,null,null,null,null,"Output as TextBox"]

{"sheet":"Sheet4","index":5,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Incorporating Data Validation Tool"]
[]
[null,"Student Name"]
[null,"Anna"]
[null,"Output as TextBox"]

{"sheet":"Converting Textbox to Cell","index":6,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,12]]}
[]
[null,"Converting TextBox to Cell Content",null,null,null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Sales Rep","Sales in Textbox","Sales in Cell Contents",null,null,null,null,null,null,null,"Sales Rep","Sales in Textbox"]
[null,"John",2597,2597,null,null,null,null,null,null,null,"John",2597]
[null,"Peter",2679,2679,null,null,null,null,null,null,null,"Peter",2679]
[null,"Lewis",2040,2040,null,null,null,null,null,null,null,"Lewis",2040]
[null,"Ryan",2145,2145,null,null,null,null,null,null,null,"Ryan",2145]
[null,"Max",2512,2512,null,null,null,null,null,null,null,"Max",2512]
[null,"Samuels",2326,2326,null,null,null,null,null,null,null,"Samuels",2326]
[null,"Williams",2982,2982,null,null,null,null,null,null,null,"Williams",2982]
[null,"Total",{"$f":"SUM(C5:C11)","v":17281},{"$f":"SUM(D5:D11)","v":17281},null,null,null,null,null,null,null,"Total",{"$f":"SUM(M5:M11)","v":17281}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null," "]