{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Problem","Solution"],"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":"Problem","index":0,"n_rows":105,"n_cols":5,"rows_kept":105,"cut":false,"hidden":false,"merged":[[1,1,1,3],[24,1,24,2],[85,2,85,4]]}
[]
[null,"Excel VBA Exercises"]
[]
[null,"Exercise 01 Count Cells by Fill Color:"]
[null,"Name","Physics","Chemistry"]
[null,"Ron",37,87]
[null,"Sam",88,48]
[null,"Bob",79,85]
[null,"Emma",76,44]
[null,"Sara",82,72]
[null,"Time",95,69]
[]
[null,"Color","Count"]
[]
[]
[null,"Exercise 02 Use VBA SUMIFS with Multiple Criteria:"]
[null,"Order No","Product","Price"]
[null,1,"Mobile",727]
[null,2,"Television",759]
[null,3,"Mobile",584]
[null,4,"AC",774]
[null,5,"Mobile",870]
[null,6,"Television",800]
[]
[null,"Mobile or AC"]
[]
[]
[null,"Exercise 03 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,"Exercise 04 Find Square Root of Numbers:"]
[null,"Number","Square Root"]
[null,64]
[null,256]
[null,400]
[null,625]
[null,800]
[null,1225]
[null,1779]
[null,2500]
[]
[]
[null,"Exercise 05 Clear Cell Contents If It Contains Specific Value:"]
[null,"Value 01","Value 02"]
[null,64,56]
[null,"Noah","2022-05-22"]
[null,"Elijah",74]
[null,25,"Noah"]
[null,96,"Jacob"]
[null,"2022-06-02",96]
[null,"Pope","Freya"]
[null,"2022-05-18","Kratos"]
[]
[null,"Exercise 06 Save This Workbook as a New File:"]
[]
[]
[null,"Exercise 07 Hide Rows Based on Cell Value:"]
[null,"Student","Marks","Grade"]
[null,"Natalia",77,"A"]
[null,"Frank",28,"F"]
[null,"Craig",63,"A-"]
[null,"Steve",26,"F"]
[null,"Benjamin",84,"A+"]
[null,"Jennifer",30,"F"]
[]
[]
[null,"Exercise 08 Capitalized First Letter of Each Word:"]
[null,"Name","Designation"]
[null,"tom smith","administrative assitant"]
[null,"john keagy","administrative coordinator"]
[null,"mia Divia yang","secretary"]
[null,"william c. Ryan","manager"]
[null,"bo R. foster","director"]
[null,"charles henry hyatt","executive assitant"]
[]
[]
[null,"Exercise 09 Generate Random Number from Range:"]
[null,null,"Subject Marks"]
[null,"Name","Chemistry","Physics","English"]
[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,"Exercise 10 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"]

{"sheet":"Solution","index":1,"n_rows":105,"n_cols":5,"rows_kept":105,"cut":false,"hidden":false,"merged":[[1,1,1,3],[24,1,24,2],[85,2,85,4]]}
[]
[null,"Excel VBA Exercises"]
[]
[null,"Exercise 01 Count Cells by Fill Color:"]
[null,"Name","Physics","Chemistry"]
[null,"Ron",37,87]
[null,"Sam",88,48]
[null,"Bob",79,85]
[null,"Emma",76,44]
[null,"Sara",82,72]
[null,"Time",95,69]
[]
[null,"Color","Count"]
[null,null,{"$f":"CountCellBy_FillColor(C6:D11,B14)","v":5}]
[]
[null,"Exercise 02 Use VBA SUMIFS with Multiple Criteria:"]
[null,"Order No","Product","Price"]
[null,1,"Mobile",727]
[null,2,"Television",759]
[null,3,"Mobile",584]
[null,4,"AC",774]
[null,5,"Mobile",870]
[null,6,"Television",800]
[]
[null,"Mobile or AC",null,2955]
[]
[]
[null,"Exercise 03 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,"Exercise 04 Find Square Root of Numbers:"]
[null,"Number","Square Root"]
[null,64,8]
[null,256,16]
[null,400,20]
[null,625,25]
[null,800,28.284271247461902]
[null,1225,35]
[null,1779,42.178193417926281]
[null,2500,50]
[]
[]
[null,"Exercise 05 Clear Cell Contents If It Contains Specific Value:"]
[null,"Value 01","Value 02"]
[null,64,56]
[null,"Noah","2022-05-22"]
[null,"Elijah",74]
[null,25,"Noah"]
[null,null,"Jacob"]
[null,"2022-06-02"]
[null,"Pope","Freya"]
[null,"2022-05-18","Kratos"]
[]
[null,"Exercise 06 Save This Workbook as a New File:"]
[]
[]
[null,"Exercise 07 Hide Rows Based on Cell Value:"]
[null,"Student","Marks","Grade"]
[null,"Natalia",77,"A"]
[null,"Frank",28,"F"]
[null,"Craig",63,"A-"]
[null,"Steve",26,"F"]
[null,"Benjamin",84,"A+"]
[null,"Jennifer",30,"F"]
[]
[]
[null,"Exercise 08 Capitalized First Letter of Each Word:"]
[null,"Name","Designation"]
[null,"Tom Smith","Administrative Assitant"]
[null,"John Keagy","Administrative Coordinator"]
[null,"Mia Divia Yang","Secretary"]
[null,"William C. Ryan","Manager"]
[null,"Bo R. Foster","Director"]
[null,"Charles Henry Hyatt","Executive Assitant"]
[]
[]
[null,"Exercise 09 Generate Random Number from Range:"]
[null,null,"Subject Marks"]
[null,"Name","Chemistry","Physics","English"]
[null,"Mary Elizabeth Smith",88,64,71]
[null,"Ross James Geller",81,52,74]
[null,"Natasha Yvone Romanoff",69,62,75]
[null,"William Jackson Harper",76,60,61]
[null,"Marco Van Basten",84,83,74]
[null,"Diego Garcia Lopez",90,87,59]
[]
[]
[null,"Exercise 10 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"]