{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["N3_Practice_Material"],"not_rendered":{"charts":1,"images":4,"macros":1,"external_links":0,"defined_names":1,"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":"N3_Practice_Material","index":0,"n_rows":151,"n_cols":72,"rows_kept":151,"cut":false,"hidden":false,"merged":[[87,4,87,9],[87,10,87,15],[87,16,87,21],[87,22,87,27],[86,4,86,9],[86,10,86,15],[86,16,86,21],[86,22,86,27],[55,11,55,17],[56,11,56,17],[54,11,54,17],[54,23,54,29],[55,23,55,29],[56,23,56,29],[40,18,40,20],[46,19,46,21],[32,17,32,22],[32,23,32,26],[29,23,29,26],[30,17,30,22],[30,23,30,26],[31,17,31,22],[31,23,31,26],[29,17,29,22],[18,17,18,22],[18,23,18,26],[23,17,23,22],[23,23,23,26],[24,17,24,22],[24,23,24,26],[19,17,19,22],[20,17,20,22],[21,17,21,22],[22,17,22,22],[19,23,19,26],[20,23,20,26],[21,23,21,26],[22,23,22,26],[1,1,5,42],[7,24,7,29],[8,24,8,29],[9,24,9,29],[7,30,7,33],[8,30,8,33],[9,30,9,33],[11,32,11,37],[11,38,11,41],[12,32,12,37],[12,38,12,41],[13,32,13,37],[13,38,13,41],[58,23,58,26],[58,27,58,29],[67,11,67,17],[67,23,67,29],[57,23,57,29],[96,15,96,20],[96,21,96,26],[99,2,99,22],[68,11,68,17],[68,23,68,29],[69,11,69,17],[69,23,69,29],[70,23,70,29],[84,4,84,9],[84,10,84,15],[84,16,84,21],[84,22,84,27],[84,28,84,33],[86,28,86,33],[85,4,85,9],[85,10,85,15],[95,15,95,20],[92,15,92,20],[92,21,92,26],[93,15,93,20],[93,21,93,26],[94,15,94,20],[94,21,94,26],[147,28,147,29],[150,25,150,29],[127,25,127,29],[71,23,71,26],[71,27,71,29],[95,21,95,26],[87,28,87,33],[124,25,124,26],[85,16,85,21],[85,22,85,27],[85,28,85,33]]}
[]
[null,"N3 Lifeskills - Practice Assessment                                                                                                                                                                   Created by Mr.Lafferty@mathsrevision.com "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,{"$f":"IF(AZ6=1,\"weekly\",\"monthly\")","v":"monthly"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BA6","v":"monthly"},{"$f":"ROUND(RAND()*(800-400)+400,1)","v":664.6}]
[null,null,null,{"$f":"\"Q1. (a)    Joseph's \"&AZ7&\" wage-slip  is shown opposite.\"","v":"Q1. (a)    Joseph's monthly wage-slip  is shown opposite."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gross Pay",null,null,null,null,null,{"$f":"AZ8","v":2658.4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AZ6=2,BA8,BA7)","v":2658.4},{"$f":"4*BA7","v":2658.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deductions",null,null,null,null,null,{"$f":"AZ9","v":850.7},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(ROUND(RAND()*(0.35-0.27)+0.27,2)*AZ8,1)","v":850.7}]
[null,null,null,null,"Calculate his NET pay.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NET Pay",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ8-AZ9","v":1807.7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AZ6=1,\"week\",\"month\")","v":"month"}]
[null,null,null,{"$f":"\"     (b)    Joseph's sells cars and receives a bonus of £\"&AZ12&\" for every car he sells.\"","v":"     (b)    Joseph's sells cars and receives a bonus of £332 for every car he sells."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BONUS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AZ8/(BA12+1),0)","v":332},{"$f":"ROUND(RAND()*(9-4)+4,0)","v":7}]
[null,null,null,null,null,{"$f":"\"This \"&AZ11&\" he sells \"&BA12&\" cars.\"","v":"This month he sells 7 cars."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Tax @ \"&AZ13&\"%\"","v":"Tax @ 20%"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(2-1)+1,0)*10","v":20},{"$f":"BA12*AZ12","v":2324}]
[null,null,null,null,null,{"$f":"\"He must pay tax on his bonus at a rate of \"&AZ13&\"%.   Fill in the bonus part of his wage-slip.\"","v":"He must pay tax on his bonus at a rate of 20%.   Fill in the bonus part of his wage-slip."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Actual Bonus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ13/100*BA13","v":464.8}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BA13-AZ14","v":1859.2}]
[]
[null,null,null,{"$f":"\"Q2.    John's monthly expenditure is shown below. Calculate his total expenditure.\"","v":"Q2.    John's monthly expenditure is shown below. Calculate his total expenditure."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(BB17=1,\"Yes\",\"No\")","v":"No"},{"$f":"ROUND(RAND()*(18-7.5)+7.5,1)","v":10},{"$f":"ROUND(RAND()*(1-0)+0,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expenditure",null,null,null,null,null,"Amount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Food",null,null,null,null,null,{"$f":"AZ20","v":349.16},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(450-300)+300,2)","v":349.16}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mortgage",null,null,null,null,null,{"$f":"AZ21","v":502.78},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(600-290)+290,2)","v":502.78}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Car",null,null,null,null,null,160,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(200-110)+110,0)","v":160}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Council Tax",null,null,null,null,null,193.32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(200-90)+90,2)","v":193.32}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Utilities",null,null,null,null,null,88.18,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(190-80)+80,2)","v":88.18}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Expenditure",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AZ20:AZ24)","v":1293.44}]
[]
[]
[null,null,null,null,{"$f":"\"If John's total income (including bonuses + overtime ) is £\"&AZ28&\".   Fill in the table below to show how much he saves each month.\"","v":"If John's total income (including bonuses + overtime ) is £1944.04.   Fill in the table below to show how much he saves each month."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AZ23:AZ27)+ROUND(RAND()*(500-100)+100,1)","v":1944.04}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ25","v":1293.44}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expenditure",null,null,null,null,null,"Amount",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ28-AZ29","v":650.59999999999991}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Income"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Expenditure"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Savings"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(2-1)+1,0)","v":2},null,{"$f":"ROUND(RAND()*(5-1)+1,0)","v":3},1,"Spain"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-3)+3,0)","v":8},{"$f":"IF(BA35=1,7,14)","v":14},null,null,2,"Greece"]
[null,null,null,{"$f":"\"Q4.    Stuart wants to go on a \"&BA36&\" night holiday to \"&BE40&\". The holiday costs £\"&AZ38&\".\"","v":"Q4.    Stuart wants to go on a 14 night holiday to America. The holiday costs £1960."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(299-81)+81,0)","v":245},null,null,null,3,"America"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ36*AZ37","v":1960},null,null,null,4,"France"]
[null,null,null,null,{"$f":"\"He would like to go on holiday in \"&AZ36&\" months.\"","v":"He would like to go on holiday in 8 months."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Italy"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(BC35,BD35:BD39,BE35:BE39)","v":"America"}]
[null,null,null,null,"How much  will he need to save each month ?"]
[]
[]
[]
[null,null,null,{"$f":"\"Q5.    Linda saves £\"&AZ46&\" a month for her holiday.\"","v":"Q5.    Linda saves £58 a month for her holiday."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-3)+3,0)","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(99-31)+31,0)","v":58}]
[null,null,null,null,null,{"$f":"\"How much will she have saved in \"&AZ45&\" months ?\"","v":"How much will she have saved in 7 months ?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ45*AZ46","v":406}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(2-1)+1,0)","v":1},{"$f":"ROUND(RAND()*(7-4)+4,1)","v":6.1}]
[null,null,null,{"$f":"\"Q6.    Laura needs some sun cream for her holidays.\"","v":"Q6.    Laura needs some sun cream for her holidays."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(2-1)+1,0)*10","v":20}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AZ50-AZ51/100*AZ50,2)","v":4.88}]
[null,null,null,null,null,"She has two options to be from",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AY50=1,AZ52-ROUND(RAND()*(0.2-0.01)+0.01,2),AZ52+ROUND(RAND()*(0.2-0.01)+0.01,2))","v":4.8}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Deal 1",null,null,null,null,null,null,null,null,null,null,null,"Deal 2"]
[null,null,null,null,null,null,null,null,null,null,null,"Tanget Sun Cream",null,null,null,null,null,null,null,null,null,null,null,"Brown Sun Cream"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ53","v":4.8},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Normal Price £\"&TEXT(AZ50,\"0.00\")","v":"Normal Price £6.10"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Discount \"&AZ51&\"%\"","v":"Discount 20%"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sale Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AY50","v":1}]
[null,null,null,null,null,"Which Deal is better ?",null,null,null,null,null,null,null,null,null,"( Enter 1 or 2 )"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(2-1)+1,0)","v":2},{"$f":"ROUND(RAND()*(30-12)+12,1)","v":25.2}]
[null,null,null,{"$f":"\"Q7.    Sean buys a pair of shorts  for his holiday.\"","v":"Q7.    Sean buys a pair of shorts  for his holiday."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(2*ROUND(RAND()*(1-0)+0,0)+1)*25","v":25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(AZ63-AZ64/100*AZ63,2)","v":18.899999999999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AY63=1,AZ65-ROUND(RAND()*(0.2-0.01)+0.01,2),AZ65+ROUND(RAND()*(0.2-0.01)+0.01,2))","v":19.09}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Shop 1",null,null,null,null,null,null,null,null,null,null,null,"Shop 2"]
[null,null,null,null,null,null,null,null,null,null,null,"Pattern Shorts",null,null,null,null,null,null,null,null,null,null,null,"Pattern Shorts"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ66","v":19.09},null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Normal Price £\"&TEXT(AZ63,\"0.00\")","v":"Normal Price £25.20"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Discount \"&AZ64&\"%\"","v":"Discount 25%"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sale Price"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AY63","v":2}]
[null,null,null,null,null,"Which shop offers the cheaper deal ?",null,null,null,null,null,null,null,null,null,null,null,null,null,"( Enter 1 or 2 )"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(3-1)+1,0)","v":2},1,"Sunshine"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AW76=3,1,AW76+1)","v":3},2,"beach"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AW77=3,1,AW77+1)","v":1},3,"Waterpark"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(AW76,AX76:AX78,AY76:AY78)","v":"beach"}]
[null,null,null,{"$f":"\"Q8.    Sean researches why people go to Crete on holiday.\"","v":"Q8.    Sean researches why people go to Crete on holiday."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(AW77,AX76:AX78,AY76:AY78)","v":"Waterpark"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(AW78,AX76:AX78,AY76:AY78)","v":"Sunshine"}]
[]
[null,null,"The results are shown in the table below:"]
[]
[null,null,null,null,{"$f":"BB93","v":"beach"},null,null,null,null,null,{"$f":"BH93","v":"Waterpark"},null,null,null,null,null,{"$f":"BE93","v":"beach"},null,null,null,null,null,{"$f":"BA93","v":"beach"},null,null,null,null,null,{"$f":"AW93","v":"beach"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(8-1)+1,0)","v":6},1,{"$f":"$AY$79","v":"beach"},{"$f":"$AY$79","v":"beach"},"beach","beach","beach","beach","beach","beach","beach","beach","beach",{"$f":"$AY$80","v":"Waterpark"},{"$f":"$AY$80","v":"Waterpark"},"Waterpark","Waterpark","Waterpark","Waterpark","Waterpark",{"$f":"$AY$81","v":"Sunshine"},{"$f":"$AY$81","v":"Sunshine"},null,11,7,2]
[null,null,null,null,{"$f":"BO93","v":"Sunshine"},null,null,null,null,null,{"$f":"BK93","v":"Waterpark"},null,null,null,null,null,{"$f":"BF93","v":"Waterpark"},null,null,null,null,null,{"$f":"BL93","v":"Sunshine"},null,null,null,null,null,{"$f":"BI93","v":"Waterpark"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"beach","beach","beach","beach","beach","beach","beach","beach","beach",{"$f":"$AY$80","v":"Waterpark"},{"$f":"$AY$80","v":"Waterpark"},"Waterpark","Waterpark","Waterpark","Waterpark",{"$f":"$AY$81","v":"Sunshine"},{"$f":"$AY$81","v":"Sunshine"},"Sunshine","Sunshine","Sunshine",null,9,6,5]
[null,null,null,null,{"$f":"BN93","v":"Sunshine"},null,null,null,null,null,{"$f":"BD93","v":"beach"},null,null,null,null,null,{"$f":"BG93","v":"Waterpark"},null,null,null,null,null,{"$f":"AY93","v":"beach"},null,null,null,null,null,{"$f":"AX93","v":"beach"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"beach","beach","beach","beach","beach","beach","beach","beach","beach","beach",{"$f":"$AY$80","v":"Waterpark"},"Waterpark","Waterpark","Waterpark","Waterpark","Waterpark","Waterpark",{"$f":"$AY$81","v":"Sunshine"},"Sunshine","Sunshine",null,10,7,3]
[null,null,null,null,{"$f":"BM93","v":"Sunshine"},null,null,null,null,null,{"$f":"BJ93","v":"Waterpark"},null,null,null,null,null,{"$f":"BC93","v":"beach"},null,null,null,null,null,{"$f":"AZ93","v":"beach"},null,null,null,null,null,{"$f":"AV93","v":"beach"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"beach","beach","beach","beach","beach","beach","beach","beach",{"$f":"$AY$80","v":"Waterpark"},{"$f":"$AY$80","v":"Waterpark"},"Waterpark","Waterpark","Waterpark","Waterpark","Waterpark",{"$f":"$AY$81","v":"Sunshine"},{"$f":"$AY$81","v":"Sunshine"},"Sunshine","Sunshine","Sunshine",null,8,7,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"beach","beach","beach","beach","beach","beach","beach","beach","beach","Waterpark","Waterpark","Waterpark","Waterpark","Waterpark","Waterpark","Waterpark",{"$f":"$AY$81","v":"Sunshine"},"Sunshine","Sunshine","Sunshine",null,9,7,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"beach","beach","beach","beach","beach","beach","beach","beach","beach","beach",{"$f":"$AY$80","v":"Waterpark"},"Waterpark","Waterpark","Waterpark","Waterpark","Waterpark",{"$f":"$AY$81","v":"Sunshine"},"Sunshine","Sunshine","Sunshine",null,10,6,4]
[null,null,"(a)   Summarise the results in a frequency table.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"beach","beach","beach","beach","beach","beach","beach","beach","beach","beach","beach","beach",{"$f":"$AY$80","v":"Waterpark"},"Waterpark","Waterpark","Waterpark","Waterpark",{"$f":"$AY$81","v":"Sunshine"},"Sunshine","Sunshine",null,12,5,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"beach","beach","beach","beach","beach","beach","beach","beach","beach","beach","beach",{"$f":"$AY$80","v":"Waterpark"},{"$f":"$AY$80","v":"Waterpark"},"Waterpark","Waterpark","Waterpark","Waterpark",{"$f":"$AY$81","v":"Sunshine"},"Sunshine","Sunshine",null,11,6,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Main Reason",null,null,null,null,null,"Frequency",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP($AT$85,$AU$85:$AU$92,AV85:AV92)","v":"beach"},{"$f":"LOOKUP($AT$85,$AU$85:$AU$92,AW85:AW92)","v":"beach"},"beach","beach","beach","beach","beach","beach","beach","beach","Waterpark","Waterpark","Waterpark","Waterpark","Waterpark","Waterpark","Sunshine","Sunshine","Sunshine","Sunshine",null,{"$f":"LOOKUP($AT$85,$AU$85:$AU$92,BQ85:BQ92)","v":10},{"$f":"LOOKUP($AT$85,$AU$85:$AU$92,BR85:BR92)","v":6},4,{"$f":"SUM(BQ93:BS93)","v":20}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AY79","v":"beach"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AY80","v":"Waterpark"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AY81","v":"Sunshine"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,"(b)   Construct a bar graph to display the data."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AY79","v":"beach"},{"$f":"BQ93","v":10}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AY80","v":"Waterpark"},{"$f":"BR93","v":6}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AY81","v":"Sunshine"},{"$f":"BS93","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ103-AZ105","v":6}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"\"  (c)  How many more people chose the \"&AY103&\" than the \"&AY105&\".\"","v":"  (c)  How many more people chose the beach than the Sunshine."}]
[]
[]
[null,null,{"$f":"\"  (d)  What do most people like to do in Crete ?\"","v":"  (d)  What do most people like to do in Crete ?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"( Enter beach , waterpark or sunshine )"]
[]
[]
[]
[]
[null,null,null,{"$f":"\"Q9.    Tam McAdam goes to a restaurant  in Crete for  a meal.   Below is a summary of food categories he can chose from.\"","v":"Q9.    Tam McAdam goes to a restaurant  in Crete for  a meal.   Below is a summary of food categories he can chose from."}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(2-1)+1,0)","v":2},{"$f":"ROUND(RAND()*(3-1)+1,0)","v":3},{"$f":"IF(BA135=1,BA135+1,IF(BA135=2,BA135+1,1))","v":1},{"$f":"IF(BB135=1,BB135+1,IF(BB135=2,BB135+1,1))","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AY136","v":5},"Different starters ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(AY136:AY141)","v":13},{"$f":"ROUND(RAND()*(8-5)+5,0)","v":5},"Starters"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(AY136:AY141)","v":3},{"$f":"ROUND(RAND()*(9-5)+5,0)","v":7},{"$f":"IF(BA135=1,\"Pasta\",IF(BA135=2,\"Pork\",\"Vegetarian\"))","v":"Vegetarian"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AY137","v":7},{"$f":"AZ137&\" dishes\"","v":"Vegetarian dishes"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(16-10)+10,0)","v":13},{"$f":"IF(AZ135=1,\"Chicken\",\"Beef\")","v":"Beef"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(9-6)+6,0)","v":7},{"$f":"IF(AZ135=2,\"Chicken\",\"Beef\")","v":"Chicken"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AY138","v":13},{"$f":"AZ138&\" dishes\"","v":"Beef dishes"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(8-5)+5,0)","v":6},{"$f":"IF(BB135=1,\"Pasta\",IF(BB135=2,\"Pork\",\"Vegetarian\"))","v":"Pasta"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(RAND()*(4-1)+1,0)","v":3},{"$f":"IF(BC135=1,\"Pasta\",IF(BC135=2,\"Pork\",\"Vegetarian\"))","v":"Pork"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AY139","v":7},{"$f":"AZ139&\" dishes\"","v":"Chicken dishes"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(AY136:AY141)","v":13}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AY140","v":6},{"$f":"AZ140&\" dishes\"","v":"Pasta dishes"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MIN(AY136:AY141)","v":3}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AY141","v":3},{"$f":"AZ141&\" dishes\"","v":"Pork dishes"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AY143-AY144","v":10}]
[]
[null,null,null,null,null,{"$f":"\"(a)   How many more types of \"&T140&\" are there than \"&T146&\" ?\"","v":"(a)   How many more types of Beef dishes are there than Pork dishes ?"}]
[]
[]
[null,null,null,null,null,{"$f":"\"(a)   Which category has the least choice on the menu ?\"","v":"(a)   Which category has the least choice on the menu ?"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AZ141","v":"Pork"}]