{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"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":"Sheet1","index":0,"n_rows":169,"n_cols":4,"rows_kept":169,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
["This Spreadsheet contains the answer key for the Formula and Function sections of the tutorial."]
[]
[null,null,null,"etc. indicates copy the formula down or across to other cells."]
[]
["Formula Overview"]
[null,"2.",null,"=SUM(E92:H95)"]
[null,null,null,"=SUM(F100:F103)"]
[null,null,null,"=E$116*$D117      etc."]
[]
[]
["Logical Formulas"]
[null,"1.",null,"=IF(D66>=70,\"sell lemonade\",\"play video games\")     etc."]
[]
[null,"2.",null,"=IF(AND(D112>=70,E112=\"sunny\"),\"sell lemonade\",\"play video games\")"]
[null,null,null,"=IF(AND(OR(C133=\"Monday\",C133=\"Wednesday\",C133=\"Friday\"),E133=\"sunny\"),\"sell lemonade\",\"play video games\")"]
[]
[null,"3.",null,"=IF(ISNUMBER(C158),C158,\"N/A\")"]
[null,null,null,"=IFERROR(C185,\"\")"]
[]
[]
["Stat&Math&Fin&CSE Formulas","1.",null,"=AVERAGE(J55:J66)"]
[null,null,null,"=COUNT(J55:J66)"]
[null,null,null,"=SUM(J55:J66)"]
[null,null,null,"=AVERAGEA(J55:J66)"]
[null,null,null,"=COUNTA(J55:J66)"]
[null,null,null,"=COUNTBLANK(J55:J66)"]
[null,null,null,"=AVERAGEIF(I55:I66,1,J55:J66)"]
[null,null,null,"=COUNTIF(I55:I66,1)"]
[null,null,null,"=SUMIF(I55:I66,1,J55:J66)"]
[null,null,null,"=AVERAGEIFS(J55:J66,H55:H66,\"<2011\",I55:I66,2)"]
[null,null,null,"=COUNTIFS(H55:H66,\"<2011\",I55:I66,2)"]
[null,null,null,"=SUMIFS(J55:J66,H55:H66,\"<2011\",I55:I66,2)"]
[null,null,null,"=SUM(D74:D78)"]
[]
[null,"2.",null,"=SUMIF(C119:C127,\"*apples*\",D119:D127)"]
[null,null,null,"=SUMIF(C132:C141,\"n6?\",D132:D141)"]
[]
[null,"3.",null,"=SUMPRODUCT(D165:D168,E165:E168)"]
[]
[null,null,null,"=MIN(D176:D187)"]
[null,null,null,"=MAX(D176:D187)"]
[null,null,null,"=MODE(D176:D187)"]
[]
[null,null,null,"=ABS(C191)"]
[null,null,null,"=ABS(C192)"]
[]
[null,null,null,"=ROUND(C201,1)"]
[null,null,null,"=ROUNDUP(C201,1)"]
[null,null,null,"=ROUNDDOWN(C201,1)"]
[]
[null,null,null,"=CEILING(C209,0.005)"]
[null,null,null,"=FLOOR(C210,0.005)"]
[]
[null,null,null,"=RANK.AVG(C218,$C$218:$C$226)         etc."]
[null,null,null,"=RANK.EQ(C218,$C$218:$C$226)         etc."]
[null,null,null,"=RANK(C218,$C$218:$C$226)         etc."]
[]
[null,null,null,"=PV(D237,D236,D235)"]
[null,null,null,"=PMT(D237,D236,D234)"]
[null,null,null,"=NPER(D237,D235,D234)"]
[null,null,null,"=RATE(D236,D235,D234)"]
[null,null,null,"=FV(D237,D236,D235)"]
[null,null,null,"=NPV(D242,D243:L243)"]
[null,null,null,"=IRR(D246:L246)"]
[null,null,null,"=XIRR(D250:L250,D249:L249)"]
[]
[null,"4.",null,"=RAND()"]
[null,null,null,"=RANDBETWEEN(0,0.4)          the .4 can be any number <=1"]
[]
[null,"5.",null,"=AVERAGE(IF(D293:D304=\"Q2\",E293:E304))"]
[null,null,null,"=SUM(IF(D293:D304=\"Q2\",E293:E304))"]
[null,null,null,"=SUM(IF(C319:C339=\"Q2\",E319:E339*F319:F339))"]
[null,null,null,"=TRANSPOSE($D350:$D390)"]
[]
[]
["Lookup Formulas","1.",null,"=VLOOKUP(4,C42:G50,5,FALSE)"]
[null,null,null,"=VLOOKUP(6,C42:G50,4,FALSE)"]
[null,null,null,"=VLOOKUP(9,C42:G50,2,FALSE)"]
[null,null,null,"=VLOOKUP($C70,$C$42:$G$50,D$68,FALSE)     etc."]
[null,null,null,"=VLOOKUP(92,C78:D81,2,TRUE)"]
[null,null,null,"=VLOOKUP(ROUNDUP(92,-1),C78:D81,2,TRUE)"]
[]
[null,null,null,"=HLOOKUP(\"Texas\",D95:G98,4,FALSE)"]
[]
[null,null,null,"4937?0376"]
[null,null,null,"=VLOOKUP(G112,C110:D120,2,FALSE)"]
[]
[null,"2.",null,"=MATCH(\"f\",C132:O132,0)"]
[null,null,null,"Any 2 single digit numbers will work"]
[null,null,null,"=INDEX(E163:M168,5,6)"]
[]
[null,null,null,"=MATCH(G183,$F$162:$M$162,0)    etc."]
[null,null,null,"=VLOOKUP($F184,$F$163:$M$168,G$182,FALSE)    etc."]
[]
[null,null,null,"=MATCH(G203,$F$162:$M$162,0)    etc."]
[null,null,null,"=MATCH(F204,$F$163:$F$168,0)    etc."]
[null,null,null,"=INDEX($F$163:$M$168,$D204,G$202)    etc."]
[]
[null,null,null,"=CHOOSE(J226-D220+1,D223,E223,F223,G223,H223,I223)"]
[null,null,null,"=AVERAGE(OFFSET(C220,3,2,1,2))"]
[]
[null,"3.",null,"=ROW(C271)      etc."]
[null,null,null,"=ROWS(F271:F280)       etc."]
[]
[null,null,null,"=COLUMN(C294)    etc."]
[null,null,null,"=COLUMNS(C298:H298)"]
[]
[null,null,null,"=INDIRECT(F335,FALSE)"]
[null,null,null,350]
[null,null,null,"=COLUMN(D350)          and use     =H335+2         for all cells below"]
[]
[]
["Text Formulas & Text","1.",null,"'0123456"]
[null,null,null,"=VALUE(C41)"]
[]
[null,null,null,"=C46&D46"]
[null,null,null,"=C46&\" \"&\"Us\""]
[null,null,null,"=G67&\", \"&C68       etc."]
[]
[null,null,null,"=C81&D81&E81     etc."]
[null,null,null,"=G81       etc."]
[null,null,null,"=VLOOKUP(\"2011Q13E\",$I$81:$J$85,2,FALSE)"]
[]
[null,"2.",null,"=LEFT(C116,1)          etc."]
[null,null,null,"=MID(C116,2,99)         etc."]
[]
[null,null,null,"=SUBSTITUTE(C137,\"-\",\"\")       etc."]
[]
[null,null,null,"=LEFT(C153,FIND(\",\",C153,1)-1)"]
[]
[null,"3.",null,"=LOWER(C176)"]
[null,null,null,"=UPPER(C179)"]
[null,null,null,"=PROPER(C182)"]
[null,null,null,"=TRIM(C186)        etc."]
[]
[null,"4.",null,"These aren't technically formulas."]
[]
[null,"5.",null,"=\"As of \"&TEXT(D272,\"mmmm dd, yyyy\")&\" the discount rate is \"&TEXT(D273,\"0.00%\")&\".\""]
[]
[]
["Date Formulas","1.",null,"Use Cell Formatting Menu (CTRL + 1)."]
[]
[null,"2.",null,"=TODAY()"]
[null,null,null,"=DAY(C66)"]
[null,null,null,"=MONTH(C66)"]
[null,null,null,"=YEAR(C66)"]
[null,null,null,"=DATE(C70,C69,C68)"]
[]
[null,null,null,"=DATE(YEAR(D83)+1,12,31)       etc."]
[]
[null,null,null,"=EOMONTH(F97,3)    In old versions of SBC, the automatic grading for this exercise does not work. It will not show up as \"complete\"."]
[null,null,null,"=\"Total Sales for \"&YEAR(C94)&\" totaled $100,001.\""]
[]
[null,null,null,"=WORKDAY($C$125,D126)            etc."]
[null,null,null,"1, 2, 3, etc."]
[]
[null,null,null,"=WEEKDAY(C138)"]
[]
[null,null,null,"=WEEKNUM(C145)"]
[]
[null,null,null,"=NETWORKDAYS(C152,C153)"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}