{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Home","Intro to Formula","Logical Functions & Comparison","Statistical Functions ","Lookup Functions","Text Functions ","Date Functions"],"not_rendered":{"charts":0,"images":72,"macros":1,"external_links":0,"defined_names":196,"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":"Home","index":0,"n_rows":51,"n_cols":14,"rows_kept":51,"cut":false,"hidden":false,"merged":[[49,0,50,2],[51,0,52,2],[39,0,40,2],[41,0,42,2],[43,0,44,2],[45,0,46,2],[47,0,48,2],[29,0,30,2],[31,0,32,2],[33,0,34,2],[35,0,36,2],[37,0,38,2],[2,4,4,15],[27,0,28,2],[5,0,6,2],[17,0,18,2],[19,0,20,2],[21,0,22,2],[23,0,24,2],[25,0,26,2],[7,0,8,2],[9,0,10,2],[11,0,12,2],[13,0,14,2],[15,0,16,2],[50,4,52,9],[50,10,52,11],[50,12,52,13],[41,4,43,9],[41,10,43,11],[41,12,43,13],[44,4,46,9],[44,10,46,11],[44,12,46,13],[32,4,34,9],[32,12,34,13],[32,10,34,11],[47,4,49,9],[47,10,49,11],[47,12,49,13],[35,4,37,9],[35,10,37,11],[35,12,37,13],[38,4,40,9],[38,10,40,11],[38,12,40,13]]}
[]
[]
[null,null,null,null,"Excel Formulas & Functions: An Interactive Tutorial"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(M36:N53,\"YES\")&\"/\"&\"6\"","v":"0/6"}]
[null,null,null,null,"Chapter",null,null,null,null,null,"Progress",null,"Completed?"]
[]
[]
[null,null,null,null,"1. Intro to Formulas\nIntroduction to Formulas and Cell References",null,null,null,null,null,{"$f":"Section1&\"/\"&\"7\"","v":"0/7"},null,{"$f":"IF(Section1=7,\"YES\",\"NO\")","v":"NO"}]
[]
[]
[null,null,null,null,"2. Logical Functions & Comparisons\nCompare Values, If statements, and more",null,null,null,null,null,{"$f":"Section2&\"/\"&\"12\"","v":"0/12"},null,{"$f":"IF(Section2=12,\"YES\",\"NO\")","v":"NO"}]
[]
[]
[null,null,null,null,"3. Statistical Functions\nCount, Sum, and Average numbers",null,null,null,null,null,{"$f":"Section3&\"/\"&\"8\"","v":"0/8"},null,{"$f":"IF(Section3=8,\"YES\",\"NO\")","v":"NO"}]
[]
[]
[null,null,null,null,"4. Lookup Functions\nFind and Return values from large datasets",null,null,null,null,null,{"$f":"Section4&\"/\"&\"8\"","v":"0/8"},null,{"$f":"IF(Section4=8,\"YES\",\"NO\")","v":"NO"}]
[]
[]
[null,null,null,null,"5. Text Functions\nJoin, truncate, manipulate, or clean text",null,null,null,null,null,{"$f":"Section5&\"/\"&\"13\"","v":"0/13"},null,{"$f":"IF(Section5=13,\"YES\",\"NO\")","v":"NO"}]
[]
[]
[null,null,null,null,"6. Date Functions\nPerform date math and output dates",null,null,null,null,null,{"$f":"Section6&\"/\"&\"6\"","v":"0/6"},null,{"$f":"IF(Section6=6,\"YES\",\"NO\")","v":"NO"}]

{"sheet":"Intro to Formula","index":1,"n_rows":251,"n_cols":25,"rows_kept":251,"cut":false,"hidden":false,"merged":[[243,9,244,11],[245,9,246,11],[247,9,248,11],[249,9,250,11],[231,9,232,11],[233,9,234,11],[235,9,236,11],[237,9,238,11],[239,9,240,11],[241,9,242,11],[219,9,220,11],[221,9,222,11],[223,9,224,11],[225,9,226,11],[227,9,228,11],[229,9,230,11],[207,9,208,11],[209,9,210,11],[211,9,212,11],[213,9,214,11],[215,9,216,11],[217,9,218,11],[193,9,194,11],[193,13,194,14],[193,15,194,24],[195,9,196,11],[195,13,205,14],[197,9,198,11],[199,9,200,11],[201,9,202,11],[203,9,204,11],[205,9,206,11],[183,9,184,11],[185,9,186,11],[187,9,188,11],[189,9,190,11],[191,9,192,11],[170,9,171,11],[172,9,173,11],[174,9,175,11],[176,9,176,11],[177,9,178,11],[179,9,180,11],[162,9,162,11],[163,9,163,11],[163,13,164,14],[163,15,164,24],[164,9,165,11],[165,13,175,14],[166,9,167,11],[168,9,169,11],[181,9,182,11],[151,9,151,11],[152,9,153,11],[154,9,155,11],[156,9,157,11],[135,9,136,11],[137,9,137,11],[138,9,138,11],[158,9,159,11],[160,9,161,11],[138,13,139,14],[138,15,139,24],[139,9,140,11],[140,13,150,14],[141,9,142,11],[143,9,144,11],[145,9,146,11],[123,9,124,11],[125,9,126,11],[127,9,128,11],[129,9,130,11],[131,9,132,11],[133,9,134,11],[147,9,148,11],[149,9,150,11],[111,9,111,11],[112,9,112,11],[112,13,113,14],[112,15,113,24],[113,9,114,11],[114,13,124,14],[115,9,116,11],[117,9,118,11],[119,9,120,11],[121,9,122,11],[99,9,100,11],[101,9,102,11],[103,9,104,11],[105,9,106,11],[107,9,108,11],[109,9,110,11],[87,9,88,11],[89,9,90,11],[91,9,92,11],[93,9,94,11],[95,9,96,11],[97,9,98,11],[75,9,76,11],[77,9,78,11],[79,9,80,11],[81,9,82,11],[83,9,84,11],[85,9,86,11],[62,9,62,11],[62,13,63,14],[62,15,63,24],[63,9,64,11],[64,13,74,14],[65,9,66,11],[67,9,68,11],[69,9,70,11],[71,9,72,11],[73,9,74,11],[51,9,52,11],[53,9,54,11],[55,9,56,11],[57,9,58,11],[59,9,60,11],[61,9,61,11],[39,9,40,11],[39,13,49,14],[41,9,42,11],[43,9,44,11],[45,9,46,11],[47,9,48,11],[49,9,50,11],[37,9,38,11],[37,13,38,14],[37,15,38,24],[15,9,16,11],[17,9,18,11],[19,9,20,11],[21,9,26,11],[21,13,22,14],[21,15,22,24],[23,13,33,14],[27,9,28,11],[29,9,30,11],[31,9,32,11],[2,13,4,25],[5,9,6,11],[7,9,8,11],[9,9,10,11],[11,9,12,11],[13,9,14,11],[33,9,33,11],[34,9,34,11],[35,9,36,11]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Introduction: Formulas & Cell References"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM(E21:E251)","v":0},null,{"$f":"Section1&\"/\"&\"7\"","v":"0/7"}]
["col_Answer",null,null,null,null,"col_Qnum"]
["Correct Ans","Ans given","Condition"]
[{"$f":"S26+S27","v":5},{"$f":"C21","v":""},{"$f":"IF(P22=\"\",\"\",IF(P22=\"=5\",\"\",IF(S28=5,5,\"\")))","v":""},{"$f":"IF(A21=B21,1,0)","v":0},{"$f":"D21","v":0},"Question 1","FILTER"]
[null,null,null,null,null,null,{"$f":"IF(Ques1=\"\",0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score1=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques1=\"\",\"\",_xlfn.FORMULATEXT(Ques1))),\"\",IF(Ques1=\"\",\"\",_xlfn.FORMULATEXT(Ques1)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Ques1=\"\",0,1)","v":0}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,{"$f":"G24","v":1},null,null,null,null,null,null,null,null,{"$f":"ROW()","v":25}]
[null,null,null,null,null,null,{"$f":"G25","v":1},null,null,null,null,null,null,null,null,{"$f":"ROW()","v":26},null,null,2]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":27},null,null,3]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":28}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":29}]
[null,null,null,null,null,null,{"$f":"G29","v":1},null,null,null,null,null,null,null,null,{"$f":"ROW()","v":30}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":31}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":32}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":33}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":34}]
["Correct Ans","Ans given","Condition",null,null,null,1]
[{"$f":"(S42+S43)*T43","v":25},{"$f":"C36","v":""},{"$f":"IF(P38=\"\",\"\",IF(P38=\"=25\",\"\",IF(P38=\"=5*5\",\"\",IF(Ques2=25,25,\"\"))))","v":""},{"$f":"IF(A36=B36,1,0)","v":0},{"$f":"IF(E21=0,0,D36)","v":0},"Question 2",{"$f":"$E$21","v":0}]
[null,null,null,null,null,null,{"$f":"$E$21","v":0}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques2=\"\",$E$21=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score2=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques2=\"\",\"\",_xlfn.FORMULATEXT(Ques2))),\"\",IF(Ques2=\"\",\"\",_xlfn.FORMULATEXT(Ques2)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques2=\"\",$E$21=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$21","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":41}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":42},null,null,2]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":43},null,null,3,5]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":44}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":45}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":46}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":47}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":48}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":49}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":50}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$36","v":0}]
[null,null,null,null,null,null,{"$f":"$E$36","v":0}]
[null,null,null,null,null,null,{"$f":"$E$36","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"S67/S68","v":0.66666666666666663},{"$f":"C61","v":""},{"$f":"IF(P63=\"=22/33\",\"\",IF(Ques3=22/33,Ques3,\"\"))","v":""},{"$f":"IF(A61=B61,1,0)","v":0},{"$f":"IF(E36=0,0,D61)","v":0},"Question 3",0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques3=\"\",$E$36=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score3=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques3=\"\",\"\",_xlfn.FORMULATEXT(Ques3))),\"\",IF(Ques3=\"\",\"\",_xlfn.FORMULATEXT(Ques3)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques3=\"\",$E$36=0),0,1)","v":0}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":66}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":67},null,null,22]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":68},null,null,33]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":69}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":70}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":71}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":72}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":73}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":74}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":75}]
[null,null,null,null,null,null,{"$f":"$E$36","v":0}]
[null,null,null,null,null,null,{"$f":"$E$61","v":0}]
[null,null,null,null,null,null,{"$f":"$E$61","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"R$118","v":0.05},{"$f":"C111","v":""},{"$f":"IF(P113=\"=R$118\",Ques4,\"\")","v":""},{"$f":"IF(A111=B111,1,0)","v":0},{"$f":"IF(E61=0,0,D111)","v":0},"Question 4",0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques4=\"\",$E$61=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score4=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques4=\"\",\"\",_xlfn.FORMULATEXT(Ques4))),\"\",IF(Ques4=\"\",\"\",_xlfn.FORMULATEXT(Ques4)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques4=\"\",$E$61=0),0,1)","v":0}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":116}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":117},"inputs","2020-01-01","2020-01-02","2020-01-03","2020-01-04","2020-01-05","2020-01-06","2020-01-07","2020-01-08"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":118},"drate",0.05,0.05,0.05,0.05,0.04,0.04,0.04,0.04]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":119}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":120}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":121}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":122}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":123}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":124}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":125}]
[null,null,null,null,null,null,{"$f":"$E$61","v":0}]
[null,null,null,null,null,null,{"$f":"$E$111","v":0}]
[null,null,null,null,null,null,{"$f":"$E$111","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
["=R143:W150",{"$f":"C137","v":""},{"$f":"P139","v":""},{"$f":"IF(A137=B137,1,0)","v":0},{"$f":"IF(E111=0,0,D137)","v":0},"Question 5",0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques5=\"\",$E$111=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score5=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(Ques5=\"\",\"\",UPPER(Ques5))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques5=\"\",$E$111=0),0,1)","v":0}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":142}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":143}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":144}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":145}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":146}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":147}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":148}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":149}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":150}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":151}]
[null,null,null,null,null,null,{"$f":"$E$111","v":0}]
[null,null,null,null,null,null,{"$f":"$E$137","v":0}]
[null,null,null,null,null,null,{"$f":"$E$137","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
["=\"THIS IS TEXT\"",{"$f":"C162","v":""},{"$f":"IF(A162=P164,A162,\"\")","v":""},{"$f":"IF(A162=B162,1,0)","v":0},{"$f":"IF(E137=0,0,D162)","v":0},"Question 6",0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques6=\"\",$E$137=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score6=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"UPPER(IF(ISERROR(IF(Ques6=\"\",\"\",_xlfn.FORMULATEXT(Ques6))),\"\",IF(Ques6=\"\",\"\",_xlfn.FORMULATEXT(Ques6))))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques6=\"\",$E$137=0),0,1)","v":0}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":167}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":168}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":169}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":170}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":171}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":172}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":173}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":174}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":175}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":176}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$162","v":0}]
[null,null,null,null,null,null,{"$f":"$E$162","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
["=TESTRANGE",{"$f":"C192","v":""},{"$f":"IF(A192=P194,P194,\"\")","v":""},{"$f":"IF(A192=B192,1,0)","v":0},{"$f":"IF(E162=0,0,D192)","v":0},"Question 7",0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques7=\"\",$E$162=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score7=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"UPPER(IF(ISERROR(IF(Ques7=\"\",\"\",_xlfn.FORMULATEXT(Ques7))),\"\",IF(Ques7=\"\",\"\",_xlfn.FORMULATEXT(Ques7))))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques7=\"\",$E$162=0),0,1)","v":0}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":197}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":198},0.99]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":199}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":200}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":201}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":202}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":203}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":204}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":205}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":206}]
[null,null,null,null,null,null,{"$f":"$E$162","v":0}]
[null,null,null,null,null,null,{"$f":"$E$192","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]

{"sheet":"Logical Functions & Comparison","index":2,"n_rows":382,"n_cols":25,"rows_kept":382,"cut":false,"hidden":false,"merged":[[328,13,338,14],[368,13,369,14],[368,15,369,24],[370,13,380,14],[290,13,300,14],[307,13,308,14],[307,15,308,24],[309,13,319,14],[326,13,327,14],[326,15,327,24],[221,13,231,14],[238,13,239,14],[238,15,239,24],[240,13,250,14],[288,13,289,14],[288,15,289,24],[144,13,154,14],[196,13,197,14],[196,15,197,24],[198,13,208,14],[219,13,220,14],[219,15,220,24],[88,13,98,14],[123,13,124,14],[123,15,124,24],[125,13,135,14],[142,13,143,14],[142,15,143,24],[40,13,50,14],[60,13,61,14],[60,15,61,24],[62,13,72,14],[86,13,87,14],[86,15,87,24],[38,15,39,24],[2,13,4,25],[5,9,6,11],[7,9,8,11],[9,9,10,11],[11,9,12,11],[13,9,14,11],[15,9,16,11],[17,9,18,11],[19,9,20,11],[21,9,22,11],[38,13,39,14]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Logical Functions"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM(E20:E386)","v":0},null,{"$f":"Section2&\"/\"&\"12\"","v":"0/12"}]
["col_Answer",null,null,null,null,"col_Qnum"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Correct Ans","Ans given","Condition"]
[{"$f":"R45<>S45","v":true},{"$f":"C38","v":""},{"$f":"IF(P39=\"\",\"\",IF(P39=\"TRUE\",\"\",IF(P39=\"=TRUE\",\"\",IF(Ques1=Answer1,Answer1,\"\"))))","v":""},{"$f":"IF(A38=B38,1,0)","v":0},{"$f":"D38","v":0},"Question 1","FILTER"]
[null,null,null,null,null,null,{"$f":"IF(Ques1=\"\",0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score1=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques1=\"\",\"\",_xlfn.FORMULATEXT(Ques1))),\"\",IF(Ques1=\"\",\"\",_xlfn.FORMULATEXT(Ques1)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Ques1=\"\",0,1)","v":0}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":42}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":43}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":44}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":45},null,5,3]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":46}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":47}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":48}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":49}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":50}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":51}]
[null,null,null,null,null,null,1]
[null,null,null,null,null,null,{"$f":"$E$38","v":0}]
[null,null,null,null,null,null,{"$f":"$E$38","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"R67*S67","v":0},{"$f":"C60","v":""},{"$f":"IF(P61=\"\",\"\",IF(P61=0,\"\",IF(P61=\"=0\",\"\",IF(Ques2=Answer2,Answer2,\"\"))))","v":""},{"$f":"IF(A60=B60,1,0)","v":0},{"$f":"IF(E38=0,0,D60)","v":0},"Question 2",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques2=\"\",$E$38=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score2=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques2=\"\",\"\",_xlfn.FORMULATEXT(Ques2))),\"\",IF(Ques2=\"\",\"\",_xlfn.FORMULATEXT(Ques2)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques2=\"\",$E$38=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$38","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":64}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":65}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":66}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":67},null,false,3]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":68}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":69}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":70}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":71}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":72}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":73}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$60","v":0}]
[null,null,null,null,null,null,{"$f":"$E$60","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"R93=S93","v":true},{"$f":"C86","v":""},{"$f":"IF(P87=\"\",\"\",IF(P87=\"TRUE\",\"\",IF(P87=\"=TRUE\",\"\",IF(Ques3=Answer3,Answer3,\"\"))))","v":""},{"$f":"IF(A86=B86,1,0)","v":0},{"$f":"IF(E60=0,0,D86)","v":0},"Question 3",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques3=\"\",$E$60=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score3=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques3=\"\",\"\",_xlfn.FORMULATEXT(Ques3))),\"\",IF(Ques3=\"\",\"\",_xlfn.FORMULATEXT(Ques3)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques3=\"\",$E$60=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$60","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":90}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":91}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":92}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":93},null,"string","String"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":94}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":95}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":96}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":97}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":98}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":99}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$86","v":0}]
[null,null,null,null,null,null,{"$f":"$E$86","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"IF(R130>S130,\"WARNING\",\"\")","v":"WARNING"},{"$f":"C123","v":""},{"$f":"IF(P124=\"\",\"\",IF(P124=\"WARNING\",\"\",IF(P124=\"=WARNING\",\"\",IF(Ques4=Answer4,Answer4,\"\"))))","v":""},{"$f":"IF(A123=B123,1,0)","v":0},{"$f":"IF(E86=0,0,D123)","v":0},"Question 4",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques4=\"\",$E$86=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score4=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques4=\"\",\"\",_xlfn.FORMULATEXT(Ques4))),\"\",IF(Ques4=\"\",\"\",_xlfn.FORMULATEXT(Ques4)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques4=\"\",$E$86=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$86","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":127}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":128}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":129}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":130},null,1.25,1]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":131}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":132}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":133}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":134}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":135}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":136}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$123","v":0}]
[null,null,null,null,null,null,{"$f":"$E$123","v":0}]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"IF(S149=\"STOP\",T148,Q149+R149)","v":11},{"$f":"C142","v":""},{"$f":"IF(P143=\"\",\"\",IF(P143=11,\"\",IF(P143=\"=11\",\"\",IF(Ques5=Answer5,Answer5,\"\"))))","v":""},{"$f":"IF(A142=B142,1,0)","v":0},{"$f":"IF(E123=0,0,D142)","v":0},"Question 5",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques5=\"\",$E$123=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score5=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques5=\"\",\"\",_xlfn.FORMULATEXT(Ques5))),\"\",IF(Ques5=\"\",\"\",_xlfn.FORMULATEXT(Ques5)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques5=\"\",$E$123=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$123","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,{"$f":"$E$123","v":0},null,null,null,null,null,null,null,null,{"$f":"ROW()","v":146}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":147},3,2,null,5]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":148},2,4,null,11]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":149},8,1,"stop"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":150},7,9]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":151}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":152}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":153}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":154}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":155}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$142","v":0}]
[null,null,null,null,null,null,{"$f":"$E$142","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"OR(S202=\"WARNING\",S203=\"WARNING\")","v":true},{"$f":"C196","v":""},{"$f":"IF(P197=\"\",\"\",IF(P197=\"TRUE\",\"\",IF(P197=\"=TRUE\",\"\",IF(Ques6=Answer6,Answer6,\"\"))))","v":""},{"$f":"IF(A196=B196,1,0)","v":0},{"$f":"IF(E142=0,0,D196)","v":0},"Question 6",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques6=\"\",$E$142=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score6=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques6=\"\",\"\",_xlfn.FORMULATEXT(Ques6))),\"\",IF(Ques6=\"\",\"\",_xlfn.FORMULATEXT(Ques6)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques6=\"\",$E$142=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$142","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":200}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":201}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":202},null,"Result","Warning?"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":203},null,-1,"warning"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":204},null,4]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":205}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":206}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":207}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":208}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":209}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$196","v":0}]
[null,null,null,null,null,null,{"$f":"$E$196","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"IF(AND(S224=\"WARNING\",S225=\"WARNING\"),\"UH OH\",\"XYZ\")","v":"XYZ"},{"$f":"C219","v":""},{"$f":"IF(P220=\"\",\"\",IF(P220=\"XYZ\",\"\",IF(P220=\"=XYZ\",\"\",IF(Ques7=Answer7,Answer7,\"\"))))","v":""},{"$f":"IF(A219=B219,1,0)","v":0},{"$f":"IF(E196=0,0,D219)","v":0},"Question 7",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques7=\"\",$E$196=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score7=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques7=\"\",\"\",_xlfn.FORMULATEXT(Ques7))),\"\",IF(Ques7=\"\",\"\",_xlfn.FORMULATEXT(Ques7)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques7=\"\",$E$196=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$196","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":223}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":224},null,"Result","Warning?"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":225},null,-1,"warning"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":226},null,4]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":227}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":228}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":229}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":230}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":231}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":232}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$219","v":0}]
[null,null,null,null,null,null,{"$f":"$E$219","v":0}]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"_xlfn.XOR(S244=\"WARNING\",S245=\"WARNING\")","v":true},{"$f":"C238","v":""},{"$f":"IF(P239=\"\",\"\",IF(P239=\"TRUE\",\"\",IF(P239=\"=TRUE\",\"\",IF(Ques8=Answer8,Answer8,\"\"))))","v":""},{"$f":"IF(A238=B238,1,0)","v":0},{"$f":"IF(E219=0,0,D238)","v":0},"Question 8",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques8=\"\",$E$219=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score8=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques8=\"\",\"\",_xlfn.FORMULATEXT(Ques8))),\"\",IF(Ques8=\"\",\"\",_xlfn.FORMULATEXT(Ques8)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques8=\"\",$E$219=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$219","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":242}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":243},null,"Result","Warning?"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":244},null,-1,"warning"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":245},null,4]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":246}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":247}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":248}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":249}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":250}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":251}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$238","v":0}]
[null,null,null,null,null,null,{"$f":"$E$238","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$238","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"ISNUMBER(R295)","v":true},{"$f":"C288","v":""},{"$f":"IF(P289=\"\",\"\",IF(P289=\"TRUE\",\"\",IF(P289=\"=TRUE\",\"\",IF(Ques9=Answer9,Answer9,\"\"))))","v":""},{"$f":"IF(A288=B288,1,0)","v":0},{"$f":"IF(E238=0,0,D288)","v":0},"Question 9",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques9=\"\",$E$238=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score9=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques9=\"\",\"\",_xlfn.FORMULATEXT(Ques9))),\"\",IF(Ques9=\"\",\"\",_xlfn.FORMULATEXT(Ques9)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques9=\"\",$E$238=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$238","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":292}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":293}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":294},null,"Is Number?"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":295},null,3]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":296}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":297}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":298}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":299}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":300}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":301}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$288","v":0}]
[null,null,null,null,null,null,{"$f":"$E$288","v":0}]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"ISTEXT(R314)","v":false},{"$f":"C307","v":""},{"$f":"IF(P308=\"\",\"\",IF(P308=\"FALSE\",\"\",IF(P308=\"=FALSE\",\"\",IF(Ques10=Answer10,Answer10,\"\"))))","v":""},{"$f":"IF(A307=B307,1,0)","v":0},{"$f":"IF(E288=0,0,D307)","v":0},"Question 10",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques10=\"\",$E$288=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score10=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques10=\"\",\"\",_xlfn.FORMULATEXT(Ques10))),\"\",IF(Ques10=\"\",\"\",_xlfn.FORMULATEXT(Ques10)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques10=\"\",$E$288=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$288","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":311}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":312}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":313},null,"Is Text?"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":314},null,3]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":315}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":316}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":317}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":318}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":319}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":320}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$307","v":0}]
[null,null,null,null,null,null,{"$f":"$E$307","v":0}]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"ISBLANK(R333)","v":false},{"$f":"C326","v":""},{"$f":"IF(P327=\"\",\"\",IF(P327=\"FALSE\",\"\",IF(P327=\"=FALSE\",\"\",IF(Ques11=Answer11,Answer11,\"\"))))","v":""},{"$f":"IF(A326=B326,1,0)","v":0},{"$f":"IF(E307=0,0,D326)","v":0},"Question 11",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques11=\"\",$E$307=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score11=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques11=\"\",\"\",_xlfn.FORMULATEXT(Ques11))),\"\",IF(Ques11=\"\",\"\",_xlfn.FORMULATEXT(Ques11)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques11=\"\",$E$307=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$307","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":330}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":331}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":332},null,"Is Blank?"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":333},null,3]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":334}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":335}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":336}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":337}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":338}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":339}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$326","v":0}]
[null,null,null,null,null,null,{"$f":"$E$326","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"IFERROR(R375/S375,0)","v":0},{"$f":"C368","v":""},{"$f":"IF(P369=\"\",\"\",IF(P369=0%,\"\",IF(P369=\"=0%\",\"\",IF(Ques12=Answer12,Answer12,\"\"))))","v":""},{"$f":"IF(A368=B368,1,0)","v":0},{"$f":"IF(E326=0,0,D368)","v":0},"Question 12",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques12=\"\",$E$326=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score12=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques12=\"\",\"\",_xlfn.FORMULATEXT(Ques12))),\"\",IF(Ques12=\"\",\"\",_xlfn.FORMULATEXT(Ques12)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques12=\"\",$E$326=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$326","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":372}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":373},null,"Units Sold","Unit Produced","Percent Sold"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":374},null,273,410,{"$f":"R374/S374","v":0.6658536585365854}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":375},null,0,0]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":376}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":377}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":378}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":379}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":380}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":381}]
[null,null,null,null,null,null,0]

