{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","Liste"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":7,"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":"Feuil1","index":0,"n_rows":35,"n_cols":21,"rows_kept":35,"cut":false,"hidden":false,"merged":[[29,3,29,4],[1,0,1,11],[17,7,17,8],[19,7,19,8],[2,0,3,0]]}
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[]
[null,"Cliquez sur l'intru !"]
[]
[9,{"$f":"VLOOKUP($A5,Intrus,2)","v":"Chinois"},null,{"$f":"VLOOKUP($A5,Intrus,3)","v":"Anglais"},null,{"$f":"VLOOKUP($A5,Intrus,4)","v":"Français"},null,{"$f":"VLOOKUP($A5,Intrus,5)","v":"Espagnol"},null,{"$f":"VLOOKUP($A5,Intrus,6)","v":"Croate"},null,null,{"$f":"VLOOKUP(A5,Intrus,7)","v":1},{"$f":"VLOOKUP(A5,Intrus,8)","v":"Pas d’origine sur le continent américain ou européen"},null,{"$f":"IF(M5=0,FALSE,IF(O5=M5,TRUE,FALSE))","v":false},{"$f":"IF(O5=0,0,IF(P5=TRUE,2,1))","v":0}]
[]
[66,{"$f":"VLOOKUP($A7,Intrus,2)","v":63},null,{"$f":"VLOOKUP($A7,Intrus,3)","v":96},null,{"$f":"VLOOKUP($A7,Intrus,4)","v":32},null,{"$f":"VLOOKUP($A7,Intrus,5)","v":24},null,{"$f":"VLOOKUP($A7,Intrus,6)","v":18},null,null,{"$f":"VLOOKUP(A7,Intrus,7)","v":3},{"$f":"VLOOKUP(A7,Intrus,8)","v":"N'est pas un multiple de 3"},null,{"$f":"IF(M7=0,FALSE,IF(O7=M7,TRUE,FALSE))","v":false},{"$f":"IF(O7=0,0,IF(P7=TRUE,2,1))","v":0}]
[]
[24,{"$f":"VLOOKUP($A9,Intrus,2)","v":"sapin"},null,{"$f":"VLOOKUP($A9,Intrus,3)","v":"mélèze"},null,{"$f":"VLOOKUP($A9,Intrus,4)","v":"bouleau"},null,{"$f":"VLOOKUP($A9,Intrus,5)","v":"if"},null,{"$f":"VLOOKUP($A9,Intrus,6)","v":"pin"},null,null,{"$f":"VLOOKUP(A9,Intrus,7)","v":3},{"$f":"VLOOKUP(A9,Intrus,8)","v":"N'est pas un conifère"},null,false,0]
[]
[4,{"$f":"VLOOKUP($A11,Intrus,2)","v":"hot-dog "},null,{"$f":"VLOOKUP($A11,Intrus,3)","v":"tarte aux pommes"},null,{"$f":"VLOOKUP($A11,Intrus,4)","v":"pâté chinois"},null,{"$f":"VLOOKUP($A11,Intrus,5)","v":"tourtière "},null,{"$f":"VLOOKUP($A11,Intrus,6)","v":"bolognaise"},null,null,{"$f":"VLOOKUP(A11,Intrus,7)","v":2},{"$f":"VLOOKUP(A11,Intrus,8)","v":"Pas de viande "},null,false,0]
[]
[25,{"$f":"VLOOKUP($A13,Intrus,2)","v":"myrtille"},null,{"$f":"VLOOKUP($A13,Intrus,3)","v":"groseille"},null,{"$f":"VLOOKUP($A13,Intrus,4)","v":"framboise"},null,{"$f":"VLOOKUP($A13,Intrus,5)","v":"pêche"},null,{"$f":"VLOOKUP($A13,Intrus,6)","v":"cassis"},null,null,{"$f":"VLOOKUP(A13,Intrus,7)","v":4},{"$f":"VLOOKUP(A13,Intrus,8)","v":"Fruit à noyau"},null,false,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(P5:P13,TRUE)","v":0},"total de cette série"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"ancien total"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S17:S18)","v":2},"choix pour corrigé"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,"Choix réponses",null,{"$f":"IF(P17=TRUE,2,0)","v":0}]
[null,null,null,null,null,null,null,{"$f":"P14","v":0},null,{"$f":"IF(H18<2,\"bonne réponse\",\"bonnes réponses\")","v":"bonne réponse"},null,"Total",{"$f":"P15+H18","v":0},null,null,false,"Choix Indices",null,{"$f":"IF(P18=TRUE,1,2)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Choix radio"]
[null,null,null,null,null,null,null,1,null,"e série",null,null,null,null,null,false,"Choix sans corriger"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H20>=INT(Liste!A2/5),\"Séries terminées !\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(P19=1,\"\",IF(A5>=Liste!A2-4,\"Séries terminées !\",\"\"))","v":""}]
[]
[]
[null,{"$f":"INT(Liste!A2/5) &\" séries\"","v":"16 séries"}]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(F30>0,\"Tirez une nouvelle série !\",\"\")","v":""}]
[null,null,null,{"$f":"IF(P19=2,\"A partir de la question :\",\"\")","v":""},null,0]
[]
[]
[]
[]
[null,"© Yvan Péguiron - avril 2010"]

