{"text_format":"3","workbook":"xlsx","n_sheets":17,"sheets":["Overview","AutoFill","Numbers","Dates","Month","Year","Day","Formula","Nth","Without Dragging","Keyboard Shortcut","Fill Series","Flash Fill","Blank Cells","SEQUENCE","VBA","Practice Section"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"Overview","index":0,"n_rows":24,"n_cols":5,"rows_kept":24,"merged":[[0,1,0,4]]}
[null,"AutoFill in Excel"]
[]
[null,"Student","ID","Marks in Math","Status"]
[null,"Mark",202101,75,{"$f":"IF(D4>=60,\"Pass\",\"Fail\")","v":"Pass"}]
[null,"Johan",202102,58,{"$f":"IF(D5>=60,\"Pass\",\"Fail\")","v":"Fail"}]
[null,"Noah",202103,65,"Pass"]
[null,"Merry",202104,85,"Pass"]
[null,"Alex",202105,47,"Fail"]
[null,"Jordan",202106,75,"Pass"]
[null,"Martha",202107,83,"Pass"]
[null,"Polina",202108,38,"Fail"]
[null,"Tressa",202109,80,"Pass"]
[null,"Johnson",202110,90,"Pass"]
{"$rows_empty":10}
[null,"Employee","Working Hour","Hourly Rate","Payment"]

{"sheet":"AutoFill","index":1,"n_rows":10,"n_cols":1,"rows_kept":10}
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]

{"sheet":"Numbers","index":2,"n_rows":23,"n_cols":5,"rows_kept":23}
[null,"AutoFill Numbers"]
[]
[null,5]
[null,10]
[null,15]
[null,20]
[null,25]
[null,30]
[null,35]
[null,40]
[null,45]
[null,50]
{"$rows_empty":10}
[null,"Employee","Working Hour","Hourly Rate","Payment"]

{"sheet":"Dates","index":3,"n_rows":23,"n_cols":5,"rows_kept":23}
[null,"AutoFill Dates"]
[]
[null,"2023-05-05"]
[null,"2023-05-06"]
[null,"2023-05-07"]
[null,"2023-05-08"]
[null,"2023-05-09"]
[null,"2023-05-10"]
[null,"2023-05-11"]
[null,"2023-05-12"]
[null,"2023-05-13"]
[null,"2023-05-14"]
{"$rows_empty":10}
[null,"Employee","Working Hour","Hourly Rate","Payment"]

{"sheet":"Month","index":4,"n_rows":23,"n_cols":5,"rows_kept":23}
[null,"AutoFill Months"]
[]
[null,"January"]
[null,"February"]
[null,"March"]
[null,"April"]
[null,"May"]
[null,"June"]
[null,"July"]
[null,"August"]
[null,"September"]
[null,"October"]
[null,"November"]
[null,"December"]
{"$rows_empty":8}
[null,"Employee","Working Hour","Hourly Rate","Payment"]

{"sheet":"Year","index":5,"n_rows":24,"n_cols":5,"rows_kept":24}
[null,"AutoFill Years"]
[]
[null,"Years"]
[null,2001]
[null,2002]
[null,2003]
[null,2004]
[null,2005]
[null,2006]
[null,2007]
[null,2008]
[null,2009]
[null,2010]
[null,2011]
[null,2012]
{"$rows_empty":8}
[null,"Employee","Working Hour","Hourly Rate","Payment"]

{"sheet":"Day","index":6,"n_rows":24,"n_cols":5,"rows_kept":24}
[null,"AutoFill Days"]
[]
[null,"Days"]
[null,"Monday"]
[null,"Tuesday"]
[null,"Wednesday"]
[null,"Thursday"]
[null,"Friday"]
[null,"Saturday"]
[null,"Sunday"]
{"$rows_empty":13}
[null,"Employee","Working Hour","Hourly Rate","Payment"]

