{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset","AutoFill Method","Shortcut Method","Excel Table Method","Dynamic Array Method","VBA Method"," Copy and Paste Command Method","Shortcut CTRL+D Method","Shortcut CTRL+R Method","Formula for Non Adjacent Cells"],"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","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sample Dataset"]
[]
[null,"Employee Name","Salary 2020","Salary 2021","Increment"]
[null,"Rob",1500,2150]
[null,"John",1700,2390]
[null,"Jack",1400,2740]
[null,"Matt",1580,2167]
[null,"Christophar",1350,2768]
[null,"David",1620,2330]
[null,"Anne",1800,2530]

{"sheet":"AutoFill Method","index":1,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Use of Autofill Tool",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name","Salary 2020","Salary 2021","Increment",null,null,null,null,null,"Employee Name","Salary 2020","Salary 2021","Increament"]
[null,"Rob",1500,2150,{"$f":"D5-C5","v":650},null,null,null,null,null,"Rob",1500,2150]
[null,"John",1700,2390,{"$f":"D6-C6","v":690},null,null,null,null,null,"John",1700,2390]
[null,"Jack",1400,2740,1340,null,null,null,null,null,"Jack",1400,2740]
[null,"Matt",1580,2167,587,null,null,null,null,null,"Matt",1580,2167]
[null,"Christophar",1350,2768,1418,null,null,null,null,null,"Christophar",1350,2768]
[null,"David",1620,2330,710,null,null,null,null,null,"David",1620,2330]
[null,"Anne",1800,2530,730,null,null,null,null,null,"Anne",1800,2530]

{"sheet":"Shortcut Method","index":2,"n_rows":11,"n_cols":14,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Use of Keyboard Shortcut",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name","Salary 2020","Salary 2021","Increment",null,null,null,null,null,"Employee Name","Salary 2020","Salary 2021","Increament"]
[null,"Rob",1500,2150,{"$f":"D5-C5","v":650},null,null,null,null,null,"Rob",1500,2150]
[null,"John",1700,2390,690,null,null,null,null,null,"John",1700,2390]
[null,"Jack",1400,2740,1340,null,null,null,null,null,"Jack",1400,2740]
[null,"Matt",1580,2167,587,null,null,null,null,null,"Matt",1580,2167]
[null,"Christophar",1350,2768,1418,null,null,null,null,null,"Christophar",1350,2768]
[null,"David",1620,2330,710,null,null,null,null,null,"David",1620,2330]
[null,"Anne",1800,2530,730,null,null,null,null,null,"Anne",1800,2530]

{"sheet":"Excel Table Method","index":3,"n_rows":11,"n_cols":13,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Use of Table",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name","Salary 2020","Salary 2021","Increment",null,null,null,null,"Employee Name","Salary 2020","Salary 2021","Increament"]
[null,"Rob",1500,2150,{"$f":"Table1[[#This Row],[Salary 2021]]-Table1[[#This Row],[Salary 2020]]","v":650},null,null,null,null,"Rob",1500,2150]
[null,"John",1700,2390,{"$f":"Table1[[#This Row],[Salary 2021]]-Table1[[#This Row],[Salary 2020]]","v":690},null,null,null,null,"John",1700,2390]
[null,"Jack",1400,2740,{"$f":"Table1[[#This Row],[Salary 2021]]-Table1[[#This Row],[Salary 2020]]","v":1340},null,null,null,null,"Jack",1400,2740]
[null,"Matt",1580,2167,{"$f":"Table1[[#This Row],[Salary 2021]]-Table1[[#This Row],[Salary 2020]]","v":587},null,null,null,null,"Matt",1580,2167]
[null,"Christophar",1350,2768,{"$f":"Table1[[#This Row],[Salary 2021]]-Table1[[#This Row],[Salary 2020]]","v":1418},null,null,null,null,"Christophar",1350,2768]
[null,"David",1620,2330,{"$f":"Table1[[#This Row],[Salary 2021]]-Table1[[#This Row],[Salary 2020]]","v":710},null,null,null,null,"David",1620,2330]
[null,"Anne",1800,2530,{"$f":"Table1[[#This Row],[Salary 2021]]-Table1[[#This Row],[Salary 2020]]","v":730},null,null,null,null,"Anne",1800,2530]

{"sheet":"Dynamic Array Method","index":4,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Creating Dynamic Array Formula",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Employee Name","Salary 2020","Salary 2021","Increment",null,null,null,null,null,null,"Employee Name","Salary 2020","Salary 2021","Increament"]
[null,"Rob",1500,2150,{"$f":"D5:D11-C5:C11","v":650},null,null,null,null,null,null,"Rob",1500,2150]
[null,"John",1700,2390,690,null,null,null,null,null,null,"John",1700,2390]
[null,"Jack",1400,2740,1340,null,null,null,null,null,null,"Jack",1400,2740]
[null,"Matt",1580,2167,587,null,null,null,null,null,null,"Matt",1580,2167]
[null,"Christophar",1350,2768,1418,null,null,null,null,null,null,"Christophar",1350,2768]
[null,"David",1620,2330,710,null,null,null,null,null,null,"David",1620,2330]
[null,"Anne",1800,2530,730,null,null,null,null,null,null,"Anne",1800,2530]

{"sheet":"VBA Method","index":5,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,10,1,14],[1,1,1,5]]}
[]
[null,"Use of VBA ",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,46,82,58,70,106,null,null,null,null,4,13,7,10,19]
[null,70,70,82,106,70,null,null,null,null,10,10,13,19,10]
[null,94,82,106,130,106,null,null,null,null,16,13,19,25,19]
[null,106,94,118,46,130,null,null,null,null,19,16,22,4,25]
[null,118,118,130,70,58,null,null,null,null,22,22,25,10,7]
[null,70,82,70,130,142,null,null,null,null,10,13,10,25,28]
[null,82,70,46,82,46,null,null,null,null,13,10,4,13,4]
[null,70,58,70,70,82,null,null,null,null,10,7,10,10,13]