{"sheet":"Statistical Functions ","index":3,"n_rows":403,"n_cols":25,"rows_kept":403,"cut":false,"hidden":false,"merged":[[386,13,387,14],[386,15,387,24],[388,13,398,14],[284,13,285,14],[284,15,285,24],[286,13,296,14],[347,13,348,14],[347,15,348,24],[349,13,359,14],[267,13,277,14],[70,13,71,14],[70,15,71,24],[72,13,82,14],[90,13,91,14],[90,15,91,24],[92,13,102,14],[245,13,246,14],[245,15,246,24],[247,13,257,14],[265,13,266,14],[265,15,266,24],[37,13,47,14],[2,13,4,25],[5,9,6,11],[7,9,8,11],[9,9,10,11],[11,9,12,11],[13,9,14,11],[15,9,16,11],[17,9,18,11],[35,13,36,14],[35,15,36,24]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Statistical Functions"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM(E20:E403)","v":0},null,{"$f":"Section3&\"/\"&\"8\"","v":"0/8"}]
["col_Answer",null,null,null,null,"col_Qnum"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Correct Ans","Ans given","Condition"]
[{"$f":"AVERAGE(R41:R44)","v":225.75},{"$f":"C35","v":""},{"$f":"IF(P36=\"\",\"\",IF(P36=225.75,\"\",IF(P36=\"=225.75\",\"\",IF(Ques1=Answer1,Answer1,\"\"))))","v":""},{"$f":"IF(A35=B35,1,0)","v":0},{"$f":"D35","v":0},"Question 1","FILTER"]
[null,null,null,null,null,null,{"$f":"IF(Ques1=\"\",0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score1=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques1=\"\",\"\",_xlfn.FORMULATEXT(Ques1))),\"\",IF(Ques1=\"\",\"\",_xlfn.FORMULATEXT(Ques1)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Ques1=\"\",0,1)","v":0}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":39}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":40},"Quarter","Unit Sold",null,"Ave Units Sold"]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":41},"Q1",273]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":42},"Q2",0]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":43},"Q3",130]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":44},"Q4",500]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":45}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":46}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":47}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":48}]
[null,null,null,null,null,null,1]
[null,null,null,null,null,null,{"$f":"$E$35","v":0}]
[null,null,null,null,null,null,{"$f":"$E$35","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"COUNTBLANK(R76:R79)","v":1},{"$f":"C70","v":""},{"$f":"IF(P71=\"\",\"\",IF(P71=1,\"\",IF(P71=\"=1\",\"\",IF(Ques2=Answer2,Answer2,\"\"))))","v":""},{"$f":"IF(A70=B70,1,0)","v":0},{"$f":"IF(E35=0,0,D70)","v":0},"Question 2",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques2=\"\",$E$35=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score2=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques2=\"\",\"\",_xlfn.FORMULATEXT(Ques2))),\"\",IF(Ques2=\"\",\"\",_xlfn.FORMULATEXT(Ques2)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques2=\"\",$E$35=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$35","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":74}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":75},"Quarter","Unit Sold",null,"#Missing Quarters"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":76},"Q1",273]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":77},"Q2"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":78},"Q3",130]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":79},"Q4",500]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":80}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":81}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":82}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":83}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$70","v":0}]
[null,null,null,null,null,null,{"$f":"$E$70","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"COUNTA(R96:R99)","v":3},{"$f":"C90","v":""},{"$f":"IF(P91=\"\",\"\",IF(P91=3,\"\",IF(P91=\"=3\",\"\",IF(Ques3=Answer3,Answer3,\"\"))))","v":""},{"$f":"IF(A90=B90,1,0)","v":0},{"$f":"IF(E70=0,0,D90)","v":0},"Question 3",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques3=\"\",$E$70=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score3=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques3=\"\",\"\",_xlfn.FORMULATEXT(Ques3))),\"\",IF(Ques3=\"\",\"\",_xlfn.FORMULATEXT(Ques3)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques3=\"\",$E$70=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$70","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":94}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":95},"Quarter","Unit Sold",null,"#Reported"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":96},"Q1",273]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":97},"Q2"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":98},"Q3",130]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":99},"Q4",500]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":100}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":101}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":102}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":103}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$90","v":0}]
[null,null,null,null,null,null,{"$f":"$E$90","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$90","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$90","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"AVERAGEIFS(R251:R255,Q251:Q255,\">2019\")","v":314},{"$f":"C245","v":""},{"$f":"IF(P246=\"\",\"\",IF(P246=314,\"\",IF(P246=\"=314\",\"\",IF(Ques4=Answer4,Answer4,\"\"))))","v":""},{"$f":"IF(A245=B245,1,0)","v":0},{"$f":"IF(E90=0,0,D245)","v":0},"Question 4",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques4=\"\",$E$90=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score4=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques4=\"\",\"\",_xlfn.FORMULATEXT(Ques4))),\"\",IF(Ques4=\"\",\"\",_xlfn.FORMULATEXT(Ques4)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques4=\"\",$E$90=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$90","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":249}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":250},"Year","Unit Sold",null,"Average sold after 2019"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":251},2018,273]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":252},2019]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":253},2020,130]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":254},2021,500]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":255},2022,312]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":256}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":257}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":258}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$245","v":0}]
[null,null,null,null,null,null,{"$f":"$E$245","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"COUNTIFS(Q271:Q275,\">2019\",R271:R275,\"<300\")","v":1},{"$f":"C265","v":""},{"$f":"IF(P266=\"\",\"\",IF(P266=1,\"\",IF(P266=\"=1\",\"\",IF(Ques5=Answer5,Answer5,\"\"))))","v":""},{"$f":"IF(A265=B265,1,0)","v":0},{"$f":"IF(E245=0,0,D265)","v":0},"Question 5",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques5=\"\",$E$245=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score5=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques5=\"\",\"\",_xlfn.FORMULATEXT(Ques5))),\"\",IF(Ques5=\"\",\"\",_xlfn.FORMULATEXT(Ques5)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques5=\"\",$E$245=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$245","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":269}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":270},"Year","Unit Sold",null,"# Years after 2019 with < 300 sold"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":271},2018,273]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":272},2019]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":273},2020,130]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":274},2021,500]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":275},2022,312]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":276}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":277}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":278}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$265","v":0}]
[null,null,null,null,null,null,{"$f":"$E$265","v":0}]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"SUMIFS(R290:R294,Q290:Q294,\"<2020\")","v":273},{"$f":"C284","v":""},{"$f":"IF(P285=\"\",\"\",IF(P285=273,\"\",IF(P285=\"=273\",\"\",IF(Ques6=Answer6,Answer6,\"\"))))","v":""},{"$f":"IF(A284=B284,1,0)","v":0},{"$f":"IF(E265=0,0,D284)","v":0},"Question 6",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques6=\"\",$E$265=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score6=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques6=\"\",\"\",_xlfn.FORMULATEXT(Ques6))),\"\",IF(Ques6=\"\",\"\",_xlfn.FORMULATEXT(Ques6)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques6=\"\",$E$265=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$265","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":288}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":289},"Year","Unit Sold",null,"Add units sold before 2020"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":290},2018,273]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":291},2019]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":292},2020,130]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":293},2021,500]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":294},2022,312]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":295}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":296}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":297}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$284","v":0}]
[null,null,null,null,null,null,{"$f":"$E$284","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"COUNTIFS(R353:R357,\"*APPLE\")","v":2},{"$f":"C347","v":""},{"$f":"IF(P348=\"\",\"\",IF(P348=2,\"\",IF(P348=\"=2\",\"\",IF(Ques7=Answer7,Answer7,\"\"))))","v":""},{"$f":"IF(A347=B347,1,0)","v":0},{"$f":"IF(E284=0,0,D347)","v":0},"Question 7",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques7=\"\",$E$284=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score7=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques7=\"\",\"\",_xlfn.FORMULATEXT(Ques7))),\"\",IF(Ques7=\"\",\"\",_xlfn.FORMULATEXT(Ques7)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques7=\"\",$E$284=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$284","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":351}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":352},null,"Fruit",null,"Count the number of apples listed"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":353},null,"Orange"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":354},null,"Blackberry"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":355},null,"Green Apple"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":356},null,"Red Apple"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":357},null,"Strawberry"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":358}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":359}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":360}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$347","v":0}]
[null,null,null,null,null,null,{"$f":"$E$347","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"SUMPRODUCT(R392:R396,S392:S396)","v":79865},{"$f":"C386","v":""},{"$f":"IF(P387=\"\",\"\",IF(P387=79865,\"\",IF(P387=\"=79865\",\"\",IF(Ques8=Answer8,Answer8,\"\"))))","v":""},{"$f":"IF(A386=B386,1,0)","v":0},{"$f":"IF(E347=0,0,D386)","v":0},"Question 8",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques8=\"\",$E$347=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score8=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques8=\"\",\"\",_xlfn.FORMULATEXT(Ques8))),\"\",IF(Ques8=\"\",\"\",_xlfn.FORMULATEXT(Ques8)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques8=\"\",$E$347=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$347","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":390}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":391},"Products","Units","Cost per unit",null,"Total cost of goods sold"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":392},"Shoes",392,64.5]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":393},"Shirts",200,36]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":394},"Ties",298,54.5]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":395},"Shorts",320,77.099999999999994]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":396},"Scarfs",154,42]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":397}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":398}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":399}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$386","v":0}]
[null,null,null,null,null,null,{"$f":"$E$386","v":0}]
[null,null,null,null,null,null,0]

