{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Dataset","Cell Select","group of cells","non-contiguous","non-contiguous+range","rangeoffset","negativerangeoffset","active cell","copy","delete","input","output","Practice"],"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":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"\"X\" College"]
[]
[null,"Student Name","Result","Email Id"]
[null,"Michael James","A (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B5,FIND(\" \",B5,1)-1),\"@gmail.com\"))","v":"michael@gmail.com"}]
[null,"William David","B (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B6,FIND(\" \",B6,1)-1),\"@gmail.com\"))","v":"william@gmail.com"}]
[null,"Joseph Michael","F (Fail)","joseph@gmail.com"]
[null,"Daniel Defoe","C (Pass)","daniel@gmail.com"]
[null,"Michael Anthony","F (Fail)",{"$f":"LOWER(CONCATENATE(LEFT(B9,FIND(\" \",B9,1)-1),\"23@gmail.com\"))","v":"michael23@gmail.com"}]
[null,"Donald Paul","F (Fail)","donald@gmail.com"]

{"sheet":"Cell Select","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Selecting a Cell"]
[]
[null,"Student Name","Result","Email Id"]
[null,"Michael James","A (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B5,FIND(\" \",B5,1)-1),\"@gmail.com\"))","v":"michael@gmail.com"}]
[null,"William David","B (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B6,FIND(\" \",B6,1)-1),\"@gmail.com\"))","v":"william@gmail.com"}]
[null,"Joseph Michael","F (Fail)","joseph@gmail.com"]
[null,"Daniel Defoe","C (Pass)","daniel@gmail.com"]
[null,"Michael Anthony","F (Fail)",{"$f":"LOWER(CONCATENATE(LEFT(B9,FIND(\" \",B9,1)-1),\"23@gmail.com\"))","v":"michael23@gmail.com"}]
[null,"Donald Paul","F (Fail)","donald@gmail.com"]

{"sheet":"group of cells","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Selecting a Group of Contiguous Cells"]
[]
[null,"Student Name","Result","Email Id"]
[null,"Michael James","A (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B5,FIND(\" \",B5,1)-1),\"@gmail.com\"))","v":"michael@gmail.com"}]
[null,"William David","B (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B6,FIND(\" \",B6,1)-1),\"@gmail.com\"))","v":"william@gmail.com"}]
[null,"Joseph Michael","F (Fail)","joseph@gmail.com"]
[null,"Daniel Defoe","C (Pass)","daniel@gmail.com"]
[null,"Michael Anthony","F (Fail)",{"$f":"LOWER(CONCATENATE(LEFT(B9,FIND(\" \",B9,1)-1),\"23@gmail.com\"))","v":"michael23@gmail.com"}]
[null,"Donald Paul","F (Fail)","donald@gmail.com"]

{"sheet":"non-contiguous","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Selecting Non- Contiguous Cells"]
[]
[null,"Student Name","Result","Email Id"]
[null,"Michael James","A (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B5,FIND(\" \",B5,1)-1),\"@gmail.com\"))","v":"michael@gmail.com"}]
[null,"William David","B (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B6,FIND(\" \",B6,1)-1),\"@gmail.com\"))","v":"william@gmail.com"}]
[null,"Joseph Michael","F (Fail)","joseph@gmail.com"]
[null,"Daniel Defoe","C (Pass)","daniel@gmail.com"]
[null,"Michael Anthony","F (Fail)",{"$f":"LOWER(CONCATENATE(LEFT(B9,FIND(\" \",B9,1)-1),\"23@gmail.com\"))","v":"michael23@gmail.com"}]
[null,"Donald Paul","F (Fail)","donald@gmail.com"]

{"sheet":"non-contiguous+range","index":4,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Selecting Non- Contiguous Cells and a Range"]
[]
[null,"Student Name","Result","Email Id"]
[null,"Michael James","A (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B5,FIND(\" \",B5,1)-1),\"@gmail.com\"))","v":"michael@gmail.com"}]
[null,"William David","B (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B6,FIND(\" \",B6,1)-1),\"@gmail.com\"))","v":"william@gmail.com"}]
[null,"Joseph Michael","F (Fail)","joseph@gmail.com"]
[null,"Daniel Defoe","C (Pass)","daniel@gmail.com"]
[null,"Michael Anthony","F (Fail)",{"$f":"LOWER(CONCATENATE(LEFT(B9,FIND(\" \",B9,1)-1),\"23@gmail.com\"))","v":"michael23@gmail.com"}]
[null,"Donald Paul","F (Fail)","donald@gmail.com"]

{"sheet":"rangeoffset","index":5,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Selecting a Range Using Range &Offset"]
[]
[null,"Student Name","Result","Email Id"]
[null,"Michael James","A (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B5,FIND(\" \",B5,1)-1),\"@gmail.com\"))","v":"michael@gmail.com"}]
[null,"William David","B (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B6,FIND(\" \",B6,1)-1),\"@gmail.com\"))","v":"william@gmail.com"}]
[null,"Joseph Michael","F (Fail)","joseph@gmail.com"]
[null,"Daniel Defoe","C (Pass)","daniel@gmail.com"]
[null,"Michael Anthony","F (Fail)",{"$f":"LOWER(CONCATENATE(LEFT(B9,FIND(\" \",B9,1)-1),\"23@gmail.com\"))","v":"michael23@gmail.com"}]
[null,"Donald Paul","F (Fail)","donald@gmail.com"]

