{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","LOWER function","Flash Fill","Power Query","Output of Using Power Query","Using Microsoft Word","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[4,1,7,1],[8,1,10,1],[11,1,14,1],[1,1,1,3]]}
[]
[null," Some Owners of Cars in California"]
[]
[null,"Car Brand","Profession","Name in Uppercase"]
[null,"Audi","Businessman","JANE KAT"]
[null,null,"Businessman","WILLIAM MARK"]
[null,null,"Doctor","MARK HENRY"]
[null,null,"Lawyer","KEVIN PIETERSON"]
[null,"Range Rover","Lawyer","JASON GOLD"]
[null,null,"Cricketer","HARRY DSUJA"]
[null,null,"Actor","NICOLAS TOM"]
[null,"Marcedes Bench","Engineer","ROB BILLY"]
[null,null,"Businessman","JIMMY HARDER"]
[null,null,"Businessman","TOM PAIN"]
[null,null,"Doctor","STEVE SMITH"]

{"sheet":"LOWER function","index":1,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[4,1,7,1],[8,1,10,1],[11,1,14,1],[1,1,1,4],[1,7,1,10],[4,7,7,7],[8,7,10,7],[11,7,14,7]]}
[]
[null,"Using LOWER Function",null,null,null,null,null,"Try It by Yourself"]
[]
[null,"Car Brand","Profession","Name in Uppercase","Name in Lowercase",null,null,"Car Brand","Profession","Name in Uppercase","Name in Lowercase"]
[null,"Audi","Businessman","JANE KAT",{"$f":"LOWER(D5)","v":"jane kat"},null,null,"Audi","Businessman","JANE KAT"]
[null,null,"Businessman","WILLIAM MARK",{"$f":"LOWER(D6)","v":"william mark"},null,null,null,"Businessman","WILLIAM MARK"]
[null,null,"Doctor","MARK HENRY","mark henry",null,null,null,"Doctor","MARK HENRY"]
[null,null,"Lawyer","KEVIN PIETERSON","kevin pieterson",null,null,null,"Lawyer","KEVIN PIETERSON"]
[null,"Range Rover","Lawyer","JASON GOLD","jason gold",null,null,"Range Rover","Lawyer","JASON GOLD"]
[null,null,"Cricketer","HARRY DSUJA","harry dsuja",null,null,null,"Cricketer","HARRY DSUJA"]
[null,null,"Actor","NICOLAS TOM","nicolas tom",null,null,null,"Actor","NICOLAS TOM"]
[null,"Marcedes Bench","Engineer","ROB BILLY","rob billy",null,null,"Marcedes Bench","Engineer","ROB BILLY"]
[null,null,"Businessman","JIMMY HARDER","jimmy harder",null,null,null,"Businessman","JIMMY HARDER"]
[null,null,"Businessman","TOM PAIN","tom pain",null,null,null,"Businessman","TOM PAIN"]
[null,null,"Doctor","STEVE SMITH","steve smith",null,null,null,"Doctor","STEVE SMITH"]

{"sheet":"Flash Fill","index":2,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[4,1,7,1],[8,1,10,1],[11,1,14,1],[1,1,1,4],[1,7,1,10],[4,7,7,7],[8,7,10,7],[11,7,14,7]]}
[]
[null,"Utilizing Flash Fill Feature",null,null,null,null,null,"Try It by Yourself"]
[]
[null,"Car Brand","Profession","Name in Uppercase","Name in Lowercase",null,null,"Car Brand","Profession","Name in Uppercase","Name in Lowercase"]
[null,"Audi","Businessman","JANE KAT","jane kat",null,null,"Audi","Businessman","JANE KAT"]
[null,null,"Businessman","WILLIAM MARK","william mark",null,null,null,"Businessman","WILLIAM MARK"]
[null,null,"Doctor","MARK HENRY","mark henry",null,null,null,"Doctor","MARK HENRY"]
[null,null,"Lawyer","KEVIN PIETERSON","kevin pieterson",null,null,null,"Lawyer","KEVIN PIETERSON"]
[null,"Range Rover","Lawyer","JASON GOLD","jason gold",null,null,"Range Rover","Lawyer","JASON GOLD"]
[null,null,"Cricketer","HARRY DSUJA","harry dsuja",null,null,null,"Cricketer","HARRY DSUJA"]
[null,null,"Actor","NICOLAS TOM","nicolas tom",null,null,null,"Actor","NICOLAS TOM"]
[null,"Marcedes Bench","Engineer","ROB BILLY","rob billy",null,null,"Marcedes Bench","Engineer","ROB BILLY"]
[null,null,"Businessman","JIMMY HARDER","jimmy harder",null,null,null,"Businessman","JIMMY HARDER"]
[null,null,"Businessman","TOM PAIN","tom pain",null,null,null,"Businessman","TOM PAIN"]
[null,null,"Doctor","STEVE SMITH","steve smith",null,null,null,"Doctor","STEVE SMITH"]