{"sheet":"Lookup Functions","index":4,"n_rows":303,"n_cols":25,"rows_kept":303,"cut":false,"hidden":false,"merged":[[301,9,301,11],[302,9,302,11],[296,9,296,11],[297,9,297,11],[298,9,298,11],[299,9,299,11],[300,9,300,11],[291,9,291,11],[292,9,292,11],[293,9,293,11],[294,9,294,11],[295,9,295,11],[286,9,286,11],[287,9,287,11],[288,9,288,11],[289,9,289,11],[290,9,290,11],[281,9,281,11],[282,9,282,11],[283,9,283,11],[284,9,284,11],[285,9,285,11],[276,9,276,11],[277,9,277,11],[278,9,278,11],[279,9,279,11],[280,9,280,11],[271,9,271,11],[272,9,272,11],[273,9,273,11],[274,9,274,11],[275,9,275,11],[266,9,266,11],[267,9,267,11],[268,9,268,11],[269,9,269,11],[270,9,270,11],[261,9,261,11],[262,9,262,11],[263,9,263,11],[264,9,264,11],[265,9,265,11],[256,9,256,11],[257,9,257,11],[258,9,258,11],[259,9,259,11],[260,9,260,11],[251,9,251,11],[252,9,252,11],[253,9,253,11],[254,9,254,11],[255,9,255,11],[246,9,246,11],[247,9,247,11],[248,9,248,11],[249,9,249,11],[250,9,250,11],[241,9,241,11],[242,9,242,11],[243,9,243,11],[244,9,244,11],[245,9,245,11],[236,9,236,11],[237,9,237,11],[238,9,238,11],[239,9,239,11],[240,9,240,11],[231,9,231,11],[232,9,232,11],[233,9,233,11],[234,9,234,11],[235,9,235,11],[226,9,226,11],[227,9,227,11],[228,9,228,11],[229,9,229,11],[230,9,230,11],[221,9,221,11],[222,9,222,11],[223,9,223,11],[224,9,224,11],[225,9,225,11],[216,9,216,11],[217,9,217,11],[218,9,218,11],[219,9,219,11],[220,9,220,11],[211,9,211,11],[212,9,212,11],[213,9,213,11],[214,9,214,11],[215,9,215,11],[206,9,206,11],[207,9,207,11],[208,9,208,11],[209,9,209,11],[210,9,210,11],[201,9,201,11],[202,9,202,11],[203,9,203,11],[204,9,204,11],[205,9,205,11],[196,9,196,11],[197,9,197,11],[198,9,198,11],[199,9,199,11],[200,9,200,11],[191,9,191,11],[192,9,192,11],[193,9,193,11],[194,9,194,11],[195,9,195,11],[186,9,186,11],[187,9,187,11],[188,9,188,11],[189,9,189,11],[190,9,190,11],[181,9,181,11],[182,9,182,11],[183,9,183,11],[184,9,184,11],[185,9,185,11],[176,9,176,11],[177,9,177,11],[178,9,178,11],[179,9,179,11],[180,9,180,11],[171,9,171,11],[172,9,172,11],[173,9,173,11],[174,9,174,11],[175,9,175,11],[166,9,166,11],[167,9,167,11],[168,9,168,11],[169,9,169,11],[170,9,170,11],[161,9,161,11],[162,9,162,11],[163,9,163,11],[164,9,164,11],[165,9,165,11],[156,9,156,11],[157,9,157,11],[158,9,158,11],[159,9,159,11],[160,9,160,11],[151,9,151,11],[152,9,152,11],[153,9,153,11],[154,9,154,11],[155,9,155,11],[146,9,146,11],[147,9,147,11],[148,9,148,11],[149,9,149,11],[150,9,150,11],[141,9,141,11],[142,9,142,11],[143,9,143,11],[144,9,144,11],[145,9,145,11],[136,9,136,11],[137,9,137,11],[138,9,138,11],[139,9,139,11],[140,9,140,11],[131,9,131,11],[132,9,132,11],[133,9,133,11],[134,9,134,11],[135,9,135,11],[126,9,126,11],[127,9,127,11],[128,9,128,11],[129,9,129,11],[130,9,130,11],[121,9,121,11],[122,9,122,11],[123,9,123,11],[124,9,124,11],[125,9,125,11],[116,9,116,11],[117,9,117,11],[118,9,118,11],[119,9,119,11],[120,9,120,11],[111,9,111,11],[112,9,112,11],[113,9,113,11],[114,9,114,11],[115,9,115,11],[106,9,106,11],[107,9,107,11],[108,9,108,11],[109,9,109,11],[110,9,110,11],[101,9,101,11],[102,9,102,11],[103,9,103,11],[104,9,104,11],[105,9,105,11],[96,9,96,11],[97,9,97,11],[98,9,98,11],[99,9,99,11],[100,9,100,11],[91,9,91,11],[92,9,92,11],[93,9,93,11],[94,9,94,11],[95,9,95,11],[86,9,86,11],[87,9,87,11],[88,9,88,11],[89,9,89,11],[90,9,90,11],[81,9,81,11],[82,9,82,11],[83,9,83,11],[84,9,84,11],[85,9,85,11],[76,9,76,11],[77,9,77,11],[78,9,78,11],[79,9,79,11],[80,9,80,11],[71,9,71,11],[72,9,72,11],[73,9,73,11],[74,9,74,11],[75,9,75,11],[52,9,52,11],[53,9,53,11],[54,9,54,11],[55,9,55,11],[66,9,66,11],[67,9,67,11],[68,9,68,11],[69,9,69,11],[70,9,70,11],[61,9,61,11],[62,9,62,11],[63,9,63,11],[64,9,64,11],[65,9,65,11],[37,9,37,11],[38,9,38,11],[39,9,39,11],[40,9,40,11],[232,13,242,14],[289,13,290,14],[289,15,290,24],[291,13,301,14],[46,9,46,11],[47,9,47,11],[48,9,48,11],[49,9,49,11],[50,9,50,11],[41,9,41,11],[42,9,42,11],[43,9,43,11],[44,9,44,11],[45,9,45,11],[56,9,56,11],[57,9,57,11],[58,9,58,11],[59,9,59,11],[60,9,60,11],[51,9,51,11],[24,9,24,11],[25,9,25,11],[26,9,26,11],[27,9,27,11],[28,9,28,11],[29,9,29,11],[30,9,30,11],[31,9,31,11],[32,9,32,11],[33,9,33,11],[34,9,34,11],[35,9,35,11],[165,13,175,14],[190,13,191,14],[190,15,191,24],[192,13,202,14],[230,13,231,14],[230,15,231,24],[117,13,127,14],[138,13,139,14],[138,15,139,24],[140,13,150,14],[163,13,164,14],[163,15,164,24],[81,13,82,14],[81,15,82,24],[83,13,93,14],[115,13,116,14],[115,15,116,24],[61,13,62,14],[61,15,62,24],[63,13,73,14],[36,9,36,11],[22,9,22,11],[23,9,23,11],[2,13,4,25],[7,9,8,11],[9,9,10,11],[11,9,12,11],[13,9,14,11],[15,9,16,11],[5,9,6,11],[17,9,18,11],[21,9,21,11],[19,9,19,11],[20,9,20,11]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Lookup Functions"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM(E21:E303)","v":0},null,{"$f":"Section4&\"/\"&\"8\"","v":"0/8"}]
["col_Answer",null,null,null,null,"col_Qnum"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Correct Ans","Ans given","Condition"]
[{"$f":"VLOOKUP(4,Q66:U70,5,FALSE)","v":52000},{"$f":"C61","v":""},{"$f":"IF(P62=\"\",\"\",IF(P62=52000,\"\",IF(P62=\"=52000\",\"\",IF(Ques1=Answer1,Answer1,\"\"))))","v":""},{"$f":"IF(A61=B61,1,0)","v":0},{"$f":"D61","v":0},"Question 1","FILTER"]
[null,null,null,null,null,null,{"$f":"IF(Ques1=\"\",0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score1=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques1=\"\",\"\",_xlfn.FORMULATEXT(Ques1))),\"\",IF(Ques1=\"\",\"\",_xlfn.FORMULATEXT(Ques1)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Ques1=\"\",0,1)","v":0}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":65}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":66},"Emp ID","Birthdate","Hiredate","Location","Salary",null,"Lookup salary of Emp ID 4"]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":67},1,"1960-12-01","2000-01-04","St.Louis",65000]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":68},2,"1980-01-01","2006-01-02","Chicago",75000]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":69},3,"1975-04-30","2001-01-03","Milwauke",125000]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":70},4,"1985-05-13","2011-01-01","NewYork",52000]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":71}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":72}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":73}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":74}]
[null,null,null,null,null,null,1]
[null,null,null,null,null,null,{"$f":"$E$61","v":0}]
[null,null,null,null,null,null,{"$f":"$E$61","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"VLOOKUP(2,Q86:U90,2,FALSE)","v":"1980-01-01"},{"$f":"C81","v":""},{"$f":"IF(P82=\"\",\"\",IF(P82=\"1/1/1980\",\"\",IF(P82=\"=1/1/1980\",\"\",IF(Ques2=Answer2,Answer2,\"\"))))","v":""},{"$f":"IF(A81=B81,1,0)","v":0},{"$f":"IF(E61=0,0,D81)","v":0},"Question 2",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques2=\"\",$E$61=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score2=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques2=\"\",\"\",_xlfn.FORMULATEXT(Ques2))),\"\",IF(Ques2=\"\",\"\",_xlfn.FORMULATEXT(Ques2)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques2=\"\",$E$61=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$61","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":85}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":86},"Emp ID","Birthdate","Hiredate","Location","Salary",null,"Lookup salary of Emp ID 2"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":87},1,"1960-12-01","2000-01-04","St.Louis",65000]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":88},2,"1980-01-01","2006-01-02","Chicago",75000]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":89},3,"1975-04-30","2001-01-03","Milwauke",125000]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":90},4,"1985-05-13","2011-01-01","NewYork",52000]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":91}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":92}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":93}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":94}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$81","v":0}]
[null,null,null,null,null,null,{"$f":"$E$81","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$81","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"VLOOKUP($V126,$Q$120:$U$124,W$124,FALSE)","v":"1975-04-30"},{"$f":"C115","v":""},{"$f":"IF(P116=\"\",\"\",IF(P116=\"4/30/1975\",\"\",IF(P116=\"=4/30/1975\",\"\",IF(Ques3=Answer3,Answer3,\"\"))))","v":""},{"$f":"IF(A115=B115,1,0)","v":0},{"$f":"IF(E81=0,0,D115)","v":0},"Question 3",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques3=\"\",$E$81=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score3=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques3=\"\",\"\",_xlfn.FORMULATEXT(Ques3))),\"\",IF(Ques3=\"\",\"\",_xlfn.FORMULATEXT(Ques3)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques3=\"\",$E$81=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$81","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":119}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":120},"Emp ID","Birthdate","Hiredate","Location","Salary"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":121},1,"1960-12-01","2000-01-04","St.Louis",65000]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":122},2,"1980-01-01","2006-01-02","Chicago",75000]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":123},3,"1975-04-30","2001-01-03","Milwauke",125000,null,"col_Index_num"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":124},4,"1985-05-13","2011-01-01","NewYork",52000,null,2,3]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":125},null,null,null,null,null,"EMP ID","Birthdate","Location"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":126},null,null,null,null,null,3,null,{"$f":"IF(Score3=1,\"Milwauke\",\"\")","v":""}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":127},null,null,null,null,null,2,{"$f":"IF(Score3=1,\"1/1/1980\",\"\")","v":""},{"$f":"IF(Score3=1,\"Chicago\",\"\")","v":""}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":128},null,null,null,null,null,4,{"$f":"IF(Score3=1,\"5/13/2985\",\"\")","v":""},{"$f":"IF(Score3=1,\"NewYork\",\"\")","v":""}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$115","v":0}]
[null,null,null,null,null,null,{"$f":"$E$115","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"VLOOKUP(V145,Q143:R147,2,TRUE)","v":4},{"$f":"C138","v":""},{"$f":"IF(P139=\"\",\"\",IF(P139=4,\"\",IF(P139=\"=4\",\"\",IF(Ques4=Answer4,Answer4,\"\"))))","v":""},{"$f":"IF(A138=B138,1,0)","v":0},{"$f":"IF(E115=0,0,D138)","v":0},"Question 4",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques4=\"\",$E$115=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score4=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques4=\"\",\"\",_xlfn.FORMULATEXT(Ques4))),\"\",IF(Ques4=\"\",\"\",_xlfn.FORMULATEXT(Ques4)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques4=\"\",$E$115=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$115","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":142}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":143},"Temp","Heat Strokes per 1000 Senior Citizens"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":144},80,1,null,null,null,"Tomorrow Temperature"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":145},90,4,null,null,null,92]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":146},100,10,null,null,null,"Expected Heat Strokes"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":147},110,20]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":148}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":149}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":150}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":151}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$138","v":0}]
[null,null,null,null,null,null,{"$f":"$E$138","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"HLOOKUP(W169,R168:U171,4,FALSE)","v":8.0399999999999999E-2},{"$f":"C163","v":""},{"$f":"IF(P164=\"\",\"\",IF(P164=8.04%,\"\",IF(P164=\"=8.04%\",\"\",IF(Ques5=Answer5,Answer5,\"\"))))","v":""},{"$f":"IF(A163=B163,1,0)","v":0},{"$f":"IF(E138=0,0,D163)","v":0},"Question 5",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques5=\"\",$E$138=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score5=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques5=\"\",\"\",_xlfn.FORMULATEXT(Ques5))),\"\",IF(Ques5=\"\",\"\",_xlfn.FORMULATEXT(Ques5)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques5=\"\",$E$138=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$138","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":167}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":168},null,"New York","California","Wisconsin","Texas",null,"% of US Population"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":169},"Population",19465197,37691912,5711767,25674681,null,"Texas"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":170},"Seats in House",29,53,8,32]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":171},"Percent of total US population",6.1899999999999997E-2,0.1191,1.8200000000000001E-2,8.0399999999999999E-2]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":172}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":173}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":174}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":175}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":176}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$163","v":0}]
[null,null,null,null,null,null,{"$f":"$E$163","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"VLOOKUP(\"?537\",Q196:R203,2,FALSE)","v":"2008-05-01"},{"$f":"C190","v":""},{"$f":"IF(P191=\"\",\"\",IF(P191=\"5/1/2008\",\"\",IF(P191=\"=5/1/2008\",\"\",IF(Ques6=Answer6,Answer6,\"\"))))","v":""},{"$f":"IF(A190=B190,1,0)","v":0},{"$f":"IF(E163=0,0,D190)","v":0},"Question 6",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques6=\"\",$E$163=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score6=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques6=\"\",\"\",_xlfn.FORMULATEXT(Ques6))),\"\",IF(Ques6=\"\",\"\",_xlfn.FORMULATEXT(Ques6)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques6=\"\",$E$163=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$163","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":194}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":195},"Emp ID","Hire Date"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":196},"a855","2000-01-04"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":197},"a303","2006-01-02","Incomplete Employee ID",null,"_537"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":198},"a456","2001-04-03",null,"Hire Date"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":199},"b942","2011-01-01"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":200},"b301","2001-11-03"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":201},"b266","2004-01-03"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":202},"b537","2008-05-01"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":203},"c725","2017-08-15"]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$190","v":0}]
[null,null,null,null,null,null,{"$f":"$E$190","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$190","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"MATCH(\"F\",R236:R242,0)","v":6},{"$f":"C230","v":""},{"$f":"IF(P231=\"\",\"\",IF(P231=6,\"\",IF(P231=\"=6\",\"\",IF(Ques7=Answer7,Answer7,\"\"))))","v":""},{"$f":"IF(A230=B230,1,0)","v":0},{"$f":"IF(E190=0,0,D230)","v":0},"Question 7",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques7=\"\",$E$190=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score7=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques7=\"\",\"\",_xlfn.FORMULATEXT(Ques7))),\"\",IF(Ques7=\"\",\"\",_xlfn.FORMULATEXT(Ques7)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques7=\"\",$E$190=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$190","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":234}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":235},null,"Letter",null,"What number position is the letter F?"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":236},null,"A"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":237},null,"B"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":238},null,"C"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":239},null,"D"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":240},null,"E"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":241},null,"F"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":242},null,"G"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":243}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$230","v":0}]
[null,null,null,null,null,null,{"$f":"$E$230","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$230","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"INDEX(R296:V301,5,4)","v":7},{"$f":"C289","v":""},{"$f":"IF(P290=\"\",\"\",IF(P290=7,\"\",IF(P290=\"=7\",\"\",IF(Ques8=Answer8,Answer8,\"\"))))","v":""},{"$f":"IF(A289=B289,1,0)","v":0},{"$f":"IF(E230=0,0,D289)","v":0},"Question 8",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques8=\"\",$E$230=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score8=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques8=\"\",\"\",_xlfn.FORMULATEXT(Ques8))),\"\",IF(Ques8=\"\",\"\",_xlfn.FORMULATEXT(Ques8)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques8=\"\",$E$230=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$230","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":293}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":294},null,1,2,3,4,5]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":295},null,"Name","Games","Hits","HRs","Runs"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":296},1,"Hoey Hamilton",69,87,13,45]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":297},2,"David Trout",67,88,8,47,"Total cost of goods sold"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":298},3,"Ryan Bourn",66,81,20,47]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":299},4,"Michael Braun",70,92,6,47]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":300},5,"Mike Wright",49,67,7,42]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":301},6,"Josh Votto",64,80,22,46]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":302}]
[null,null,null,null,null,null,{"$f":"$E$289","v":0}]