{"sheet":" Copy and Paste Command Method","index":6,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[10,1,10,3],[1,10,1,14],[10,10,10,12]]}
[]
[null,"Use of Copy and Paste Command",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Product","Price (February)","Price (March)","Price (April)","Price (May)",null,null,null,null,"Product","Price (February)","Price (March)","Price (April)","Price (May)"]
[null,"Orange",5,{"$f":"$C5-$C5*B$14","v":4.9000000000000004},null,null,null,null,null,null,"Orange",5]
[null,"Banana",3,2.94,null,null,null,null,null,null,"Banana",3]
[null,"Mango",7,6.86,null,null,null,null,null,null,"Mango",7]
[null,"Apple",4,3.92,null,null,null,null,null,null,"Apple",4]
[null,"Grape",6,5.88,null,null,null,null,null,null,"Grape",6]
[]
[null,"Discount",null,null,null,null,null,null,null,null,"Discount"]
[]
[null,"March","April","May",null,null,null,null,null,null,"March","April","May"]
[null,0.02,0.03,0.05,null,null,null,null,null,null,0.02,0.03,0.05]

{"sheet":"Shortcut CTRL+D Method","index":7,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15],[10,1,10,3],[10,11,10,13]]}
[]
[null,"Keyboard Shortcut CTRL + D",null,null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Product","Price (February)","Price (March)","Price (April)","Price (May)",null,null,null,null,null,"Product","Price (February)","Price (March)","Price (April)","Price (May)"]
[null,"Orange",5,{"$f":"$C5-$C5*B$14","v":4.9000000000000004},{"$f":"$C5-$C5*C$14","v":4.8499999999999996},{"$f":"$C5-$C5*D$14","v":4.75},null,null,null,null,null,"Orange",5]
[null,"Banana",3,{"$f":"$C6-$C6*B$14","v":2.94},{"$f":"$C6-$C6*C$14","v":2.91},{"$f":"$C6-$C6*D$14","v":2.85},null,null,null,null,null,"Banana",3]
[null,"Mango",7,6.86,{"$f":"$C7-$C7*C$14","v":6.79},{"$f":"$C7-$C7*D$14","v":6.65},null,null,null,null,null,"Mango",7]
[null,"Apple",4,3.92,{"$f":"$C8-$C8*C$14","v":3.88},{"$f":"$C8-$C8*D$14","v":3.8},null,null,null,null,null,"Apple",4]
[null,"Grape",6,5.88,{"$f":"$C9-$C9*C$14","v":5.82},{"$f":"$C9-$C9*D$14","v":5.7},null,null,null,null,null,"Grape",6]
[]
[null,"Discount",null,null,null,null,null,null,null,null,null,"Discount"]
[]
[null,"March","April","May",null,null,null,null,null,null,null,"March","April","May"]
[null,0.02,0.03,0.05,null,null,null,null,null,null,null,0.02,0.03,0.05]

{"sheet":"Shortcut CTRL+R Method","index":8,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14],[10,1,10,3],[10,10,10,12]]}
[]
[null,"Keyboard Shortcut CTRL + R",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Product","Price (February)","Price (March)","Price (April)","Price (May)",null,null,null,null,"Product","Price (February)","Price (March)","Price (April)","Price (May)"]
[null,"Orange",5,5,5,5,null,null,null,null,"Orange",5]
[null,"Banana",3,3,3,3,null,null,null,null,"Banana",3]
[null,"Mango",7,7,7,7,null,null,null,null,"Mango",7]
[null,"Apple",4,4,4,4,null,null,null,null,"Apple",4]
[null,"Grape",6,6,6,6,null,null,null,null,"Grape",6]
[]
[null,"Discount",null,null,null,null,null,null,null,null,"Discount"]
[]
[null,"March","April","May",null,null,null,null,null,null,"March","April","May"]
[null,0.02,0.03,0.05,null,null,null,null,null,null,0.02,0.03,0.05]

{"sheet":"Formula for Non Adjacent Cells","index":9,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14],[12,1,12,3],[12,10,12,12]]}
[]
[null,"Formula for Non Adjacent Multiple Cells",null,null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Product","Price (February)","Price (March)","Price (April)","Price (May)",null,null,null,null,"Product","Price (February)","Price (March)","Price (April)","Price (May)"]
[null,"Orange",5,{"$f":"$C5-$C5*B$16","v":4.9000000000000004},{"$f":"$C5-$C5*C$16","v":4.8499999999999996},{"$f":"$C5-$C5*D$16","v":4.75},null,null,null,null,"Orange",5]
[]
[null,"Banana",3,{"$f":"$C7-$C7*B$16","v":2.94},{"$f":"$C7-$C7*C$16","v":2.91},{"$f":"$C7-$C7*D$16","v":2.85},null,null,null,null,"Banana",3]
[null,"Mango",7,{"$f":"$C8-$C8*B$16","v":6.86},{"$f":"$C8-$C8*C$16","v":6.79},{"$f":"$C8-$C8*D$16","v":6.65},null,null,null,null,"Mango",7]
[]
[null,"Apple",4,{"$f":"$C10-$C10*B$16","v":3.92},{"$f":"$C10-$C10*C$16","v":3.88},{"$f":"$C10-$C10*D$16","v":3.8},null,null,null,null,"Apple",4]
[null,"Grape",6,{"$f":"$C11-$C11*B$16","v":5.88},{"$f":"$C11-$C11*C$16","v":5.82},{"$f":"$C11-$C11*D$16","v":5.7},null,null,null,null,"Grape",6]
[]
[null,"Discount",null,null,null,null,null,null,null,null,"Discount"]
[]
[null,"March","April","May",null,null,null,null,null,null,"March","April","May"]
[null,0.02,0.03,0.05,null,null,null,null,null,null,0.02,0.03,0.05]