{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Evaluations","Classements","Session","Memoire"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Evaluations","index":0,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[[6,1,6,3],[7,1,7,3],[6,5,6,7],[7,5,7,7],[13,1,13,7],[1,1,1,7],[4,1,4,3],[3,1,3,3],[3,5,3,7],[4,5,4,7]]}
[]
[null,"Pour supprimer une feuille d'un classeur d'Excel :",null,null,null,null,null,null,null,null,null,null,"Choix 1"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Choix 2"]
[null,"Choix 1",null,null,null,"Choix 2",null,null,null,null,null,null,"Choix 3"]
[null,"J'enfonce la touche SUPPR",null,null,null,"Je vais dans le menu EDITION/SUPPRIMER",null,null,null,null,null,null,"Choix 4"]
[]
[null,"Choix 3",null,null,null,"Choix 4"]
[null,"Je sélectionne toutes les cellules de la feuille, je réalise un clic droit sur la sélection et je choisi SUPPRIMER dans le menu contextuel",null,null,null,"Je vais dans le menu EDITION/SUPPRIMER UNE FEUILLE"]
[]
[]
[null,"Votre choix","Choix 2",null,null,"Votre Score / 20",13]
[]
[]
[null,"Nombre de questions restantes : 0"]

{"sheet":"Classements","index":1,"n_rows":299,"n_cols":7,"rows_kept":299,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Classements"]
[]
[null,"Nom","Prénom","Date","Note","Durée","Rang"]
[null,"Doeuf","John","2018-07-23",15,132,{"$f":"IFERROR(RANK(F5,$F$5:$F$995),\"\")","v":2}]
[null,"Doeuf","John","2018-07-23",13,150,1]
[null,"Galls","Charline","2018-07-23",13,126,3]
[null,"Galls","Charline","2018-07-23",4,13,4]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"IFERROR(RANK(F69,$F$5:$F$995),\"\")","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"IFERROR(RANK(F133,$F$5:$F$995),\"\")","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"IFERROR(RANK(F197,$F$5:$F$995),\"\")","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,{"$f":"IFERROR(RANK(F261,$F$5:$F$995),\"\")","v":""}]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]
[null,null,null,null,null,null,""]

{"sheet":"Session","index":2,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Informations de session"]
[]
[null,"Id. Utilisateur",999999]
[null,"Questionnaire","Microsoft Excel"]
[null,"Date","2018-07-23"]
[null,"Nom","Doeuf"]
[null,"Prénom","John"]

{"sheet":"Memoire","index":3,"n_rows":24,"n_cols":8,"rows_kept":24,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Historique de l'évaluation"]
[]
[null,"Q_ID","Q_Question","Q_Choix1","Q_Choix2","Q_Choix3","Q_Choix4","Q_Brep"]
[null,39,"Pour ajouter une ligne de données dans un graphique Excel :","Je sélectionne la ligne et je vais dans le menu INSERTION LIGNE","Je clique avec le bouton droite sur le graphique et je choisi INSERER UNE LIGNE","Je sélectionne la ligne et la glisse sur le graphique","C'est trop tard, je dois recommencer le graphique pour prendre en compte cette ligne de donnée",3]
[null,30,"La fonction RECHERCHEV d'Excel permet :","De rechercher les \"V\" dans des cellules","De rechercher Vite","De rechercher les Valeurs à sépcifier","De rechercher Verticalement",4]
[null,60,"L'opérateur de comparaison Excel \"Différent de\" s'écrit:","/=","!=","<>","Pas =",3]
[null,2,"Pour supprimer le contenu d'une cellule Excel :","J'enfonce la touche Suppr du clavier","J'enfonce la touche Entrée du clavier","Je réalise la combinaison de touches Ctrl + Entrée","Je dois passer par le menu Edition/Effacer/Format",1]
[null,36,"Lequel de ces types n'est pas un type de graphique Excel :","Secteurs","Histogramme","Radar","Barette",4]
[null,37,"Dans un graphique Histogramme d'Excel, je souhaite représenter les barres en dégradé de couleurs, je les sélectionne et :","Je choisi DEGRADE dans le menu contextuel","Je choisi MOTIFS ET TEXTURES dans la liste déroulante du bouton COULEUR DE REMPLISSAGE","Ce n'est pas possible","Je ne peux le définir que pendant les étapes de l'assistant graphique",2]
[null,55,"Quelle syntaxe est correcte :","=ET(a1=2;B1>10)","=ET(a1=\"2\";B1>\"10\")","=ET(a1=2) ET(B1=10)","=ET(a1=2);ET(B1=10)",1]
[null,23,"A1 à A3 comportent des montants hors taxe. A4 contient le taux de TVA. De B1 à B3 je souhaite cacluler les charges sur ces montants en tirant la poignée du calcul effectué en B1. Quel est la formule la plus adaptée :","A1*$A$4","$A$1*A4","A1*A$4","A1*$A4",3]
[null,26,"La fonction Excel permettant de poser une condition s'appelle :","CONDITION","SI","CRITERE","PEUTETRE",2]
[null,28,"Parmi ces choix, quel est la bonne formule Excel permettant d'imbriquer des fonctions SI :","=Si(A1>10;reçu;si(A1>9,5;conseil;éliminé))","=Si(A1>10;\"reçu\";si(A1>9,5;\"conseil\";\"éliminé\")","=Si(A1>10,\"reçu\",si(A1>9,5,\"conseil\",\"éliminé\"))","=Si(A1>10;\"reçu\";si(A1>9,5;\"conseil\";\"éliminé\"))",4]
[null,63,"Lorsque le symbole \"#\" apparaît de façon répétée dans une cellule Excel (\"####\"):","La formule contient une erreur","La calcul n'a pas de résultat","Il s'agit d'un caractère masqué type Numérotation de page","La colonne est trop étroite pour que la cellule affiche le résultat",4]
[null,3,"Je souhaite que mon texte apparaissent en Arial Taille 13 dans une cellule Excel. Hors cette taille n'existe pas dans la liste TAILLE DE LA POLICE :","Je ne peux donc pas affecter cette taille","Je dois passer par le menu Format/Cellule-Onglet Polices","Je saisi 13 dans la zone TAILLE DE LA POLICE et je valide par Entrée","Je saisi tout simplement 13 dans la zone TAILLE DE LA POLICE",3]
[null,10,"Après avoir saisi dans une cellule Excel, je souhaite valider en conservant la cellule active :","Je clique dans cette cellule à l'aide de la souris","J'enfonce la touche ENTREE du clavier","Je réalise la combinaison CTRL + ENTREE","J'utilise les flèches du pavé directionnel",3]
[null,4,"Je souhaite appliquer une bordure, une couleur de fond ainsi qu'une couleur de texte à une ou plusieurs cellules Excel :","J'utilise les boutons COULEUR DE REMPLISSAGE et COULEUR DE TEXTE de la barre d'outils, mais pour les bordures je dois aller dans le menu FORMAT/CELLULE-Onglet BORDURES","Je peux accéder à toutes ces fonctions seulement dans le menu FORMAT/CELLULE","Les trois boutons sont présents sur la barre d'outils MISE EN FORME et proposent toutes les options","Les trois boutons sont présents sur la barre d'outils MISE EN FORME mais ne proposent pas toutes les options",4]
[null,49,"Je pose 2 critères dans un tableau Excel à l'aide d'un filtre automatique :","J'obtiens uniquement les enregistrements correspondant aux deux critères recoupés","Je n'obtiens aucun résultat","J'obtiens des enregistrements mais ils ne correspondent pas aux critères posés","Cette action n'est pas réalisable",1]
[null,43,"Excel est un produit :","De la gamme Office","Du pack Windows","Du pack Visual Studio","Du pack Linux",1]
[null,59,"L'opérateur de comparaison Excel \"Supérieur ou égal à\" s'écrit:","> ou =","= ou >","=>",">=",4]
[null,15,"Pour réaliser une somme automatique dans Excel, plusieurs méthodes peuvent fonctionner mais une seule est vraiment correcte :","Je me place dans la cellule du résultat, je clique sur le bouton SOMME AUTOMATIQUE et je valise par ENTREE","Je sélectionne toutes les cellules à sommer et je clique sur le bouton SOMME AUTOMATIQUE","Je sélectionne toutes les cellules à sommer ainsi que la cellule où doit apparaître le résultat et je clique sur le bouton SOMME AUTOMATIQUE","Je sélectionne toutes les cellules à sommer et je vais dans le menu FONCTIONS/SOMME AUTOMATIQUE",3]
[null,67,"L'exportation d'une feuille Excel au format texte conduit à un fichier à l'extension:",".txt",".csv",".ini",".bat",2]
[null,22,"Pour supprimer une feuille d'un classeur d'Excel :","J'enfonce la touche SUPPR","Je vais dans le menu EDITION/SUPPRIMER","Je sélectionne toutes les cellules de la feuille, je réalise un clic droit sur la sélection et je choisi SUPPRIMER dans le menu contextuel","Je vais dans le menu EDITION/SUPPRIMER UNE FEUILLE",4]