{"sheet":"Power Query","index":3,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Power Query"]
[]
[null,"Car Brand","Profession","Name in Uppercase"]
[null,"Audi","Businessman","JANE KAT"]
[null,null,"Businessman","WILLIAM MARK"]
[null,null,"Doctor","MARK HENRY"]
[null,null,"Lawyer","KEVIN PIETERSON"]
[null,"Range Rover","Lawyer","JASON GOLD"]
[null,null,"Cricketer","HARRY DSUJA"]
[null,null,"Actor","NICOLAS TOM"]
[null,"Marcedes Bench","Engineer","ROB BILLY"]
[null,null,"Businessman","JIMMY HARDER"]
[null,null,"Businessman","TOM PAIN"]
[null,null,"Doctor","STEVE SMITH"]

{"sheet":"Output of Using Power Query","index":4,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Output of Using Power Query"]
[]
[null,"Car Brand","Profession","Name in Uppercase","Name in Lowercase"]
[null,"Audi","Businessman","JANE KAT","jane kat"]
[null,null,"Businessman","WILLIAM MARK","william mark"]
[null,null,"Doctor","MARK HENRY","mark henry"]
[null,null,"Lawyer","KEVIN PIETERSON","kevin pieterson"]
[null,"Range Rover","Lawyer","JASON GOLD","jason gold"]
[null,null,"Cricketer","HARRY DSUJA","harry dsuja"]
[null,null,"Actor","NICOLAS TOM","nicolas tom"]
[null,"Marcedes Bench","Engineer","ROB BILLY","rob billy"]
[null,null,"Businessman","JIMMY HARDER","jimmy harder"]
[null,null,"Businessman","TOM PAIN","tom pain"]
[null,null,"Doctor","STEVE SMITH","steve smith"]

{"sheet":"Using Microsoft Word","index":5,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[4,1,7,1],[8,1,10,1],[11,1,14,1],[1,1,1,4],[1,7,1,10],[4,7,7,7],[8,7,10,7],[11,7,14,7]]}
[]
[null,"Utilizing Microsoft Word",null,null,null,null,null,"Try It by Yourself"]
[]
[null,"Car Brand","Profession","Name in Uppercase","Name in Lowercase",null,null,"Car Brand","Profession","Name in Uppercase","Name in Lowercase"]
[null,"Audi","Businessman","JANE KAT","jane kat",null,null,"Audi","Businessman","JANE KAT"]
[null,null,"Businessman","WILLIAM MARK","william mark",null,null,null,"Businessman","WILLIAM MARK"]
[null,null,"Doctor","MARK HENRY","mark henry",null,null,null,"Doctor","MARK HENRY"]
[null,null,"Lawyer","KEVIN PIETERSON","kevin pieterson",null,null,null,"Lawyer","KEVIN PIETERSON"]
[null,"Range Rover","Lawyer","JASON GOLD","jason gold",null,null,"Range Rover","Lawyer","JASON GOLD"]
[null,null,"Cricketer","HARRY DSUJA","harry dsuja",null,null,null,"Cricketer","HARRY DSUJA"]
[null,null,"Actor","NICOLAS TOM","nicolas tom",null,null,null,"Actor","NICOLAS TOM"]
[null,"Marcedes Bench","Engineer","ROB BILLY","rob billy",null,null,"Marcedes Bench","Engineer","ROB BILLY"]
[null,null,"Businessman","JIMMY HARDER","jimmy harder",null,null,null,"Businessman","JIMMY HARDER"]
[null,null,"Businessman","TOM PAIN","tom pain",null,null,null,"Businessman","TOM PAIN"]
[null,null,"Doctor","STEVE SMITH","steve smith",null,null,null,"Doctor","STEVE SMITH"]

{"sheet":"VBA","index":6,"n_rows":15,"n_cols":11,"rows_kept":15,"cut":false,"hidden":false,"merged":[[4,1,7,1],[8,1,10,1],[11,1,14,1],[1,1,1,4],[1,7,1,10],[4,7,7,7],[8,7,10,7],[11,7,14,7]]}
[]
[null,"Applying VBA",null,null,null,null,null,"Try It by Yourself"]
[]
[null,"Car Brand","Profession","Name in Uppercase","Name in Uppercase",null,null,"Car Brand","Profession","Name in Uppercase","Name in Uppercase"]
[null,"Audi","Businessman","JANE KAT","jane kat",null,null,"Audi","Businessman","JANE KAT"]
[null,null,"Businessman","WILLIAM MARK","william mark",null,null,null,"Businessman","WILLIAM MARK"]
[null,null,"Doctor","MARK HENRY","mark henry",null,null,null,"Doctor","MARK HENRY"]
[null,null,"Lawyer","KEVIN PIETERSON","kevin pieterson",null,null,null,"Lawyer","KEVIN PIETERSON"]
[null,"Range Rover","Lawyer","JASON GOLD","jason gold",null,null,"Range Rover","Lawyer","JASON GOLD"]
[null,null,"Cricketer","HARRY DSUJA","harry dsuja",null,null,null,"Cricketer","HARRY DSUJA"]
[null,null,"Actor","NICOLAS TOM","nicolas tom",null,null,null,"Actor","NICOLAS TOM"]
[null,"Marcedes Bench","Engineer","ROB BILLY","rob billy",null,null,"Marcedes Bench","Engineer","ROB BILLY"]
[null,null,"Businessman","JIMMY HARDER","jimmy harder",null,null,null,"Businessman","JIMMY HARDER"]
[null,null,"Businessman","TOM PAIN","tom pain",null,null,null,"Businessman","TOM PAIN"]
[null,null,"Doctor","STEVE SMITH","steve smith",null,null,null,"Doctor","STEVE SMITH"]