{"sheet":"Text Functions ","index":5,"n_rows":403,"n_cols":25,"rows_kept":403,"cut":false,"hidden":false,"merged":[[391,13,401,14],[334,13,344,14],[370,13,371,14],[370,15,371,24],[372,13,382,14],[389,13,390,14],[389,15,390,24],[271,13,281,14],[305,13,306,14],[305,15,306,24],[307,13,317,14],[332,13,333,14],[332,15,333,24],[218,13,228,14],[236,13,237,14],[236,15,237,24],[238,13,248,14],[269,13,270,14],[269,15,270,24],[196,13,197,14],[196,15,197,24],[198,13,208,14],[216,13,217,14],[216,15,217,24],[111,13,121,14],[153,13,154,14],[153,15,154,24],[155,13,165,14],[42,13,52,14],[58,13,59,14],[58,15,59,24],[60,13,70,14],[109,13,110,14],[109,15,110,24],[2,13,4,25],[21,13,22,14],[21,15,22,24],[23,13,33,14],[40,13,41,14],[40,15,41,24],[5,9,6,11],[17,9,18,11],[19,9,20,11],[21,9,22,11],[7,9,8,11],[9,9,10,11],[11,9,12,11],[13,9,14,11],[15,9,16,11]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Text Functions"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM(E20:E403)","v":0},null,{"$f":"Section5&\"/\"&\"13\"","v":"0/13"}]
["col_Answer",null,null,null,null,"col_Qnum"]
["Correct Ans","Ans given","Condition"]
[{"$f":"\"TEXT\"","v":"TEXT"},{"$f":"C21","v":""},{"$f":"IF(P22=\"\",\"\",IF(P22=\"TEXT\",\"\",IF(P22=\"=TEXT\",\"\",IF(Ques1=Answer1,Answer1,\"\"))))","v":""},{"$f":"IF(A21=B21,1,0)","v":0},{"$f":"D21","v":0},"Question 1","FILTER"]
[null,null,null,null,null,null,{"$f":"IF(Ques1=\"\",0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score1=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques1=\"\",\"\",_xlfn.FORMULATEXT(Ques1))),\"\",IF(Ques1=\"\",\"\",_xlfn.FORMULATEXT(Ques1)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Ques1=\"\",0,1)","v":0}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":25}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":26}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":27}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":28}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":29}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":30}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":31}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":32}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":33}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":34}]
[null,null,null,null,null,null,1]
[null,null,null,null,null,null,{"$f":"$E$21","v":0}]
[null,null,null,null,null,null,{"$f":"$E$21","v":0}]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"\"TE\" & \"XT\"","v":"TEXT"},{"$f":"C40","v":""},{"$f":"IF(P41=\"\",\"\",IF(P41=\"TEXT\",\"\",IF(P41=\"=\"\"TEXT\"\"\",\"\",IF(Ques2=Answer2,Answer2,\"\"))))","v":""},{"$f":"IF(A40=B40,1,0)","v":0},{"$f":"IF(E21=0,0,D40)","v":0},"Question 2",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques2=\"\",$E$21=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score2=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques2=\"\",\"\",_xlfn.FORMULATEXT(Ques2))),\"\",IF(Ques2=\"\",\"\",_xlfn.FORMULATEXT(Ques2)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques2=\"\",$E$21=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$21","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":44}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":45}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":46}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":47}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":48}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":49}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":50}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":51}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":52}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":53}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$40","v":0}]
[null,null,null,null,null,null,{"$f":"$E$40","v":0}]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"\"Q\" & S65","v":"Q2"},{"$f":"C58","v":""},{"$f":"IF(P59=\"\",\"\",IF(P59=\"Q2\",\"\",IF(P59=\"=Q2\",\"\",IF(Ques3=Answer3,Answer3,\"\"))))","v":""},{"$f":"IF(A58=B58,1,0)","v":0},{"$f":"IF(E40=0,0,D58)","v":0},"Question 3",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques3=\"\",$E$40=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score3=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques3=\"\",\"\",_xlfn.FORMULATEXT(Ques3))),\"\",IF(Ques3=\"\",\"\",_xlfn.FORMULATEXT(Ques3)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques3=\"\",$E$40=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$40","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":62}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":63}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":64},null,null,1,"Q1"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":65},null,null,2]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":66},null,null,3,"Q3"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":67},null,null,4,"Q4"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":68}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":69}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":70}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":71}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$58","v":0}]
[null,null,null,null,null,null,{"$f":"$E$58","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
["00123",{"$f":"C109","v":""},{"$f":"IF(P110=\"\",\"\",IF(P110=\"WARNING\",\"\",IF(P110=\"=WARNING\",\"\",IF(Ques4=Answer4,Answer4,\"\"))))","v":""},{"$f":"IF(A109=B109,1,0)","v":0},{"$f":"IF(E58=0,0,D109)","v":0},"Question 4",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques4=\"\",$E$58=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score4=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(Ques4=\"\",\"\",IF(Ques4=\"00123\",\"'00123\"))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques4=\"\",$E$58=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$58","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":113}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":114}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":115}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":116}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":117}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":118}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":119}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":120}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":121}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":122}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$109","v":0}]
[null,null,null,null,null,null,{"$f":"$E$109","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"VALUE(S160)","v":123},{"$f":"C153","v":""},{"$f":"IF(P154=\"\",\"\",IF(P154=123,\"\",IF(P154=\"=123\",\"\",IF(Ques5=Answer5,Answer5,\"\"))))","v":""},{"$f":"IF(A153=B153,1,0)","v":0},{"$f":"IF(E109=0,0,D153)","v":0},"Question 5",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques5=\"\",$E$109=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score5=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques5=\"\",\"\",_xlfn.FORMULATEXT(Ques5))),\"\",IF(Ques5=\"\",\"\",_xlfn.FORMULATEXT(Ques5)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques5=\"\",$E$109=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$109","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":157}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":158}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":159}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":160},null,null,"00123"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":161}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":162}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":163}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":164}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":165}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":166}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$153","v":0}]
[null,null,null,null,null,null,{"$f":"$E$153","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$153","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"RIGHT(R203,2)","v":"21"},{"$f":"C196","v":""},{"$f":"IF(P197=\"\",\"\",IF(P197=21,\"\",IF(P197=\"=21\",\"\",IF(Ques6=Answer6,Answer6,\"\"))))","v":""},{"$f":"IF(A196=B196,1,0)","v":0},{"$f":"IF(E153=0,0,D196)","v":0},"Question 6",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques6=\"\",$E$153=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score6=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques6=\"\",\"\",_xlfn.FORMULATEXT(Ques6))),\"\",IF(Ques6=\"\",\"\",_xlfn.FORMULATEXT(Ques6)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques6=\"\",$E$153=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$153","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":200}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":201},null,"Code","Right 2 Chars"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":202},null,"E53",53]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":203},null,"S21"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":204},null,"W10",10]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":205},null,"N97",97]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":206},null,"S47",47]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":207},null,"W25",25]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":208},null,"S10",10]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":209}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$196","v":0}]
[null,null,null,null,null,null,{"$f":"$E$196","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"MID(R223,2,2)","v":"ex"},{"$f":"C216","v":""},{"$f":"IF(P217=\"\",\"\",IF(P217=\"EX\",\"\",IF(P217=\"=EX\",\"\",IF(Ques7=Answer7,Answer7,\"\"))))","v":""},{"$f":"IF(A216=B216,1,0)","v":0},{"$f":"IF(E196=0,0,D216)","v":0},"Question 7",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques7=\"\",$E$196=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score7=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques7=\"\",\"\",_xlfn.FORMULATEXT(Ques7))),\"\",IF(Ques7=\"\",\"\",_xlfn.FORMULATEXT(Ques7)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques7=\"\",$E$196=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$196","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":220}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":221},null,"Code","Middle 2 Char"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":222},null,"test","es"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":223},null,"text"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":224},null,"this","hi"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":225},null,"team","ea"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":226},null,"trim","ri"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":227},null,"take","ak"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":228},null,"tool","oo"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":229}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$216","v":0}]
[null,null,null,null,null,null,{"$f":"$E$216","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"MID(R243,2,999)","v":"21432"},{"$f":"C236","v":""},{"$f":"IF(P237=\"\",\"\",IF(P237=21432,\"\",IF(P237=\"=21432\",\"\",IF(Ques8=Answer8,Answer8,\"\"))))","v":""},{"$f":"IF(A236=B236,1,0)","v":0},{"$f":"IF(E216=0,0,D236)","v":0},"Question 8",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques8=\"\",$E$216=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score8=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques8=\"\",\"\",_xlfn.FORMULATEXT(Ques8))),\"\",IF(Ques8=\"\",\"\",_xlfn.FORMULATEXT(Ques8)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques8=\"\",$E$216=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$216","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":240}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":241},null,"Code","All Chars starting at 2"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":242},null,"E53",53]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":243},null,"S21432"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":244},null,"W108",108]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":245},null,"N9721",9721]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":246},null,"S47432",47432]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":247},null,"W252",252]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":248},null,"S101",101]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":249}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$236","v":0}]
[null,null,null,null,null,null,{"$f":"$E$236","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"FIND(\",\",R276)","v":6},{"$f":"C269","v":""},{"$f":"IF(P270=\"\",\"\",IF(P270=6,\"\",IF(P270=\"=6\",\"\",IF(Ques9=Answer9,Answer9,\"\"))))","v":""},{"$f":"IF(A269=B269,1,0)","v":0},{"$f":"IF(E236=0,0,D269)","v":0},"Question 9",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques9=\"\",$E$236=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score9=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques9=\"\",\"\",_xlfn.FORMULATEXT(Ques9))),\"\",IF(Ques9=\"\",\"\",_xlfn.FORMULATEXT(Ques9)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques9=\"\",$E$236=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$236","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":273}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":274}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":275},null,"Name",null,"Comma Position"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":276},null,"Smith, John"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":277}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":278}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":279}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":280}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":281}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":282}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$269","v":0}]
[null,null,null,null,null,null,{"$f":"$E$269","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"SUBSTITUTE(R313,\"-\",\"\")","v":"987654321"},{"$f":"C305","v":""},{"$f":"IF(P306=\"\",\"\",IF(P306=987654321,\"\",IF(P306=\"=987654321\",\"\",IF(Ques10=Answer10,Answer10,\"\"))))","v":""},{"$f":"IF(A305=B305,1,0)","v":0},{"$f":"IF(E269=0,0,D305)","v":0},"Question 10",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques10=\"\",$E$269=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score10=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques10=\"\",\"\",_xlfn.FORMULATEXT(Ques10))),\"\",IF(Ques10=\"\",\"\",_xlfn.FORMULATEXT(Ques10)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques10=\"\",$E$269=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$269","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":309}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":310}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":311},null,"SSNs",null,"Clean SSN"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":312},null,"123-456-789",null,123456789]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":313},null,"987-65-4321"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":314},null,"111-22-3333",null,111223333]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":315}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":316}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":317}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":318}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$305","v":0}]
[null,null,null,null,null,null,{"$f":"$E$305","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"TRIM(R339)","v":"Scott Adams"},{"$f":"C332","v":""},{"$f":"IF(P333=\"\",\"\",IF(P333=\"SCOTT ADAMS\",\"\",IF(P333=\"=SCOTT ADAMS\",\"\",IF(Ques11=Answer11,Answer11,\"\"))))","v":""},{"$f":"IF(A332=B332,1,0)","v":0},{"$f":"IF(E305=0,0,D332)","v":0},"Question 11",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques11=\"\",$E$305=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score11=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques11=\"\",\"\",_xlfn.FORMULATEXT(Ques11))),\"\",IF(Ques11=\"\",\"\",_xlfn.FORMULATEXT(Ques11)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques11=\"\",$E$305=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$305","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":336}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":337},null,"Text",null,"Cleaned Text"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":338},null,"John    Smith",null,"John Smith"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":339},null,"Scott         Adams"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":340},null,"Adam  Smith",null,"Adam Smith"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":341}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":342}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":343}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":344}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":345}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$332","v":0}]
[null,null,null,null,null,null,{"$f":"$E$332","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"LOWER(R377)","v":"scott adams"},{"$f":"C370","v":""},{"$f":"IF(P371=\"\",\"\",IF(P371=\"SCOTT ADAMS\",\"\",IF(P371=\"=SCOTT ADAMS\",\"\",IF(Ques12=Answer12,Answer12,\"\"))))","v":""},{"$f":"IF(A370=B370,1,0)","v":0},{"$f":"IF(E332=0,0,D370)","v":0},"Question 12",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques12=\"\",$E$332=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score12=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques12=\"\",\"\",_xlfn.FORMULATEXT(Ques12))),\"\",IF(Ques12=\"\",\"\",_xlfn.FORMULATEXT(Ques12)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques12=\"\",$E$332=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$332","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":374}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":375},null,"Text",null,"Cleaned Text"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":376},null,"John Smith",null,"john smith"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":377},null,"Scott ADAMS"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":378},null,"Adam Smith",null,"adam smith"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":379}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":380}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":381}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":382}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":383}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$370","v":0}]
[null,null,null,null,null,null,{"$f":"$E$370","v":0}]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"PROPER(R396)","v":"Scott Adams"},{"$f":"C389","v":""},{"$f":"IF(P390=\"\",\"\",IF(P390=\"SCOTT ADAMS\",\"\",IF(P390=\"=SCOTT ADAMS\",\"\",IF(Ques12=Answer12,Answer12,\"\"))))","v":""},{"$f":"IF(A389=B389,1,0)","v":0},{"$f":"IF(E370=0,0,D389)","v":0},"Question 13",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques13=\"\",$E$370=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score13=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques13=\"\",\"\",_xlfn.FORMULATEXT(Ques13))),\"\",IF(Ques13=\"\",\"\",_xlfn.FORMULATEXT(Ques13)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques13=\"\",$E$370=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$370","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":393}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":394},null,"Text",null,"Cleaned Text"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":395},null,"John Smith",null,"john smith"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":396},null,"Scott ADAMS"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":397},null,"Adam Smith",null,"adam smith"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":398}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":399}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":400}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":401}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":402}]
[null,null,null,null,null,null,{"$f":"$E$389","v":0}]

