{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset 1","No Arguments","Dataset 2","Selecting Cells","Dataset 3","Input as Array","Dataset 4","Multiple Arguments","Dataset 5","Optional Arguments"],"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":"Dataset 1","index":0,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset 1"]
[]
[null,"Formatting","Date"]
[null,"dd-mm-yy"]
[null,"dd-mmm-yy"]
[null,"dd-mmm"]
[null,"mmm-yy"]

{"sheet":"No Arguments","index":1,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Creating User Defined Function with No Arguments",null,null,null,null,null,"Practice Section"]
[]
[null,"Formatting","Date",null,null,null,null,"Formatting","Date"]
[null,"dd-mm-yy",{"$f":"present_day()","v":"2022-09-11"},null,null,null,null,"dd-mm-yy"]
[null,"dd-mmm-yy",{"$f":"present_day()","v":"2022-09-11"},null,null,null,null,"dd-mmm-yy"]
[null,"dd-mmm",{"$f":"present_day()","v":"2022-09-11"},null,null,null,null,"dd-mmm"]
[null,"mmm-yy",{"$f":"present_day()","v":"2022-09-11"},null,null,null,null,"mmm-yy"]

{"sheet":"Dataset 2","index":2,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset 2"]
[]
[null,"Kilometers","Miles"]
[null,3]
[null,7]
[null,15]
[null,30]

{"sheet":"Selecting Cells","index":3,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Selecting Cells in Mandatory Arguments",null,null,null,null,null,"Practice Section"]
[]
[null,"Kilometers","Miles",null,null,null,null,"Kilometers","Miles"]
[null,3,{"$f":"km_to_mile(B5)","v":1.8641099999999999},null,null,null,null,3]
[null,7,{"$f":"km_to_mile(B6)","v":4.3495900000000001},null,null,null,null,7]
[null,15,{"$f":"km_to_mile(B7)","v":9.320549999999999},null,null,null,null,15]
[null,30,{"$f":"km_to_mile(B8)","v":18.641099999999998},null,null,null,null,30]

{"sheet":"Dataset 3","index":4,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[4,2,11,2]]}
[]
[null,"Dataset 3"]
[]
[null,"Numbers","Sum of Even Numbers"]
[null,6]
[null,7]
[null,9]
[null,2]
[null,18]
[null,21]
[null,19]
[null,30]

{"sheet":"Input as Array","index":5,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[4,2,11,2],[1,8,1,9],[4,9,11,9]]}
[]
[null,"Taking Input as Array",null,null,null,null,null,null,"Practice Section"]
[]
[null,"Numbers","Sum of Even Numbers",null,null,null,null,null,"Numbers","Sum of Even Numbers"]
[null,6,{"$f":"even_number_sum(B5:B12)","v":56},null,null,null,null,null,6]
[null,7,null,null,null,null,null,null,7]
[null,9,null,null,null,null,null,null,9]
[null,2,null,null,null,null,null,null,2]
[null,18,null,null,null,null,null,null,18]
[null,21,null,null,null,null,null,null,21]
[null,19,null,null,null,null,null,null,19]
[null,30,null,null,null,null,null,null,30]

{"sheet":"Dataset 4","index":6,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset 4"]
[]
[null,"Date 1","Date 2","Day Difference"]
[null,"2022-03-02","2022-06-04"]
[null,"2020-06-06","2022-09-12"]
[null,"2021-08-04","2021-11-06"]
[null,"2019-11-03","2020-09-05"]

{"sheet":"Multiple Arguments","index":7,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Utilizing Multiple Arguments",null,null,null,null,null,null,"Practice Section"]
[]
[null,"Date 1","Date 2","Day Difference",null,null,null,null,"Date 1","Date 2","Day Difference"]
[null,"2022-03-02","2022-06-04",{"$f":"day_difference(B5,C5)","v":94},null,null,null,null,"2022-03-02","2022-06-04"]
[null,"2020-06-06","2022-09-12",{"$f":"day_difference(B6,C6)","v":828},null,null,null,null,"2020-06-06","2022-09-12"]
[null,"2021-08-04","2021-11-06",{"$f":"day_difference(B7,C7)","v":94},null,null,null,null,"2021-08-04","2021-11-06"]
[null,"2019-11-03","2020-09-05",{"$f":"day_difference(B8,C8)","v":307},null,null,null,null,"2019-11-03","2020-09-05"]

{"sheet":"Dataset 5","index":8,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset 5"]
[]
[null,"Texts","Desired Format"]
[null,"ExcelDemy"]
[null,"Microsoft"]
[null,"Excel"]
[null,"Microsoft Office"]

{"sheet":"Optional Arguments","index":9,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Using Optional Arguments",null,null,null,null,null,"Practice Section"]
[]
[null,"Texts","Desired Format",null,null,null,null,"Texts","Desired Format"]
[null,"ExcelDemy",{"$f":"fetch_text(B5,TRUE)","v":"EXCELDEMY"},null,null,null,null,"ExcelDemy"]
[null,"Microsoft",{"$f":"fetch_text(B6,FALSE)","v":"Microsoft"},null,null,null,null,"Microsoft"]
[null,"Excel",{"$f":"fetch_text(B7)","v":"Excel"},null,null,null,null,"Excel"]
[null,"Microsoft Office",{"$f":"fetch_text(B8,TRUE)","v":"MICROSOFT OFFICE"},null,null,null,null,"Microsoft Office"]