{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Ampersand Operator","CONCAT Function","Flash Fill","REPLACE function","TEXTJOIN Function","Format Cells","VBA"],"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":"Ampersand Operator","index":0,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Use of Ampersand Operator",null,null,null,"Practice Yourself"]
[]
[null,"Original Data","Text Added",null,null,"Original Data","Text Added"]
[null,80,{"$f":"\"Passed-\"&B5","v":"Passed-80"},null,null,80]
[null,75,{"$f":"\"Passed-\"&B6","v":"Passed-75"},null,null,75]
[null,85,"Passed-85",null,null,85]
[null,90,"Passed-90",null,null,90]
[null,83,"Passed-83",null,null,83]
[null,89,"Passed-89",null,null,89]

{"sheet":"CONCAT Function","index":1,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Use of CONCAT Function",null,null,null,"Practice Yourself"]
[]
[null,"Original Data","Text Added",null,null,"Original Data","Text Added"]
[null,80,{"$f":"_xlfn.CONCAT(\"Passed-\",B5)","v":"Passed-80"},null,null,80]
[null,75,{"$f":"_xlfn.CONCAT(\"Passed-\",B6)","v":"Passed-75"},null,null,75]
[null,85,"Passed-85",null,null,85]
[null,90,"Passed-90",null,null,90]
[null,83,"Passed-83",null,null,83]
[null,89,"Passed-89",null,null,89]

{"sheet":"Flash Fill","index":2,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Use of Flash Fill",null,null,null,null,"Practice Yourself"]
[]
[null,"Original Data","Text Added",null,null,null,"Original Data","Text Added"]
[null,80,"Passed-80",null,null,null,80]
[null,75,"Passed-75",null,null,null,75]
[null,85,"Passed-85",null,null,null,85]
[null,90,"Passed-90",null,null,null,90]
[null,83,"Passed-83",null,null,null,83]
[null,89,"Passed-89",null,null,null,89]

{"sheet":"REPLACE function","index":3,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Use of REPLACE Function",null,null,null,null,"Practice Yourself"]
[]
[null,"Original Data","Text Added",null,null,null,"Original Data","Text Added"]
[null,80,{"$f":"REPLACE(B5,1,0,\"Passed-\")","v":"Passed-80"},null,null,null,80]
[null,75,{"$f":"REPLACE(B6,1,0,\"Passed-\")","v":"Passed-75"},null,null,null,75]
[null,85,"Passed-85",null,null,null,85]
[null,90,"Passed-90",null,null,null,90]
[null,83,"Passed-83",null,null,null,83]
[null,89,"Passed-89",null,null,null,89]

{"sheet":"TEXTJOIN Function","index":4,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Use of TEXTJOIN Function",null,null,null,"Practice Yourself"]
[]
[null,"Original Data","Text Added",null,null,"Original Data","Text Added"]
[null,80,{"$f":"_xlfn.TEXTJOIN(\": \",TRUE,\"Passed\",B5)","v":"Passed: 80"},null,null,80]
[null,75,{"$f":"_xlfn.TEXTJOIN(\": \",TRUE,\"Passed\",B6)","v":"Passed: 75"},null,null,75]
[null,85,"Passed: 85",null,null,85]
[null,90,"Passed: 90",null,null,90]
[null,83,"Passed: 83",null,null,83]
[null,89,"Passed: 89",null,null,89]

{"sheet":"Format Cells","index":5,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Use of Format Cells Feature",null,null,null,"Practice Yourself"]
[]
[null,"Original Data","Text Added",null,null,"Original Data","Text Added"]
[null,80,80,null,null,80]
[null,75,75,null,null,75]
[null,85,85,null,null,85]
[null,90,90,null,null,90]
[null,83,83,null,null,83]
[null,89,89,null,null,89]

{"sheet":"VBA","index":6,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Use of VBA",null,null,null,"Practice Yourself"]
[]
[null,"Original Data","Text Added",null,null,"Original Data","Text Added"]
[null,80,"Passed-80",null,null,80]
[null,75,"Passed-75",null,null,75]
[null,85,"Passed-85",null,null,85]
[null,90,"Passed-90",null,null,90]
[null,83,"Passed-83",null,null,83]
[null,89,"Passed-89",null,null,89]