{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Sample Dataset","Apostrophe","Format Cell","TEXT Function","Text to Columns Wizard","IF Function","Excel VBA","Practice Worksheet"],"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":"Sample Dataset","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Converting number to text with 2 decimal places"]
[]
[null,"Items","Price in USD"]
[null,"Glazed Donut",2.19]
[null,"Blueberry Muffin",2.75]
[null,"Baked Apple Pie",1.0900000000000001]
[null,"Apple Fritter",2.86]
[null,"Cinnamon Roll",3.22]
[null,"Cherry Pie",1.1200000000000001]

{"sheet":"Apostrophe","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Adding an apostrophe symbol"]
[]
[null,"Items","Price in USD","Price in Text"]
[null,"Glazed Donut",2.19,"2.19"]
[null,"Blueberry Muffin",2.75,"2.20"]
[null,"Baked Apple Pie",1.0900000000000001,"2.21"]
[null,"Apple Fritter",2.86,"2.22"]
[null,"Cinnamon Roll",3.22,"2.23"]
[null,"Cherry Pie",1.1200000000000001,"2.24"]

{"sheet":"Format Cell","index":2,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Utilizing the format cell option"]
[]
[null,"Items","Price in USD","Price in Text"]
[null,"Glazed Donut",2.19,2.19]
[null,"Blueberry Muffin",2.75,2.75]
[null,"Baked Apple Pie",1.0900000000000001,1.0900000000000001]
[null,"Apple Fritter",2.86,2.86]
[null,"Cinnamon Roll",3.22,3.22]
[null,"Cherry Pie",1.1200000000000001,1.1200000000000001]

{"sheet":"TEXT Function","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Employing the TEXT function "]
[]
[null,"Items","Price in USD","Price in Text"]
[null,"Glazed Donut",2.19,{"$f":"TEXT(C6,\"##0.00\")","v":"2.19"}]
[null,"Blueberry Muffin",2.75,{"$f":"TEXT(C7,\"##0.00\")","v":"2.75"}]
[null,"Baked Apple Pie",1.0900000000000001,"1.09"]
[null,"Apple Fritter",2.86,"2.86"]
[null,"Cinnamon Roll",3.22,"3.22"]
[null,"Cherry Pie",1.1200000000000001,"1.12"]

{"sheet":"Text to Columns Wizard","index":4,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Using the Text to Columns Wizard"]
[]
[null,"Items","Price in USD","Price in Text"]
[null,"Glazed Donut",2.19,"2.19"]
[null,"Blueberry Muffin",2.75,"2.75"]
[null,"Baked Apple Pie",1.0900000000000001,"1.09"]
[null,"Apple Fritter",2.86,"2.86"]
[null,"Cinnamon Roll",3.22,"3.22"]
[null,"Cherry Pie",1.1200000000000001,"1.12"]

{"sheet":"IF Function","index":5,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Implementing the IF function"]
[]
[null,"Items","Price in USD","Price in Text"]
[null,"Glazed Donut",2.19,{"$f":"IF(CELL(\"FORMAT\",C6)=\"F2\", TEXT(C6,\"0.00\"), TEXT(C6, 0))","v":"2.19"}]
[null,"Blueberry Muffin",2.75,{"$f":"IF(CELL(\"FORMAT\",C7)=\"F2\", TEXT(C7,\"0.00\"), TEXT(C7, 0))","v":"2.75"}]
[null,"Baked Apple Pie",1.0900000000000001,"1.09"]
[null,"Apple Fritter",2.86,"2.86"]
[null,"Cinnamon Roll",3.22,"3.22"]
[null,"Cherry Pie",1.1200000000000001,"1.12"]

{"sheet":"Excel VBA","index":6,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Executing Excel VBA code"]
[]
[null,"Items","Price in USD","Price in Text"]
[null,"Glazed Donut",2.19,2.19]
[null,"Blueberry Muffin",2.75,2.75]
[null,"Baked Apple Pie",1.0900000000000001,1.0900000000000001]
[null,"Apple Fritter",2.86,2.86]
[null,"Cinnamon Roll",3.22,3.22]
[null,"Cherry Pie",1.1200000000000001,1.1200000000000001]

{"sheet":"Practice Worksheet","index":7,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Practice"]
[]
[null,"Items","Price in USD","Price in Text"]
[null,"Glazed Donut",2.19]
[null,"Blueberry Muffin",2.75]
[null,"Baked Apple Pie",1.0900000000000001]
[null,"Apple Fritter",2.86]
[null,"Cinnamon Roll",3.22]
[null,"Cherry Pie",1.1200000000000001]