{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Data Set","CTRL+Enter","CTRL+R","CTRL+D","AutoFill","Copy and Paste","Non-adjacent Cells","Fill Handle","Excel Table","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":"Data Set","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[10,1,11,1]]}
[]
[null,"Sample Data Set"]
[]
[null,"Product","Price (Euro)","Price (USD) ","Price (GBP)","Price (JPY)"]
[null,"Apple",6.25]
[null,"Orange",4.75]
[null,"Banana",3.8]
[null,"Pineapple",4.7]
[null,"Lemon",2.5]
[]
[null,"Exchange Rate","EUR-USD","EUR-GBP","EUR-JPY"]
[null,null,1.1359999999999999,0.89249999999999996,128.38]

{"sheet":"CTRL+Enter","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[10,1,11,1]]}
[]
[null,"Pressing CTRL + Enter Keys "]
[]
[null,"Product","Price (Euro)","Price (USD) ","Price (GBP)","Price (JPY)"]
[null,"Apple",6.25,{"$f":"$C5*C$12","v":7.1},5.578125,802.375]
[null,"Orange",4.75,5.3959999999999999,4.2393749999999999,609.80499999999995]
[null,"Banana",3.8,4.3167999999999997,3.3914999999999997,487.84399999999994]
[null,"Pineapple",4.7,5.3391999999999999,4.19475,603.38599999999997]
[null,"Lemon",2.5,2.84,2.2312499999999997,320.95]
[]
[null,"Exchange Rate","EUR-USD","EUR-GBP","EUR-JPY"]
[null,null,1.1359999999999999,0.89249999999999996,128.38]

{"sheet":"CTRL+R","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[10,1,11,1]]}
[]
[null,"Pressing CTRL + R Keys "]
[]
[null,"Product","Price (Euro)","Price (USD) ","Price (GBP)","Price (JPY)"]
[null,"Apple",6.25,{"$f":"$C5*C$12","v":7.1},{"$f":"$C5*D$12","v":5.578125},{"$f":"$C5*E$12","v":802.375}]
[null,"Orange",4.75,{"$f":"$C6*C$12","v":5.3959999999999999},4.2393749999999999,{"$f":"$C6*E$12","v":609.80499999999995}]
[null,"Banana",3.8,4.3167999999999997,3.3914999999999997,{"$f":"$C7*E$12","v":487.84399999999994}]
[null,"Pineapple",4.7,5.3391999999999999,4.19475,{"$f":"$C8*E$12","v":603.38599999999997}]
[null,"Lemon",2.5,2.84,2.2312499999999997,{"$f":"$C9*E$12","v":320.95}]
[]
[null,"Exchange Rate","EUR-USD","EUR-GBP","EUR-JPY"]
[null,null,1.1359999999999999,0.89249999999999996,128.38]

{"sheet":"CTRL+D","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[10,1,11,1]]}
[]
[null,"Pressing CTRL + D Keys "]
[]
[null,"Product","Price (Euro)","Price (USD) ","Price (GBP)","Price (JPY)"]
[null,"Apple",6.25,{"$f":"$C5*C$12","v":7.1},{"$f":"$C5*D$12","v":5.578125},802.375]
[null,"Orange",4.75,{"$f":"$C6*C$12","v":5.3959999999999999},4.2393749999999999,609.80499999999995]
[null,"Banana",3.8,4.3167999999999997,3.3914999999999997,487.84399999999994]
[null,"Pineapple",4.7,5.3391999999999999,4.19475,603.38599999999997]
[null,"Lemon",2.5,2.84,2.2312499999999997,320.95]
[]
[null,"Exchange Rate","EUR-USD","EUR-GBP","EUR-JPY"]
[null,null,1.1359999999999999,0.89249999999999996,128.38]

{"sheet":"AutoFill","index":4,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[10,1,11,1]]}
[]
[null,"Implying AutoFill Feature "]
[]
[null,"Product","Price (Euro)","Price (USD) ","Price (GBP)","Price (JPY)"]
[null,"Apple",6.25,{"$f":"$C5*C$12","v":7.1}]
[null,"Orange",4.75]
[null,"Banana",3.8]
[null,"Pineapple",4.7]
[null,"Lemon",2.5]
[]
[null,"Exchange Rate","EUR-USD","EUR-GBP","EUR-JPY"]
[null,null,1.1359999999999999,0.89249999999999996,128.38]

{"sheet":"Copy and Paste","index":5,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[10,1,11,1]]}
[]
[null,"Utilizing Copy and Paste Command"]
[]
[null,"Product","Price (Euro)","Price (USD) ","Price (GBP)","Price (JPY)"]
[null,"Apple",6.25,{"$f":"$C5*C$12","v":7.1},{"$f":"$C5*D$12","v":5.578125},802.375]
[null,"Orange",4.75,{"$f":"$C6*C$12","v":5.3959999999999999},4.2393749999999999,609.80499999999995]
[null,"Banana",3.8,{"$f":"$C7*C$12","v":4.3167999999999997},3.3914999999999997,487.84399999999994]
[null,"Pineapple",4.7,{"$f":"$C8*C$12","v":5.3391999999999999},4.19475,603.38599999999997]
[null,"Lemon",2.5,{"$f":"$C9*C$12","v":2.84},2.2312499999999997,320.95]
[]
[null,"Exchange Rate","EUR-USD","EUR-GBP","EUR-JPY"]
[null,null,1.1359999999999999,0.89249999999999996,128.38]

{"sheet":"Non-adjacent Cells","index":6,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[10,1,11,1]]}
[]
[null,"Copying Formula to Non-adjacent Cells"]
[]
[null,"Product","Price (Euro)","Price (USD) ","Price (GBP)","Price (JPY)"]
[null,"Apple",6.25,{"$f":"$C5*C$12","v":7.1}]
[null,"Orange",4.75,null,{"$f":"$C6*D$12","v":4.2393749999999999},{"$f":"$C6*E$12","v":609.80499999999995}]
[null,"Banana",3.8,{"$f":"$C7*C$12","v":4.3167999999999997}]
[null,"Pineapple",4.7,null,{"$f":"$C8*D$12","v":4.19475}]
[null,"Lemon",2.5,{"$f":"$C9*C$12","v":2.84},null,{"$f":"$C9*E$12","v":320.95}]
[]
[null,"Exchange Rate","EUR-USD","EUR-GBP","EUR-JPY"]
[null,null,1.1359999999999999,0.89249999999999996,128.38]

