{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Change Format","Paste Special","VBA","Text To Column","Hidden Characters","Hidden Character-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":"Change Format","index":0,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Convert Text to Number",null,null,null,null,null,"Practice Yourself"]
[]
[null,"Books","Quantity",null,null,null,null,"Books","Quantity"]
[null,"Anna Karenina ",35,null,null,null,null,"Anna Karenina ","35"]
[null,"War and Peace",45,null,"COUNTA",{"$f":"COUNTA(C5:C9)","v":5},null,"War and Peace","45",null,"COUNTA",{"$f":"COUNTA(I5:I9)","v":5}]
[null,"The Great Gatsby",60,null,"COUNT",{"$f":"COUNT(C5:C9)","v":5},null,"The Great Gatsby","60",null,"COUNT",{"$f":"COUNT(I5:I9)","v":0}]
[null,"David Copperfield",40,null,null,null,null,"David Copperfield","40"]
[null,"Pride and Prejudice",60,null,null,null,null,"Pride and Prejudice","60"]
[null,"Total",{"$f":"SUM(C5:C9)","v":240},null,null,null,null,"Total",{"$f":"SUM(I5:I9)","v":0}]

{"sheet":"Paste Special","index":1,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Use of 'Paste Special' Option",null,null,"Practice Yourself"]
[]
[null,"Books","Quantity",null,"Books","Quantity"]
[null,"Anna Karenina ",35,null,"Anna Karenina ","35"]
[null,"War and Peace",45,null,"War and Peace","45"]
[null,"The Great Gatsby",60,null,"The Great Gatsby","60"]
[null,"David Copperfield",40,null,"David Copperfield","40"]
[null,"Pride and Prejudice",60,null,"Pride and Prejudice","60"]
[null,"Total",{"$f":"SUM(C5:C9)","v":240},null,"Total",{"$f":"SUM(F5:F9)","v":0}]

{"sheet":"VBA","index":2,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Use of VBA Code",null,null,"Practice Yourself"]
[]
[null,"Books","Quantity",null,"Books","Quantity"]
[null,"Anna Karenina ",35,null,"Anna Karenina ","35"]
[null,"War and Peace",45,null,"War and Peace","45"]
[null,"The Great Gatsby",60,null,"The Great Gatsby","60"]
[null,"David Copperfield",40,null,"David Copperfield","40"]
[null,"Pride and Prejudice",60,null,"Pride and Prejudice","60"]
[null,"Total",{"$f":"SUM(C5:C9)","v":240},null,"Total",{"$f":"SUM(F5:F9)","v":0}]

{"sheet":"Text To Column","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Use of 'Text to Column' Option",null,null,"Practice Yourself"]
[]
[null,"Books","Quantity",null,"Books","Quantity"]
[null,"Anna Karenina ",35,null,"Anna Karenina ","35"]
[null,"War and Peace",45,null,"War and Peace","45"]
[null,"The Great Gatsby",60,null,"The Great Gatsby","60"]
[null,"David Copperfield",40,null,"David Copperfield","40"]
[null,"Pride and Prejudice",60,null,"Pride and Prejudice","60"]
[null,"Total",{"$f":"SUM(C5:C9)","v":240},null,"Total",{"$f":"SUM(F5:F9)","v":0}]

{"sheet":"Hidden Characters","index":4,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Use of Character Code",null,null,"Practice Yourself"]
[]
[null,"Books","Quantity",null,"Books","Quantity"]
[null,"Anna Karenina ",237,null,"Anna Karenina ","237  "]
[null,"War and Peace",792,null,"War and Peace","792  "]
[null,"The Great Gatsby",514,null,"The Great Gatsby","514  "]
[null,"David Copperfield",491,null,"David Copperfield","491  "]
[null,"Total",{"$f":"SUM(C5:C8)","v":2034},null,"Total",{"$f":"SUM(F7:F8)","v":0}]

{"sheet":"Hidden Character-VBA","index":5,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Use of VBA Code",null,null,"Practice Yourself"]
[]
[null,"Books","Quantity",null,"Books","Quantity"]
[null,"Anna Karenina ",237,null,"Anna Karenina ","237  "]
[null,"War and Peace",792,null,"War and Peace","792  "]
[null,"The Great Gatsby",514,null,"The Great Gatsby","514  "]
[null,"David Copperfield",491,null,"David Copperfield","491  "]
[null,"Total",{"$f":"SUM(C5:C8)","v":2034},null,"Total",{"$f":"SUM(F7:F8)","v":0}]