{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Problem","Reference Table","Solution"],"not_rendered":{"charts":1,"images":4,"macros":1,"external_links":0,"defined_names":5,"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":"Problem","index":0,"n_rows":200,"n_cols":15,"rows_kept":200,"cut":false,"hidden":false,"merged":[[60,1,60,3],[1,1,1,4],[3,1,3,4],[27,1,27,5],[29,2,29,4],[52,1,52,3],[182,1,182,2],[182,4,182,5],[199,1,199,4],[67,1,67,3],[73,1,73,3],[97,1,97,3],[135,1,135,3],[159,1,159,4],[180,1,180,3]]}
[]
[null,"Advanced Excel Test"]
[]
[null,"Exercise 01: Separate First, Middle, and Last Name"]
[]
[null,"Name","First Name","Middle Name","Last Name"]
[null,"Mary Elizabeth Smith"]
[null,"Ross James Geller"]
[null,"Natasha Yvone Romanoff"]
[null,"William Jackson Harper"]
[null,"Marco Van Basten"]
[null,"Diego Garcia Lopez"]
[null,"Alexis Mac Allister"]
[null,"Lucas Martinez Quarta"]
[null,"Giovani Lo Celso"]
[null,"Angel Di Maria"]
[null,"Lionel Andres Messi"]
[null,"Philip Hallen Dybvig"]
[null,"Ben Shalom Bernanke"]
[null,"Douglas Warren Diamond"]
[null,"Karl Barry Sharpless"]
[null,"Carolyn Ruth Bertozzi"]
[null,"Morten Peter Meldal"]
[null,"Jennifer Anne Doudna"]
[null,"David William Cross"]
[null,"Emmanuelle Marie Charpentier"]
[]
[null,"Exercise 02: Generate Random Number from Range"]
[]
[null,null,"Random Number"]
[null,"Name","Number 01","Number 02","Number 03","SUM"]
[null,"Mary Elizabeth Smith",null,null,null,{"$f":"SUM(C32:E32)","v":0}]
[null,"Ross James Geller",null,null,null,{"$f":"SUM(C33:E33)","v":0}]
[null,"Natasha Yvone Romanoff",null,null,null,0]
[null,"William Jackson Harper",null,null,null,0]
[null,"Marco Van Basten",null,null,null,0]
[null,"Diego Garcia Lopez",null,null,null,0]
[null,"Alexis Mac Allister",null,null,null,0]
[null,"Lucas Martinez Quarta",null,null,null,0]
[null,"Giovani Lo Celso",null,null,null,0]
[null,"Angel Di Maria",null,null,null,0]
[null,"Lionel Andres Messi",null,null,null,0]
[null,"Philip Hallen Dybvig",null,null,null,0]
[null,"Ben Shalom Bernanke",null,null,null,0]
[null,"Douglas Warren Diamond",null,null,null,0]
[null,"Karl Barry Sharpless",null,null,null,0]
[null,"Carolyn Ruth Bertozzi",null,null,null,0]
[null,"Morten Peter Meldal",null,null,null,0]
[null,"Jennifer Anne Doudna",null,null,null,0]
[null,"David William Cross",null,null,null,0]
[null,"Emmanuelle Marie Charpentier",null,null,null,0]
[]
[null,"Exercise 03: Find Distance Between Two Addresses"]
[]
[null,"State","Latitude","Longitude"]
[null,"Ohio",40.417299999999997,82.9071]
[null,"Alaska",64.200800000000001,149.49369999999999]
[]
[null,"Distance (Kilometers)"]
[]
[null,"Exercise 04: Insert Picture from URL"]
[]
[null,"Number","Link","Image"]
[null,1,"https://www.exceldemy.com/wp-content/uploads/2021/08/count-single-range-of-cells-with-counta-function-in-excel.png"]
[null,2,"https://www.exceldemy.com/wp-content/uploads/2021/08/counta-function-for-multiple-range-of-cells-in-excel.png"]
[null,3,"https://www.exceldemy.com/wp-content/uploads/2021/08/counta-with-mixed-data-input-in-excel.png"]
[]
[null,"Exercise 05: Create Dependent Dropdown List"]
[]
[null,"Category","Item"]
[]
[]
[]
[null,"Exercise 06: Find Duplicate Rows"]
[]
[null,"Name","Gender","State"]
[null,"Rachel Green","Female","New Mexico"]
[null,"Ross Geller","Male","Mississippi"]
[null,"Joey Tribbiani","Male","Texas"]
[null,"Chandler Bing","Male","California"]
[null,"Rachel Green","Female","New Mexico"]
[null,"Ben Van Lier","Male","Colorado"]
[null,"Adam King","Male","Washington"]
[null,"Chandler Bing","Male","California"]
[null,"Mary Elizabeth Smith","Female","Utah"]
[null,"Ross James Geller","Male","New Mexico"]
[null,"Natasha Yvone Romanoff","Female","California"]
[null,"William Jackson Harper","Male","New Mexico"]
[null,"Marco Van Basten","Male","Colorado"]
[null,"Diego Garcia Lopez","Male","California"]
[null,"Alexis Mac Allister","Male","Mississippi"]
[null,"Lucas Martinez Quarta","Male","Washington"]
[null,"Giovani Lo Celso","Male","Utah"]
[null,"Jennifer Anne Doudna","Female","California"]
[null,"David William Cross","Male","New Mexico"]
[null,"Emmanuelle Marie Charpentier","Female","Washington"]
[]
[null,"Exercise 07: Combine Duplicate Rows without Losing Data"]
[]
[null,"Name","Car Maker","Car Model"]
[null,"Anthony","BMW","7 Series"]
[null,"Ronald","Toyota","Camry"]
[null,"Timothy","Lincoln","Town Car"]
[null,"David","Ford","Taurus"]
[null,"Ronald","Toyota","Corolla"]
[null,"Timothy","Lincoln","Continental"]
[null,"Issac","Volvo","S80"]
[null,"Issac","Ford","Fusion"]
[null,"Paul","Porsche",924]
[null,"Timothy","Ford","Mustang"]
[null,"Heather","Subaru","Justy"]
[null,"Jacob","Hyundai","Accent"]
[null,"Issac","Chevrolet","Silverado 1500"]
[null,"Timothy","Hummer","H3"]
[null,"Anthony","Dodge","Durango"]
[null,"Lena","Toyota","Supra"]
[null,"Vinicius","Daewoo","Nubira"]
[null,"Terry","Kia","Carens"]
[null,"Rodrygo","Honda","Accord"]
[null,"Lena","Mercury","Tracer"]
[]
[null,"Name","Car Maker","Car Model"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Exercise 08: Unhide Rows Within Range"]
[]
[null,"Name","Gender","State"]
[null,"Rachel Green","Female","New Mexico"]
[null,"Ross Geller","Male","Mississippi"]
[null,"Joey Tribbiani","Male","Texas"]
[null,"Chandler Bing","Male","California"]
[null,"Rachel Green","Female","New Mexico"]
[null,"Ben Van Lier","Male","Colorado"]
[null,"Adam King","Male","Washington"]
[null,"Chandler Bing","Male","California"]
[null,"Mary Elizabeth Smith","Female","Utah"]
[null,"Ross James Geller","Male","New Mexico"]
[null,"Natasha Yvone Romanoff","Female","California"]
[null,"William Jackson Harper","Male","New Mexico"]
[null,"Marco Van Basten","Male","Colorado"]
[null,"Diego Garcia Lopez","Male","California"]
[null,"Alexis Mac Allister","Male","Mississippi"]
[null,"Lucas Martinez Quarta","Male","Washington"]
[null,"Giovani Lo Celso","Male","Utah"]
[null,"Jennifer Anne Doudna","Female","California"]
[null,"David William Cross","Male","New Mexico"]
[null,"Emmanuelle Marie Charpentier","Female","Washington"]
[]
[null,"Exercise 09: Transpose Rows to Columns Using Power Query"]
[]
[null,"Name","Anthony","Ronald","Timothy","David","Issac","Paul","Heather","Jacob","Lena","Vinicius","Terry","Rodrygo","Perry"]
[null,"Car Maker","BMW","Toyota","Lincoln","Subaru","Hyundai","Chevrolet","Hummer","Dodge","Toyota","Daewoo","Kia","Honda","Mercury"]
[null,"Car Model","7 Series","Camry","Town Car","Justy","Accent","Silverado 1500","H3","Durango","Supra","Nubira","Carens","Accord","Tracer"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"<<< Close and Load to cell B167"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Exercise 10: Create Meter Chart"]
[]
[null,"Meter Chart",null,null,"Pointer"]
[null,"Start",0,null,"Value",80]
[null,"Initial",10,null,"Pointer",3]
[null,"Middle",30,null,"End",{"$f":"200-F184-F185","v":117}]
[null,"End",70]
[null,"Max",100]
[]
[]
[]
[]
[null,null,null,null,"<<< Insert Meter Chart here"]
[]
[]
[]
[]
[]
[]
[null,"Exercise 11: Scrape Date from Website",null,null,null,null,null,"website link>>> https://studee.com/discover/best-states-usa/"]

{"sheet":"Reference Table","index":1,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,1,1,2],[3,1,3,2]]}
[]
[null,"Reference Tables"]
[]
[null,"Problem 05"]
[]
[null,"Drinks","Chips"]
[null,"Pepsi","Lay's"]
[null,"Cocacola","Sun Chips"]
[null,"Mountain Dew","Doritos"]
[null,"Sprite","Ruffles"]
[null,"7 Up","Fritos"]
[null,"50/50","Parm Crisps"]
[null,"Duke's","Cheetos"]
[null,"Gatorade","Tostitos"]
[null,"Sierra Mist","Rold Gold"]
[null,"Canada Dry","Funyuns"]
[null,"Gini","Walkers"]
[null,"RC Cola","Kurkure"]
[null,"Squirt","Uncel Chipps"]
[null,"Sun Drop","Pringles"]
[null,"Mirinda","Kettle Chips"]
[null,"Vernors","Zapp's"]
[null,"Wink","Herr's"]
[null,"Fanta","Martin's"]
[null,"Aquaris","Charles Chips"]
[null,"Ambasa","Sabritas"]

{"sheet":"Solution","index":2,"n_rows":253,"n_cols":15,"rows_kept":253,"cut":false,"hidden":false,"merged":[[200,1,200,4],[60,1,60,3],[1,1,1,4],[3,1,3,4],[29,2,29,4],[52,1,52,3],[27,1,27,5],[183,1,183,2],[183,4,183,5],[67,1,67,3],[73,1,73,3],[97,1,97,3],[135,1,135,3],[159,1,159,4],[181,1,181,3]]}
[]
[null,"Advanced Excel Test"]
[]
[null,"Exercise 01: Separate First, Middle, and Last Name"]
[]
[null,"Name","First Name","Middle Name","Last Name"]
[null,"Mary Elizabeth Smith",{"$f":"LEFT(B7,SEARCH(\" \",B7)-1)","v":"Mary"},{"$f":"MID(B7,SEARCH(\" \",B7)+1,SEARCH(\" \",B7,SEARCH(\" \",B7)+1)-(SEARCH(\" \",B7)+1))","v":"Elizabeth"},{"$f":"RIGHT(B7,LEN(B7)-FIND(\"^\",SUBSTITUTE(B7,\" \",\"^\",LEN(B7)-LEN(SUBSTITUTE(B7,\" \",\"\")))))","v":"Smith"}]
[null,"Ross James Geller",{"$f":"LEFT(B8,SEARCH(\" \",B8)-1)","v":"Ross"},{"$f":"MID(B8,SEARCH(\" \",B8)+1,SEARCH(\" \",B8,SEARCH(\" \",B8)+1)-(SEARCH(\" \",B8)+1))","v":"James"},{"$f":"RIGHT(B8,LEN(B8)-FIND(\"^\",SUBSTITUTE(B8,\" \",\"^\",LEN(B8)-LEN(SUBSTITUTE(B8,\" \",\"\")))))","v":"Geller"}]
[null,"Natasha Yvone Romanoff","Natasha","Yvone","Romanoff"]
[null,"William Jackson Harper","William","Jackson","Harper"]
[null,"Marco Van Basten","Marco","Van","Basten"]
[null,"Diego Garcia Lopez","Diego","Garcia","Lopez"]
[null,"Alexis Mac Allister","Alexis","Mac","Allister"]
[null,"Lucas Martinez Quarta","Lucas","Martinez","Quarta"]
[null,"Giovani Lo Celso","Giovani","Lo","Celso"]
[null,"Angel Di Maria","Angel","Di","Maria"]
[null,"Lionel Andres Messi","Lionel","Andres","Messi"]
[null,"Philip Hallen Dybvig",{"$f":"LEFT(B18,SEARCH(\" \",B18)-1)","v":"Philip"},{"$f":"MID(B18,SEARCH(\" \",B18)+1,SEARCH(\" \",B18,SEARCH(\" \",B18)+1)-(SEARCH(\" \",B18)+1))","v":"Hallen"},{"$f":"RIGHT(B18,LEN(B18)-FIND(\"^\",SUBSTITUTE(B18,\" \",\"^\",LEN(B18)-LEN(SUBSTITUTE(B18,\" \",\"\")))))","v":"Dybvig"}]
[null,"Ben Shalom Bernanke","Ben","Shalom","Bernanke"]
[null,"Douglas Warren Diamond","Douglas","Warren","Diamond"]
[null,"Karl Barry Sharpless","Karl","Barry","Sharpless"]
[null,"Carolyn Ruth Bertozzi","Carolyn","Ruth","Bertozzi"]
[null,"Morten Peter Meldal","Morten","Peter","Meldal"]
[null,"Jennifer Anne Doudna","Jennifer","Anne","Doudna"]
[null,"David William Cross","David","William","Cross"]
[null,"Emmanuelle Marie Charpentier","Emmanuelle","Marie","Charpentier"]
[]
[null,"Exercise 02: Generate Random Number from Range"]
[]
[null,null,"Random Number"]
[null,"Name","Number 01","Number 02","Number 03","SUM"]
[null,"Mary Elizabeth Smith",66,66,79,{"$f":"SUM(C32:E32)","v":211}]
[null,"Ross James Geller",63,75,58,{"$f":"SUM(C33:E33)","v":196}]
[null,"Natasha Yvone Romanoff",57,73,53,183]
[null,"William Jackson Harper",68,87,60,215]
[null,"Marco Van Basten",82,65,61,208]
[null,"Diego Garcia Lopez",87,75,75,237]
[null,"Alexis Mac Allister",67,54,73,194]
[null,"Lucas Martinez Quarta",78,87,84,249]
[null,"Giovani Lo Celso",50,72,87,209]
[null,"Angel Di Maria",67,77,70,214]
[null,"Lionel Andres Messi",71,68,64,203]
[null,"Philip Hallen Dybvig",66,61,52,179]
[null,"Ben Shalom Bernanke",59,90,52,201]
[null,"Douglas Warren Diamond",66,64,70,200]
[null,"Karl Barry Sharpless",56,69,60,185]
[null,"Carolyn Ruth Bertozzi",75,72,56,203]
[null,"Morten Peter Meldal",88,76,70,234]
[null,"Jennifer Anne Doudna",66,54,82,202]
[null,"David William Cross",68,80,74,222]
[null,"Emmanuelle Marie Charpentier",84,50,58,192]
[]
[null,"Exercise 03: Find Distance Between Two Addresses"]
[]
[null,"State","Latitude","Longitude"]
[null,"Ohio",40.417299999999997,82.9071]
[null,"Alaska",64.200800000000001,149.49369999999999]
[]
[null,"Distance (Kilometers)",{"$f":"2*6400*ASIN(SQRT((SIN(C57-C56)/2)^2+COS(C56)*COS(C57)*(SIN(D57-D56)/2)^2))","v":6292.133385033706}]
[]
[null,"Exercise 04: Insert Picture from URL"]
[]
[null,"Number","Link","Image"]
[null,1,"https://www.exceldemy.com/wp-content/uploads/2021/08/count-single-range-of-cells-with-counta-function-in-excel.png"]
[null,2,"https://www.exceldemy.com/wp-content/uploads/2021/08/counta-function-for-multiple-range-of-cells-in-excel.png"]
[null,3,"https://www.exceldemy.com/wp-content/uploads/2021/08/counta-with-mixed-data-input-in-excel.png"]
[]
[null,"Exercise 05: Create Dependent Dropdown List"]
[]
[null,"Category","Item"]
[null,"Drinks"]
[null,"Chips"]
[]
[null,"Exercise 06: Find Duplicate Rows"]
[]
[null,"Name","Gender","State"]
[null,"Rachel Green","Female","New Mexico"]
[null,"Ross Geller","Male","Mississippi"]
[null,"Joey Tribbiani","Male","Texas"]
[null,"Chandler Bing","Male","California"]
[null,"Rachel Green","Female","New Mexico"]
[null,"Ben Van Lier","Male","Colorado"]
[null,"Adam King","Male","Washington"]
[null,"Chandler Bing","Male","California"]
[null,"Mary Elizabeth Smith","Female","Utah"]
[null,"Ross James Geller","Male","New Mexico"]
[null,"Natasha Yvone Romanoff","Female","California"]
[null,"William Jackson Harper","Male","New Mexico"]
[null,"Marco Van Basten","Male","Colorado"]
[null,"Diego Garcia Lopez","Male","California"]
[null,"Alexis Mac Allister","Male","Mississippi"]
[null,"Lucas Martinez Quarta","Male","Washington"]
[null,"Giovani Lo Celso","Male","Utah"]
[null,"Jennifer Anne Doudna","Female","California"]
[null,"David William Cross","Male","New Mexico"]
[null,"Emmanuelle Marie Charpentier","Female","Washington"]
[]
[null,"Exercise 07: Combine Duplicate Rows without Losing Data"]
[]
[null,"Name","Car Maker","Car Model"]
[null,"Anthony","BMW","7 Series"]
[null,"Ronald","Toyota","Camry"]
[null,"Timothy","Lincoln","Town Car"]
[null,"David","Ford","Taurus"]
[null,"Ronald","Toyota","Corolla"]
[null,"Timothy","Lincoln","Continental"]
[null,"Issac","Volvo","S80"]
[null,"Issac","Ford","Fusion"]
[null,"Paul","Porsche",924]
[null,"Timothy","Ford","Mustang"]
[null,"Heather","Subaru","Justy"]
[null,"Jacob","Hyundai","Accent"]
[null,"Issac","Chevrolet","Silverado 1500"]
[null,"Timothy","Hummer","H3"]
[null,"Anthony","Dodge","Durango"]
[null,"Lena","Toyota","Supra"]
[null,"Vinicius","Daewoo","Nubira"]
[null,"Terry","Kia","Carens"]
[null,"Rodrygo","Honda","Accord"]
[null,"Lena","Mercury","Tracer"]
[]
[null,"Name","Car Maker","Car Model"]
[null,{"$f":"_xlfn.UNIQUE(B101:B120)","v":"Anthony"},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B123,$C$101:$C$120,\"\")))","v":"BMW, Dodge"},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B123,$D$101:$D$120,\"\")))","v":"7 Series, Durango"}]
[null,"Ronald",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B124,$C$101:$C$120,\"\")))","v":"Toyota"},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B124,$D$101:$D$120,\"\")))","v":"Camry, Corolla"}]
[null,"Timothy",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B125,$C$101:$C$120,\"\")))","v":"Lincoln, Ford, Hummer"},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B125,$D$101:$D$120,\"\")))","v":"Town Car, Continental, Mustang, H3"}]
[null,"David",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B126,$C$101:$C$120,\"\")))","v":"Ford"},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B126,$D$101:$D$120,\"\")))","v":"Taurus"}]
[null,"Issac",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B127,$C$101:$C$120,\"\")))","v":"Volvo, Ford, Chevrolet"},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B127,$D$101:$D$120,\"\")))","v":"S80, Fusion, Silverado 1500"}]
[null,"Paul",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B128,$C$101:$C$120,\"\")))","v":"Porsche"},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B128,$D$101:$D$120,\"\")))","v":"924"}]
[null,"Heather",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B129,$C$101:$C$120,\"\")))","v":"Subaru"},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B129,$D$101:$D$120,\"\")))","v":"Justy"}]
[null,"Jacob",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B130,$C$101:$C$120,\"\")))","v":"Hyundai"},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B130,$D$101:$D$120,\"\")))","v":"Accent"}]
[null,"Lena",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B131,$C$101:$C$120,\"\")))","v":"Toyota, Mercury"},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B131,$D$101:$D$120,\"\")))","v":"Supra, Tracer"}]
[null,"Vinicius",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B132,$C$101:$C$120,\"\")))","v":"Daewoo"},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B132,$D$101:$D$120,\"\")))","v":"Nubira"}]
[null,"Terry",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B133,$C$101:$C$120,\"\")))","v":"Kia"},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B133,$D$101:$D$120,\"\")))","v":"Carens"}]
[null,"Rodrygo",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B134,$C$101:$C$120,\"\")))","v":"Honda"},{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,_xlfn.UNIQUE(IF($B$101:$B$120=$B134,$D$101:$D$120,\"\")))","v":"Accord"}]
[]
[null,"Exercise 08: Unhide Rows Within Range"]
[]
[null,"Name","Gender","State"]
[null,"Rachel Green","Female","New Mexico"]
[null,"Ross Geller","Male","Mississippi"]
[null,"Joey Tribbiani","Male","Texas"]
[null,"Chandler Bing","Male","California"]
[null,"Rachel Green","Female","New Mexico"]
[null,"Ben Van Lier","Male","Colorado"]
[null,"Adam King","Male","Washington"]
[null,"Chandler Bing","Male","California"]
[null,"Mary Elizabeth Smith","Female","Utah"]
[null,"Ross James Geller","Male","New Mexico"]
[null,"Natasha Yvone Romanoff","Female","California"]
[null,"William Jackson Harper","Male","New Mexico"]
[null,"Marco Van Basten","Male","Colorado"]
[null,"Diego Garcia Lopez","Male","California"]
[null,"Alexis Mac Allister","Male","Mississippi"]
[null,"Lucas Martinez Quarta","Male","Washington"]
[null,"Giovani Lo Celso","Male","Utah"]
[null,"Jennifer Anne Doudna","Female","California"]
[null,"David William Cross","Male","New Mexico"]
[null,"Emmanuelle Marie Charpentier","Female","Washington"]
[]
[null,"Exercise 09: Transpose Rows to Columns Using Power Query"]
[]
[null,"Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11","Column12","Column13","Column14"]
[null,"Name","Anthony","Ronald","Timothy","David","Issac","Paul","Heather","Jacob","Lena","Vinicius","Terry","Rodrygo","Perry"]
[null,"Car Maker","BMW","Toyota","Lincoln","Subaru","Hyundai","Chevrolet","Hummer","Dodge","Toyota","Daewoo","Kia","Honda","Mercury"]
[null,"Car Model","7 Series","Camry","Town Car","Justy","Accent","Silverado 1500","H3","Durango","Supra","Nubira","Carens","Accord","Tracer"]
[]
[null,"Name","Car Maker","Car Model"]
[null,"Anthony","BMW","7 Series"]
[null,"Ronald","Toyota","Camry"]
[null,"Timothy","Lincoln","Town Car"]
[null,"David","Subaru","Justy"]
[null,"Issac","Hyundai","Accent"]
[null,"Paul","Chevrolet","Silverado 1500",null,"<<< Close and Load to cell B167"]
[null,"Heather","Hummer","H3"]
[null,"Jacob","Dodge","Durango"]
[null,"Lena","Toyota","Supra"]
[null,"Vinicius","Daewoo","Nubira"]
[null,"Terry","Kia","Carens"]
[null,"Rodrygo","Honda","Accord"]
[null,"Perry","Mercury","Tracer"]
[]
[null,"Exercise 10: Create Meter Chart"]
[]
[null,"Meter Chart",null,null,"Pointer"]
[null,"Start",0,null,"Value",80]
[null,"Initial",10,null,"Pointer",3]
[null,"Middle",30,null,"End",{"$f":"200-F185-F186","v":117}]
[null,"End",70]
[null,"Max",100]
[]
[]
[]
[]
[]
[null,null,null,null,"<<< Insert Meter Chart Here"]
[]
[]
[]
[]
[]
[null,"Exercise 11: Scrape Date from Website",null,null,null,null,null,"website link>>> https://studee.com/discover/best-states-usa/"]
[]
[null,"State","Overall Rank","Number of high ranking colleges","Tuition","Room","Board","19-25 (% of population)","Happiness","Crime","Grad salary","Things to do","LGBT","Mental health","Final Score"]
[null,"California",1,15,8192,8426,6419,9.6000000000000002E-2,63.14,442,68218,27872,39.25,32,7.54]
[null,"New York",2,14,8467,10180,5228,9.0999999999999998E-2,57.35,363.8,67024,16303,39,29.6,7.04]
[null,"Minnesota",3,1,11748,5579,4284,9.4E-2,67.260000000000005,277.5,63492,4049,33.5,24.6,6.87]
[null,"Utah",4,1,6700,3671,4248,0.107,67.84,260.7,60170,3075,15.25,31.1,6.8]
[null,"Florida",5,10,4463,6330,4444,7.3999999999999996E-2,51.01,383.6,60243,25643,7.75,31.6,6.28]
[null,"Wisconsin",6,3,8764,5497,3523,6.9000000000000006E-2,58.87,323.39999999999998,60528,5654,18,22.9,6.2]
[null,"Texas",7,12,8598,5360,4752,9.6000000000000002E-2,52.56,446.5,62771,13498,0.5,34.200000000000003,6.07]
[null,"Virginia",8,5,13655,6390,5028,8.8999999999999996E-2,57.35,208.7,64240,6040,26,27.9,6.04]
[null,"Colorado",9,6,9144,6541,6499,9.7000000000000003E-2,55.38,423.1,65313,7154,39.5,32,5.97]
[null,"Massachusetts",10,10,13729,8587,5302,8.5999999999999993E-2,56.85,308.8,67531,6693,33.5,31.4,5.97]
[null,"Washington",11,2,7168,6725,5953,8.6999999999999994E-2,56.44,293.7,66627,6828,36.75,33.5,5.92]
[null,"Maryland",12,5,9714,7305,5485,8.5000000000000006E-2,61.78,399.9,65386,3505,29.75,28.4,5.9]
[null,"Iowa",13,2,9373,5842,4593,9.0999999999999998E-2,61.07,303.5,60103,2358,17,27.2,5.81]
[null,"North Dakota",14,0,8628,3930,4892,0.104,65.62,329,60490,644,11.75,33.299999999999997,5.81]
[null,"Illinois",15,7,14455,6143,5208,9.5000000000000001E-2,52.47,425.9,63869,7491,35,31.3,5.8]
[null,"North Carolina",16,7,7228,5816,4525,9.7000000000000003E-2,53.69,419.3,61025,8497,5.75,35,5.67]
[null,"Idaho",17,1,7518,4268,4552,0.10199999999999999,63.09,242.6,57479,1656,3.75,33,5.66]
[null,"Nevada",18,1,6023,6358,5606,8.7999999999999995E-2,51.8,460.3,61538,3798,38,30,5.52]
[null,"New Jersey",19,5,14360,9052,4960,7.1999999999999995E-2,58.1,195.4,65561,4308,37,28.6,5.49]
[null,"Hawaii",20,1,10109,5785,5960,7.5999999999999998E-2,68.27,254.2,61724,6016,31,32.5,5.4]
[null,"Connecticut",21,2,13886,7491,6186,8.5000000000000006E-2,58.24,181.6,64895,2357,37.5,28.7,5.37]
[null,"Oregon",22,3,10813,7573,5196,9.1999999999999998E-2,48.05,291.89999999999998,63347,5398,36.5,34.6,5.3]
[null,"Ohio",23,6,9902,6869,5617,9.4E-2,48.19,308.8,60245,5903,9.75,26.4,5.29]
[null,"Maine",24,0,10103,5323,5032,6.6000000000000003E-2,49.81,108.6,59693,3361,37,28.6,5.26]
[null,"Nebraska",25,3,8582,5982,4957,0.105,59.11,334.1,59385,1227,4,33.5,5.24]
[null,"Georgia",26,5,7457,6745,4352,9.0999999999999998E-2,55.15,400.1,61580,5879,-0.5,34.299999999999997,5.21]
[null,"New Mexico",27,2,7152,4887,4154,9.5000000000000001E-2,43.35,778.3,60280,2716,28,31.9,5.19]
[null,"Indiana",28,4,9268,5634,5083,9.2999999999999999E-2,50.2,357.7,59293,3432,6.5,28.6,5.15]
[null,"South Dakota",29,1,8978,4092,4228,7.9000000000000001E-2,60.8,501.4,58399,1151,-4.5,24.7,5.1100000000000003]
[null,"Michigan",30,6,13315,5341,5430,9.1999999999999998E-2,49.52,478,60827,6704,19,29.8,5.1100000000000003]
[null,"Wyoming",31,1,4747,4493,5661,8.6999999999999994E-2,48.9,234.2,59171,1470,1.75,29.5,5.03]
[null,"Kansas",32,2,9088,5260,4753,8.8999999999999996E-2,52.3,425,58581,1606,7.75,29.2,4.9400000000000004]
[null,"New Hampshire",33,1,16679,7480,4575,7.0999999999999994E-2,52.37,146.4,60448,2115,27.5,23.5,4.9000000000000004]
[null,"Pennsylvania",34,7,15565,7127,4711,8.8999999999999996E-2,50.54,389.5,62080,7948,15.5,33.799999999999997,4.87]
[null,"Delaware",35,1,11091,7906,5361,0.09,51.67,431.9,61135,813,25.25,26.6,4.83]
[null,"Missouri",36,4,8992,5759,3983,8.8999999999999996E-2,42.76,542.70000000000005,61526,4167,0.75,33.6,4.72]
[null,"Arizona",37,3,11072,7610,5334,0.10100000000000001,52.92,484.8,62936,5971,4.25,33,4.71]
[null,"Montana",38,2,6967,4457,5308,7.3999999999999996E-2,51.08,469.8,57369,2662,4,28.2,4.49]
[null,"Rhode Island",39,2,13105,7858,4629,7.5999999999999998E-2,50.44,230.8,62160,1321,32.5,37.299999999999997,4.47]
[null,"South Carolina",40,2,12497,6399,3894,8.5999999999999993E-2,48.26,530.70000000000005,59272,4776,-0.5,30.2,4.37]
[null,"Oklahoma",41,1,8009,4816,4134,9.6000000000000002E-2,38.89,458.6,57868,1884,-2,37.700000000000003,4.16]
[null,"Alabama",42,3,10323,5703,4471,8.6999999999999994E-2,39.35,453.6,59221,2405,-4,34.1,3.97]
[null,"Kentucky",43,2,10888,6156,4755,8.2000000000000003E-2,39.42,259.10000000000002,58100,2576,10.25,36.200000000000003,3.94]
[null,"Louisiana",44,2,9571,5865,4062,8.8999999999999996E-2,37.15,639.4,58801,3104,-2.5,32.5,3.94]
[null,"Tennessee",45,3,10164,5365,4831,8.7999999999999995E-2,46.13,672.7,59829,5230,-6,34.6,3.92]
[null,"Vermont",46,0,17083,7980,4602,6.5000000000000002E-2,48.18,173.4,59169,1641,36,33.6,3.84]
[null,"Mississippi",47,1,8604,6250,4226,0.08,41.63,291.2,56044,1364,-3.5,35.9,3.7]
[null,"Alaska",48,1,8297,5843,5479,0.09,38.21,837.8,62950,2793,17.75,38.5,3.69]
[null,"West Virginia",49,0,8195,5786,5053,7.5999999999999998E-2,33.43,355.9,56958,1347,4,31.7,3.56]
[null,"Arkansas",50,1,8689,5486,4049,9.4E-2,36.61,671.9,57532,1760,-5.5,37.799999999999997,3.5]