{"text_format":"1","workbook":"xlsx","n_sheets":30,"sheets":["Réglage","1","2","3","4","5","6","7","8","8bis","9","10","11","12","13","14","15","15 bis","16","17","18","19","20","21","22","23","24","25","26","F I N"],"not_rendered":{"charts":0,"images":23,"macros":1,"external_links":0,"defined_names":3,"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":"Réglage","index":0,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[" page 0"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Choix du zoom :",100]

{"sheet":"1","index":1,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[" page 1"]
[]
[]
[]
[]
[]
[]
[]
[null,"Feuille",1,null,"Accueil, table des matières"]
[null,null,2,null,"Principes de base"]
[null,null,3,null,"Une cellule"]
[null,null,4,null,"Barre de formule"]
[null,null,6,null,"La souris"]
[null,null,7,null,"Fusion de cellules"]
[null,null,8,null,"Ajustement des colonnes"]
[null,null,9,null,"Programmation"]
[null,null,10,null,"L'assistant…"]
[null,null,11,null,"Format des nombres"]
[null,null,13,null,"Programmer un tableau"]
[null,null,14,null,"Faire un graphique"]
[null,null,15,null,"Adresses absolues"]
[null,null,16,null,"Exercice sur un tableau"]
[null,null,17,null,"Quiz de démonstration"]
[null,null,18,null,"Réalisation d'un quiz"]
[null,null,19,null,"\"        recherche d'éléments"]
[null,null,21,null,"\"        les macros"]
[null,null,23,null,"\"        les boutons"]
[null,null,24,null,"Votre propre QUIZ"]
[null,null,25,null,"Résumé formulaires et macros"]
[null,null,26,null,"Derniers petits conseils !"]
[null,null,"fin"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"     © Y. Péguiron 2007"]

{"sheet":"2","index":2,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[0,1,1,10]]}
["page 2","Un tableur c'est une feuille de calculs…"]
[]
[]
[]
[null,"Théorie :"]
[]
[null,null,null,null,null,null,null,null,null,"chien"]
[null,null,null,null,null,null,null,null,"chat"]
[]
[null,null,null,null,null,null,null,null,null,"souris"]
[null,null,null,null,null,null,null,null,null,null,"poisson"]
[]
[null,null,null,null,null,null,null,null,"éléphant"]
[]
[]
[]
[null,"Exercice 1"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"test Q1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I21=\"j7\",1,0)","v":0}]
[null,null,null,null,null,"Cliquez et répondez ici",null," -------------->",null,null,null,"    ",null,null,{"$f":"IF(I21=\"j 7\",1,0)","v":0}]
[null,null,null,null,null,"puis pressez RETURN",null,null,{"$f":"IF(I21=\"\",\"\",IF(O23=1,\"Bravo !\",\"Non, cherchez encore\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O20:O22)","v":0}]
[]
[]
[null,"Exercice 2",null,null,null,null,null,null,null,null,null,null,null,null,"test Q2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($I$30=\"k11\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($I$30=\"k 11\",1,0)","v":0}]
[]
[null,null,null,null,null,"Cliquez et répondez ici",null," -------------->",null,null,null,null,null,null,{"$f":"SUM(O27:O29)","v":0}]
[null,null,null,null,null,"puis pressez RETURN",null,null,{"$f":"IF(I30=\"\",\"\",IF(O30=1,\"Bravo !\",\"Non, cherchez encore\"))","v":""}]
[]
[null,null,null,null,null,null,null,{"$f":"IF(O30=0,\"\",IF(O30=1,\"Vous pouvez passez à la fenêtre suivante...\",\"\"))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,"    "]

{"sheet":"3","index":3,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[[16,2,16,6],[4,1,4,3],[13,2,13,6],[14,2,14,6],[15,2,15,6]]}
["page 3"]
[]
[null,null,null,null,"du texte"," ----->","Bonjour"]
[]
[null,"Une cellule peut contenir :",null,null,"un nombre"," ----->",5]
[]
[null,null,null,null,"une formule "," ----->"," = 3 * G49 + 0.57"]
[]
[]
[]
[]
[null,"Exercice 3 :","Tapez la lettre \"v\" (comme vu) dans la bonne colonne !",null,null,null,null,"oui","non"]
[null,null,"Par défaut, dans une cellule, …",null,null,null,null,null,null,null,null,null,null,null,"test Q1"]
[null,null,"1) ... les mots doivent commencer par une majuscule",null,null,null,null,null,null,null,null," ",null,null,{"$f":"IF(H14=\"\",IF(I14=\"v\",1,0),10)","v":0}]
[null,null,"2) ... les nombres s'alignent automatiquement sur la droite",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I15=\"\",IF(H15=\"v\",1,0),10)","v":0}]
[null,null,"3) ... les formules commencent toujours par le signe \"égal\"",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(I16=\"\",IF(H16=\"v\",1,0),10)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O14:O16)","v":0}]
[null,null,null,null,null,null,"(Validez la dernière réponse"]
[null,null,null,null,null,null,"avec la touche Return\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"IF(O17>4,\"Je ne suis pas satisfait de votre réponse !!!\",\"\")","v":""}]
[]
[null,null,null,null,null,{"$f":"IF(O17=3,\"Bonnes réponses...\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,"    "]
[null,null,null,null,null,{"$f":"IF(O17=3,\"vous pouvez passer à la feuille suivante...\",\"\")","v":""}]

{"sheet":"4","index":4,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[[1,1,1,9],[5,1,5,3],[8,3,9,3]]}
["page 4"]
[null,"Quelques définitions"]
[]
[null,"Cellule active :"]
[]
[]
[]
[]
[null,null,null," "]
[null,null,"Vous m'avez trouvée, félicitation !!!"]
[]
[]
[]
[null,null,"Exercice 4"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Barre de formule :"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Message :     I love you so much my friend !","         "]
[]
[null,null,"Exercice 5"]

{"sheet":"5","index":5,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[33,1,33,6]]}
["page 5"]
[]
[null,"Constantes : "]
[]
[]
[]
[]
[]
[]
[]
[null,"Variables :"]
[]
[null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Exercice 6 :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Collecte de la classe pour la Croix-Rouge"]
[null,"groupe Alex","groupe Marie","groupe Annie","groupe Steve"]
[null,140,200,220,85,"Moyenne =",null,null,{"$f":"IF(G36=\"\",\"\",IF(G36=AVERAGE(B36:E36),\"Bien, c'est juste\",\"\"))","v":""}]
[]
[null,null,null,null,{"$f":"IF(G36=\"\",\"\",IF(G36<>AVERAGE(B36:E36),\"Je crois que vous n'avez pas bien recopié la formule rouge !\",\"\"))","v":""}]

{"sheet":"6","index":6,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["page 6"]
[]
[null,"La souris :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Exercice 7"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,0]

{"sheet":"7","index":7,"n_rows":39,"n_cols":17,"rows_kept":39,"cut":false,"hidden":false,"merged":[[2,1,2,4],[16,1,16,8],[11,1,11,8]]}
["page 7"]
[]
[null,"Corriger le texte d' une cellule :"]
[]
[]
[]
[]
[]
[]
[]
[null,"Exercice 8"]
[null,"Le texte ci-dessous n'a pas été vérifié. Veuillez corriger les fautes d'orthographe…"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"test phrase",null,"  "]
[null,"La plus perdue de toute les journées et celle où l'on à pas rit.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B14=\"La plus perdue de toute les journées et celle où l'on à pas rit.\",0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B14=\"La plus perdue de toutes les journées est celle où l'on n'a pas ri.\",10,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O14:O15)","v":0}]
[null,{"$f":"IF(O16=0,\"\",IF(O16>9,\"Bravo, ce texte est bien corrigé !\",\"Il reste encore des fautes…\"))","v":""}]
[]
[]
[null,"Fusionner des cellules pour y placer du texte :"]
[]
[]
[]
[]
[]
[null,"Musiciens italiens",null,"  "]
[null,"Renaissance",null,"Monteverdi"]
[null,"Classicisme et baroque",null,"Vivaldi, Albinoni"]
[null,"Romantisme","Rossini, Verdi, Bellini"]
[]
[]
["   Exercice 9"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"o"]

{"sheet":"8","index":8,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":false,"merged":[[24,1,24,3],[2,1,2,6]]}
["page 8"]
[]
[null,"Ajuster les colonnes et les lignes :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Exercice 10"]
[]
[]
[]
[null,"Divinités"]
[null,"Hellénique ","Latine ","Statut "]
[]
[null,"Aphrodite ","Vénus ","déesse de la Beauté et de l’Amour ","  "]
[null,"Arès ","Mars ","dieu de la Guerre "," "]
[null,"Artémis ","Diane ","déesse de la Chasse "," "]
[null,"Athéna ","Minerve ","déesse de l’Intelligence, de la Raison, des Arts"," "]
[null,"Éros ","Cupidon ","fils d’Aphrodite, dieu de l’Amour "," "]
[null,"Hermès ","Mercure ","dieu messager des Olympiens, guide des voyageurs,  protecteur des marchands"," "]
[null,"Poséidon ","Neptune ","dieu des Mers, de l’Élément liquide et desTremblements de terre "," "]
[null,"Zeus ","Jupiter ","divinité suprême du panthéon des Anciens, dieu des phénomènes physiques ","  "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"o"]

{"sheet":"8bis","index":9,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[[20,1,20,2]]}
["page 8 bis"]
[]
[null,"Déplacer des cellules ou des colonnes"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Exercice 10 bis"]
[]
[]
[]
[null,"Divinités"]
[null,"Hellénique ","Latine ",null,"E",null,"F"]
[]
[null,"Aphrodite",null,null,"Zeus",null,"Hermès"]
[null,"Arès","Mars",null,"Vénus",null,"Diane"]
[null,"Artémis",null,null,"Cupidon",null,"Neptune"]
[null,"Athéna","Minerve"]
[null,"Eros"]
[null,null,"Mercure",null," "]
[null,"Poséidon"]
[null,null,"Jupiter"]
[]
[null,null,null,null,null,null,null,null,0,"/ 6"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"o"]

{"sheet":"9","index":10,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[[2,1,2,6],[23,1,23,3]]}
["page 9"]
[]
[null,"Assez joué… programmez maintenant  !"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Voici une liste de nombres : ",null,null,115]
[null,null,null,null,25]
[null,null,null,null,48]
[null,null,null,null,5.5]
[null,null,null,null,78.25]
[null,null,null,"Somme",{"$f":"SUM(E24:E28)","v":271.75}]
[null,null,null,"Moyenne"]
[]
[]
[]
[null,"Exercice 11"]
[]
[]
[]
[null,null,{"$f":"IF(E30=\"\",\"\",IF(E30<>AVERAGE(E24:E28),\"Erreur, vous n'avez pas la moyenne!\",\"Bravo, vous savez programmez ! Passez à la 2ème méthode\"))","v":""}]

{"sheet":"10","index":11,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[30,2,30,3],[32,1,32,3],[31,1,31,3],[2,1,2,6],[23,1,23,3],[28,2,28,3],[29,2,29,3]]}
["page 10"]
[]
[null,"Programmation, 2ème méthode…"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Exercice 12"]
[null,"Voici une liste de nombres : ",null,null,124.25]
[null,null,null,null,234]
[null,null,null,null,987.5]
[null,null,null,null,112.3]
[null,null,null,null,456.65,null,null,null,null,null,null,null,null,null,"test v"]
[null,null,"Somme",null,null,{"$f":"IF(E29=\"\",\"\",IF(E29=SUM(E24:E28),\"v\",\"x\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(F29=\"v\",1,0)","v":0}]
[null,null,"Moyenne",null,null,{"$f":"IF(E30=\"\",\"\",IF(E30=AVERAGE(E24:E28),\"v\",\"x\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(F30=\"v\",1,0)","v":0}]
[null,null,"Nombre d'éléments (NB)",null,null,{"$f":"IF(E31=\"\",\"\",IF(E31=COUNT(E24:E28),\"v\",\"x\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(F31=\"v\",1,0)","v":0}]
[null,"Le plus grand nombre (MAX)",null,null,null,{"$f":"IF(E32=\"\",\"\",IF(E32=MAX(E24:E28),\"v\",\"x\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(F32=\"v\",1,0)","v":0}]
[null,"Arrondir la somme à l'unité inf.",null,null,null,{"$f":"IF(E33=\"\",\"\",IF(E33=(ROUNDDOWN(E29,0)),\"v\",\"x\"))","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(F33=\"v\",1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O29:O33)","v":0}]
[]
[]
[]
[null,null,{"$f":"IF(O34=0,\"\",IF(O34=5,\"Magnifique, toutes vos formules sont justes\",\"Encore un petit effort !\"))","v":""}]

{"sheet":"11","index":12,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,6,3,8],[22,6,22,8]]}
["page 11"]
[]
[null,"Format des nombres :"]
[null,null,null,null,null,null,"Voici une liste de nombres : ",null,null,124.26]
[null,null,null,null,null,null,null,null,null,234]
[null,null,null,null,null,null,null,null,null,987.57]
[null,null,null,null,null,null,null,null,null,0.1235]
[null,null,null,null,null,null,null,null,null,1095.4880000000001]
[null,null,null,null,null,null,null,null,null,112.3111]
[null,null,null,null,null,null,null,null,null,456.64]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J4:J10)","v":3010.3925999999997}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Exercice 13"]
[]
[null,null,null,null,null,null,"Voici une liste de nombres : ",null,null,124.26]
[null,null,null,null,null,null,null,null,null,234]
[null,null,null,null,null,null,null,null,null,987.57]
[null,null,null,null,null,null,null,null,null,0.12]
[null,null,null,null,null,null,null,null,null,1095.48]
[null,null,null,null,null,null,null,null,null,112.31]
[null,null,null,null,null,null,null,null,null,456.64]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J23:J29)","v":3010.3799999999997}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"o"]

{"sheet":"12","index":13,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[[17,1,17,5],[33,5,33,6],[34,5,34,6],[36,1,36,8],[35,1,35,8],[19,6,19,8]]}
["page 12"]
[]
[null,"Format des cellules :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Bouteilles de Champagne"]
[]
[null,"Capacité","Nom",null,"Capacité","Nom"]
[null,"1/8 litre","Baby",null,"6 litres","Réhoboam"]
[null,"1/4 litre","Quart",null,"8 litres","Mathusalem"]
[null,"1 litre","Bouteille",null,"16 litres","Balthazar"]
[null,"2 litres","Magnum",null,"20 litres","Nabuchodonozor"]
[null,"4 litres","Jéroboam"]
[]
[]
[null,"Exercice 14",null,null,null,"Exercice 15"]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Cliquez et répondez ici",null," --------->"]
[null,null,null,null,null,"puis pressez RETURN"]
[null,{"$f":"IF(I34=\"\",\"\",IF($I$34=9,\"\",\"Cliquez sur Champagne puis allez dans le menu Alignement,\"))","v":""}]
[null,{"$f":"IF(I34=\"\",\"\",IF($I$34=9,\"Mes félicitations…\",\"vous trouverez la solution sous le tableau d'orientation.\"))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,"o"]

{"sheet":"13","index":14,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[[19,3,19,8]]}
["page 13"]
[]
[null,"Polycopier des formules :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Exercice 16"]
[]
[]
[]
[]
[null,null,null,"Chiffre d'affaires"]
[null,null,null,"Janv. - Mars","Avril - Juin","Juil. - Sept.","Oct. - Déc.","Total","Moyenne"]
[null,"Magasin Genève",null,365004,355603,426532,326471,{"$f":"SUM(D22:G22)","v":1473610},{"$f":"AVERAGE(D22:G22)","v":368402.5}]
[null,"Magasin Crissier",null,426897,405567,388566,399856]
[null,"Magasin Sion",null,224856,285565,310204,275560]
[null,"Magasin Marin",null,185120,153491,195602,228555]
[null,null,"Total",{"$f":"SUM(D22:D25)","v":1201877}]
[null,null,"Moy.",{"$f":"AVERAGE(D22:D25)","v":300469.25}]
[]
[]
[]
[]
[null,"Aide :",{"$f":"IF(H25=SUM(D25:G25),IF(G26=SUM(G22:G25),\"Félicitation, vous êtes champion de la souris !!!\",\"\"),\"\")","v":""}]
[null,"Sélectionner une ou plusieurs cellules vertes avec le bouton gauche, tirer,dans la direction souhaitée, "]
[null,"le petit rectangle situé dans l'angle inférieur droite du rectangle sélectionné."]

{"sheet":"14","index":15,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["page 14"]
[]
[null,"Les graphiques :"]
[]
[null,"Tableau de la page 11"]
[null,null,null,"Chiffre d'affaires"]
[null,null,null,"Janv. - Mars","Avril - Juin","Juil. - Sept.","Oct. - Déc.","Total","Moyenne"]
[null,"Magasin Genève",null,365004,355603,426532,326471,{"$f":"SUM(D8:G8)","v":1473610},{"$f":"AVERAGE(D8:G8)","v":368402.5}]
[null,"Magasin Crissier",null,426897,405567,388566,399856]
[null,"Magasin Sion",null,224856,285565,310204,275560]
[null,"Magasin Marin",null,185120,153491,195602,228555]
[null,null,"Total",{"$f":"SUM(D8:D11)","v":1201877}]
[null,null,"Moy.",{"$f":"AVERAGE(D8:D11)","v":300469.25}]
[]
[]
[null,"Exercice 17"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Question :"]
[]
[]
[null,5,{"$f":"IF(B39=3,\"Bien vu !  Sacrés valaisans…\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"o"]

{"sheet":"15","index":16,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[7,1,7,2],[5,1,5,5]]}
["page 15"]
[]
[null,"Adresses relatives et adresses absolues…"]
[]
[]
[null,"Table de multiplication"]
[]
[null,"Livret :",null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pour format"]
[null,1,"x",{"$f":"D8","v":3}," =",{"$f":"B10*D8","v":3},null,null,null,null,null,null,null,null,1]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[" ",null,null,null,null,null,"Exercice 18",null,null,null,null,null,null,null,10]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["  Exercice 19"]
[null,null,null,null,null,null,null,null,{"$f":"IF(F24=15*D8,\"Bravo, votre table a bonne allure !\",\"\")","v":""}]

{"sheet":"15 bis","index":17,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[7,1,7,2],[5,1,5,5]]}
["page 15 bis"]
[]
[null,"Adresses relatives et adresses absolues…"]
[]
[]
[null,"Table de multiplication"]
[]
[null,"Livret :",null,7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pour format"]
[null,1,"x",{"$f":"D8","v":7}," =",{"$f":"B10*D8","v":7},null,null,null,null,null,null,null,null,1]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,4]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,10]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[" ",null,null,null,null,null,"Exercice 19bis",null,null,null,null,null,null,null,15]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF(F24=15*D8,\"Vous voyez, ça marche !\",\"Allez-y, faites l'exercice\")","v":"Allez-y, faites l'exercice"}]
[null,null,null,null,null,null,null,null,{"$f":"IF(F24=15*D8,\"Bravo, votre table a bonne allure !\",\"\")","v":""}]

{"sheet":"16","index":18,"n_rows":33,"n_cols":23,"rows_kept":33,"cut":false,"hidden":false,"merged":[[31,5,31,8],[32,2,32,3],[26,20,27,20],[26,21,27,21],[28,16,29,16],[28,17,29,17],[28,18,29,18],[28,19,29,19],[28,20,29,20],[28,21,29,21],[22,16,22,21],[24,16,25,16],[24,17,25,17],[24,18,25,18],[24,19,25,19],[28,7,29,7],[24,20,25,20],[24,21,25,21],[24,2,25,2],[24,3,25,3],[26,6,27,6],[26,7,27,7],[26,2,27,2],[26,3,27,3],[26,4,27,4],[26,5,27,5],[26,16,27,16],[26,17,27,17],[26,18,27,18],[26,19,27,19],[28,2,29,2],[28,3,29,3],[28,4,29,4],[28,5,29,5],[28,6,29,6],[13,8,13,9],[14,8,14,9],[15,8,15,9],[24,4,25,4],[24,5,25,5],[24,6,25,6],[24,7,25,7],[13,6,14,7],[22,2,22,7]]}
["page 16"]
[]
[null,"Un peu de pratique…"]
[]
[]
[null,"Chiffres 2000","Fribourg","Vaud","Valais","Neuchâtal","Genève","Jura","Suisse","Romandie"]
[null,"Population",235100,623400,271700,166200,403100,67300,7164400]
[null,"Recettes   en millions",1892,4880,1994,1324,5471,565,58842]
[null,"Dépenses  \"",1909,5079,1937,1349,5465,564,58316]
[null,"Excédent   \" "]
[null,"Excéd. par habitant en Fr."]
[]
[null,"Exercice 20"]
[null,null,null,null,null,null,null,null,"C10 = C8-C9"]
[null,null,null,null,null,null,null,null,"C11 = C10*1000000/C7"]
[null,null,null,null,null,null,null,null,"J7   = SOMME(C7:H7)"]
[]
[]
[null,"Exercice 21"]
[]
[]
[]
[null,null,"Statistiques",null,null,null,null,null,null,null,null,null,null,null,null,null,"Statistiques"]
[null,null,"Fribourg","Vaud","Valais","Neuchâtal","Genève","Jura",null,null,null,null,null,null,null,null,"Fribourg","Vaud","Valais","Neuchâtal","Genève","Jura"]
[null,"Population en % de",null,null,null,null,null,null,null,null,null,null,null,null,null,"Population en % ",{"$f":"C7*100/$I$7","v":3.2815029869912342},8.7013567081681646,3.7923622354977389,2.3198034727262575,5.6264306850538777,0.93936686952152304]
[null,"la Suisse (Suisse = 100%)",null,null,null,null,null,null,null,null,null,null,null,null,null,"de la Suisse"]
[null,"Population en % ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Population en % ",{"$f":"C7*100/$J$7","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"de la Romandie",null,null,null,null,null,null,null,null,null,null,null,null,null,"de la Romandie",null,null,null,null,null,null,"test résultat"]
[null,"Dépenses en %",null,null,null,null,null,null,null,null,null,null,null,null,null,"Dépenses en %",{"$f":"C9*100/$I$9","v":3.2735441388298239},8.7094450922559847,3.3215584059263326,2.3132587968996501,9.3713560600864252,0.96714452294396047]
[null,"de la Suisse",null,null,null,null,null,null,null,null,null,null,null,null,null,"de la Suisse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q25:Q30)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(Q31:V31)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"IF(H29=\"\",\"\",IF(W31=W33,\"Magnifique, votre tableau est parfait\",\"Désolé, votre tableau n'est pas correcte !\"))","v":""}]
[null,null,"C25 = C7*100 / $I7",null,null,null,null,null,null,null,null,null,null,null,null,"somme p14",{"$f":"SUM(C25:C30)","v":0},0,0,0,0,0,{"$f":"SUM(Q33:V33)","v":0}]

{"sheet":"17","index":19,"n_rows":47,"n_cols":25,"rows_kept":47,"cut":false,"hidden":false,"merged":[[9,2,9,10],[14,2,14,10],[16,0,16,2],[24,5,25,9]]}
["page 17"]
[]
[]
[null,"Un peu de détente…"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"no","Questions","Réponses","Réponses pour test",null,null,"Test réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Combien les adultes ont-ils de dents ?",32,32]
[null,null,"Question :",null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Comment s'appelle le château situé sur un îlot en face de Marseille ?","Château d'If","if","  ",null,"Réponse E","contenu"]
[null,1,{"$f":"VLOOKUP(B10,Q8:S47,2)","v":"Combien les adultes ont-ils de dents ?"},null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Quel est l'auteur du livre de la jungle ?","Rudyard Kipling","Kipling",null,null,{"$f":"F25","v":0},{"$f":"SEARCH(VLOOKUP(B10,Q8:T47,4),W10)","v":{"$error":"#VALUE!"}},{"$f":"IF(ISERR(X10)=TRUE,0,1)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Un homme a-t-il le droit d'épouser la sœur de sa veuve ?","Non, il est mort !","non"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Quel gaz est transporté par le sang","L'oxygène","oxygène",null,null,{"$f":"B10","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Qui inventa la dynamite","Alfred Nobel","nobel"]
[null,null,"Réponse :",null,null,null,null,null,null,null,null,null,null,null,null,null,7,"De quelle maladie le roi Louis IX mourut-il en 1270 ?","La peste","peste"]
[null,null,{"$f":"IF(W12=B10,VLOOKUP(B10,Q8:S47,3),\"\")","v":32},null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Quel est l'astre connu sous le nom de l'Etoile du berger ?","Vénus","vénus"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Qui était Jean Baptiste Poquelin ?","Molière","molière"]
["      Question suivante     ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Qui fut le dernier roi français ?","Louis-Philippe 1er","Louis-Philippe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Résultat de la division de 1000 par 1/2",2000,2000]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Quel mammifère pond des œufs ?","L'ornithorynque","ornithorynque"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"A quelle ère l'homme est-il apparu ?","Quaternaire (il y a 2,5 millions d'années)","quaternaire"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"Quelle est l'altitude du Kilimandjaro","5963 mètres",596]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Les 3 mots qui sont masculins au singulier et féminins au pluriel ?","Amour, délice et orgue","amour délice orgue"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"Quelle est la planète la plus proche du Soleil ?","Mercure","mercure"]
[null,null,"Ctrl s = voir solution",null,null,"Réponse écrite éventuelle :",null,null,null,null,null,null,null,null,null,null,17,"Quel ouvrage doit-on à Ferdinand de Lesseps ?","Canal de Suez","suez"]
[null,null,"Ctrl w = cacher la zone solution",null,null,null,null,null,null,null,null,null,null,null,null,null,18,"Quel est le prénom du plus petit des Dalton ?","Joe","joe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"Le dieu grec condamné à soutenir sur ses épaules la voûte céleste ?","Atlas","atlas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"Comment s'appelle le don d'être partout en même temps ?","Don d'ubiquité","ubiquité"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"Comment s'appelle l'aqueduc romain qui alimentait en eau Nîmes ?","Le pont du Gard","gard"]
[null,null,null,null,null,{"$f":"IF(F25=\"\",\"\",IF(Y10=1,\"B R A V O !\",\"Désolé, je n'ai pas cette réponse...\"))","v":""},null,null,null,null,null,null,null,null,null,null,22,"A quel sport joue-t-on traditionnellement à Bayonne ?","La pelote basque","pelote"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"A quelle date les Alliés débarquèrent-ils en Normandie","6 juin 1944","1944-06-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"Nom des guerres menées par les chrétiens pour prendre Jérusalem ?","Les croisades (XI et XIIe siècle)","croisades"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"Combien pèse un sac de 7,750 kg après lui avoir enlevé 8 hg et 5 dag ?","6,9 kg","6,9"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"Comment s'appelle le jour le plus long de l'année ?","Solstice d'été","solstice"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"Où est né Léonard de Vinci en 1452 ?","A Vinci près de Florence !","vinci"]
[null,null,{"$f":"IF(B10=40,\"Fini de rigoler… maintenant, à vous de créer un quiz !\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,28,"Comment s'appelle le tempe grec construit sur l'Acropole (Athènes) ?","Le Parthénon","parthénon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"Comment s'appellent les glandes qui sécrètent les larmes ?","Glandes lacrymales","lacrymales"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,"Contre quelle maladie protège le vaccin \"bacille Calmette-Guérin\" ? ","B.C.G. contre la tuberculose","tuberculose"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,"Comment s'appellent les parties du cœur qui envoient le sang dans les artères ?","Les ventricules","ventricule"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32,"Quel est le chef-lieu de l'Île de la Réunion ?","Saint-Denis","denis"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,"Quelle comète revient dans le voisinage de la Lune tous les 76 ans ?","Halley","halley"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34,"Quel est le seul mammifère volant ?","La chauve-souris","chauve-souris"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35,"Quelle est l'année donnée ainsi en chiffres romains : MCMLXXXI",1981,1981]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36,"A quel continent appartient la Nouvelle-Calédonie ?","L'Océanie","océanie"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,"En quelle année furent unifiées les deux Allemagne ?",1990,1990]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38,"Comment s'appelle un collectionneur de médailles","Monnaies et médailles - un numismate","numismate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39,"Qu'étudie un botaniste","Les plantes","plante"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,"Dans quel Tintin apparaît pour la première fois le capitaine Haddock ?","Le Crabe aux pinces d'Or","pince"]

{"sheet":"18","index":20,"n_rows":37,"n_cols":20,"rows_kept":37,"cut":false,"hidden":false,"merged":[[9,2,9,10],[13,2,13,10],[15,0,15,2]]}
["page 18"]
[]
[]
[null,"Un peu de travail …"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retour au début de cette page 18"]
[]
[null,null,"Question :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"no","Questions","Réponses"]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Combien les adultes ont-ils de dents ?",32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Comment s'appelle le château situé sur un îlot en face de Marseille ?","Château d'If"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Quel est l'auteur du livre de la jungle ?","Rudyard Kipling"]
[null,null,"Réponse :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Quel gaz est transporté par le sang","oxygène"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"Qui inventa la dynamite","Alfred Nobel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"De quelle maladie le roi Louis IX mourut-il en 1270 ?","La peste"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"Quel est l'astre connu sous le nom de l'Etoile du berger ?","Vénus"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"Qui était Jean Baptiste Poquelin ?","Molière"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"Qui fut le dernier roi français ?","Louis-Philippe 1er"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"Résultat de la division de 1000 par 1/2",2000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"Quel mammifère pond des œufs ?","L'ornithorynque"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"A quelle ère l'homme est-il apparu ?","Quaternaire (il y a 2,5 millions d'années)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"Quelle est l'altitude du Kilimandjaro","5963 mètres"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"Les 3 mots qui sont masculins au singulier et féminins au pluriel ?","Amour, délice et orgue"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"Quelle est la planète la plus proche du Soleil ?","Mercure"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"Quel ouvrage doit-on à Ferdinand de Lesseps ?","Canal de Suez"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"Quel est le prénom du plus petit des Dalton ?","Joe"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"Le dieu grec condamné à soutenir sur ses épaules la voûte céleste ?","Atlas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"Comment s'appelle le don d'être partout en même temps ?","Don d'ubiquité"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Voir la base de données"]
[null,"Exercice  22"]

{"sheet":"19","index":21,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[6,8,6,10],[5,8,5,10]]}
["page 19"]
[]
[null,"Recherche d'éléments dans un tableau :"]
[]
[" Exercice  23"]
[null,null,null,null,null,null,null,null,"Aller en C10 de la feuille 24"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Valeur_cherchée",null,"B10"]
[null,null,null,null,null,null,null,"Table_matrice",null,"R10:T39"]
[null,null,null,null,null,null,null,"No_index_col",null,2]
[]
[null,null,null,null,null,null,null,"Formule en C10",null," =RECHERCHEV(B10;R10:T39;2)"]

{"sheet":"20","index":22,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[[6,8,6,10]]}
["page 20"]
[]
[null,"Recherche d'éléments dans un tableau :"]
[]
[" Exercice  24"]
[]
[null,null,null,null,null,null,null,null,"Aller en C15 de la feuille 24"]

{"sheet":"21","index":23,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,0,19,1]]}
["page 21"]
[]
[null,"Les macros :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["    Exercice 25"]

{"sheet":"22","index":24,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[6,2,6,3]]}
["page 22"]
[]
[null,"Les macros :"]
[]
[]
[]
[null,null,"    Exercice 26"]

{"sheet":"23","index":25,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":false,"merged":[[19,0,19,1]]}
["page 23"]
[]
[null,"Les boutons :"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["  Exercice 27"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"  Exercice 28"]
[]
[]
[]
[]
["  Exercice 29"]

{"sheet":"24","index":26,"n_rows":40,"n_cols":20,"rows_kept":40,"cut":false,"hidden":false,"merged":[[9,2,9,10],[14,2,14,10]]}
["page 24"]
[]
[]
[null,"Ici, votre message d'accueil "]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Retour au début de la page 16"]
[]
[null,null,"Question :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"no","Questions","Réponses"]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Combien les adultes ont-ils de dents ?",32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Comment s'appelle le château situé sur un îlot en face de Marseille ?","Château d'If"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"Quel est l'auteur du livre de la jungle ?","Rudyard Kipling"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,"Un homme a-t-il le droit d'épouser la sœur de sa veuve ?","Non, il est mort !"]
[null,null,"Réponse :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,"Quel gaz est transporté par le sang","L'oxygène"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,"etc…","etc…"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,"o",null,null,null,null,null,30,"votre question","sa réponse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"et vous pouvez continuer !!!"]

{"sheet":"25","index":27,"n_rows":37,"n_cols":13,"rows_kept":37,"cut":false,"hidden":false,"merged":[[21,1,21,3],[21,4,21,5],[21,7,21,8],[21,10,21,11],[0,0,0,1],[3,4,3,5],[4,1,4,2],[4,10,4,11],[9,3,9,4],[33,2,33,11],[23,10,23,11],[26,10,26,12],[27,10,27,11],[28,10,28,11]]}
["page 25"]
[]
[]
[null,null,null,null,"Bouton d'option"]
[null,"Base de donnée",null,null,null,null,null,null,null,null,"Zone de liste"]
[null,1,"lundi",null,null,"cellule liée"]
[null,2,"mardi",null,"résultat= 1 ou 2",2,null,"Bouton de commande"]
[null,3,"mercredi",null,null,null,null,null,null,null,null,"cellule liée"]
[null,4,"jeudi",null,null,"cellule programmée",null,null,null,null,null,1]
[null,5,"vendredi","si(E7=2;\"oui\";\"non\")",null,{"$f":"IF(F7=2,\"OUI\",\"NON\")","v":"OUI"},null,null,null,null,null,"résultat = no de la liste"]
[null,6,"samedi"]
[null,7,"dimanche",null,null,null,null,null,null,null,"avec recherche V"]
[null,8,"Monday",null,null,null,null,null,null,null,"               ->",{"$f":"VLOOKUP(L9,B6:C19,2)","v":"lundi"}]
[null,9,"Tuesday"]
[null,10,"Wednesday"]
[null,11,"Thursday"]
[null,12,"Friday"]
[null,13,"Saturday",null,null,null,null,null,null,null,"Zone de liste modifiable"]
[null,14,"Sunday"]
[]
[]
[null,"Case à cocher",null,null,"Défilement",null,null,"Toupie",null,null,"cellule liée"]
[null,null,null,"cellule liée",null,null,null,null,null,null,1]
[null,null,null,true,null,"cellule liée",null," +","cellule liée",null,"résultat = no de la liste"]
[null,null,null,false,null,39,null,null,10]
[null,null,null,false]
[null,null,null,null,null,"par défaut",null,null,"idem",null,"Zone sensible d'un objet"]
[null,null,{"$f":"VLOOKUP(IF(D24=FALSE,K23,IF(K23<8,K23+7,K23)),B6:C19,2)","v":"Monday"},null,null,"valeur comprise",null,null,"défilement",null,"Pour rouge, il faut"]
[null,"          voir liste modifiable",null,{"$f":"IF(D25=TRUE,K23,\"\")","v":""},null,"entre 0 et 100",null,null,"ici, pas de 5",null,"bien viser !"]
[null,null,null,null,null,null,null," -"]
[]
[]
[]
[null,null,"Testez ces formulaires, observez les actions, analysez la barre de formule"]
[]
[null,"© Y. Péguiron 2001"]
[null,null,null,null,null,null,null,null,null,null,null,null,"o"]

{"sheet":"26","index":28,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[6,2,6,3]]}
["page 26"]
[null,"Pour finir …"]

{"sheet":"F I N","index":29,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,null,null,null,"Ce tuteur a été entièrement réalisé dans Excel !"]
[null,null,null,null,null,null,null,"Je ne vous ai pas menti en affirmant au début"]
[null,null,null,null,null,null,null,"que ce logiciel se prête à beaucoup d'applications"]
[null,null,null,null,null,null,null,"variées qui n'ont pas grand chose à voir avec les"]
[null,null,null,null,null,null,null,"calculs !"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"© Y. Péguiron 22.12.01"]