{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["INDEX,RANDBETWEEN,ROW Function","INDEX,RANDBETWEEN,COUNTFunction","RANK Function","VBA","Select Numeric Data"],"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":"INDEX,RANDBETWEEN,ROW Function","index":0,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Applying INDEX, RANDBETWEEN and ROW Functions",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Participants ","Grades",null,"Random Selection",null,null,null,"Participants ","Grades",null,"Random Selection"]
[null,"Adam","A",null,{"$f":"INDEX($B$5:$B$10,RANDBETWEEN(1,ROWS($B$5:$B$10)),1)","v":"Penny"},null,null,null,"Adam","A"]
[null,"Jhon","A",null,null,null,null,null,"Jhon","A"]
[null,"Penny","B",null,null,null,null,null,"Penny","B"]
[null,"Stuart","C",null,null,null,null,null,"Stuart","C"]
[null,"Sheldon","D",null,null,null,null,null,"Sheldon","D"]
[null,"Merry","F",null,null,null,null,null,"Merry","F"]

{"sheet":"INDEX,RANDBETWEEN,COUNTFunction","index":1,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Applying INDEX, RANDBETWEEN and COUNTA Functions",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Participants ","Grades",null,"Random Selection",null,null,null,"Participants ","Grades",null,"Random Selection"]
[null,"Adam","A",null,{"$f":"INDEX($B$5:$B$10,RANDBETWEEN(1,COUNTA($B$5:$B$10)),1)","v":"Stuart"},null,null,null,"Adam","A"]
[null,"Jhon","A",null,null,null,null,null,"Jhon","A"]
[null,"Penny","B",null,null,null,null,null,"Penny","B"]
[null,"Stuart","C",null,null,null,null,null,"Stuart","C"]
[null,"Sheldon","D",null,null,null,null,null,"Sheldon","D"]
[null,"Merry","F",null,null,null,null,null,"Merry","F"]

{"sheet":"RANK Function","index":2,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Applying RANK Function",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Participants ","Grades","Random Number","Random Selection",null,null,null,"Participants ","Grades","Random Number","Random Selection"]
[null,"Adam","A",{"$f":"RAND()","v":0.5952580142946996},{"$f":"INDEX($B$5:$B$10, RANK(D5,$D$5:$D$10), 1)","v":"Sheldon"},null,null,null,"Adam","A"]
[null,"Jhon","A",{"$f":"RAND()","v":0.70719981836324863},{"$f":"INDEX($B$5:$B$10, RANK(D6,$D$5:$D$10), 1)","v":"Penny"},null,null,null,"Jhon","A"]
[null,"Penny","B",{"$f":"RAND()","v":0.92986002839484927},{"$f":"INDEX($B$5:$B$10, RANK(D7,$D$5:$D$10), 1)","v":"Jhon"},null,null,null,"Penny","B"]
[null,"Stuart","C",0.64130609477382294,null,null,null,null,"Stuart","C"]
[null,"Sheldon","D",0.26825853488799467,null,null,null,null,"Sheldon","D"]
[null,"Merry","F",0.98828388901934372,null,null,null,null,"Merry","F"]

{"sheet":"VBA","index":3,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Participants ","Grades",null,"Random Selection",null,null,null,"Participants ","Grades",null,"Random Selection"]
[null,"Adam","A",null,"Penny",null,null,null,"Adam","A"]
[null,"Jhon","A",null,null,null,null,null,"Jhon","A"]
[null,"Penny","B",null,null,null,null,null,"Penny","B"]
[null,"Stuart","C",null,null,null,null,null,"Stuart","C"]
[null,"Sheldon","D",null,null,null,null,null,"Sheldon","D"]
[null,"Merry","F",null,null,null,null,null,"Merry","F"]

{"sheet":"Select Numeric Data","index":4,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Utilizing Data Analysis Toolbar",null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Participants ","Marks","Grades",null,"Random Selection",null,null,"Participants ","Marks","Grades",null,"Random Selection"]
[null,"Adam",85,"A",null,52,null,null,"Adam",85,"A"]
[null,"Jhon",89,"A",null,85,null,null,"Jhon",89,"A"]
[null,"Penny",72,"B",null,52,null,null,"Penny",72,"B"]
[null,"Stuart",65,"C",null,null,null,null,"Stuart",65,"C"]
[null,"Sheldon",52,"D",null,null,null,null,"Sheldon",52,"D"]
[null,"Merry",39,"F",null,null,null,null,"Merry",39,"F"]