{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["RAND & VLOOKUP Function","RAND & SORT Function","SORTBY Function","RANDBETWEEN Function","INDEX & RANDBETWEEN Function","CHOOSE & RANDBETWEEN Function","Excel 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":"RAND & VLOOKUP Function","index":0,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Combination of RANDBETWEEN and VLOOKUP Functions",null,null,null,null,"Practice Yourself"]
[]
[null,"Number","Salesperson","Random Number","Shuffle List",null,"Number","Salesperson","Random Number","Shuffle List"]
[null,1,"Andy Teal",{"$f":"RANDBETWEEN(1,5)","v":5},{"$f":"VLOOKUP(D5,$B$5:$C$9,2,FALSE)","v":"Kathie Flood"},null,1,"Andy Teal"]
[null,2,"Robert Walters",{"$f":"RANDBETWEEN(1,5)","v":1},{"$f":"VLOOKUP(D6,$B$5:$C$9,2,FALSE)","v":"Andy Teal"},null,2,"Robert Walters"]
[null,3,"Susan W. Eaton",4,"Kim Ralls",null,3,"Susan W. Eaton"]
[null,4,"Kim Ralls",1,"Andy Teal",null,4,"Kim Ralls"]
[null,5,"Kathie Flood",1,"Andy Teal",null,5,"Kathie Flood"]

{"sheet":"RAND & SORT Function","index":1,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Combination of RAND and SORT Functions",null,null,null,null,"Practice Yourself"]
[]
[null,"Number","Salesperson","Random Number","Shuffle List",null,"Number","Salesperson","Random Number","Shuffle List"]
[null,1,"Andy Teal",{"$f":"RAND()","v":0.21078407031364299},"Robert Walters",null,1,"Andy Teal"]
[null,2,"Robert Walters",{"$f":"RAND()","v":0.44125447806193241},"Susan W. Eaton",null,2,"Robert Walters"]
[null,3,"Susan W. Eaton",{"$f":"RAND()","v":0.3411155917357781},"Andy Teal",null,3,"Susan W. Eaton"]
[null,4,"Kim Ralls",{"$f":"RAND()","v":0.51206270390106878},"Kim Ralls",null,4,"Kim Ralls"]
[null,5,"Kathie Flood",{"$f":"RAND()","v":0.83771380951037644},"Kathie Flood",null,5,"Kathie Flood"]

{"sheet":"SORTBY Function","index":2,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Use of SORTBY Function",null,null,null,"Practice Yourself"]
[]
[null,"Number","Salesperson","Shuffle List",null,"Number","Salesperson","Shuffle List"]
[null,1,"Andy Teal",{"$f":"_xlfn.SORTBY(C5:C9,_xlfn.RANDARRAY(5))","v":"Andy Teal"},null,1,"Andy Teal"]
[null,2,"Robert Walters","Susan W. Eaton",null,2,"Robert Walters"]
[null,3,"Susan W. Eaton","Kathie Flood",null,3,"Susan W. Eaton"]
[null,4,"Kim Ralls","Kim Ralls",null,4,"Kim Ralls"]
[null,5,"Kathie Flood","Robert Walters",null,5,"Kathie Flood"]

{"sheet":"RANDBETWEEN Function","index":3,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Use of RANDBETWEEN Function",null,null,null,null,"Practice Yourself"]
[]
[null,"Number","Salesperson","Random Number","Shuffle List",null,"Number","Salesperson","Random Number","Shuffle List"]
[null,1,"Andy Teal",{"$f":"RANDBETWEEN(1,5)","v":3},"Andy Teal",null,1,"Andy Teal",null,"Andy Teal"]
[null,2,"Robert Walters",{"$f":"RANDBETWEEN(1,5)","v":3},"Susan W. Eaton",null,2,"Robert Walters",null,"Robert Walters"]
[null,3,"Susan W. Eaton",{"$f":"RANDBETWEEN(1,5)","v":4},"Kim Ralls",null,3,"Susan W. Eaton",null,"Susan W. Eaton"]
[null,4,"Kim Ralls",{"$f":"RANDBETWEEN(1,5)","v":2},"Robert Walters",null,4,"Kim Ralls",null,"Kim Ralls"]
[null,5,"Kathie Flood",{"$f":"RANDBETWEEN(1,5)","v":5},"Kathie Flood",null,5,"Kathie Flood",null,"Kathie Flood"]

{"sheet":"INDEX & RANDBETWEEN Function","index":4,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Combination of INDEX and RANDBETWEEN Functions",null,null,null,null,"Practice Yourself"]
[]
[null,"Number","Salesperson","Shuffle List",null,null,"Number","Salesperson","Shuffle List"]
[null,1,"Andy Teal",{"$f":"INDEX($C$5:$C$9,RANDBETWEEN(1,5))","v":"Kathie Flood"},null,null,1,"Andy Teal"]
[null,2,"Robert Walters",{"$f":"INDEX($C$5:$C$9,RANDBETWEEN(1,5))","v":"Robert Walters"},null,null,2,"Robert Walters"]
[null,3,"Susan W. Eaton",{"$f":"INDEX($C$5:$C$9,RANDBETWEEN(1,5))","v":"Robert Walters"},null,null,3,"Susan W. Eaton"]
[null,4,"Kim Ralls",{"$f":"INDEX($C$5:$C$9,RANDBETWEEN(1,5))","v":"Kathie Flood"},null,null,4,"Kim Ralls"]
[null,5,"Kathie Flood",{"$f":"INDEX($C$5:$C$9,RANDBETWEEN(1,5))","v":"Kim Ralls"},null,null,5,"Kathie Flood"]

{"sheet":"CHOOSE & RANDBETWEEN Function","index":5,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Combination of CHOOSE and RANDBETWEEN Functions",null,null,null,null,"Practice Yourself"]
[]
[null,"Number","Salesperson","Shuffle List",null,null,"Number","Salesperson","Shuffle List"]
[null,1,"Andy Teal",{"$f":"CHOOSE(RANDBETWEEN(1,5),$C$5,$C$6,$C$7,$C$8,$C$9)","v":"Andy Teal"},null,null,1,"Andy Teal"]
[null,2,"Robert Walters",{"$f":"CHOOSE(RANDBETWEEN(1,5),$C$5,$C$6,$C$7,$C$8,$C$9)","v":"Susan W. Eaton"},null,null,2,"Robert Walters"]
[null,3,"Susan W. Eaton","Andy Teal",null,null,3,"Susan W. Eaton"]
[null,4,"Kim Ralls","Kathie Flood",null,null,4,"Kim Ralls"]
[null,5,"Kathie Flood","Kim Ralls",null,null,5,"Kathie Flood"]

{"sheet":"Excel VBA","index":6,"n_rows":9,"n_cols":9,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null,"Use of Excel VBA",null,null,null,null,"Practice Yourself"]
[]
[null,"Number","Salesperson","Shuffle List",null,null,"Number","Salesperson","Shuffle List"]
[null,1,"Andy Teal","Susan W. Eaton",null,null,1,"Andy Teal"]
[null,2,"Robert Walters","Kim Ralls",null,null,2,"Robert Walters"]
[null,3,"Susan W. Eaton","Robert Walters",null,null,3,"Susan W. Eaton"]
[null,4,"Kim Ralls","Andy Teal",null,null,4,"Kim Ralls"]
[null,5,"Kathie Flood","Kathie Flood",null,null,5,"Kathie Flood"]