{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Format Cells","LEFT","TEXT","IF","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":"Format Cells","index":0,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,10,1,12]]}
[]
[null,"Utilization of Format Cells Feature",null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Customer Name","Address","Zip Code",null,null,null,null,null,null,"Customer Name","Address","Zip Code"]
[null,"Emily","71 ST. NICHOLAS DRIVE",9705,null,null,null,null,null,null,"Emily","71 ST. NICHOLAS DRIVE",9705]
[null,"Nick","1830 E. PARKS HWY",9956,null,null,null,null,null,null,"Nick","1830 E. PARKS HWY",9956]
[null,"Robertson","800 E DIMOND BLVD",852,null,null,null,null,null,null,"Robertson","800 E DIMOND BLVD",852]
[null,"James","2010 RAINBOW DR","925-0",null,null,null,null,null,null,"James","2010 RAINBOW DR","925-0"]
[null,"Cooper","11520 FINANCIAL CENTER PKWY",8520,null,null,null,null,null,null,"Cooper","11520 FINANCIAL CENTER PKWY",8520]
[null,"Milner","2700 S WOODLANDS VILLAGE BLVD",9262,null,null,null,null,null,null,"Milner","2700 S WOODLANDS VILLAGE BLVD",9262]
[null,"Ashley","641 INDIAN HILL BOULEVARD",9171,null,null,null,null,null,null,"Ashley","641 INDIAN HILL BOULEVARD",9171]

{"sheet":"LEFT","index":1,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,12,1,16]]}
[]
[null,"Use of LEFT Function",null,null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Customer Name","Address","Zip Code",null,"Result",null,null,null,null,null,null,"Customer Name","Address","Zip Code",null,"Result"]
[null,"Emily","71 ST. NICHOLAS DRIVE","99705-2",null,{"$f":"LEFT(D5,5)","v":"99705"},null,null,null,null,null,null,"Emily","71 ST. NICHOLAS DRIVE","99705-2"]
[null,"Nick","1830 E. PARKS HWY",9956434,null,{"$f":"LEFT(D6,5)","v":"99564"},null,null,null,null,null,null,"Nick","1830 E. PARKS HWY",9956434]
[null,"Robertson","800 E DIMOND BLVD","85202-89",null,"85202",null,null,null,null,null,null,"Robertson","800 E DIMOND BLVD","85202-89"]
[null,"James","2010 RAINBOW DR",9250700,null,"92507",null,null,null,null,null,null,"James","2010 RAINBOW DR",9250700]
[null,"Cooper","11520 FINANCIAL CENTER PKWY",8520600,null,"85206",null,null,null,null,null,null,"Cooper","11520 FINANCIAL CENTER PKWY",8520600]
[null,"Milner","2700 S WOODLANDS VILLAGE BLVD","92620-78",null,"92620",null,null,null,null,null,null,"Milner","2700 S WOODLANDS VILLAGE BLVD","92620-78"]
[null,"Ashley","641 INDIAN HILL BOULEVARD","91710-90",null,"91710",null,null,null,null,null,null,"Ashley","641 INDIAN HILL BOULEVARD","91710-90"]

{"sheet":"TEXT","index":2,"n_rows":11,"n_cols":17,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,12,1,16]]}
[]
[null,"Use of TEXT Function",null,null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Customer Name","Address","Zip Code",null,"Result",null,null,null,null,null,null,"Customer Name","Address","Zip Code",null,"Result"]
[null,"Emily","71 ST. NICHOLAS DRIVE",9705,null,{"$f":"TEXT(D5,\"00000\")","v":"09705"},null,null,null,null,null,null,"Emily","71 ST. NICHOLAS DRIVE",9705]
[null,"Nick","1830 E. PARKS HWY",9956,null,{"$f":"TEXT(D6,\"00000\")","v":"09956"},null,null,null,null,null,null,"Nick","1830 E. PARKS HWY",9956]
[null,"Robertson","800 E DIMOND BLVD",852,null,"00852",null,null,null,null,null,null,"Robertson","800 E DIMOND BLVD",852]
[null,"James","2010 RAINBOW DR",9250,null,"09250",null,null,null,null,null,null,"James","2010 RAINBOW DR",9250]
[null,"Cooper","11520 FINANCIAL CENTER PKWY",8520,null,"08520",null,null,null,null,null,null,"Cooper","11520 FINANCIAL CENTER PKWY",8520]
[null,"Milner","2700 S WOODLANDS VILLAGE BLVD",9262,null,"09262",null,null,null,null,null,null,"Milner","2700 S WOODLANDS VILLAGE BLVD",9262]
[null,"Ashley","641 INDIAN HILL BOULEVARD",9171,null,"09171",null,null,null,null,null,null,"Ashley","641 INDIAN HILL BOULEVARD",9171]

{"sheet":"IF","index":3,"n_rows":11,"n_cols":16,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Use of IF Function",null,null,null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Customer Name","Address","Zip Code",null,"Result",null,null,null,null,null,"Customer Name","Address","Zip Code",null,"Result"]
[null,"Emily","71 ST. NICHOLAS DRIVE",9705,null,{"$f":"IF(D5<9999,0&D5,D5)","v":"09705"},null,null,null,null,null,"Emily","71 ST. NICHOLAS DRIVE",9705]
[null,"Nick","1830 E. PARKS HWY",99569,null,{"$f":"IF(D6<9999,0&D6,D6)","v":99569},null,null,null,null,null,"Nick","1830 E. PARKS HWY",99569]
[null,"Robertson","800 E DIMOND BLVD",852,null,"0852",null,null,null,null,null,"Robertson","800 E DIMOND BLVD",852]
[null,"James","2010 RAINBOW DR",92561,null,92561,null,null,null,null,null,"James","2010 RAINBOW DR",92561]
[null,"Cooper","11520 FINANCIAL CENTER PKWY",8520,null,"08520",null,null,null,null,null,"Cooper","11520 FINANCIAL CENTER PKWY",8520]
[null,"Milner","2700 S WOODLANDS VILLAGE BLVD",9262,null,"09262",null,null,null,null,null,"Milner","2700 S WOODLANDS VILLAGE BLVD",9262]
[null,"Ashley","641 INDIAN HILL BOULEVARD",91712,null,91712,null,null,null,null,null,"Ashley","641 INDIAN HILL BOULEVARD",91712]

{"sheet":"VBA","index":4,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Use of VBA Code",null,null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Customer Name","Address","Zip Code",null,null,null,null,null,"Customer Name","Address","Zip Code"]
[null,"Emily","71 ST. NICHOLAS DRIVE",99705,null,null,null,null,null,"Emily","71 ST. NICHOLAS DRIVE","99705-2"]
[null,"Nick","1830 E. PARKS HWY",99564,null,null,null,null,null,"Nick","1830 E. PARKS HWY",9956434]
[null,"Robertson","800 E DIMOND BLVD",85202,null,null,null,null,null,"Robertson","800 E DIMOND BLVD","85202-89"]
[null,"James","2010 RAINBOW DR",92507,null,null,null,null,null,"James","2010 RAINBOW DR",9250700]
[null,"Cooper","11520 FINANCIAL CENTER PKWY",85206,null,null,null,null,null,"Cooper","11520 FINANCIAL CENTER PKWY",8520600]
[null,"Milner","2700 S WOODLANDS VILLAGE BLVD",92620,null,null,null,null,null,"Milner","2700 S WOODLANDS VILLAGE BLVD","92620-78"]
[null,"Ashley","641 INDIAN HILL BOULEVARD",91710,null,null,null,null,null,"Ashley","641 INDIAN HILL BOULEVARD","91710-90"]