{"sheet":"Fill Handle","index":7,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[10,1,11,1]]}
[]
[null,"Using Excel Fill Handle Tool"]
[]
[null,"Product","Price (Euro)","Price (USD) ","Price (GBP)","Price (JPY)"]
[null,"Apple",6.25,{"$f":"$C5*C$12","v":7.1}]
[null,"Orange",4.75,{"$f":"$C6*C$12","v":5.3959999999999999}]
[null,"Banana",3.8,4.3167999999999997]
[null,"Pineapple",4.7,5.3391999999999999]
[null,"Lemon",2.5,2.84]
[]
[null,"Exchange Rate","EUR-USD","EUR-GBP","EUR-JPY"]
[null,null,1.1359999999999999,0.89249999999999996,128.38]

{"sheet":"Excel Table","index":8,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[10,1,11,1]]}
[]
[null,"Inserting Excel Table"]
[]
[null,"Product","Price (Euro)","Price (USD) ","Price (GBP)","Price (JPY)"]
[null,"Apple",6.25,{"$f":"$C5*C$12","v":7.1},5.578125,802.375]
[null,"Orange",4.75,5.3959999999999999,4.2393749999999999,609.80499999999995]
[null,"Banana",3.8,4.3167999999999997,3.3914999999999997,487.84399999999994]
[null,"Pineapple",4.7,5.3391999999999999,4.19475,603.38599999999997]
[null,"Lemon",2.5,2.84,2.2312499999999997,320.95]
[]
[null,"Exchange Rate","EUR-USD","EUR-GBP","EUR-JPY"]
[null,null,1.1359999999999999,0.89249999999999996,128.38]

{"sheet":"VBA","index":9,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5],[10,1,11,1]]}
[]
[null,"Applying VBA"]
[]
[null,"Product","Price (Euro)","Price (USD) ","Price (GBP)","Price (JPY)"]
[null,"Apple",6.25,{"$f":"$C5*C$12","v":7.1},5.578125,802.375]
[null,"Orange",4.75,5.3959999999999999,4.2393749999999999,609.80499999999995]
[null,"Banana",3.8,4.3167999999999997,3.3914999999999997,487.84399999999994]
[null,"Pineapple",4.7,5.3391999999999999,4.19475,603.38599999999997]
[null,"Lemon",2.5,2.84,2.2312499999999997,320.95]
[]
[null,"Exchange Rate","EUR-USD","EUR-GBP","EUR-JPY"]
[null,null,1.1359999999999999,0.89249999999999996,128.38]