{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calendar","Questions"],"not_rendered":{"charts":0,"images":29,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Calendar","index":0,"n_rows":8,"n_cols":21,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,1,5,11],[6,1,6,11],[7,1,7,11]]}
["Excel Advent Calendar",null,null,null,null,null,{"$f":"R1","v":"29 Days till Christmas!"},null,null,null,null,null,null,null,{"$f":"IF(OR(Q1-P1>24,Q1-P1<1),\"\",(Q1-P1))","v":""},{"$f":"TODAY()","v":"2014-11-26"},"2014-12-25",{"$f":"IF(P1=41997,Q1-P1&\" Day till Christmas!\",Q1-P1&\" Days till Christmas!\")","v":"29 Days till Christmas!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Date Chosen",null,null,null,null,"Created by Mynda and Philip Treacy"]
["Choose the date you want to open:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"25-O2","v":21},"Days to go"]
[]
["Question:",{"$f":"IFERROR(VLOOKUP(O3,Table1[[Q Number]:[Question]],2,0),\"\")","v":"What is the shortcut key for inserting a SUM formula?"}]
[null,{"$f":"IFERROR(VLOOKUP($O$3,Table1[[Q Number]:[AA 3]],7,0),\"\")","v":"F10"},null,null,null,null,null,null,null,null,null,null,null,null,false,null,{"$f":"VLOOKUP(O3,Table1[],10,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"IFERROR(VLOOKUP($O$3,Table1[[Q Number]:[AA 3]],8,0),\"\")","v":"CTRL+="},null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,{"$f":"IFERROR(VLOOKUP($O$3,Table1[[Q Number]:[AA 3]],9,0),\"\")","v":"ALT+="},null,null,null,null,null,null,null,null,null,null,null,null,false]

{"sheet":"Questions","index":1,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Q Number","Question","Answer","False 1","False 2","Random","AA 1","AA 2","AA 3","VBA","Choice:",{"$f":"MATCH(TRUE,Calendar!O6:O8,0)","v":{"$error":"#N/A"}},null,"2014-12-01"]
[24,"What is the shortcut key for Undo?","CTRL+Z","CTRL+C","ALT+Z",1,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":"CTRL+Z"},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":"CTRL+C"},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":"ALT+Z"},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-02"]
[23,"How many rows in Excel 2010?",1048576,1058764,1045768,2,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":1058764},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":1045768},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":1048576},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-03"]
[22,"What are the 2 shortest functions?","N & T","DB & FV","SMALL & MIN",2,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":"DB & FV"},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":"SMALL & MIN"},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":"N & T"},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-04"]
[21,"What is the shortcut key for inserting a SUM formula?","ALT+=","CTRL+=","F10",3,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":"F10"},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":"CTRL+="},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":"ALT+="},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-05"]
[20,"What is the shortcut key for Save As?","F12","CTRL+S","ALT+S",2,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":"CTRL+S"},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":"ALT+S"},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":"F12"},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-06"]
[19,"How many columns in Excel 2013?",16384,15834,16834,2,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":15834},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":16834},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":16384},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-07"]
[18,"What is the shortcut key for spell check?","F7","ALT+S","F8",2,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":"ALT+S"},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":"F8"},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":"F7"},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-08"]
[17,"How do you force a carriage return in a cell?","ALT+ENTER","CTRL+ENTER","SHIFT+ENTER",1,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":"ALT+ENTER"},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":"CTRL+ENTER"},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":"SHIFT+ENTER"},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-09"]
[16,"How do you use Format Painter more than once?","Double Click Format Painter icon","Hold down SHIFT while clicking the Format Painter icon","Left click to apply the format",1,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":"Double Click Format Painter icon"},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":"Hold down SHIFT while clicking the Format Painter icon"},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":"Left click to apply the format"},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-10"]
[15,"What is the shortcut key to insert a named range into a formula?","F3","SHIFT+3","ALT+F3",3,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":"ALT+F3"},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":"SHIFT+3"},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":"F3"},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-11"]
[14,"What was Excel's original name?","Multiplan","Lotus 1-2-3","MS Excel",1,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":"Multiplan"},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":"Lotus 1-2-3"},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":"MS Excel"},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-12"]
[13,"What does QAT stand for?","Quick Access Toolbar","Quick Accounting Table","Quite A Task",1,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":"Quick Access Toolbar"},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":"Quick Accounting Table"},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":"Quite A Task"},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-13"]
[12,"Text prefixed by a caret ^ is aligned to the?","Center","Right","Left",2,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":"Right"},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":"Left"},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":"Center"},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-14"]
[11,"What was the first year Excel was released?",1987,1985,1986,1,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":1987},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":1985},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":1986},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-15"]
[10,"What came first; Excel for the Mac or Excel for the PC?","Excel for the Mac","Excel for the PC","They came out at the same time",3,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":"They came out at the same time"},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":"Excel for the PC"},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":"Excel for the Mac"},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-16"]
[9,"What is the 'secret' date function not listed in the Formulas menu?","DATEDIF","DIFFDATE","DATEIF",3,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":"DATEIF"},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":"DIFFDATE"},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":"DATEDIF"},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-17"]
[8,"What was the first version of Excel to include PivotTables?","Excel 5.0","Excel 95","Excel 1.0",1,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":"Excel 5.0"},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":"Excel 95"},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":"Excel 1.0"},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-18"]
[7,"The CTRL+Tab keys…","Switch between Excel windows","Tab through worksheets","Close Excel",1,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":"Switch between Excel windows"},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":"Tab through worksheets"},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":"Close Excel"},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-19"]
[6,"Which function was new in Excel 2010?","AGGREGATE","SUMIFS","FORMULATEXT",2,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":"SUMIFS"},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":"FORMULATEXT"},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":"AGGREGATE"},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-20"]
[5,"What are the most IF's you can nest in one formula in Excel 2010?",64,7,255,1,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":64},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":7},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":255},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-21"]
[4,"The programming language for Excel is called?","VBA","VBE","C++",2,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":"VBE"},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":"C++"},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":"VBA"},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-22"]
[3,"What function key inserts absolute references?","F4","F10","F6",2,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":"F10"},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":"F6"},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":"F4"},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-23"]
[2,"How many functions are there in Excel 2010",439,375,611,3,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":611},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":375},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":439},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}},null,null,null,"2014-12-24"]
[1,"What's the first date that Excel recognises?","Jan 1, 1900","Jan 1, 1904","Jan 1, 1800",1,{"$f":"CHOOSE(Table1[[#This Row],[Random]],Table1[[#This Row],[Answer]],Table1[[#This Row],[False 1]],Table1[[#This Row],[False 2]])","v":"Jan 1, 1900"},{"$f":"INDEX(Table1[[#This Row],[Answer]:[False 2]],,MOD(3,Table1[[#This Row],[Random]])+2)","v":"Jan 1, 1904"},{"$f":"IF(Table1[[#This Row],[Random]]=1,Table1[[#This Row],[False 2]],IF(Table1[[#This Row],[Random]]=2,Table1[[#This Row],[Answer]],IF(Table1[[#This Row],[Random]]=3,Table1[[#This Row],[Answer]])))","v":"Jan 1, 1800"},{"$f":"INDEX(Table1[[#This Row],[AA 1]:[AA 3]],,$L$1)=Table1[[#This Row],[Answer]]","v":{"$error":"#N/A"}}]