{"text_format":"1","workbook":"xlsx","n_sheets":30,"sheets":["Sommaire","Applic1","Applic1_corrigé","Applic2_consignes","Applic2","Applic2_corrigé","Applic3","Applic3_corrigé","Applic4","Applic4_corrigé","Filtre1_corrigé","Filtre2_corrigé","Filtre3_corrigé","Filtre4_corrigé","FiltreElab1_corrigé","FiltreElab2_corrigé","FiltreElab3_corrigé","FiltreElab4_corrigé","FiltreElab5_corrigé","FiltreElab6_corrigé","Sous-Totaux1_corrigé","Sous-Totaux2_corrigé","Sous-Totaux3_corrigé","Fonctions classiques_corrigé","TCD1_corrigé","TCD2_corrigé","TCD3_corrigé","TCD4_corrigé","TCD5_corrigé","TCD6_corrigé"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":31,"comments":1,"pivot_tables":6},"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":"Sommaire","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Applic1","Références absolues, RECHERCHEV, SI",null,"Ci-contre, vous pouvez utiliser les liens hypertextes de façon à atteindre une application selon le thème précisé en colonne B."]
[null,null,null,null,"Sur chaque feuille est présenté l'exercice à réaliser. Un bouton 'Help' permet d'afficher la feuille contenant le corrigé."]
[null,"Applic2","SI, SI.CONDITIONS, RECHERCHEV",null,"Avant de commencer, masquer tous les corrigés en utilisant le bouton de la barre d'outils 'Employés'"]
[]
[null,"Applic3","RECHERCHEV par valeur proche",null,"Lors de la réalisation des exercices, nous effectuerons d'abord tous les calculs avant d'afficher le corrigé pour voir y voir les résolutions"]
[]
[null,"Applic4","RECHERCHEV, limites et solutions"]
[null,null,"EQUIV, INDEX"]
[null,null,"RECHERCHEX"]

{"sheet":"Applic1","index":1,"n_rows":23,"n_cols":12,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Titre","Référence de l'auteur","Prix","Prix avec réduction 1","Prix avec réduction 2","Nom de l'auteur","Prénom de l'auteur",null,null,null,"Retour sommaire"]
["Cartes sur table",13,10]
["Drame en trois actes",13,12,null,null,null,null,null,"1) Calculez le prix avec réduction (= prix - taux * prix ). Utilisez le taux se trouvant dans la cellule ci-dessous"]
["Contes",2,12]
["Dix petits nègres",13,15,null,null,null,null,null,"Taux : ",0.1]
["Café turc",5,12]
["Poétique",4,18,null,null,null,null,null,"2) Calculez un prix avec une réduction supplémentaire de 5% pour les livres qui coûtent 15 € ou plus"]
["La Main froide",12,12]
["Cinq petits cochons",13,12,null,null,null,null,null,"3) A partir de la liste ci-dessous, complétez les noms et prénoms des auteurs"]
["Conan Lord",12,17]
["La mort l'aime chaud",11,12,null,null,null,null,null,null,"Id_Auteur","Nom","Prénom"]
["Le Spleen de Paris",8,15,null,null,null,null,null,null,1,"Alain-Fournier",""]
["La Case de l'oncle Tom",9,10,null,null,null,null,null,null,2,"Andersen","Hans Christian"]
["Jeux de glaces",13,15,null,null,null,null,null,null,4,"Aristote",""]
["Rhétorique",4,18,null,null,null,null,null,null,5,"Arjouni","Jakob"]
["L'étameur des morts",6,12,null,null,null,null,null,null,6,"Arnaud","Georges J."]
["A.B.C. contre Poirot",13,12,null,null,null,null,null,null,7,"Balzac (de)","Honoré"]
["le mystérieux Mr Quinn",13,15,null,null,null,null,null,null,8,"Baudelaire","Charles"]
["L'heure zéro",13,15,null,null,null,null,null,null,9,"Beecher-Stowe","Harriet"]
["La Fille de la nuit",12,10,null,null,null,null,null,null,10,"Boccace","Giovanni"]
[null,null,null,null,null,null,null,null,null,11,"Box","Edgar"]
[null,null,null,null,null,null,null,null,null,12,"Brussolo","Serge"]
[null,null,null,null,null,null,null,null,null,13,"Christie","Agatha"]

{"sheet":"Applic1_corrigé","index":2,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["Titre","Référence de l'auteur","Prix","Prix avec réduction 1","Prix avec réduction 2","Nom de l'auteur","Prénom de l'auteur"]
["Cartes sur table",13,10,{"$f":"C2-$J$5*C2","v":9},{"$f":"IF(C2>=15,D2-5%*D2,D2)","v":9},{"$f":"VLOOKUP(B2,$J$20:$L$31,2)","v":"Christie"},{"$f":"VLOOKUP(B2,$J$19:$L$31,3)","v":"Agatha"}]
["Drame en trois actes",13,12,{"$f":"C3-$J$5*C3","v":10.8},{"$f":"IF(C3>=15,D3-5%*D3,D3)","v":10.8},{"$f":"VLOOKUP(B3,$J$20:$L$31,2)","v":"Christie"},{"$f":"VLOOKUP(B3,$J$19:$L$31,3)","v":"Agatha"},null,"1) Calculez le prix avec réduction (= prix - taux * prix ). Utilisez le taux se trouvant dans la cellule ci-dessous"]
["Contes",2,12,10.8,10.8,"Andersen","Hans Christian"]
["Dix petits nègres",13,15,13.5,12.824999999999999,"Christie","Agatha",null,"Taux : ",0.1]
["Café turc",5,12,10.8,10.8,"Arjouni","Jakob"]
["Poétique",4,18,16.2,15.389999999999999,"Aristote","",null,"NB : Attention, la cellule du taux doit être en référence absolue ($J$5)"]
["La Main froide",12,12,10.8,10.8,"Brussolo","Serge"]
["Cinq petits cochons",13,12,10.8,10.8,"Christie","Agatha",null,"2) Calculez un prix avec une réduction supplémentaire de 5% pour les livres qui coûtent 15 € ou plus"]
["Conan Lord",12,17,15.3,14.535,"Brussolo","Serge"]
["La mort l'aime chaud",11,12,10.8,10.8,"Box","Edgar",null,null,"SI Prix >= 15"]
["Le Spleen de Paris",8,15,13.5,12.824999999999999,"Baudelaire","Charles",null,null,"ALORS PrixRéd1 - 5% * PrixRéd1"]
["La Case de l'oncle Tom",9,10,9,9,"Beecher-Stowe","Harriet",null,null,"SINON PrixRéd1"]
["Jeux de glaces",13,15,13.5,12.824999999999999,"Christie","Agatha"]
["Rhétorique",4,18,16.2,15.389999999999999,"Aristote","",null,"3) A partir de la liste ci-dessous, complétez les noms et prénoms des auteurs"]
["L'étameur des morts",6,12,10.8,10.8,"Arnaud","Georges J."]
["A.B.C. contre Poirot",13,12,10.8,10.8,"Christie","Agatha",null,"NB : Attention, le tableau des données 'Auteurs'doit être en référence absolue ($J$20:$L$31)"]
["le mystérieux Mr Quinn",13,15,13.5,12.824999999999999,"Christie","Agatha"]
["L'heure zéro",13,15,13.5,12.824999999999999,"Christie","Agatha",null,null,"Id_Auteur","Nom","Prénom"]
["La Fille de la nuit",12,10,9,9,"Brussolo","Serge",null,null,1,"Alain-Fournier",""]
[null,null,null,null,null,null,null,null,null,2,"Andersen","Hans Christian"]
[null,null,null,null,null,null,null,null,null,4,"Aristote",""]
[null,null,null,null,null,null,null,null,null,5,"Arjouni","Jakob"]
[null,null,null,null,null,null,null,null,null,6,"Arnaud","Georges J."]
[null,null,null,null,null,null,null,null,null,7,"Balzac (de)","Honoré"]
[null,null,null,null,null,null,null,null,null,8,"Baudelaire","Charles"]
[null,null,null,null,null,null,null,null,null,9,"Beecher-Stowe","Harriet"]
[null,null,null,null,null,null,null,null,null,10,"Boccace","Giovanni"]
[null,null,null,null,null,null,null,null,null,11,"Box","Edgar"]
[null,null,null,null,null,null,null,null,null,12,"Brussolo","Serge"]
[null,null,null,null,null,null,null,null,null,13,"Christie","Agatha"]

{"sheet":"Applic2_consignes","index":3,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
[null,"1) Ecrire 'Madame' ou 'Monsieur' selon le sexe de la personne "]
[]
[null,"NB : plusieurs fonctions seront utilisées pour réaliser l'exercice"]
[]
[]
[null,"2) Ecrire 'Madame', 'Mademoiselle' ou 'Monsieur' selon le sexe et l'état civil"]
[]
[null,"3) Utiliser la liste suivante de façon à obtenir la ville qui correspond au code postal de la personne"]
[]
[null,null,"CP","Ville"]
[null,null,1030,"Schaerbeek"]
[null,null,1000,"Bruxelles"]
[null,null,1070,"Anderlecht"]
[null,null,1050,"Ixelles"]
[null,null,1060,"Saint-Gilles"]
[null,null,1040,"Etterbeek"]
[]
[null,"4) Calculer les âges des employés"]
[]
[null,"5) Dans la colonne 'Catégorie', écrire la catégorie des employés qui dépend de l'âge selon les indications suivantes :"]
[]
[null,null,"Age","Catégorie"]
[null,null,"<25","A"]
[null,null,">=25 et <35","B"]
[null,null,">=35 et <45","C"]
[null,null,">=45 et <55","D"]
[null,null,">=55","E"]
[]
[null,"6) Calculer le salaire qui dépend du sservice dans lequel travaille l'employé"]
[]
[null,null,"Services","Salaire minimum"]
[null,null,"Direction",2500]
[null,null,"Informatique",1900]
[null,null,"Secrétariat",1700]
[null,null,"Personnel",1600]

{"sheet":"Applic2","index":4,"n_rows":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Nom","Prénom","Sexe","Mme, Mr\n(*)\n(SI)","Mme, Mr\n(*)\n(SI.CONDITIONS)","Mme, Mr\n(*)\n(RECHERCHEV)","Etat civil","Mme, Mlle, Mr (**)\n(SI)","Mme, Mlle, Mr (**)\n(SI.Conditions)","CP","Ville","Date de naissance","Age","Catégorie\n(SI)\n(***)","Catégorie\n(SI.Conditions)\n(***)","Catégorie\n(RechercheV)\n(CF Applic3)","Services","Salaires",null,"Retour sommaire"]
["Bistrot","Alonso","m",null,null,null,"Marié(e)",null,null,1030,null,"1966-01-17",null,null,null,null,"Informatique"]
["Bijoba","Jo","m",null,null,null,"Marié(e)",null,null,1000,null,"1996-03-15",null,null,null,null,"Direction"]
["Covert","Harry","m",null,null,null,"Divorcé(e)",null,null,1000,null,"2000-02-10",null,null,null,null,"Personnel"]
["Culaire","Laury","m",null,null,null,"Marié(e)",null,null,1030,null,"1965-05-05",null,null,null,null,"Personnel"]
["Deuf","John","m",null,null,null,"Célibataire",null,null,1070,null,"1993-09-08",null,null,null,null,"Informatique"]
["Foupasune","Jean","m",null,null,null,"Célibataire",null,null,1070,null,"1975-08-07",null,null,null,null,"Personnel"]
["Lairbon","Oussama","m",null,null,null,"Marié(e)",null,null,1030,null,"1983-02-08",null,null,null,null,"Personnel"]
["Menvussa","Gérard","m",null,null,null,"Célibataire",null,null,1050,null,"1970-12-04",null,null,null,null,"Informatique"]
["Lalalalalalala","Starsky","m",null,null,null,"Célibataire",null,null,1060,null,"1955-07-08",null,null,null,null,"Personnel"]
["Lalalalalalala","Hutch","m",null,null,null,"Divorcé(e)",null,null,1050,null,"1952-10-07",null,null,null,null,"Direction"]
["Cléssoulaporte","Djamila","f",null,null,null,"Marié(e)",null,null,1050,null,"1989-09-07",null,null,null,null,"Personnel"]
["Noux","Marion","f",null,null,null,"Divorcé(e)",null,null,1050,null,"1978-12-30",null,null,null,null,"Secrétariat"]
["Ouzi","Jacques","m",null,null,null,"Célibataire",null,null,1000,null,"1969-02-28",null,null,null,null,"Personnel"]
["Stiké","Sophie","f",null,null,null,"Divorcé(e)",null,null,1070,null,"1998-04-04",null,null,null,null,"Secrétariat"]
["Tare","Guy","m",null,null,null,"Divorcé(e)",null,null,1070,null,"1960-08-07",null,null,null,null,"Informatique"]
["Vaisselle","Aude","f",null,null,null,"Marié(e)",null,null,1070,null,"1966-06-06",null,null,null,null,"Secrétariat"]
["Zetofrais","Mélanie","f",null,null,null,"Célibataire",null,null,1070,null,"1978-11-25",null,null,null,null,"Direction"]
["Touille","Sasha","m",null,null,null,"Célibataire",null,null,1070,null,"2000-10-30",null,null,null,null,"Personnel"]
["Proviste","Alain","m",null,null,null,"Marié(e)",null,null,1030,null,"1959-09-09",null,null,null,null,"Personnel"]
["Peulaporte","Firmin","m",null,null,null,"Divorcé(e)",null,null,1040,null,"1993-07-01",null,null,null,null,"Informatique"]
["Unetitlaine","Jérémy","m",null,null,null,"Marié(e)",null,null,1030,null,"1983-06-09",null,null,null,null,"Informatique"]
[]
["NB : les consignes sont précisées sur la feuille précédente."]

{"sheet":"Applic2_corrigé","index":5,"n_rows":73,"n_cols":18,"rows_kept":73,"cut":false,"hidden":true,"merged":[]}
["Nom","Prénom","Sexe","Mme, Mr\n(*)\n(SI)","Mme, Mr\n(*)\n(SI.CONDITIONS)","Mme, Mr\n(*)\n(RECHERCHEV)","Etat civil","Mme, Mlle, Mr (**)\n(SI)","Mme, Mlle, Mr (**)\n(SI.Conditions)","CP","Ville","Date de naissance","Age","Catégorie\n(SI)\n(***)","Catégorie\n(SI.Conditions)\n(***)","Catégorie\n(RechercheV)\n(CF Applic3)","Services","Salaires"]
["Bistrot","Alonso","m",{"$f":"IF(C2=\"f\",\"Madame\",\"Monsieur\")","v":"Monsieur"},{"$f":"_xlfn.IFS(C2=\"f\",\"Madame\",C2=\"m\",\"Monsieur\")","v":"Monsieur"},{"$f":"VLOOKUP(C2,$C$38:$D$39,2,FALSE)","v":"Monsieur"},"Marié(e)",{"$f":"IF(AND(C2=\"f\",OR(G2=\"Marié(e)\",G2=\"Divorcé(e)\")),\"Madame\",IF(AND(C2=\"f\",G2=\"Célibataire\"),\"Mademoiselle\",\"Monsieur\"))","v":"Monsieur"},{"$f":"_xlfn.IFS(C2=\"m\",\"Monsieur\",G2=\"Célibataire\",\"Mademoiselle\",C2<>\"m\",\"Madame\")","v":"Monsieur"},1030,{"$f":"VLOOKUP(J2,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Schaerbeek"},"1966-01-17",{"$f":"DATEDIF(L2,TODAY(),\"y\")","v":57},{"$f":"IF(M2<25,\"A\",IF(M2<35,\"B\",IF(M2<45,\"C\",IF(M2<55,\"D\",\"E\"))))","v":"E"},{"$f":"_xlfn.IFS(M2<25,\"A\",M2<35,\"B\",M2<45,\"C\",M2<55,\"D\",M2>=55,\"E\")","v":"E"},null,"Informatique",{"$f":"VLOOKUP(Q2,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900}]
["Bijoba","Jo","m",{"$f":"IF(C3=\"f\",\"Madame\",\"Monsieur\")","v":"Monsieur"},{"$f":"_xlfn.IFS(C3=\"f\",\"Madame\",C3=\"m\",\"Monsieur\")","v":"Monsieur"},{"$f":"VLOOKUP(C3,$C$38:$D$39,2,FALSE)","v":"Monsieur"},"Marié(e)","Monsieur",{"$f":"_xlfn.IFS(C3=\"m\",\"Monsieur\",G3=\"Célibataire\",\"Mademoiselle\",C3<>\"m\",\"Madame\")","v":"Monsieur"},1000,{"$f":"VLOOKUP(J3,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Bruxelles"},"1996-03-15",{"$f":"DATEDIF(L3,TODAY(),\"y\")","v":27},{"$f":"IF(M3<25,\"A\",IF(M3<35,\"B\",IF(M3<45,\"C\",IF(M3<55,\"D\",\"E\"))))","v":"B"},{"$f":"_xlfn.IFS(M3<25,\"A\",M3<35,\"B\",M3<45,\"C\",M3<55,\"D\",M3>=55,\"E\")","v":"B"},null,"Direction",{"$f":"VLOOKUP(Q3,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500}]
["Covert","Harry","m","Monsieur",{"$f":"_xlfn.IFS(C4=\"f\",\"Madame\",C4=\"m\",\"Monsieur\")","v":"Monsieur"},"Monsieur","Divorcé(e)","Monsieur",{"$f":"_xlfn.IFS(C4=\"m\",\"Monsieur\",G4=\"Célibataire\",\"Mademoiselle\",C4<>\"m\",\"Madame\")","v":"Monsieur"},1000,{"$f":"VLOOKUP(J4,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Bruxelles"},"2000-02-10",23,"A",{"$f":"_xlfn.IFS(M4<25,\"A\",M4<35,\"B\",M4<45,\"C\",M4<55,\"D\",M4>=55,\"E\")","v":"A"},null,"Personnel",{"$f":"VLOOKUP(Q4,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600}]
["Culaire","Laury","m","Monsieur",{"$f":"_xlfn.IFS(C5=\"f\",\"Madame\",C5=\"m\",\"Monsieur\")","v":"Monsieur"},"Monsieur","Marié(e)","Monsieur",{"$f":"_xlfn.IFS(C5=\"m\",\"Monsieur\",G5=\"Célibataire\",\"Mademoiselle\",C5<>\"m\",\"Madame\")","v":"Monsieur"},1030,{"$f":"VLOOKUP(J5,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Schaerbeek"},"1965-05-05",58,"E",{"$f":"_xlfn.IFS(M5<25,\"A\",M5<35,\"B\",M5<45,\"C\",M5<55,\"D\",M5>=55,\"E\")","v":"E"},null,"Personnel",{"$f":"VLOOKUP(Q5,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600}]
["Deuf","John","m","Monsieur",{"$f":"_xlfn.IFS(C6=\"f\",\"Madame\",C6=\"m\",\"Monsieur\")","v":"Monsieur"},"Monsieur","Célibataire","Monsieur",{"$f":"_xlfn.IFS(C6=\"m\",\"Monsieur\",G6=\"Célibataire\",\"Mademoiselle\",C6<>\"m\",\"Madame\")","v":"Monsieur"},1070,{"$f":"VLOOKUP(J6,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Anderlecht"},"1993-09-08",29,"B",{"$f":"_xlfn.IFS(M6<25,\"A\",M6<35,\"B\",M6<45,\"C\",M6<55,\"D\",M6>=55,\"E\")","v":"B"},null,"Informatique",{"$f":"VLOOKUP(Q6,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900}]
["Foupasune","Jean","m","Monsieur",{"$f":"_xlfn.IFS(C7=\"f\",\"Madame\",C7=\"m\",\"Monsieur\")","v":"Monsieur"},"Monsieur","Célibataire","Monsieur",{"$f":"_xlfn.IFS(C7=\"m\",\"Monsieur\",G7=\"Célibataire\",\"Mademoiselle\",C7<>\"m\",\"Madame\")","v":"Monsieur"},1070,{"$f":"VLOOKUP(J7,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Anderlecht"},"1975-08-07",47,"D",{"$f":"_xlfn.IFS(M7<25,\"A\",M7<35,\"B\",M7<45,\"C\",M7<55,\"D\",M7>=55,\"E\")","v":"D"},null,"Personnel",{"$f":"VLOOKUP(Q7,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600}]
["Lairbon","Oussama","m","Monsieur",{"$f":"_xlfn.IFS(C8=\"f\",\"Madame\",C8=\"m\",\"Monsieur\")","v":"Monsieur"},"Monsieur","Marié(e)","Monsieur",{"$f":"_xlfn.IFS(C8=\"m\",\"Monsieur\",G8=\"Célibataire\",\"Mademoiselle\",C8<>\"m\",\"Madame\")","v":"Monsieur"},1030,{"$f":"VLOOKUP(J8,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Schaerbeek"},"1983-02-08",40,"C",{"$f":"_xlfn.IFS(M8<25,\"A\",M8<35,\"B\",M8<45,\"C\",M8<55,\"D\",M8>=55,\"E\")","v":"C"},null,"Personnel",{"$f":"VLOOKUP(Q8,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600}]
["Menvussa","Gérard","m","Monsieur",{"$f":"_xlfn.IFS(C9=\"f\",\"Madame\",C9=\"m\",\"Monsieur\")","v":"Monsieur"},"Monsieur","Célibataire","Monsieur",{"$f":"_xlfn.IFS(C9=\"m\",\"Monsieur\",G9=\"Célibataire\",\"Mademoiselle\",C9<>\"m\",\"Madame\")","v":"Monsieur"},1050,{"$f":"VLOOKUP(J9,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Ixelles"},"1970-12-04",52,"D",{"$f":"_xlfn.IFS(M9<25,\"A\",M9<35,\"B\",M9<45,\"C\",M9<55,\"D\",M9>=55,\"E\")","v":"D"},null,"Informatique",{"$f":"VLOOKUP(Q9,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900}]
["Lalalalalalala","Starsky","m","Monsieur",{"$f":"_xlfn.IFS(C10=\"f\",\"Madame\",C10=\"m\",\"Monsieur\")","v":"Monsieur"},"Monsieur","Célibataire","Monsieur",{"$f":"_xlfn.IFS(C10=\"m\",\"Monsieur\",G10=\"Célibataire\",\"Mademoiselle\",C10<>\"m\",\"Madame\")","v":"Monsieur"},1060,{"$f":"VLOOKUP(J10,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Saint-Gilles"},"1955-07-08",67,"E",{"$f":"_xlfn.IFS(M10<25,\"A\",M10<35,\"B\",M10<45,\"C\",M10<55,\"D\",M10>=55,\"E\")","v":"E"},null,"Personnel",{"$f":"VLOOKUP(Q10,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600}]
["Lalalalalalala","Hutch","m","Monsieur",{"$f":"_xlfn.IFS(C11=\"f\",\"Madame\",C11=\"m\",\"Monsieur\")","v":"Monsieur"},"Monsieur","Divorcé(e)","Monsieur",{"$f":"_xlfn.IFS(C11=\"m\",\"Monsieur\",G11=\"Célibataire\",\"Mademoiselle\",C11<>\"m\",\"Madame\")","v":"Monsieur"},1050,{"$f":"VLOOKUP(J11,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Ixelles"},"1952-10-07",70,"E",{"$f":"_xlfn.IFS(M11<25,\"A\",M11<35,\"B\",M11<45,\"C\",M11<55,\"D\",M11>=55,\"E\")","v":"E"},null,"Direction",{"$f":"VLOOKUP(Q11,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500}]
["Cléssoulaporte","Djamila","f","Madame",{"$f":"_xlfn.IFS(C12=\"f\",\"Madame\",C12=\"m\",\"Monsieur\")","v":"Madame"},"Madame","Marié(e)","Madame",{"$f":"_xlfn.IFS(C12=\"m\",\"Monsieur\",G12=\"Célibataire\",\"Mademoiselle\",C12<>\"m\",\"Madame\")","v":"Madame"},1050,{"$f":"VLOOKUP(J12,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Ixelles"},"1989-09-07",33,"B",{"$f":"_xlfn.IFS(M12<25,\"A\",M12<35,\"B\",M12<45,\"C\",M12<55,\"D\",M12>=55,\"E\")","v":"B"},null,"Personnel",{"$f":"VLOOKUP(Q12,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600}]
["Noux","Marion","f","Madame",{"$f":"_xlfn.IFS(C13=\"f\",\"Madame\",C13=\"m\",\"Monsieur\")","v":"Madame"},"Madame","Divorcé(e)","Madame",{"$f":"_xlfn.IFS(C13=\"m\",\"Monsieur\",G13=\"Célibataire\",\"Mademoiselle\",C13<>\"m\",\"Madame\")","v":"Madame"},1050,{"$f":"VLOOKUP(J13,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Ixelles"},"1978-12-30",44,"C",{"$f":"_xlfn.IFS(M13<25,\"A\",M13<35,\"B\",M13<45,\"C\",M13<55,\"D\",M13>=55,\"E\")","v":"C"},null,"Secrétariat",{"$f":"VLOOKUP(Q13,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700}]
["Ouzi","Jacques","m","Monsieur",{"$f":"_xlfn.IFS(C14=\"f\",\"Madame\",C14=\"m\",\"Monsieur\")","v":"Monsieur"},"Monsieur","Célibataire","Monsieur",{"$f":"_xlfn.IFS(C14=\"m\",\"Monsieur\",G14=\"Célibataire\",\"Mademoiselle\",C14<>\"m\",\"Madame\")","v":"Monsieur"},1000,{"$f":"VLOOKUP(J14,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Bruxelles"},"1969-02-28",54,"D",{"$f":"_xlfn.IFS(M14<25,\"A\",M14<35,\"B\",M14<45,\"C\",M14<55,\"D\",M14>=55,\"E\")","v":"D"},null,"Personnel",{"$f":"VLOOKUP(Q14,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600}]
["Stiké","Sophie","f","Madame",{"$f":"_xlfn.IFS(C15=\"f\",\"Madame\",C15=\"m\",\"Monsieur\")","v":"Madame"},"Madame","Divorcé(e)","Madame",{"$f":"_xlfn.IFS(C15=\"m\",\"Monsieur\",G15=\"Célibataire\",\"Mademoiselle\",C15<>\"m\",\"Madame\")","v":"Madame"},1070,{"$f":"VLOOKUP(J15,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Anderlecht"},"1998-04-04",25,"B",{"$f":"_xlfn.IFS(M15<25,\"A\",M15<35,\"B\",M15<45,\"C\",M15<55,\"D\",M15>=55,\"E\")","v":"B"},null,"Secrétariat",{"$f":"VLOOKUP(Q15,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700}]
["Tare","Guy","m","Monsieur",{"$f":"_xlfn.IFS(C16=\"f\",\"Madame\",C16=\"m\",\"Monsieur\")","v":"Monsieur"},"Monsieur","Divorcé(e)","Monsieur",{"$f":"_xlfn.IFS(C16=\"m\",\"Monsieur\",G16=\"Célibataire\",\"Mademoiselle\",C16<>\"m\",\"Madame\")","v":"Monsieur"},1070,{"$f":"VLOOKUP(J16,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Anderlecht"},"1960-08-07",62,"E",{"$f":"_xlfn.IFS(M16<25,\"A\",M16<35,\"B\",M16<45,\"C\",M16<55,\"D\",M16>=55,\"E\")","v":"E"},null,"Informatique",{"$f":"VLOOKUP(Q16,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900}]
["Vaisselle","Aude","f","Madame",{"$f":"_xlfn.IFS(C17=\"f\",\"Madame\",C17=\"m\",\"Monsieur\")","v":"Madame"},"Madame","Marié(e)","Madame",{"$f":"_xlfn.IFS(C17=\"m\",\"Monsieur\",G17=\"Célibataire\",\"Mademoiselle\",C17<>\"m\",\"Madame\")","v":"Madame"},1070,{"$f":"VLOOKUP(J17,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Anderlecht"},"1966-06-06",57,"E",{"$f":"_xlfn.IFS(M17<25,\"A\",M17<35,\"B\",M17<45,\"C\",M17<55,\"D\",M17>=55,\"E\")","v":"E"},null,"Secrétariat",{"$f":"VLOOKUP(Q17,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700}]
["Zetofrais","Mélanie","f","Madame",{"$f":"_xlfn.IFS(C18=\"f\",\"Madame\",C18=\"m\",\"Monsieur\")","v":"Madame"},"Madame","Célibataire","Mademoiselle",{"$f":"_xlfn.IFS(C18=\"m\",\"Monsieur\",G18=\"Célibataire\",\"Mademoiselle\",C18<>\"m\",\"Madame\")","v":"Mademoiselle"},1070,{"$f":"VLOOKUP(J18,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Anderlecht"},"1978-11-25",44,"C",{"$f":"_xlfn.IFS(M18<25,\"A\",M18<35,\"B\",M18<45,\"C\",M18<55,\"D\",M18>=55,\"E\")","v":"C"},null,"Direction",{"$f":"VLOOKUP(Q18,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500}]
["Touille","Sasha","m","Monsieur",{"$f":"_xlfn.IFS(C19=\"f\",\"Madame\",C19=\"m\",\"Monsieur\")","v":"Monsieur"},"Monsieur","Célibataire","Monsieur",{"$f":"_xlfn.IFS(C19=\"m\",\"Monsieur\",G19=\"Célibataire\",\"Mademoiselle\",C19<>\"m\",\"Madame\")","v":"Monsieur"},1070,{"$f":"VLOOKUP(J19,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Anderlecht"},"2000-10-30",22,"A",{"$f":"_xlfn.IFS(M19<25,\"A\",M19<35,\"B\",M19<45,\"C\",M19<55,\"D\",M19>=55,\"E\")","v":"A"},null,"Personnel",{"$f":"VLOOKUP(Q19,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600}]
["Proviste","Alain","m","Monsieur",{"$f":"_xlfn.IFS(C20=\"f\",\"Madame\",C20=\"m\",\"Monsieur\")","v":"Monsieur"},"Monsieur","Marié(e)","Monsieur",{"$f":"_xlfn.IFS(C20=\"m\",\"Monsieur\",G20=\"Célibataire\",\"Mademoiselle\",C20<>\"m\",\"Madame\")","v":"Monsieur"},1030,{"$f":"VLOOKUP(J20,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Schaerbeek"},"1959-09-09",63,"E",{"$f":"_xlfn.IFS(M20<25,\"A\",M20<35,\"B\",M20<45,\"C\",M20<55,\"D\",M20>=55,\"E\")","v":"E"},null,"Personnel",{"$f":"VLOOKUP(Q20,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600}]
["Peulaporte","Firmin","m","Monsieur",{"$f":"_xlfn.IFS(C21=\"f\",\"Madame\",C21=\"m\",\"Monsieur\")","v":"Monsieur"},"Monsieur","Divorcé(e)","Monsieur",{"$f":"_xlfn.IFS(C21=\"m\",\"Monsieur\",G21=\"Célibataire\",\"Mademoiselle\",C21<>\"m\",\"Madame\")","v":"Monsieur"},1040,{"$f":"VLOOKUP(J21,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Etterbeek"},"1993-07-01",29,"B",{"$f":"_xlfn.IFS(M21<25,\"A\",M21<35,\"B\",M21<45,\"C\",M21<55,\"D\",M21>=55,\"E\")","v":"B"},null,"Informatique",{"$f":"VLOOKUP(Q21,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900}]
["Unetitlaine","Jérémy","m","Monsieur",{"$f":"_xlfn.IFS(C22=\"f\",\"Madame\",C22=\"m\",\"Monsieur\")","v":"Monsieur"},"Monsieur","Marié(e)","Monsieur",{"$f":"_xlfn.IFS(C22=\"m\",\"Monsieur\",G22=\"Célibataire\",\"Mademoiselle\",C22<>\"m\",\"Madame\")","v":"Monsieur"},1030,{"$f":"VLOOKUP(J22,Applic2_consignes!$C$13:$D$18,2,FALSE)","v":"Schaerbeek"},"1983-06-09",40,"C",{"$f":"_xlfn.IFS(M22<25,\"A\",M22<35,\"B\",M22<45,\"C\",M22<55,\"D\",M22>=55,\"E\")","v":"C"},null,"Informatique",{"$f":"VLOOKUP(Q22,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900}]
[]
[]
["(*)","1-","Avec SI",null,null,null,null,null,null,null,null,null,"(***)","1-","Avec SI"]
[]
[null,null,"SI Sexe = \"f\"",null,null,null,null,null,null,null,null,null,null,null,"SI Age < 25"]
[null,null,"ALORS \"MADAME\"",null,null,null,null,null,null,null,null,null,null,null,"ALORS \"A\""]
[null,null,"SINON \"MONSIEUR\"",null,null,null,null,null,null,null,null,null,null,null,"SINON SI Age < 35"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"           ALORS \"B\""]
[null,"2-","Avec SI.CONDITIONS",null,null,null,null,null,null,null,null,null,null,null,"           SINON SI Age < 45"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                      ALORS \"C\""]
[null,null,"SI Sexe = \"f\" ALORS \"Madame\"",null,null,null,null,null,null,null,null,null,null,null,"                      SINON SI Age < 55"]
[null,null,"SI Sexe = \"m\" ALORS \"Monsieur\"",null,null,null,null,null,null,null,null,null,null,null,"                                 ALORS \"D\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"                                 SINON \"E\""]
[null,"3-","Avec une rechercheV"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2-","Avec SI.CONDITIONS"]
[null,null,"f","Madame"]
[null,null,"m","Monsieur",null,null,null,null,null,null,null,null,null,null,"Si Age < 25 ALORS \"A\""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Si Age < 35 ALORS \"B\""]
["(**)","Selon le \"départ\" choisi, la logique peut être +/- simple.",null,null,null,null,null,null,null,null,null,null,null,null,"Si Age < 45 ALORS \"C\""]
[null,"Ici sera traité le cas le plus complexe de façon à être capable d'écrire ce cas.",null,null,null,null,null,null,null,null,null,null,null,null,"Si Age < 55 ALORS \"D\""]
[null,"Les différents cas peuvent être résolu avec un SI (1-) ou un SI.Conditions (2-)",null,null,null,null,null,null,null,null,null,null,null,null,"Si Age >= 55 ALORS \"E\""]
[]
[null,"1-","Avec SI"]
[]
[]
[]
[null,null,"SI Sexe = \"f\" ET Etat civil = \"Marié(e)\" OU \"Divorcé(e)\""]
[null,null,"ALORS \"Madame\""]
[null,null,"SINON SI Sexe = \"f\" ET Etat civil = \"Célibataire\""]
[null,null,"           ALORS \"Mademoiselle\""]
[null,null,"           SINON \"Monsieur\""]
[]
[null,null,"OU"]
[]
[null,null,"SI Sexe = \"m\""]
[null,null,"ALORS \"Monsieur\""]
[null,null,"SINON SI Etat civil = \"Célibataire\""]
[null,null,"           ALORS \"Mademoiselle\""]
[null,null,"           SINON \"Madame\""]
[]
[null,"2-","Avec SI.CONDITIONS"]
[]
[null,null,"SI Sexe = \"f\" ET Etat civil = \"Marié(e)\" OU \"Divorcé(e)\" ALORS \"Madame\""]
[null,null,"SI Sexe = \"f\" ET Etat civil = \"Célibataire\" ALORS \"Mademoiselle\""]
[null,null,"SI Sexe = \"m\" ALORS \"Monsieur\""]
[]
[null,null,"OU"]
[]
[null,null,"SI Sexe = \"m\" ALORS \"Monsieur\""]
[null,null,"SI Etat civil = \"Célibataire\" ALORS \"Mademoiselle\""]
[null,null,"SI Sexe <> \"m\" ALORS \"Madame\""]

{"sheet":"Applic3","index":6,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
[null,"Lors de l'utilisation des 'SI' imbriqués, nous ne disposons que de 8 'SI'. Si les tranches été différentes (cf. ci-dessous), le problème n'aurait pas pu être résolu avec des 'SI' "]
[null,"Ce genre de problème peut être solutionné par l'utilisation d'une 'RechercheV' par valeur proche."]
[]
[]
[null,"Ages","Catégories",null,null,"Age","Catégories"]
[null,"<25","A",null,null,42]
[null,">=25 et <30","B",null,null,28]
[null,">=30 et <35","C",null,null,66]
[null,">=35 et <40","D",null,null,42]
[null,">=40 et <45","E",null,null,44]
[null,">=45 et <50","F",null,null,32]
[null,">=50 et <55","G",null,null,25]
[null,">=55 et <60","H",null,null,37]
[null,">=60 et <65","I",null,null,52]
[null,">=65 et <70","J",null,null,55]
[null,">=70","K",null,null,48]
[null,null,null,null,null,29]
[null,null,null,null,null,39]
[null,null,null,null,null,49]
[null,null,null,null,null,47]
[null,null,null,null,null,41]
[null,null,null,null,null,29]
[null,null,null,null,null,25]
[null,null,null,null,null,48]
[null,null,null,null,null,42]
[null,null,null,null,null,24]

{"sheet":"Applic3_corrigé","index":7,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Lors de l'utilisation des 'SI' imbriqués, nous ne disposons que de 8 'SI'. Si les tranches été différentes (cf. ci-dessous), le problème n'aurait pas pu être résolu avec des 'SI' "]
[null,"Ce genre de problème peut être solutionné par l'utilisation d'une 'RechercheV' par valeur proche."]
[]
[]
[null,"Ages",null,"Catégories",null,"Age","Catégories"]
[null,"<25",0,"A",null,42,{"$f":"VLOOKUP(F8,$C$8:$D$18,2,TRUE)","v":"E"}]
[null,">=25 et <30",25,"B",null,28,{"$f":"VLOOKUP(F9,$C$8:$D$18,2,TRUE)","v":"B"}]
[null,">=30 et <35",30,"C",null,66,"J"]
[null,">=35 et <40",35,"D",null,42,"E"]
[null,">=40 et <45",40,"E",null,44,"E"]
[null,">=45 et <50",45,"F",null,32,"C"]
[null,">=50 et <55",50,"G",null,25,"B"]
[null,">=55 et <60",55,"H",null,37,"D"]
[null,">=60 et <65",60,"I",null,52,"G"]
[null,">=65 et <70",65,"J",null,55,"H"]
[null,">=70",70,"K",null,48,"F"]
[null,null,null,null,null,29,"B"]
[null,null,null,null,null,39,"D"]
[null,null,null,null,null,49,"F"]
[null,null,null,null,null,47,"F"]
[null,null,null,null,null,41,"E"]
[null,null,null,null,null,29,"B"]
[null,null,null,null,null,25,"B"]
[null,null,null,null,null,48,"F"]
[null,null,null,null,null,42,"E"]
[null,null,null,null,null,24,"A"]

{"sheet":"Applic4","index":8,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Nom","Prénom","Sexe","Etat civil","Ville","CP\n(Equiv)","CP\n(Index)","CP\n(RechercheX)",null,null,null,"Retour sommaire"]
["Bistrot","Alonso","m","Marié(e)","Schaerbeek"]
["Bijoba","Jo","m","Marié(e)","Bruxelles",null,null,null,null,"1)","Via la liste ci-dessous, choisir une personne et obtenir son état civil dans la cellule à côté"]
["Covert","Harry","m","Divorcé(e)","Bruxelles"]
["Culaire","Laury","m","Marié(e)","Schaerbeek",null,null,null,null,null,null,"Choix de la personne :","Covert"]
["Deuf","John","m","Célibataire","Anderlecht"]
["Foupasune","Jean","m","Célibataire","Anderlecht",null,null,null,null,null,null,"Son état civil :",{"$f":"VLOOKUP(M5,A2:D22,4,FALSE)","v":"Divorcé(e)"}]
["Lairbon","Oussama","m","Marié(e)","Schaerbeek"]
["Menvussa","Gérard","m","Célibataire","Ixelles",null,null,null,null,null,"=> Pour les noms en double, quel que soit le nom choisi, la RechercheV renvoit toujours le premier retrouvé"]
["Lalalalalalala","Starsky","m","Célibataire","Saint-Gilles"]
["Lalalalalalala","Hutch","m","Divorcé(e)","Ixelles",null,null,null,null,null,"Solution :","Rendre la valeur que nous recherchons unique et faire la recherche sur cette valeur unique"]
["Cléssoulaporte","Djamila","f","Marié(e)","Ixelles"]
["Noux","Marion","f","Divorcé(e)","Ixelles",null,null,null,null,"2)","A l'aide d'une recherche, obtenir le CP qui correspond à la ville"]
["Ouzi","Jacques","m","Célibataire","Bruxelles"]
["Stiké","Sophie","f","Divorcé(e)","Anderlecht",null,null,null,null,null,null,"CP","Ville"]
["Tare","Guy","m","Divorcé(e)","Anderlecht",null,null,null,null,null,null,1030,"Schaerbeek"]
["Vaisselle","Aude","f","Marié(e)","Anderlecht",null,null,null,null,null,null,1000,"Bruxelles"]
["Zetofrais","Mélanie","f","Célibataire","Anderlecht",null,null,null,null,null,null,1070,"Anderlecht"]
["Touille","Sasha","m","Célibataire","Anderlecht",null,null,null,null,null,null,1050,"Ixelles"]
["Proviste","Alain","m","Marié(e)","Schaerbeek",null,null,null,null,null,null,1060,"Saint-Gilles"]
["Peulaporte","Firmin","m","Divorcé(e)","Etterbeek",null,null,null,null,null,null,1040,"Etterbeek"]
["Unetitlaine","Jérémy","m","Marié(e)","Schaerbeek"]
[null,null,null,null,null,null,null,null,null,null,"=> Problème rencontré : via une RechercheV, la valeur cherchée doit absolument se trouver dans la 1ère colonne du tableau"]
[]
[null,null,null,null,null,null,null,null,null,null,"Solution 1 :","Reconstruire le tableau dans le bon sens"]
[]
[null,null,null,null,null,null,null,null,null,null,"Solution 2 :","Utiliser les fonctions EQUIV et INDEX"]
[]
[null,null,null,null,null,null,null,null,null,null,"Solution 3 :","Utiliser la fonction RechercheX"]

{"sheet":"Applic4_corrigé","index":9,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Nom","Prénom","Nom & Prénom","Sexe","Etat civil","Ville","CP\n(Equiv)","CP\n(Index)","CP\n(RechercheX)",null,null,null,"Retour sommaire"]
["Bistrot","Alonso",{"$f":"A2&\" \"&B2","v":"Bistrot Alonso"},"m","Marié(e)","Schaerbeek",{"$f":"MATCH(F:F,$N$16:$N$21,0)","v":1},{"$f":"INDEX($M$16:$M$21,G2)","v":1030},{"$f":"_xlfn.XLOOKUP(F2,$N$16:$N$21,$M$16:$M$21,,0)","v":1030}]
["Bijoba","Jo",{"$f":"A3&\" \"&B3","v":"Bijoba Jo"},"m","Marié(e)","Bruxelles",{"$f":"MATCH(F:F,$N$16:$N$21,0)","v":2},{"$f":"INDEX($M$16:$M$21,G3)","v":1000},{"$f":"_xlfn.XLOOKUP(F3,$N$16:$N$21,$M$16:$M$21,,0)","v":1000},null,"1)","Via la liste ci-dessous, choisir une personne et obtenir son état civil dans la cellule à côté"]
["Covert","Harry","Covert Harry","m","Divorcé(e)","Bruxelles",2,{"$f":"INDEX($M$16:$M$21,G4)","v":1000},1000]
["Culaire","Laury","Culaire Laury","m","Marié(e)","Schaerbeek",1,{"$f":"INDEX($M$16:$M$21,G5)","v":1030},1030,null,null,null,"Choix de la personne :","Lalalalalalala Hutch"]
["Deuf","John","Deuf John","m","Célibataire","Anderlecht",3,{"$f":"INDEX($M$16:$M$21,G6)","v":1070},1070]
["Foupasune","Jean","Foupasune Jean","m","Célibataire","Anderlecht",3,{"$f":"INDEX($M$16:$M$21,G7)","v":1070},1070,null,null,null,"Son état civil :",{"$f":"VLOOKUP(N5,C2:E22,3,FALSE)","v":"Divorcé(e)"}]
["Lairbon","Oussama","Lairbon Oussama","m","Marié(e)","Schaerbeek",1,{"$f":"INDEX($M$16:$M$21,G8)","v":1030},1030]
["Menvussa","Gérard","Menvussa Gérard","m","Célibataire","Ixelles",4,{"$f":"INDEX($M$16:$M$21,G9)","v":1050},1050,null,null,"=> Pour les noms en double, quel que soit le nom choisi, la RechercheV renvoit toujours le premier retrouvé"]
["Lalalalalalala","Starsky","Lalalalalalala Starsky","m","Célibataire","Saint-Gilles",5,{"$f":"INDEX($M$16:$M$21,G10)","v":1060},1060]
["Lalalalalalala","Hutch","Lalalalalalala Hutch","m","Divorcé(e)","Ixelles",4,{"$f":"INDEX($M$16:$M$21,G11)","v":1050},1050,null,null,"Solution :","Rendre la valeur que nous recherchons unique et faire la recherche sur cette valeur unique"]
["Cléssoulaporte","Djamila","Cléssoulaporte Djamila","f","Marié(e)","Ixelles",4,{"$f":"INDEX($M$16:$M$21,G12)","v":1050},1050]
["Noux","Marion","Noux Marion","f","Divorcé(e)","Ixelles",4,{"$f":"INDEX($M$16:$M$21,G13)","v":1050},1050,null,"2)","A l'aide d'une recherche, obtenir le CP qui correspond à la ville"]
["Ouzi","Jacques","Ouzi Jacques","m","Célibataire","Bruxelles",2,{"$f":"INDEX($M$16:$M$21,G14)","v":1000},1000]
["Stiké","Sophie","Stiké Sophie","f","Divorcé(e)","Anderlecht",3,{"$f":"INDEX($M$16:$M$21,G15)","v":1070},1070,null,null,null,"CP","Ville"]
["Tare","Guy","Tare Guy","m","Divorcé(e)","Anderlecht",3,{"$f":"INDEX($M$16:$M$21,G16)","v":1070},1070,null,null,null,1030,"Schaerbeek"]
["Vaisselle","Aude","Vaisselle Aude","f","Marié(e)","Anderlecht",3,{"$f":"INDEX($M$16:$M$21,G17)","v":1070},1070,null,null,null,1000,"Bruxelles"]
["Zetofrais","Mélanie","Zetofrais Mélanie","f","Célibataire","Anderlecht",3,{"$f":"INDEX($M$16:$M$21,G18)","v":1070},1070,null,null,null,1070,"Anderlecht"]
["Touille","Sasha","Touille Sasha","m","Célibataire","Anderlecht",3,{"$f":"INDEX($M$16:$M$21,G19)","v":1070},1070,null,null,null,1050,"Ixelles"]
["Proviste","Alain","Proviste Alain","m","Marié(e)","Schaerbeek",1,{"$f":"INDEX($M$16:$M$21,G20)","v":1030},1030,null,null,null,1060,"Saint-Gilles"]
["Peulaporte","Firmin","Peulaporte Firmin","m","Divorcé(e)","Etterbeek",6,{"$f":"INDEX($M$16:$M$21,G21)","v":1040},1040,null,null,null,1040,"Etterbeek"]
["Unetitlaine","Jérémy","Unetitlaine Jérémy","m","Marié(e)","Schaerbeek",1,{"$f":"INDEX($M$16:$M$21,G22)","v":1030},1030]
[null,null,null,null,null,null,null,null,null,null,null,"=> Problème rencontré : via une RechercheV, la valeur cherchée doit absolument se trouver dans la 1ère colonne du tableau"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Solution 1 :","Reconstruire le tableau dans le bon sens"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Solution 2 :","Utiliser les fonctions EQUIV et INDEX"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Solution 3 :","Utiliser la fonction RechercheX"]

{"sheet":"Filtre1_corrigé","index":10,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Filtres automatiques"]
[]
["A l'aide des filtres automatiques, afficher les employés dont le nom commence par un 'p'"]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H8,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",59,4,"Informatique",{"$f":"VLOOKUP(H11,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",47,3,"Personnel",{"$f":"VLOOKUP(H12,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",67,4,"Personnel",{"$f":"VLOOKUP(H15,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",70,4,"Direction",{"$f":"VLOOKUP(H16,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",63,4,"Personnel",{"$f":"VLOOKUP(H17,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",62,4,"Informatique",{"$f":"VLOOKUP(H21,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",63,4,"Personnel",{"$f":"VLOOKUP(H25,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",57,4,"Informatique",{"$f":"VLOOKUP(H26,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2090]

{"sheet":"Filtre2_corrigé","index":11,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Filtres automatiques"]
[]
["A l'aide des filtres automatiques, afficher les employés du secrétariat et de la direction"]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H8,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",59,4,"Informatique",{"$f":"VLOOKUP(H11,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",47,3,"Personnel",{"$f":"VLOOKUP(H12,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",67,4,"Personnel",{"$f":"VLOOKUP(H15,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",70,4,"Direction",{"$f":"VLOOKUP(H16,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",63,4,"Personnel",{"$f":"VLOOKUP(H17,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",62,4,"Informatique",{"$f":"VLOOKUP(H21,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",63,4,"Personnel",{"$f":"VLOOKUP(H25,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",57,4,"Informatique",{"$f":"VLOOKUP(H26,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2090]

{"sheet":"Filtre3_corrigé","index":12,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Filtres automatiques"]
[]
["A l'aide des filtres automatiques, afficher les employés nés entre 1965 et 1975"]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H8,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",59,4,"Informatique",{"$f":"VLOOKUP(H11,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",47,3,"Personnel",{"$f":"VLOOKUP(H12,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",67,4,"Personnel",{"$f":"VLOOKUP(H15,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",70,4,"Direction",{"$f":"VLOOKUP(H16,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",63,4,"Personnel",{"$f":"VLOOKUP(H17,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",62,4,"Informatique",{"$f":"VLOOKUP(H21,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",63,4,"Personnel",{"$f":"VLOOKUP(H25,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",57,4,"Informatique",{"$f":"VLOOKUP(H26,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2090]

{"sheet":"Filtre4_corrigé","index":13,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Filtres automatiques"]
[]
["A l'aide des filtres automatiques, afficher les employés de l'informatique et de la direction nés entre 1965 et 1975"]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H8,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Deuf","John","m","Célibataire","1963-09-08",59,4,"Informatique",{"$f":"VLOOKUP(H11,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280]
["Foupasune","Jean","m","Célibataire","1975-08-07",47,3,"Personnel",{"$f":"VLOOKUP(H12,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",67,4,"Personnel",{"$f":"VLOOKUP(H15,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",70,4,"Direction",{"$f":"VLOOKUP(H16,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",63,4,"Personnel",{"$f":"VLOOKUP(H17,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},1870]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1840]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",62,4,"Informatique",{"$f":"VLOOKUP(H21,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},2750]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",63,4,"Personnel",{"$f":"VLOOKUP(H25,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",57,4,"Informatique",{"$f":"VLOOKUP(H26,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2090]

{"sheet":"FiltreElab1_corrigé","index":14,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[]
["A l'aide des filtres élaborés, afficher les employés dont le nom commence par un 'p'"]
[]
[]
[null,"Nom"]
[null,"p"]
[]
[]
[null,"Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
[null,"Proviste","Alain","m","Marié(e)","1959-09-09",48,3,"Personnel",1600,1840]
[null,"Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",42,2,"Informatique",1900,2090]

{"sheet":"FiltreElab2_corrigé","index":15,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[]
["A l'aide des filtres élaborés, afficher les nom, prénom et service des employés du secrétariat et de la direction"]
[]
[null,"Services"]
[null,"Secrétariat"]
[null,"Direction"]
[]
[]
[null,"Nom","Prénom","Services"]
[null,"Bijoba","Jo","Direction"]
[null,"Lalalalalalala","Hutch","Direction"]
[null,"Noux","Marion","Secrétariat"]
[null,"Stiké","Sophie","Secrétariat"]
[null,"Vaisselle","Aude","Secrétariat"]
[null,"Zetofrais","Mélanie","Direction"]

{"sheet":"FiltreElab3_corrigé","index":16,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[]
["A l'aide des filtres élaborés, afficher les employés nés entre 1965 et 1975"]
[]
[]
[]
[null,"Date de naissance","Date de naissance"]
[null,">=1/1/1965","<1/1/1975"]
[]
[]
[null,"Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
[null,"Bistrot","Alonso","m","Marié(e)","1966-01-17",42,2,"Informatique",1900,2090]
[null,"Culaire","Laury","m","Marié(e)","1965-05-05",42,2,"Personnel",1600,1760]
[null,"Menvussa","Gérard","m","Célibataire","1970-12-04",37,2,"Informatique",1900,2090]
[null,"Ouzi","Jacques","m","Célibataire","1969-02-28",39,2,"Personnel",1600,1760]
[null,"Vaisselle","Aude","f","Marié(e)","1966-06-06",41,2,"Secrétariat",1700,1870]
[null,"Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",42,2,"Informatique",1900,2090]
[null,"Ouzi","Jacques","m","Célibataire","1969-02-28",39,2,"Personnel",1600,1760]

{"sheet":"FiltreElab4_corrigé","index":17,"n_rows":14,"n_cols":11,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
["A l'aide des filtres élaborés, afficher les employés de l'informatique et de la direction nés entre 1965 et 1975"]
[]
[]
[null,"Date de naissance","Date de naissance","Services"]
[null,">=1/1/1965","<1/1/1975","informatique"]
[null,">=1/1/1965","<1/1/1975","direction"]
[]
[]
[null,"Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
[null,"Bistrot","Alonso","m","Marié(e)","1966-01-17",42,2,"Informatique",1900,2090]
[null,"Menvussa","Gérard","m","Célibataire","1970-12-04",37,2,"Informatique",1900,2090]
[null,"Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",42,2,"Informatique",1900,2090]

{"sheet":"FiltreElab5_corrigé","index":18,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[]
[]
["A l'aide des filtres élaborés, faites une extraction des données sans recopier les doublons"]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",42,2,"Informatique",1900,2090]
["Bijoba","Jo","m","Marié(e)","1980-03-15",28,1,"Direction",2500,2625]
["Covert","Harry","m","Divorcé(e)","1942-02-10",66,4,"Personnel",1600,1920]
["Culaire","Laury","m","Marié(e)","1965-05-05",42,2,"Personnel",1600,1760]
["Deuf","John","m","Célibataire","1963-09-08",44,2,"Informatique",1900,2090]
["Foupasune","Jean","m","Célibataire","1975-08-07",32,1,"Personnel",1600,1680]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",25,1,"Personnel",1600,1680]
["Menvussa","Gérard","m","Célibataire","1970-12-04",37,2,"Informatique",1900,2090]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",52,3,"Personnel",1600,1840]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",55,4,"Direction",2500,3000]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",48,3,"Personnel",1600,1840]
["Noux","Marion","f","Divorcé(e)","1978-12-30",29,1,"Secrétariat",1700,1785]
["Ouzi","Jacques","m","Célibataire","1969-02-28",39,2,"Personnel",1600,1760]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",49,3,"Secrétariat",1700,1955]
["Tare","Guy","m","Divorcé(e)","1960-08-07",47,3,"Informatique",1900,2185]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",41,2,"Secrétariat",1700,1870]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",29,1,"Direction",2500,2625]
["Touille","Sasha","m","Célibataire","1982-10-30",25,1,"Personnel",1600,1680]
["Proviste","Alain","m","Marié(e)","1959-09-09",48,3,"Personnel",1600,1840]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",42,2,"Informatique",1900,2090]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",24,0,"Informatique",1900,1900]

{"sheet":"FiltreElab6_corrigé","index":19,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[]
[]
["A l'aide des filtres élaborés, afficher les employés dont l'âge est supérieur à la moyenne des âges"]
[]
[null,"Condition"]
[null,{"$f":"#REF!>AVERAGE(#REF!)","v":{"$error":"#REF!"}}]
[]
[]
[null,"Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
[null,"Bistrot","Alonso","m","Marié(e)","1966-01-17",42,2,"Informatique",1900,2090]
[null,"Covert","Harry","m","Divorcé(e)","1942-02-10",66,4,"Personnel",1600,1920]
[null,"Culaire","Laury","m","Marié(e)","1965-05-05",42,2,"Personnel",1600,1760]
[null,"Deuf","John","m","Célibataire","1963-09-08",44,2,"Informatique",1900,2090]
[null,"Lalalalalalala","Starsky","m","Célibataire","1955-07-08",52,3,"Personnel",1600,1840]
[null,"Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",55,4,"Direction",2500,3000]
[null,"Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",48,3,"Personnel",1600,1840]
[null,"Stiké","Sophie","f","Divorcé(e)","1959-04-04",49,3,"Secrétariat",1700,1955]
[null,"Tare","Guy","m","Divorcé(e)","1960-08-07",47,3,"Informatique",1900,2185]
[null,"Vaisselle","Aude","f","Marié(e)","1966-06-06",41,2,"Secrétariat",1700,1870]
[null,"Proviste","Alain","m","Marié(e)","1959-09-09",48,3,"Personnel",1600,1840]
[null,"Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",42,2,"Informatique",1900,2090]

{"sheet":"Sous-Totaux1_corrigé","index":20,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
["Sous-Totaux"]
[]
["Utilisez les sous-totaux de façon à afficher le nombre d'employés par service."]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bijoba","Jo","m","Marié(e)","1980-03-15",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":43},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":2},"Direction",{"$f":"VLOOKUP(H7,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},{"$f":"I7+5%*G7*I7","v":2750}]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",{"$f":"DATEDIF(E8,TODAY(),\"y\")","v":70},{"$f":"IF(F8<25,0,IF(F8<35,1,IF(F8<45,2,IF(F8<55,3,4))))","v":4},"Direction",{"$f":"VLOOKUP(H8,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},{"$f":"I8+5%*G8*I8","v":3000}]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",{"$f":"DATEDIF(E9,TODAY(),\"y\")","v":44},{"$f":"IF(F9<25,0,IF(F9<35,1,IF(F9<45,2,IF(F9<55,3,4))))","v":2},"Direction",{"$f":"VLOOKUP(H9,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},{"$f":"I9+5%*G9*I9","v":2750}]
[null,null,null,null,null,null,"Nombre Direction",{"$f":"SUBTOTAL(3,H7:H9)","v":3}]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E11,TODAY(),\"y\")","v":57},{"$f":"IF(F11<25,0,IF(F11<35,1,IF(F11<45,2,IF(F11<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H11,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},{"$f":"I11+5%*G11*I11","v":2280}]
["Deuf","John","m","Célibataire","1963-09-08",59,4,"Informatique",{"$f":"VLOOKUP(H12,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H13,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2185]
["Tare","Guy","m","Divorcé(e)","1960-08-07",62,4,"Informatique",{"$f":"VLOOKUP(H14,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",57,4,"Informatique",{"$f":"VLOOKUP(H15,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H16,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2090]
[null,null,null,null,null,null,"Nombre Informatique",{"$f":"SUBTOTAL(3,H11:H16)","v":6}]
["Covert","Harry","m","Divorcé(e)","1942-02-10",{"$f":"DATEDIF(E18,TODAY(),\"y\")","v":81},{"$f":"IF(F18<25,0,IF(F18<35,1,IF(F18<45,2,IF(F18<55,3,4))))","v":4},"Personnel",{"$f":"VLOOKUP(H18,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},{"$f":"I18+5%*G18*I18","v":1920}]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H19,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Foupasune","Jean","m","Célibataire","1975-08-07",47,3,"Personnel",{"$f":"VLOOKUP(H20,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H21,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1760]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",67,4,"Personnel",{"$f":"VLOOKUP(H22,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",63,4,"Personnel",{"$f":"VLOOKUP(H23,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H24,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1840]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H25,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",63,4,"Personnel",{"$f":"VLOOKUP(H26,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H27,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1840]
[null,null,null,null,null,null,"Nombre Personnel",{"$f":"SUBTOTAL(3,H18:H27)","v":10}]
["Noux","Marion","f","Divorcé(e)","1978-12-30",{"$f":"DATEDIF(E29,TODAY(),\"y\")","v":44},{"$f":"IF(F29<25,0,IF(F29<35,1,IF(F29<45,2,IF(F29<55,3,4))))","v":2},"Secrétariat",{"$f":"VLOOKUP(H29,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},{"$f":"I29+5%*G29*I29","v":1870}]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",{"$f":"DATEDIF(E30,TODAY(),\"y\")","v":64},{"$f":"IF(F30<25,0,IF(F30<35,1,IF(F30<45,2,IF(F30<55,3,4))))","v":4},"Secrétariat",{"$f":"VLOOKUP(H30,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},{"$f":"I30+5%*G30*I30","v":2040}]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",{"$f":"DATEDIF(E31,TODAY(),\"y\")","v":57},{"$f":"IF(F31<25,0,IF(F31<35,1,IF(F31<45,2,IF(F31<55,3,4))))","v":4},"Secrétariat",{"$f":"VLOOKUP(H31,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},{"$f":"I31+5%*G31*I31","v":2040}]
[null,null,null,null,null,null,"Nombre Secrétariat",{"$f":"SUBTOTAL(3,H29:H31)","v":3}]
[null,null,null,null,null,null,"Nbval",{"$f":"SUBTOTAL(3,H7:H31)","v":22}]

{"sheet":"Sous-Totaux2_corrigé","index":21,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["Sous-Totaux"]
[]
["Utilisez les sous-totaux de façon à afficher le salaire moyen par service et par sexe."]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":44},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":2},"Direction",{"$f":"VLOOKUP(H7,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},{"$f":"I7+5%*G7*I7","v":2750}]
[null,null,"Moyenne f",null,null,null,null,null,null,{"$f":"SUBTOTAL(1,J7:J7)","v":2750}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",{"$f":"DATEDIF(E9,TODAY(),\"y\")","v":43},{"$f":"IF(F9<25,0,IF(F9<35,1,IF(F9<45,2,IF(F9<55,3,4))))","v":2},"Direction",{"$f":"VLOOKUP(H9,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},{"$f":"I9+5%*G9*I9","v":2750}]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",{"$f":"DATEDIF(E10,TODAY(),\"y\")","v":70},{"$f":"IF(F10<25,0,IF(F10<35,1,IF(F10<45,2,IF(F10<55,3,4))))","v":4},"Direction",{"$f":"VLOOKUP(H10,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},{"$f":"I10+5%*G10*I10","v":3000}]
[null,null,"Moyenne m",null,null,null,null,null,null,{"$f":"SUBTOTAL(1,J9:J10)","v":2875}]
[null,null,null,null,null,null,null,"Moyenne Direction",null,{"$f":"SUBTOTAL(1,J7:J10)","v":2833.3333333333335}]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E13,TODAY(),\"y\")","v":57},{"$f":"IF(F13<25,0,IF(F13<35,1,IF(F13<45,2,IF(F13<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H13,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},{"$f":"I13+5%*G13*I13","v":2280}]
["Deuf","John","m","Célibataire","1963-09-08",59,4,"Informatique",{"$f":"VLOOKUP(H14,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H15,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2185]
["Tare","Guy","m","Divorcé(e)","1960-08-07",62,4,"Informatique",{"$f":"VLOOKUP(H16,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",57,4,"Informatique",{"$f":"VLOOKUP(H17,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H18,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2090]
[null,null,null,null,null,null,null,"Moyenne Informatique",null,{"$f":"SUBTOTAL(1,J13:J18)","v":2232.5}]
[null,null,"Moyenne m",null,null,null,null,null,null,{"$f":"SUBTOTAL(1,J13:J18)","v":2232.5}]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",{"$f":"DATEDIF(E21,TODAY(),\"y\")","v":63},{"$f":"IF(F21<25,0,IF(F21<35,1,IF(F21<45,2,IF(F21<55,3,4))))","v":4},"Personnel",{"$f":"VLOOKUP(H21,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},{"$f":"I21+5%*G21*I21","v":1920}]
[null,null,"Moyenne f",null,null,null,null,null,null,{"$f":"SUBTOTAL(1,J21:J21)","v":1920}]
["Covert","Harry","m","Divorcé(e)","1942-02-10",{"$f":"DATEDIF(E23,TODAY(),\"y\")","v":81},{"$f":"IF(F23<25,0,IF(F23<35,1,IF(F23<45,2,IF(F23<55,3,4))))","v":4},"Personnel",{"$f":"VLOOKUP(H23,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},{"$f":"I23+5%*G23*I23","v":1920}]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H24,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Foupasune","Jean","m","Célibataire","1975-08-07",47,3,"Personnel",{"$f":"VLOOKUP(H25,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1840]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H26,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1760]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",67,4,"Personnel",{"$f":"VLOOKUP(H27,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H28,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1840]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H29,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",63,4,"Personnel",{"$f":"VLOOKUP(H30,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H31,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1840]
[null,null,null,null,null,null,null,"Moyenne Personnel",null,{"$f":"SUBTOTAL(1,J21:J31)","v":1864}]
[null,null,"Moyenne m",null,null,null,null,null,null,{"$f":"SUBTOTAL(1,J23:J31)","v":1857.7777777777778}]
["Noux","Marion","f","Divorcé(e)","1978-12-30",{"$f":"DATEDIF(E34,TODAY(),\"y\")","v":44},{"$f":"IF(F34<25,0,IF(F34<35,1,IF(F34<45,2,IF(F34<55,3,4))))","v":2},"Secrétariat",{"$f":"VLOOKUP(H34,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},{"$f":"I34+5%*G34*I34","v":1870}]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",{"$f":"DATEDIF(E35,TODAY(),\"y\")","v":64},{"$f":"IF(F35<25,0,IF(F35<35,1,IF(F35<45,2,IF(F35<55,3,4))))","v":4},"Secrétariat",{"$f":"VLOOKUP(H35,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},{"$f":"I35+5%*G35*I35","v":2040}]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",{"$f":"DATEDIF(E36,TODAY(),\"y\")","v":57},{"$f":"IF(F36<25,0,IF(F36<35,1,IF(F36<45,2,IF(F36<55,3,4))))","v":4},"Secrétariat",{"$f":"VLOOKUP(H36,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},{"$f":"I36+5%*G36*I36","v":2040}]
[null,null,null,null,null,null,null,"Moyenne Secrétariat",null,{"$f":"SUBTOTAL(1,J34:J36)","v":1983.3333333333333}]
[null,null,"Moyenne f",null,null,null,null,null,null,{"$f":"SUBTOTAL(1,J34:J36)","v":1983.3333333333333}]
[null,null,null,null,null,null,null,"Moyenne",null,{"$f":"SUBTOTAL(1,J7:J36)","v":2112.9545454545455}]

{"sheet":"Sous-Totaux3_corrigé","index":22,"n_rows":49,"n_cols":10,"rows_kept":49,"cut":false,"hidden":true,"merged":[]}
["Sous-Totaux"]
[]
["Utilisez les sous-totaux de façon à afficher le nombre d'employés et la moyenne des âges par sexe et par état civil."]
[]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":44},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":2},"Direction",{"$f":"VLOOKUP(H7,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},{"$f":"I7+5%*G7*I7","v":2750}]
[{"$f":"SUBTOTAL(3,A7:A7)","v":1},null,null,"Nombre Célibataire"]
[null,null,null,"Moyenne Célibataire",null,{"$f":"SUBTOTAL(1,F7:F7)","v":44}]
["Noux","Marion","f","Divorcé(e)","1978-12-30",{"$f":"DATEDIF(E10,TODAY(),\"y\")","v":44},{"$f":"IF(F10<25,0,IF(F10<35,1,IF(F10<45,2,IF(F10<55,3,4))))","v":2},"Secrétariat",{"$f":"VLOOKUP(H10,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},{"$f":"I10+5%*G10*I10","v":1870}]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",{"$f":"DATEDIF(E11,TODAY(),\"y\")","v":64},{"$f":"IF(F11<25,0,IF(F11<35,1,IF(F11<45,2,IF(F11<55,3,4))))","v":4},"Secrétariat",{"$f":"VLOOKUP(H11,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},{"$f":"I11+5%*G11*I11","v":2040}]
[{"$f":"SUBTOTAL(3,A10:A11)","v":2},null,null,"Nombre Divorcé(e)"]
[null,null,null,"Moyenne Divorcé(e)",null,{"$f":"SUBTOTAL(1,F10:F11)","v":54}]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",{"$f":"DATEDIF(E14,TODAY(),\"y\")","v":63},{"$f":"IF(F14<25,0,IF(F14<35,1,IF(F14<45,2,IF(F14<55,3,4))))","v":4},"Personnel",{"$f":"VLOOKUP(H14,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},{"$f":"I14+5%*G14*I14","v":1920}]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",{"$f":"DATEDIF(E15,TODAY(),\"y\")","v":57},{"$f":"IF(F15<25,0,IF(F15<35,1,IF(F15<45,2,IF(F15<55,3,4))))","v":4},"Secrétariat",{"$f":"VLOOKUP(H15,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},{"$f":"I15+5%*G15*I15","v":2040}]
[{"$f":"SUBTOTAL(3,A14:A15)","v":2},null,null,"Nombre Marié(e)"]
[null,null,null,"Moyenne Marié(e)",null,{"$f":"SUBTOTAL(1,F14:F15)","v":60}]
[null,null,"Moyenne f",null,null,{"$f":"SUBTOTAL(1,F7:F15)","v":54.4}]
[{"$f":"SUBTOTAL(3,A7:A15)","v":5},null,"Nombre f"]
["Deuf","John","m","Célibataire","1963-09-08",{"$f":"DATEDIF(E20,TODAY(),\"y\")","v":59},{"$f":"IF(F20<25,0,IF(F20<35,1,IF(F20<45,2,IF(F20<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H20,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},{"$f":"I20+5%*G20*I20","v":2280}]
["Foupasune","Jean","m","Célibataire","1975-08-07",47,3,"Personnel",{"$f":"VLOOKUP(H21,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1840]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H22,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2185]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",67,4,"Personnel",{"$f":"VLOOKUP(H23,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H24,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1840]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H25,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1760]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H26,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1840]
[{"$f":"SUBTOTAL(3,A20:A26)","v":7},null,null,"Nombre Célibataire"]
[null,null,null,"Moyenne Célibataire",null,{"$f":"SUBTOTAL(1,F20:F26)","v":53.285714285714285}]
["Covert","Harry","m","Divorcé(e)","1942-02-10",{"$f":"DATEDIF(E29,TODAY(),\"y\")","v":81},{"$f":"IF(F29<25,0,IF(F29<35,1,IF(F29<45,2,IF(F29<55,3,4))))","v":4},"Personnel",{"$f":"VLOOKUP(H29,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},{"$f":"I29+5%*G29*I29","v":1920}]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",{"$f":"DATEDIF(E30,TODAY(),\"y\")","v":70},{"$f":"IF(F30<25,0,IF(F30<35,1,IF(F30<45,2,IF(F30<55,3,4))))","v":4},"Direction",{"$f":"VLOOKUP(H30,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},{"$f":"I30+5%*G30*I30","v":3000}]
["Tare","Guy","m","Divorcé(e)","1960-08-07",{"$f":"DATEDIF(E31,TODAY(),\"y\")","v":62},{"$f":"IF(F31<25,0,IF(F31<35,1,IF(F31<45,2,IF(F31<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H31,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},{"$f":"I31+5%*G31*I31","v":2280}]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",{"$f":"DATEDIF(E32,TODAY(),\"y\")","v":57},{"$f":"IF(F32<25,0,IF(F32<35,1,IF(F32<45,2,IF(F32<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H32,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},{"$f":"I32+5%*G32*I32","v":2280}]
[{"$f":"SUBTOTAL(3,A29:A32)","v":4},null,null,"Nombre Divorcé(e)"]
[null,null,null,"Moyenne Divorcé(e)",null,{"$f":"SUBTOTAL(1,F29:F32)","v":67.5}]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E35,TODAY(),\"y\")","v":57},{"$f":"IF(F35<25,0,IF(F35<35,1,IF(F35<45,2,IF(F35<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H35,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},{"$f":"I35+5%*G35*I35","v":2280}]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H36,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},2750]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H37,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H38,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1760]
["Proviste","Alain","m","Marié(e)","1959-09-09",63,4,"Personnel",{"$f":"VLOOKUP(H39,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H40,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2090]
[{"$f":"SUBTOTAL(3,A35:A40)","v":6},null,null,"Nombre Marié(e)"]
[null,null,null,"Moyenne Marié(e)",null,{"$f":"SUBTOTAL(1,F35:F40)","v":50.166666666666664}]
[null,null,"Moyenne m",null,null,{"$f":"SUBTOTAL(1,F20:F40)","v":55.529411764705884}]
[{"$f":"SUBTOTAL(3,A20:A40)","v":17},null,"Nombre m"]
[null,null,null,"Nbval"]
[null,null,"Moyenne",null,null,{"$f":"SUBTOTAL(1,F7:F40)","v":55.272727272727273}]
[null,null,null,"Moyenne Nbval",null,{"$f":"SUBTOTAL(1,F45:F45)","v":{"$error":"#DIV/0!"}}]
[{"$f":"SUBTOTAL(3,A7:A40)","v":22},null,"Nbval"]
[null,null,null,"Moyenne",null,{"$f":"SUBTOTAL(1,F7:F45)","v":55.272727272727273}]

{"sheet":"Fonctions classiques_corrigé","index":23,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Utilisation des fonctions classiques",null,null,null,null,null,null,null,null,null,null,null,"Retour sommaire"]
[]
["Utilisez les fonctions classiques de façon à afficher le nombre d'employés par service."]
["Utilisez les fonctions classiques de façon à afficher le nombre d'employés et la moyenne des âges par sexe et par état civil."]
[]
["Nom","Prénom","Sexe","Etat civil","Date de naissance","Age","Tranches","Services","Salaires Minimum","Salaires"]
["Bistrot","Alonso","m","Marié(e)","1966-01-17",{"$f":"DATEDIF(E7,TODAY(),\"y\")","v":57},{"$f":"IF(F7<25,0,IF(F7<35,1,IF(F7<45,2,IF(F7<55,3,4))))","v":4},"Informatique",{"$f":"VLOOKUP(H7,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},{"$f":"I7+5%*G7*I7","v":2280},null,null,"Nombre d'employés par service"]
["Bijoba","Jo","m","Marié(e)","1980-03-15",43,2,"Direction",{"$f":"VLOOKUP(H8,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},2750]
["Covert","Harry","m","Divorcé(e)","1942-02-10",81,4,"Personnel",{"$f":"VLOOKUP(H9,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920,null,null,"Direction",{"$f":"COUNTIF($H$7:$H$28,M9)","v":3}]
["Culaire","Laury","m","Marié(e)","1965-05-05",58,4,"Personnel",{"$f":"VLOOKUP(H10,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920,null,null,"Informatique",{"$f":"COUNTIF($H$7:$H$28,M10)","v":6}]
["Deuf","John","m","Célibataire","1963-09-08",59,4,"Informatique",{"$f":"VLOOKUP(H11,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280,null,null,"Personnel",{"$f":"COUNTIF($H$7:$H$28,M11)","v":10}]
["Foupasune","Jean","m","Célibataire","1975-08-07",47,3,"Personnel",{"$f":"VLOOKUP(H12,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1840,null,null,"Secrétariat",{"$f":"COUNTIF($H$7:$H$28,M12)","v":3}]
["Lairbon","Oussama","m","Marié(e)","1983-02-08",40,2,"Personnel",{"$f":"VLOOKUP(H13,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1760]
["Menvussa","Gérard","m","Célibataire","1970-12-04",52,3,"Informatique",{"$f":"VLOOKUP(H14,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2185,null,null,"Nombre d'employés par sexe et état civil"]
["Lalalalalalala","Starsky","m","Célibataire","1955-07-08",67,4,"Personnel",{"$f":"VLOOKUP(H15,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920]
["Lalalalalalala","Hutch","m","Divorcé(e)","1952-10-07",70,4,"Direction",{"$f":"VLOOKUP(H16,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},3000,null,null,null,"f","m"]
["Cléssoulaporte","Djamila","f","Marié(e)","1959-09-07",63,4,"Personnel",{"$f":"VLOOKUP(H17,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920,null,null,"Célibataire",{"$f":"COUNTIFS($C$7:$C$28,N$16,$D$7:$D$28,$M17)","v":1},7]
["Noux","Marion","f","Divorcé(e)","1978-12-30",44,2,"Secrétariat",{"$f":"VLOOKUP(H18,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},1870,null,null,"Divorcé(e)",2,4]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H19,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1840,null,null,"Marié(e)",2,6]
["Stiké","Sophie","f","Divorcé(e)","1959-04-04",64,4,"Secrétariat",{"$f":"VLOOKUP(H20,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},2040]
["Tare","Guy","m","Divorcé(e)","1960-08-07",62,4,"Informatique",{"$f":"VLOOKUP(H21,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280,null,null,"Salaire moyen par sexe et état civil"]
["Vaisselle","Aude","f","Marié(e)","1966-06-06",57,4,"Secrétariat",{"$f":"VLOOKUP(H22,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1700},2040]
["Zetofrais","Mélanie","f","Célibataire","1978-11-25",44,2,"Direction",{"$f":"VLOOKUP(H23,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":2500},2750,null,null,null,"f","m"]
["Touille","Sasha","m","Célibataire","1982-10-30",40,2,"Personnel",{"$f":"VLOOKUP(H24,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1760,null,null,"Célibataire",{"$f":"AVERAGEIFS($J$7:$J$28,$C$7:$C$28,N$23,$D$7:$D$28,$M24)","v":2750},{"$f":"AVERAGEIFS($J$7:$J$28,$C$7:$C$28,O$23,$D$7:$D$28,$M24)","v":1952.1428571428571}]
["Proviste","Alain","m","Marié(e)","1959-09-09",63,4,"Personnel",{"$f":"VLOOKUP(H25,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1920,null,null,"Divorcé(e)",{"$f":"AVERAGEIFS($J$7:$J$28,$C$7:$C$28,N$23,$D$7:$D$28,$M25)","v":1955},2370]
["Peulaporte","Firmin","m","Divorcé(e)","1965-07-01",57,4,"Informatique",{"$f":"VLOOKUP(H26,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2280,null,null,"Marié(e)",1980,2120]
["Unetitlaine","Jérémy","m","Marié(e)","1983-06-09",40,2,"Informatique",{"$f":"VLOOKUP(H27,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1900},2090]
["Ouzi","Jacques","m","Célibataire","1969-02-28",54,3,"Personnel",{"$f":"VLOOKUP(H28,Applic2_consignes!$C$34:$D$37,2,FALSE)","v":1600},1840]

{"sheet":"TCD1_corrigé","index":24,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Utilisez les tableaux croisés dynamiques de façon à afficher le nombre d'employés par service."]
[]
[]
[]
[]
[null,"Nombre de Nom"]
[null,"Services","Total"]
[null,"Direction",3]
[null,"Informatique",6]
[null,"Personnel",10]
[null,"Secrétariat",3]
[null,"Total général",22]

{"sheet":"TCD2_corrigé","index":25,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Utilisez les tableaux croisés dynamiques de façon à afficher le salaire moyen par service et par sexe."]
[]
[]
[]
[null,"Moyenne de Salaires","Sexe"]
[null,"Services","f","m","Total général"]
[null,"Direction",2750,2875,2833.3333333333335]
[null,"Informatique",null,2200.8333333333335,2200.8333333333335]
[null,"Personnel",1920,1840,1848]
[null,"Secrétariat",1955,null,1955]
[null,"Total général",2107,2089.1176470588234,2093.181818181818]

{"sheet":"TCD3_corrigé","index":26,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Utilisez les tableaux croisés dynamiqes de façon à afficher le nombre d'employés et la moyenne des âges par sexe et par état civil."]
[]
[]
[]
[]
[null,null,"Sexe","Données"]
[null,null,"f",null,"m"]
[null,"Etat civil","Nombre","Moyenne des Ages","Nombre","Moyenne des Ages"]
[null,"Célibataire",1,40,7,49.857142857142854]
[null,"Divorcé(e)",2,50,4,64.25]
[null,"Marié(e)",2,56.5,6,46.333333333333336]
[null,"Total général",5,50.6,17,52]

{"sheet":"TCD4_corrigé","index":27,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Utilisez les tableaux croisés dynamiques de façon à afficher le nombre d'employés ayant un salaire compris entre 1600 et 1800, entre 1800 et 2000 et ainsi de suite jusque 3000."]
[]
[]
[]
[]
[null,"Nombre de Nom"]
[null,"Salaires","Total"]
[null,"1600-1799",3]
[null,"1800-1999",9]
[null,"2000-2199",5]
[null,"2200-2399",2]
[null,"2600-2799",2]
[null,"2800-3000",1]
[null,"Total général",22]

{"sheet":"TCD5_corrigé","index":28,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Afin d'établir un budget 'anniversaire', la société souhaite savoir quel est le nombre de personnes nées par mois."]
["Etablir un TCD fournissant ces rensigenements."]
[]
[]
[]
[null,"Nombre de Nom"]
[null,"Date de naissance","Total"]
[null,"janv",1]
[null,"févr",4]
[null,"mars",1]
[null,"avr",1]
[null,"mai",1]
[null,"juin",2]
[null,"juil",2]
[null,"août",2]
[null,"sept",3]
[null,"oct",2]
[null,"nov",1]
[null,"déc",2]
[null,"Total général",22]

{"sheet":"TCD6_corrigé","index":29,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Créez un TCD donnant le pourcentage de femmes et d'hommes par service."]
["A partir de ça, créez un graphique croisé dynamique représentant ce pourcentage en 'histogramme'."]
[]
[]
[]
[null,"Nombre de Nom","Sexe"]
[null,"Services","f","m"]
[null,"Direction",0.33333333333333331,0.66666666666666663]
[null,"Informatique",0,1]
[null,"Personnel",0.1,0.9]
[null,"Secrétariat",1,0]
[null,"Total général",0.22727272727272727,0.77272727272727271]