{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Overview","Ex1","Ex2","Ex3","Ex4","Ex5","Flash Fill","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":"Overview","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,4,3,5],[1,1,1,5]]}
[]
["                         ","  Excel LOWER Function"]
[]
[null,"Value","Formula ","Result","Explanation"]
[null,"Computer"," =LOWER(B6)",{"$f":"LOWER(B5)","v":"computer"},">>","Converts all the letters into lowercase"]
[null,"COMPUTER"," =LOWER(B7)","computer",">>","Converts all the letters into lowercase"]
[null,"Computer Science"," =LOWER(B8)","computer science",">>","Converts all the letters into lowercase"]
[null,"Computer, Science"," =LOWER(B9)","computer, science",">>","Converts all the letters into lowercase"]
[null,"CS-005"," =LOWER(B10)","cs-005",">>","Converts all the letters into lowercase (Alphanumeric case)"]
[null,500.25," =LOWER(B11)","500.25",">>","Formatting is ignored"]
[null,"2021-08-18"," =LOWER(B12)","44426",">>","Date format is lost "]
[null,550500," =LOWER(B13)","550500",">>","Numbers remained same"]

{"sheet":"Ex1","index":1,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Conversion of Text",null,null,null,null,null,null,null,null,"For Practice"]
[]
[null,"ID","Name","Price","Updated Name",null,null,null,null,null,"ID","Name","Price","Updated Name"]
[null,1122,"APPLE IPHONE 11 PRO",1200,{"$f":"LOWER(C5)","v":"apple iphone 11 pro"},null,null,null,null,null,1122,"APPLE IPHONE 11 PRO",1200]
[null,1133,"SAMSUNG GALAXY NOTE 10",1100,{"$f":"LOWER(C6)","v":"samsung galaxy note 10"},null,null,null,null,null,1133,"SAMSUNG GALAXY NOTE 10",1100]
[null,1133,"GALAXY NOTE 10 LITE",1000,"galaxy note 10 lite",null,null,null,null,null,1133,"GALAXY NOTE 10 LITE",1000]
[null,1144,"SAMSUNG GALAXY NOTE 9 ",900,"samsung galaxy note 9 ",null,null,null,null,null,1144,"SAMSUNG GALAXY NOTE 9 ",900]
[null,1155,"APPLE IPHONE  X",1150,"apple iphone  x",null,null,null,null,null,1155,"APPLE IPHONE  X",1150]
[null,1166,"APPLE IPHONE XR",850,"apple iphone xr",null,null,null,null,null,1166,"APPLE IPHONE XR",850]

{"sheet":"Ex2","index":2,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Conversion of Alphanumeric Text",null,null,null,null,null,null,null,null,"For Practice"]
[]
[null,"ID","Name","Price","Updated ID",null,null,null,null,null,"ID","Name","Price","Updated ID"]
[null,"AP-1122","APPLE IPHONE 11 PRO",1200,{"$f":"LOWER(B5)","v":"ap-1122"},null,null,null,null,null,"AP-1122","APPLE IPHONE 11 PRO",1200]
[null,"SM-1133","SAMSUNG GALAXY NOTE 10",1100,{"$f":"LOWER(B6)","v":"sm-1133"},null,null,null,null,null,"SM-1133","SAMSUNG GALAXY NOTE 10",1100]
[null,"SG-1133","GALAXY NOTE 10 LITE",1000,"sg-1133",null,null,null,null,null,"SG-1133","GALAXY NOTE 10 LITE",1000]
[null,"SM-1144","SAMSUNG GALAXY NOTE 9 ",900,"sm-1144",null,null,null,null,null,"SM-1144","SAMSUNG GALAXY NOTE 9 ",900]
[null,"AP-1155","APPLE IPHONE  X",1150,"ap-1155",null,null,null,null,null,"AP-1155","APPLE IPHONE  X",1150]
[null,"AP-1166","APPLE IPHONE XR",850,"ap-1166",null,null,null,null,null,"AP-1166","APPLE IPHONE XR",850]

{"sheet":"Ex3","index":3,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Creation of Email Address",null,null,null,null,null,null,null,"For Practice"]
[]
[null,"ID ","First Name","Last Name","Email",null,null,null,null,"ID ","First Name","Last Name","Email"]
[null,122,"James","Parks",{"$f":"LOWER(C5&\".\"&D5&\"@\"&\"xyz.com\")","v":"james.parks@xyz.com"},null,null,null,null,122,"James","Parks"]
[null,133,"Jackson","Potter",{"$f":"LOWER(C6&\".\"&D6&\"@\"&\"xyz.com\")","v":"jackson.potter@xyz.com"},null,null,null,null,133,"Jackson","Potter"]
[null,144,"Avery","Lindsey","avery.lindsey@xyz.com",null,null,null,null,144,"Avery","Lindsey"]
[null,155,"Jack","Simon","jack.simon@xyz.com",null,null,null,null,155,"Jack","Simon"]
[null,166,"Eleanor","Lee","eleanor.lee@xyz.com",null,null,null,null,166,"Eleanor","Lee"]
[null,177,"Ellie","Perez","ellie.perez@xyz.com",null,null,null,null,177,"Ellie","Perez"]

{"sheet":"Ex4","index":4,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Conversion of Dates",null,null,null,null,null,null,null,null,"For Practice"]
[]
[null,"ID"," Name","Delivery Date","Updated Date",null,null,null,null,null,"ID"," Name","Delivery Date","Updated Date"]
[null,"AP-1122","APPLE IPHONE 11 PRO","2021-08-25",{"$f":"LOWER(TEXT(D5,\"mmmm d, yyyy\"))","v":"august 25, 2021"},null,null,null,null,null,"AP-1122","APPLE IPHONE 11 PRO","2021-08-25"]
[null,"SM-1133","SAMSUNG GALAXY NOTE 10","2021-08-20",{"$f":"LOWER(TEXT(D6,\"mmmm d, yyyy\"))","v":"august 20, 2021"},null,null,null,null,null,"SM-1133","SAMSUNG GALAXY NOTE 10","2021-08-20"]
[null,"SG-1133","GALAXY NOTE 10 LITE","2021-09-01","september 1, 2021",null,null,null,null,null,"SG-1133","GALAXY NOTE 10 LITE","2021-09-01"]
[null,"SM-1144","SAMSUNG GALAXY NOTE 9 ","2021-10-02","october 2, 2021",null,null,null,null,null,"SM-1144","SAMSUNG GALAXY NOTE 9 ","2021-10-02"]
[null,"AP-1155","APPLE IPHONE  X","2021-08-03","august 3, 2021",null,null,null,null,null,"AP-1155","APPLE IPHONE  X","2021-08-03"]
[null,"AP-1166","APPLE IPHONE XR","2021-11-04","november 4, 2021",null,null,null,null,null,"AP-1166","APPLE IPHONE XR","2021-11-04"]

{"sheet":"Ex5","index":5,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Conversion of Text with Range",null,null,null,null,null,null,null,null,"For Practice"]
[]
[null,"ID","Name","Price","Updated Name",null,null,null,null,null,"ID","Name","Price","Updated Name"]
[null,1122,"APPLE IPHONE 11 PRO",1200,{"$f":"LOWER(C5:C10)","v":"apple iphone 11 pro"},null,null,null,null,null,1122,"APPLE IPHONE 11 PRO",1200]
[null,1133,"SAMSUNG GALAXY NOTE 10",1100,"samsung galaxy note 10",null,null,null,null,null,1133,"SAMSUNG GALAXY NOTE 10",1100]
[null,1133,"GALAXY NOTE 10 LITE",1000,"galaxy note 10 lite",null,null,null,null,null,1133,"GALAXY NOTE 10 LITE",1000]
[null,1144,"SAMSUNG GALAXY NOTE 9 ",900,"samsung galaxy note 9 ",null,null,null,null,null,1144,"SAMSUNG GALAXY NOTE 9 ",900]
[null,1155,"APPLE IPHONE  X",1150,"apple iphone  x",null,null,null,null,null,1155,"APPLE IPHONE  X",1150]
[null,1166,"APPLE IPHONE XR",850,"apple iphone xr",null,null,null,null,null,1166,"APPLE IPHONE XR",850]

{"sheet":"Flash Fill","index":6,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Use of Flash Fill",null,null,null,null,null,null,null,"For Practice"]
[]
[null,"ID ","Name","Updated Name",null,null,null,null,null,"ID ","Name","Updated Name"]
[null,122,"James Parks","james parks",null,null,null,null,null,122,"James Parks"]
[null,133,"Jackson Potter","jackson potter",null,null,null,null,null,133,"Jackson Potter"]
[null,144,"Avery Lindsey","avery lindsey",null,null,null,null,null,144,"Avery Lindsey"]
[null,155,"Jack Simon","jack simon",null,null,null,null,null,155,"Jack Simon"]
[null,166,"Eleanor Lee","eleanor lee",null,null,null,null,null,166,"Eleanor Lee"]
[null,177,"Ellie Perez","ellie perez",null,null,null,null,null,177,"Ellie Perez"]

{"sheet":"VBA","index":7,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of VBA"]
[]
[null,"ID ","Name"]
[null,122,"James Parks"]
[null,133,"Jackson Potter"]
[null,144,"Avery Lindsey"]
[null,155,"Jack Simon"]
[null,166,"Eleanor Lee"]
[null,177,"Ellie Perez"]