{"sheet":"Formula","index":7,"n_rows":24,"n_cols":5,"rows_kept":24,"merged":[[0,1,0,4]]}
[null,"Using AutoFill Feature to Fill Formula"]
[]
[null,"Student","ID","Marks in Math","Status"]
[null,"Mark",202101,75,{"$f":"IF(D4>=60,\"Pass\",\"Fail\")","v":"Pass"}]
[null,"Johan",202102,58,{"$f":"IF(D5>=60,\"Pass\",\"Fail\")","v":"Fail"}]
[null,"Noah",202103,65,"Pass"]
[null,"Merry",202104,85,"Pass"]
[null,"Alex",202105,47,"Fail"]
[null,"Jordan",202106,75,"Pass"]
[null,"Martha",202107,83,"Pass"]
[null,"Polina",202108,38,"Fail"]
[null,"Tressa",202109,80,"Pass"]
[null,"Johnson",202110,90,"Pass"]
{"$rows_empty":10}
[null,"Employee","Working Hour","Hourly Rate","Payment"]

{"sheet":"Nth","index":8,"n_rows":24,"n_cols":5,"rows_kept":24,"merged":[[0,1,0,4]]}
[null,"Using AutoFill Feature to Fill Every Other Cell"]
[]
[null,"Student","ID","Marks in Math","Status"]
[null,"Mark",202101,75,{"$f":"IF(D4>=60,\"Pass\",\"Fail\")","v":"Pass"}]
[null,"Johan",202102,58]
[null,"Noah",202103,65,{"$f":"IF(D6>=60,\"Pass\",\"Fail\")","v":"Pass"}]
[null,"Merry",202104,85]
[null,"Alex",202105,47,{"$f":"IF(D8>=60,\"Pass\",\"Fail\")","v":"Fail"}]
[null,"Jordan",202106,75]
[null,"Martha",202107,83,{"$f":"IF(D10>=60,\"Pass\",\"Fail\")","v":"Pass"}]
[null,"Polina",202108,38]
[null,"Tressa",202109,80,{"$f":"IF(D12>=60,\"Pass\",\"Fail\")","v":"Pass"}]
[null,"Johnson",202110,90]
{"$rows_empty":10}
[null,"Employee","Working Hour","Hourly Rate","Payment"]

{"sheet":"Without Dragging","index":9,"n_rows":24,"n_cols":5,"rows_kept":24,"merged":[[0,1,0,4]]}
[null,"AutoFill Formula Without Dragging"]
[]
[null,"Student","ID","Marks in Math","Status"]
[null,"Mark",202101,75,{"$f":"IF(D4>=60,\"Pass\",\"Fail\")","v":"Pass"}]
[null,"Johan",202102,58,{"$f":"IF(D5>=60,\"Pass\",\"Fail\")","v":"Fail"}]
[null,"Noah",202103,65,"Pass"]
[null,"Merry",202104,85,"Pass"]
[null,"Alex",202105,47,"Fail"]
[null,"Jordan",202106,75,"Pass"]
[null,"Martha",202107,83,"Pass"]
[null,"Polina",202108,38,"Fail"]
[null,"Tressa",202109,80,"Pass"]
[null,"Johnson",202110,90,"Pass"]
{"$rows_empty":10}
[null,"Employee","Working Hour","Hourly Rate","Payment"]

{"sheet":"Keyboard Shortcut","index":10,"n_rows":24,"n_cols":5,"rows_kept":24,"merged":[[0,1,0,4]]}
[null,"Using Keyboard Shortcut to AutoFill Formula"]
[]
[null,"Student","ID","Marks in Math","Status"]
[null,"Mark",202101,75,{"$f":"IF(D4>=60,\"Pass\",\"Fail\")","v":"Pass"}]
[null,"Johan",202102,58,{"$f":"IF(D5>=60,\"Pass\",\"Fail\")","v":"Fail"}]
[null,"Noah",202103,65,"Pass"]
[null,"Merry",202104,85,"Pass"]
[null,"Alex",202105,47,"Fail"]
[null,"Jordan",202106,75,"Pass"]
[null,"Martha",202107,83,"Pass"]
[null,"Polina",202108,38,"Fail"]
[null,"Tressa",202109,80,"Pass"]
[null,"Johnson",202110,90,"Pass"]
{"$rows_empty":10}
[null,"Employee","Working Hour","Hourly Rate","Payment"]