{"sheet":"Date Functions","index":6,"n_rows":200,"n_cols":25,"rows_kept":200,"cut":false,"hidden":false,"merged":[[185,13,186,14],[185,15,186,24],[187,13,197,14],[109,13,119,14],[2,13,4,25],[142,13,143,14],[142,15,143,24],[144,13,154,14],[57,13,67,14],[82,13,83,14],[82,15,83,24],[84,13,94,14],[107,13,108,14],[107,15,108,24],[32,13,33,14],[32,15,33,24],[55,15,56,24],[7,9,8,11],[9,9,10,11],[11,9,12,11],[13,9,14,11],[15,9,16,11],[19,9,19,11],[20,9,20,11],[5,9,6,11],[17,9,18,11],[21,9,21,11],[34,13,44,14],[55,13,56,14]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Functions"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"SUM(E21:E200)","v":0},null,{"$f":"Section6&\"/\"&\"6\"","v":"0/6"}]
["col_Answer",null,null,null,null,"col_Qnum"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Correct Ans","Ans given","Condition"]
[{"$f":"S37-S38","v":3827},{"$f":"C32","v":""},{"$f":"IF(P33=\"\",\"\",IF(P33=3827,\"\",IF(P33=\"=3827\",\"\",IF(Ques1=Answer1,Answer1,\"\"))))","v":""},{"$f":"IF(A32=B32,1,0)","v":0},{"$f":"D32","v":0},"Question 1","FILTER"]
[null,null,null,null,null,null,{"$f":"IF(Ques1=\"\",0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score1=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques1=\"\",\"\",_xlfn.FORMULATEXT(Ques1))),\"\",IF(Ques1=\"\",\"\",_xlfn.FORMULATEXT(Ques1)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(Ques1=\"\",0,1)","v":0}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":36}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":37},null,null,"2041-05-22"]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":38},null,null,"2030-11-29"]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":39}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":40}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":41}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":42}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":43}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":44}]
[null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":45}]
[null,null,null,null,null,null,1]
[null,null,null,null,null,null,{"$f":"$E$32","v":0}]
[null,null,null,null,null,null,{"$f":"$E$32","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"TODAY()+1","v":"2020-07-24"},{"$f":"C55","v":""},{"$f":"IF(P56=\"\",\"\",IF(P56=1,\"\",IF(P56=\"=1\",\"\",IF(Ques2=Answer2,Answer2,\"\"))))","v":""},{"$f":"IF(A55=B55,1,0)","v":0},{"$f":"IF(E32=0,0,D55)","v":0},"Question 2",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques2=\"\",$E$32=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score2=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques2=\"\",\"\",_xlfn.FORMULATEXT(Ques2))),\"\",IF(Ques2=\"\",\"\",_xlfn.FORMULATEXT(Ques2)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques2=\"\",$E$32=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$32","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":59}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":60}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":61}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":62}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":63}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":64}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":65}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":66}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":67}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":68}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$55","v":0}]
[null,null,null,null,null,null,{"$f":"$E$55","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$55","v":0}]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"DAY(R89)","v":16},{"$f":"C82","v":""},{"$f":"IF(P83=\"\",\"\",IF(P83=16,\"\",IF(P83=\"=16\",\"\",IF(Ques3=Answer3,Answer3,\"\"))))","v":""},{"$f":"IF(A82=B82,1,0)","v":0},{"$f":"IF(E55=0,0,D82)","v":0},"Question 3",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques3=\"\",$E$55=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score3=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques3=\"\",\"\",_xlfn.FORMULATEXT(Ques3))),\"\",IF(Ques3=\"\",\"\",_xlfn.FORMULATEXT(Ques3)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques3=\"\",$E$55=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$55","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":86}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":87}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":88},null,"Date","Day"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":89},null,"2019-06-16"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":90}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":91}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":92}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":93}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":94}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":95}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$82","v":0}]
[null,null,null,null,null,null,{"$f":"$E$82","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"DATE(2030,11,25)","v":"2030-11-25"},{"$f":"C107","v":""},{"$f":"IF(P108=\"\",\"\",IF(P108=1,\"\",IF(P108=\"=1\",\"\",IF(Ques4=Answer4,Answer4,\"\"))))","v":""},{"$f":"IF(A107=B107,1,0)","v":0},{"$f":"IF(E82=0,0,D107)","v":0},"Question 4",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques4=\"\",$E$82=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score4=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques4=\"\",\"\",_xlfn.FORMULATEXT(Ques4))),\"\",IF(Ques4=\"\",\"\",_xlfn.FORMULATEXT(Ques4)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques4=\"\",$E$82=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$82","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":111}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":112}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":113}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":114}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":115}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":116}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":117}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":118}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":119}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":120}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$107","v":0}]
[null,null,null,null,null,null,{"$f":"$E$107","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$107","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"EDATE(S149,3)","v":"2019-04-01"},{"$f":"C142","v":""},{"$f":"IF(P143=\"\",\"\",IF(P143=1,\"\",IF(P143=\"=1\",\"\",IF(Ques5=Answer5,Answer5,\"\"))))","v":""},{"$f":"IF(A142=B142,1,0)","v":0},{"$f":"IF(E107=0,0,D142)","v":0},"Question 5",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques5=\"\",$E$107=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score5=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques5=\"\",\"\",_xlfn.FORMULATEXT(Ques5))),\"\",IF(Ques5=\"\",\"\",_xlfn.FORMULATEXT(Ques5)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques5=\"\",$E$107=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$107","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":146}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":147}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":148},null,"Quarter start date","Q1","Q2","Q3","Q4"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":149},null,"Date","2019-01-01",null,"7//1/2019","2019-10-01"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":150}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":151}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":152}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":153}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":154}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":155}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$142","v":0}]
[null,null,null,null,null,null,{"$f":"$E$142","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$142","v":0}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,0]
["Correct Ans","Ans given","Condition",null,null,null,0]
[{"$f":"EOMONTH(S191,3)","v":"2019-06-30"},{"$f":"C185","v":""},{"$f":"IF(P186=\"\",\"\",IF(P186=1,\"\",IF(P186=\"=1\",\"\",IF(Ques6=Answer6,Answer6,\"\"))))","v":""},{"$f":"IF(A185=B185,1,0)","v":0},{"$f":"IF(E142=0,0,D185)","v":0},"Question 6",0]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques6=\"\",$E$142=0),0,1)","v":0},null,null,null,null,null,null,{"$f":"IF(Score6=0,\"Incorrect:\",\"Correct Answer:\")","v":"Incorrect:"},null,{"$f":"IF(ISERROR(IF(Ques6=\"\",\"\",_xlfn.FORMULATEXT(Ques6))),\"\",IF(Ques6=\"\",\"\",_xlfn.FORMULATEXT(Ques6)))","v":""}]
[null,null,null,null,null,null,{"$f":"IF(OR(Ques6=\"\",$E$142=0),0,1)","v":0}]
[null,null,null,null,null,null,{"$f":"$E$142","v":0},null,null,null,null,null,null,"\nEnter Answer In Highlighted Cell",null,null,{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"Q"},{"$f":"SUBSTITUTE(ADDRESS(1,COLUMN(),4),\"1\",\"\")","v":"R"},"S","T","U","V","W","X","Y"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":189}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":190},null,"Quarter","Q1","Q2","Q3","Q4"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":191},null,"Date","2019-03-31",null,"2019-09-30","2019-12-31"]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":192}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":193}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":194}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":195}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":196}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":197}]
[null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,{"$f":"ROW()","v":198}]
[null,null,null,null,null,null,0]
[null,null,null,null,null,null,{"$f":"$E$185","v":0}]