{"sheet":"negativerangeoffset","index":6,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null," Using Range &Negative Offset"]
[]
[null,"Student Name","Result","Email Id"]
[null,"Michael James","A (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B5,FIND(\" \",B5,1)-1),\"@gmail.com\"))","v":"michael@gmail.com"}]
[null,"William David","B (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B6,FIND(\" \",B6,1)-1),\"@gmail.com\"))","v":"william@gmail.com"}]
[null,"Joseph Michael","F (Fail)","joseph@gmail.com"]
[null,"Daniel Defoe","C (Pass)","daniel@gmail.com"]
[null,"Michael Anthony","F (Fail)",{"$f":"LOWER(CONCATENATE(LEFT(B9,FIND(\" \",B9,1)-1),\"23@gmail.com\"))","v":"michael23@gmail.com"}]
[null,"Donald Paul","F (Fail)","donald@gmail.com"]

{"sheet":"active cell","index":7,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Selecting a Range with Respect to Active Cell"]
[]
[null,"Student Name","Result","Email Id"]
[null,"Michael James","A (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B5,FIND(\" \",B5,1)-1),\"@gmail.com\"))","v":"michael@gmail.com"}]
[null,"William David","B (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B6,FIND(\" \",B6,1)-1),\"@gmail.com\"))","v":"william@gmail.com"}]
[null,"Joseph Michael","F (Fail)","joseph@gmail.com"]
[null,"Daniel Defoe","C (Pass)","daniel@gmail.com"]
[null,"Michael Anthony","F (Fail)",{"$f":"LOWER(CONCATENATE(LEFT(B9,FIND(\" \",B9,1)-1),\"23@gmail.com\"))","v":"michael23@gmail.com"}]
[null,"Donald Paul","F (Fail)","donald@gmail.com"]

{"sheet":"copy","index":8,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Copy a Range"]
[]
[null,"Student Name","Result","Email Id"]
[null,"Michael James","A (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B5,FIND(\" \",B5,1)-1),\"@gmail.com\"))","v":"michael@gmail.com"}]
[null,"William David","B (Pass)",{"$f":"LOWER(CONCATENATE(LEFT(B6,FIND(\" \",B6,1)-1),\"@gmail.com\"))","v":"william@gmail.com"}]
[null,"Joseph Michael","F (Fail)","joseph@gmail.com"]
[null,"Daniel Defoe","C (Pass)","daniel@gmail.com"]
[null,"Michael Anthony","F (Fail)",{"$f":"LOWER(CONCATENATE(LEFT(B9,FIND(\" \",B9,1)-1),\"23@gmail.com\"))","v":"michael23@gmail.com"}]
[null,"Donald Paul","F (Fail)","donald@gmail.com"]

{"sheet":"delete","index":9,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Delete a Range"]
[]
[null,"Student Name","Result"]
[null,"Michael James","A (Pass)"]
[null,"William David","B (Pass)"]
[null,"Joseph Michael","F (Fail)"]
[null,"Daniel Defoe","C (Pass)"]
[null,"Michael Anthony","F (Fail)"]
[null,"Donald Paul","F (Fail)"]

{"sheet":"input","index":10,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Enter a Value"]
[]
[null,"Student Name","Result","Email Id"]
[null,"Michael James","A (Pass)","michael@gmail.com"]
[null,"William David","B (Pass)","william@gmail.com"]
[null,"Joseph Michael","F (Fail)","joseph@gmail.com"]
[null,"Daniel Defoe","C (Pass)","daniel@gmail.com"]
[null,"Michael Anthony","F (Fail)","michael23@gmail.com"]
[null,"Donald Paul","F (Fail)","donald@gmail.com"]

{"sheet":"output","index":11,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Output"]
[]
[null,"Student Name","Result","Pass/Fail"]
[null,"Michael James","A (Pass)","Passed"]
[null,"William David","B (Pass)","Passed"]
[null,"Joseph Michael","F (Fail)","Failed"]
[null,"Daniel Defoe","C (Pass)","Passed"]
[null,"Michael Anthony","F (Fail)","Failed"]
[null,"Donald Paul","F (Fail)","Failed"]

{"sheet":"Practice","index":12,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Practice"]
[]
[null,"Student Name","Result","Email Id"]
[null,"Michael James","A (Pass)","michael@gmail.com"]
[null,"William David","B (Pass)","william@gmail.com"]
[null,"Joseph Michael","F (Fail)","joseph@gmail.com"]
[null,"Daniel Defoe","C (Pass)","daniel@gmail.com"]
[null,"Michael Anthony","F (Fail)","michael23@gmail.com"]
[null,"Donald Paul","F (Fail)","donald@gmail.com"]