{"sheet":"Fill Series","index":11,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"AutoFill Series"]
[]
[null,3]
[null,7]
[null,11]
[null,15]
[null,19]
[null,23]

{"sheet":"Flash Fill","index":12,"n_rows":24,"n_cols":4,"rows_kept":24,"merged":[[0,1,0,3]]}
[null,"Using Flash Fill Feature"]
[]
[null,"First Name","Last Name","Full Name"]
[null,"Jhon","Mark","Jhon Mark"]
[null,"Johan","Roy","Johan Roy"]
[null,"Noah","Green","Noah Green"]
[null,"Merry","Tressa","Merry Tressa"]
[null,"Alex","Pop","Alex Pop"]
[null,"Jordan","Polina","Jordan Polina"]
[null,"Martha","Roy","Martha Roy"]
[null,"Polina","Dhon","Polina Dhon"]
[null,"Tressa","Mark","Tressa Mark"]
[null,"Johnson","Tressa","Johnson Tressa"]
{"$rows_empty":10}
[null,"Employee","Working Hour","Hourly Rate"]

{"sheet":"Blank Cells","index":13,"n_rows":24,"n_cols":6,"rows_kept":24,"merged":[[0,1,0,5]]}
[null,"Using AutoFill Feature to Fill Blank Cells"]
[]
[null,"Student","ID","Math","Physics","Chemistry"]
[null,"Mark",202101,"Abs",63,92]
[null,"Johan",202102,58,"Abs",52]
[null,"Noah",202103,65,56,"Abs"]
[null,"Merry",202104,"Abs",54,83]
[null,"Alex",202105,47,35,42]
[null,"Jordan",202106,75,60,"Abs"]
[null,"Martha",202107,83,"Abs",48]
[null,"Polina",202108,"Abs",84,62]
[null,"Tressa",202109,80,41,53]
[null,"Johnson",202110,90,95,"Abs"]
{"$rows_empty":10}
[null,"Employee","Working Hour","Hourly Rate","Payment"]

{"sheet":"SEQUENCE","index":14,"n_rows":11,"n_cols":2,"rows_kept":11}
[null,"Using SEQUENCE Function"]
[]
[null,"Sequence of Numbers"]
[null,{"$f":"_xlfn.SEQUENCE(8,1,10,6)","v":10}]
[null,16]
[null,22]
[null,28]
[null,34]
[null,40]
[null,46]
[null,52]

{"sheet":"VBA","index":15,"n_rows":12,"n_cols":2,"rows_kept":12}
[null,"Applying VBA Code"]
[]
[null,"AutiFill Numbers"]
[null,15]
[null,20]
[null,25]
[null,30]
[null,35]
[null,40]
[null,45]
[null,50]
[null,55]

{"sheet":"Practice Section","index":16,"n_rows":24,"n_cols":6,"rows_kept":24,"merged":[[0,1,0,5]]}
[null,"Try Yourself"]
[]
[null,"Student","ID","Math","Physics","Chemistry"]
[null,"Mark",202101,"Abs",63,92]
[null,"Johan",202102,58,"Abs",52]
[null,"Noah",202103,65,56,"Abs"]
[null,"Merry",202104,"Abs",54,83]
[null,"Alex",202105,47,35,42]
[null,"Jordan",202106,75,60,"Abs"]
[null,"Martha",202107,83,"Abs",48]
[null,"Polina",202108,"Abs",84,62]
[null,"Tressa",202109,80,41,53]
[null,"Johnson",202110,90,95,"Abs"]
{"$rows_empty":10}
[null,"Employee","Working Hour","Hourly Rate","Payment"]