{"sheet":"Liste","index":1,"n_rows":106,"n_cols":11,"rows_kept":106,"cut":false,"hidden":false,"merged":[[0,8,1,14],[0,7,1,7],[0,6,1,6],[0,0,0,3]]}
["La colonne A doit être numérotée de 1 à 100",null,null,null,null,null,"Intru","Indices","No ou info. pour tris personnels"]
[{"$f":"COUNTA(B3:B102)","v":82},"Nombre d'intrus"]
[1,"carotte","épinard","vinaigrette","casserole","orange",4,"Pas mangeable ",1,0]
[2,"auto","avion","trotinette","tracteur","cheval",2,"Seul qui vole",2,0]
[3,"écureuil","pie","singe","paresseux","panda",2,"Seul qui vole",3,0]
[4,"hot-dog ","tarte aux pommes","pâté chinois","tourtière ","bolognaise",2,"Pas de viande ",4,0]
[5,"clavier","mémoire","TV","souris ","écran",3,"Pas rapport avec ordinateur",5,0]
[6,"nounours","livre de conte","poupée","Lego ","train électrique",2,"Le seul qu’il faut lire ",6,0]
[7,"crayon","règle","effaceur","compas ","feutre",4,"Le seul qui a deux «branches» ",7,0]
[8,"dictionnaire","roman","Donjon dragon","BD ","bible",3,"Seul livre de jeu",8,0,"littérature"]
[9,"Chinois","Anglais","Français","Espagnol","Croate",1,"Pas d’origine sur le continent américain ou européen",9,0]
[10,"Bras","Nez","Langue","Jambe "," ",3,"N’a pas de poils  ",10,0]
[11,"timbre","étiquette","enveloppe","carte postale","postit",4,"Ne colle pas «automatiquement»",11,0]
[12,"chemise","manteau","robe","pantalon  ","polo",2,"Le seul qui se met par-dessus les autres  ",12,0]
[13,"bonnet","foulard","casquette","chaussette","cagoule",4,"Pas pour la tête",13,0]
[14,"trapèze","triangle","rectangle","parallélogramme","losange",2,"N'a pas 4 côtés",14,0,"math"]
[15,"dormir","sauter","grimper","marcher","courir",1,"Sans mouvement",15,0]
[16,"dompteur","clown","acteur","trapéziste","jongleur",3,"N'est pas du cirque",16,0]
[17,"chaussée","trottoir","piste cyclable","piéton","route",4,"Ne sert pas à la circulation",17,0]
[18,"écurie","remise","étable","bergerie","porcherie",2,"Pas destiné aux animaux",18,0]
[19,"armoire","table","buffet","commode","tiroire",2,"Ne peut rien contenir",19,0]
[20,"diamant","aluminium","zing","argent","plomb",1,"N'est pas un métal",20,0,"science"]
[21,"football","rugby","course","basketball","tennis",3,"Se pratique sans balle",21,1]
[22,"musique","voile","peinture","sculpture","gravure",2,"Seul sport",22,1]
[23,"charpentier","menuisier","ébéniste","bûcheron","serrurier",5,"Pas lié au bois",23,1]
[24,"sapin","mélèze","bouleau","if","pin",3,"N'est pas un conifère",24,1,"science"]
[25,"myrtille","groseille","framboise","pêche","cassis",4,"Fruit à noyau",25,1,"science"]
[26,"merle","pie","mouette","moineau","mésange",3,"Oiseau marin",26,1,"science"]
[27,"violon","flûte","guitare","contrebasse","harpe",2,"N'est pas à cordes",27,1,"musique"]
[28,"torche","flambeau","chandelle","foyer","lampion",4,"Ne se déplace pas",28,1]
[29,"examiner","questionner","répondre","interroger","demander",3,"Pas interrogatif",29,1]
[30,"quotidien","spécial","hebdomadaire","mensuel","biennal",2,"Pas périodique",30,1]
[31,"ahuri","stupéfait","étonné","perplexe","précis",5,"N'évoque pas la surprise",31,1]
[32,"isolé","veuf","célibataire","unique","jumeau",5,"N'est pas seul",32,1]
[33,"instruit","ignare","cultivé","savant","érudit",2,"Antonyme de la liste",33,1]
[34,"journal","feuille","revue","article","gazette",4,"Fait partie des autres",34,1]
[35,"hibou","bijou","caillou","verrou","genou",4,"prend s au pluriel en non x"]
[36,"haie","haricot","hachoir","harnais","hangar",1,"féminin"]
[37,"gibier","germe","gabarit","géométrie","gicleur",3,"Le \"g\" se prononce \"gue\" et non \"j\""]
[38,"heureux","déçu","jaloux","fatigué","amoureux",4,"N'est pas un sentiment"]
[39,"astreindre","contraindre","provoquer","forcer","obliger",3,"Pas imposant",35,1]
[40,"extraire","enlever","extirper","rétorquer","ôter",4,"Ne retire rien",36,1]
[41,"inquiétant","éprouvant","terrifiant","scandalisant","effrayant",4,"N'inspire pas la peur",37,1]
[42,"luire","étinceler","irradier","miroiter","brûler",3,"Ne scintille pas",38,1,"science"]
[43,"rouge ","vert","bleu","jaune"," ",4,"N'est pas une couleur primaire",39,1,"science"]
[44,"feuille","brochure","cahier","livre","opuscule",1,"Compose les autres",40,2]
[45,"Goncourt","Médicis","Fémina","Lépine","Renaudot",4,"N'est pas un prix littéraire",41,2,"littérature"]
[46,"Titicaca","Victoria","Elizabeth","Niagara","Iguassu",1,"N'est pas une chute d'eau",42,2,"géo"]
[47,"Rome","Berlin","Tokyo","New York","Bogota",4,"N'est pas une capitale",43,2,"géo"]
[48,"Asie","Australie","Afrique","Europe","Antarctique",2,"N'est pas un continent",44,2,"géo"]
[49,"Céline","Camus","Constant","Hugo","Colette",5,"Seule femme écrivain",45,2,"littérature"]
[50,"crème glacée","fromage","lait","beurre","yaourt",3,"Les autres sont faits à partir de lui !",46]
[51,"yeux pour voir","dents pour manger","oreilles pour entendre","main pour toucher","nez pour sentir",2,"Ne permet pas d'exercer nos 5 sens !",47]
[52,"écureuil","aigle","nuage","lune","avion",1,"Ne peut être vu dans le ciel",48]
[53,"tennis","football","escrime","golf","volley-ball",3,"N'est pas un sport de balle",49]
[54,"aluminium","magnésium","sodium","zinc","plomb",3,"Métal de densité 0.97, il flotte !",50,3,"science"]
[55,"verglas","givre","buée","neige","grésil",3,"Seul à l'état liquide",51,3,"science"]
[56,"pluie","brouillard","bruine","brume","vapeur",5,"Seul à l'état gazeux",52,3,"science"]
[57,"brume","verglas","brouillard","ondée","rosée",2,"Seul à l'état solide",53,3,"science"]
[58,"iceberg","glacier","banquise","mer du Groenland","calotte glaciaire",4,"Seul à l'état liquide",54,3,"science"]
[59,"34,2","342 / 10","34 + 2/10","3 + 42/10","30 + 42/10",4," = 7,2",55,3,"math"]
[60,"807 /10","8 + 70/100","80,7","80 + 7/10","80,70",2," = 8,7",56,3,"math"]
[61,"12.5 dam","125 dm","12500 mm","0,125 hm","1250 cm",1,"12,5 m = 1,25 dam !",57,3,"math"]
[62,90,110,130,150,180,5,"suite de 90 + 20 +20 +20…",58,3,"logique"]
[63,67,47,37,27,17,4,"27 n'est pas un nmbre premier",59,3,"math"]
[64,"giga","yotta","nano","kilo","méga",3,"Préfixe pour des valeurs plus petites que l'unité (10 ^ -9)",60,3,"math"]
[65,121,33,242,572,336,5,"N'est pas un multiple de 11",61,3,"math"]
[66,63,96,32,24,18,3,"N'est pas un multiple de 3",62,3,"math"]
[67,767,77,66,676,716,5,"Ne contient pas que des \"\"7\" et des \"6\"",63,3,"math"]
[68,43,35,71,26,80,1,"La somme des chiffres ne fait pas 8",64,3,"math"]
[69,"1.2347…","5.4327…","2.15156…","3.141592…","4.141592…",4,"Chiffre que tout le monde connaît (Pi)",65,3,"math"]
[70,16,58,36,25,49,2,"N'est pas un carré parfait",66,3,"math"]
[71,"Raymond Weil","Patek Philippe","Omega","Franck Muller","Audemars Piguet",3,"N'est pas une personne physique",67,4,"droit"]
[72,"famille","successions","réels","personnes","sociétés",5,"N'est pas un titre du code civil",68,4,"droit"]
[73,"tutelle","tutoriel","curatelle","conseil légal","interdiction",2,"N'est pas une mesure tutélaire",69,4,"droit"]
[74,"mauvaise gestion","prodigalité","ivrognerie","négligence","inconduite",4,"N'est pas une cause d'interdicition",70,4,"droit"]
[75,"nom","profession","parenté","origine","domicile",2,"N'est pas un élément de l'état civil d'une personne",71,4,"droit"]
[76,"CD","CO","CR","CC","CP",1,"N'est pas l'abréviation d'un code suisse",72,4,"droit"]
[77,"droit des personnes","droit de la famille","droit des successions","droit pénal","droit des obligations",4,"Fait partie du droit public et non privé",73,4,"droit"]
[78,"lois","jurisprudence","autorité","coutume","doctrine",3,"N'est pas une source du droit",74,5,"droit"]
[79,"législatif","financier","exécutif","judiciaire","constituant",2,"N'est pas un pouvoir politique",75,6,"droit"]
[80,"Conseil national","Grand Conseil","Tribunal cantonal","Conseil d'Etat","Peuple",1,"Est une autorité fédérale",76,7,"droit"]
[81,"impôt sur les chiens","imp. / bière","impôt foncier","Imp. / divertissements","Imp. / véhicules",2,"Est un impôt fédéral",77,8,"droit"]
[82,"droit de vote","droit d'éligibilité","droit de cité","droit d'élection","droit de référendum",3,"N'est pas un droit politique",78,9,"droit"]
[83,null,null,null,null,null,null,null,79]
[84,null,null,null,null,null,null,null,80]
[85,null,null,null,null,null,null,null,81]
[86,null,null,null,null,null,null,null,82]
[87,null,null,null,null,null,null,null,83]
[88,null,null,null,null,null,null,null,84]
[89,null,null,null,null,null,null,null,85]
[90,null,null,null,null,null,null,null,86]
[91,null,null,null,null,null,null,null,87]
[92,null,null,null,null,null,null,null,88]
[93,null,null,null,null,null,null,null,89]
[94,null,null,null,null,null,null,null,90]
[95,null,null,null,null,null,null,null,91]
[96,null,null,null,null,null,null,null,92]
[97,null,null,null,null,null,null,null,93]
[98,null,null,null,null,null,null,null,94]
[99,null,null,null,null,null,null,null,95]
[100,null,null,null,null,null,null,null,96]
[100,null,null,null,null,null,null,null,97]
[98,null,null,null,null,null,null,null,98]
[99,null,null,null,null,null,null,null,99]
[100,null,null,null,null,null,null,null,100]