{"id":1454,"date":"2025-09-07T23:07:25","date_gmt":"2025-09-07T23:07:25","guid":{"rendered":"https:\/\/technoesn.com\/pl\/?page_id=1454"},"modified":"2025-09-09T16:35:07","modified_gmt":"2025-09-09T16:35:07","slug":"tache-excel","status":"publish","type":"page","link":"https:\/\/technoesn.com\/pl\/tache-excel\/","title":{"rendered":"T\u00e2che Excel"},"content":{"rendered":"\n<h1>Guide pas-\u00e0-pas \u2014 Excel 365 (Windows)<\/h1>\n<p>\u00a0<\/p>\n<p>ASSUREZ-VOUS D&rsquo;UTILISER LA VERSION <strong>BUREAU<\/strong> ET <strong><span style=\"color: #ff0000;\">NON<\/span><\/strong> LA VERSION WEB<\/p>\n<h2>0) Mise en route et sauvegarde<\/h2>\n<ol>\n<li>\n<p>Ouvre <strong>Excel<\/strong> \u2192 <strong>Classeur vierge<\/strong>.<\/p>\n<\/li>\n<li>\n<p>Sauvegarde tout de suite : <strong>Ctrl+S<\/strong> \u2192 nomme le fichier <code>Sondage_[Pr\u00e9nom]<\/code> \u2192 choisis ton dossier \u2192 <strong>Enregistrer<\/strong>.<br \/><em>(Raccourcis utiles : Ctrl+S = enregistrer, Ctrl+Z = annuler, Ctrl+Y = r\u00e9tablir, Ctrl+C \/ Ctrl+V = copier\/coller.)<\/em><\/p>\n<\/li>\n<\/ol>\n<hr \/>\n<h2>1) Feuille 1 \u2014 Construire le tableau de donn\u00e9es et les formules<\/h2>\n<h3>1.1 Titres et ent\u00eates<\/h3>\n<ol>\n<li>\n<p>Clique la cellule <strong>A1<\/strong> \u2192 tape <strong>R\u00e9ponses du sondage<\/strong> \u2192 <strong>Entr\u00e9e<\/strong>.<\/p>\n<\/li>\n<li>\n<p>Dans <strong>A2<\/strong>, laisse vide (on d\u00e9marre les \u00e9tiquettes \u00e0 A3).<\/p>\n<\/li>\n<li>\n<p>Dans <strong>B2<\/strong>, tape <strong>Aiment [ton sujet]<\/strong> (ex. <em>Aiment le jeu X<\/em>).<\/p>\n<\/li>\n<li>\n<p>Dans <strong>C2<\/strong>, tape <strong>N\u2019aiment pas [ton sujet]<\/strong>.<\/p>\n<\/li>\n<li>\n<p>Dans <strong>D2<\/strong>, tape <strong>Total par niveau<\/strong>.<\/p>\n<\/li>\n<\/ol>\n<h3>1.2 Niveaux (cat\u00e9gories en colonne A)<\/h3>\n<ol>\n<li>\n<p>Clique <strong>A3<\/strong> \u2192 tape <strong>Neuvi\u00e8me ann\u00e9e<\/strong> \u2192 <strong>Entr\u00e9e<\/strong>.<\/p>\n<\/li>\n<li>\n<p><strong>A4<\/strong> : <strong>Dixi\u00e8me ann\u00e9e<\/strong>.<\/p>\n<\/li>\n<li>\n<p><strong>A5<\/strong> : <strong>Onzi\u00e8me ann\u00e9e<\/strong>.<\/p>\n<\/li>\n<li>\n<p><strong>A6<\/strong> : <strong>Douzi\u00e8me ann\u00e9e<\/strong>.<\/p>\n<\/li>\n<\/ol>\n<p><em>(Astuce : pour aller vite, tu peux taper la premi\u00e8re \u00e9tiquette, puis tirer la poign\u00e9e de recopie si ta liste est d\u00e9j\u00e0 pr\u00e9sente dans une autre feuille; sinon, \u00e9cris-les une par une.)<\/em><\/p>\n<h3>1.3 Saisir 8 nombres au choix (r\u00e9ponses fictives)<\/h3>\n<ul>\n<li>\n<p>Dans la zone <strong>B3:C6<\/strong>, entre <strong>8 nombres entiers, tous diff\u00e9rents<\/strong> (ex. entre 0 et 200).<\/p>\n<ul>\n<li>\n<p>B = \u00ab aiment \u00bb, C = \u00ab n\u2019aiment pas \u00bb.<\/p>\n<\/li>\n<li>\n<p>Exemple (remplace par <strong>tes<\/strong> chiffres) :<\/p>\n<ul>\n<li>\n<p>B3=24, C3=7 ; B4=31, C4=10 ; B5=15, C5=12 ; B6=27, C6=5.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3>1.4 Total par niveau (formule D = B + C)<\/h3>\n<ol>\n<li>\n<p>Clique <strong>D3<\/strong> \u2192 tape la formule : <code>=B3+C3<\/code> \u2192 <strong>Entr\u00e9e<\/strong>.<\/p>\n<\/li>\n<li>\n<p>Reviens sur <strong>D3<\/strong> \u2192 attrape la <strong>poign\u00e9e de recopie<\/strong> (petit carr\u00e9 en bas-\u00e0-droite de la cellule) \u2192 <strong>tire jusqu\u2019\u00e0 D6<\/strong>.<\/p>\n<ul>\n<li>\n<p>R\u00e9sultat attendu : D3\u2026D6 affichent la somme de chaque ligne (niveau).<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h3>1.5 Totaux \u00e9cole et pourcentage global (lignes 9 \u00e0 12)<\/h3>\n<ol>\n<li>\n<p><strong>A9<\/strong> : tape <strong>Nombre d\u2019\u00e9l\u00e8ves dans l\u2019\u00e9cole<\/strong>.<\/p>\n<\/li>\n<li>\n<p><strong>A10<\/strong> (cellule du r\u00e9sultat, <strong>dans la m\u00eame colonne A<\/strong>, comme demand\u00e9) : tape <code>=SOMME(D3:D6)<\/code> \u2192 <strong>Entr\u00e9e<\/strong>.<\/p>\n<ul>\n<li>\n<p><em>(Oui, on met d\u00e9lib\u00e9r\u00e9ment le nombre dans A10 sous l\u2019\u00e9tiquette A9, pour respecter l\u2019emplacement demand\u00e9.)<\/em><\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li>\n<p><strong>A11<\/strong> : tape <strong>Pourcentage d\u2019\u00e9l\u00e8ves qui [aiment ton sujet]<\/strong>.<\/p>\n<\/li>\n<li>\n<p><strong>A12<\/strong> (r\u00e9sultat) : tape <code>=SOMME(B3:B6)\/A10<\/code> \u2192 <strong>Entr\u00e9e<\/strong>.<\/p>\n<\/li>\n<li>\n<p>Formate <strong>A12<\/strong> en pourcentage :<\/p>\n<ul>\n<li>\n<p>Onglet <strong>Accueil<\/strong> \u2192 groupe <strong>Nombre<\/strong> \u2192 clique <strong>%<\/strong> \u2192 clique <strong>Augmenter\/diminuer les d\u00e9cimales<\/strong> si besoin (0 ou 1 d\u00e9cimale suffit).<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h3>1.6 Lisibilit\u00e9 rapide<\/h3>\n<ul>\n<li>\n<p>S\u00e9lectionne <strong>A1:D1<\/strong> \u2192 <strong>Accueil &gt; Gras<\/strong> (Ctrl+B).<\/p>\n<\/li>\n<li>\n<p>Ajuste la largeur des colonnes : place le curseur entre <strong>A<\/strong> et <strong>B<\/strong> (en haut dans l\u2019ent\u00eate) \u2192 <strong>double-clic<\/strong> pour <em>Ajustement automatique<\/em>. R\u00e9p\u00e8te entre <strong>B\/C<\/strong>, <strong>C\/D<\/strong>.<\/p>\n<\/li>\n<\/ul>\n<hr \/>\n<h2>2) Cr\u00e9er un <strong>graphique<\/strong> \u00e0 partir des donn\u00e9es (A3:C6)<\/h2>\n<blockquote>\n<p>Tu as dit \u00ab tableau avec des bandes plac\u00e9 \u00e0 c\u00f4t\u00e9 \u00bb. En Excel, on parle d\u2019un <strong>graphique en colonnes (histogramme group\u00e9)<\/strong> ou <strong>en barres<\/strong>. Voici la proc\u00e9dure standard, avec d\u00e9placement du graphique \u00e0 droite des donn\u00e9es.<\/p>\n<\/blockquote>\n<ol>\n<li>\n<p>S\u00e9lectionne <strong>A3:C6<\/strong> (inclut les 4 niveaux + les colonnes Aiment \/ N\u2019aiment pas).<\/p>\n<\/li>\n<li>\n<p>Onglet <strong>Ins\u00e9rer<\/strong> \u2192 groupe <strong>Graphiques<\/strong> \u2192 clique <strong>Histogramme<\/strong> \u2192 choisis <strong>Histogramme group\u00e9<\/strong> <em>(ou \u00ab Barres group\u00e9es \u00bb si tu pr\u00e9f\u00e8res horizontal)<\/em>.<\/p>\n<\/li>\n<li>\n<p>Un graphique appara\u00eet :<\/p>\n<ul>\n<li>\n<p>Clique le graphique pour le s\u00e9lectionner \u2192 <strong>glisse-le<\/strong> avec la souris <strong>\u00e0 droite<\/strong> du tableau (\u00e0 c\u00f4t\u00e9 des colonnes D\/E).<\/p>\n<\/li>\n<li>\n<p>Clique le <strong>Titre du graphique<\/strong> \u2192 tape <strong>Pr\u00e9f\u00e9rences \u2014 [ton sujet]<\/strong>.<\/p>\n<\/li>\n<li>\n<p>V\u00e9rifie la <strong>L\u00e9gende<\/strong> (deux s\u00e9ries : <em>Aiment<\/em>, <em>N\u2019aiment pas<\/em>).<\/p>\n<\/li>\n<li>\n<p>(Optionnel) <strong>+<\/strong> (Bouton \u00c9l\u00e9ments du graphique) \u2192 <strong>\u00c9tiquettes de donn\u00e9es<\/strong> si tu veux afficher les valeurs sur les barres.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<blockquote>\n<p><strong>Alternative (optionnelle)<\/strong> : tu peux aussi <strong>mettre la plage A2:C6 \u201csous forme de tableau\u201d<\/strong> (Accueil \u2192 <strong>Mettre sous forme de tableau<\/strong> \u2192 choisis un style \u201c\u00e0 bandes\u201d). Cela colore les lignes en alternance, mais <strong>\u00e7a reste des cellules<\/strong> (pas un graphique). L\u2019\u00e9l\u00e9ment <em>\u00e0 placer \u00e0 c\u00f4t\u00e9<\/em> est bien le <strong>graphique<\/strong>.<\/p>\n<\/blockquote>\n<p><strong>Enregistre<\/strong> (Ctrl+S).<\/p>\n<hr \/>\n<h2>3) Feuille 2 \u2014 Dupliquer, changer 8 chiffres, refaire le graphique<\/h2>\n<h3>3.1 Dupliquer la feuille 1<\/h3>\n<ol>\n<li>\n<p>En bas, <strong>clic droit<\/strong> sur l\u2019onglet <strong>Feuil1<\/strong> (ou le nom actuel) \u2192 <strong>D\u00e9placer ou copier\u2026<\/strong><\/p>\n<\/li>\n<li>\n<p>Coche <strong>Cr\u00e9er une copie<\/strong> \u2192 <strong>OK<\/strong>.<\/p>\n<\/li>\n<li>\n<p>Renomme l\u2019onglet copi\u00e9 <strong>Feuille 2<\/strong> : <strong>clic droit<\/strong> sur l\u2019onglet \u2192 <strong>Renommer<\/strong> \u2192 tape <em>Feuille 2<\/em> \u2192 <strong>Entr\u00e9e<\/strong>.<\/p>\n<\/li>\n<\/ol>\n<h3>3.2 Changer les donn\u00e9es (8 nouveaux nombres, tous diff\u00e9rents)<\/h3>\n<ol>\n<li>\n<p>Dans <strong>B3:C6<\/strong>, remplace <strong>les 8 valeurs<\/strong> par <strong>8 chiffres diff\u00e9rents<\/strong> des pr\u00e9c\u00e9dents.<\/p>\n<\/li>\n<li>\n<p>Les cellules <strong>D3:D6<\/strong>, <strong>A10<\/strong> (SOMME) et <strong>A12<\/strong> (%) se recalculent automatiquement.<\/p>\n<ul>\n<li>\n<p><em>(Si jamais le calcul n\u2019est pas automatique : onglet <strong>Formules<\/strong> \u2192 <strong>Options de calcul<\/strong> \u2192 <strong>Automatique<\/strong>.)<\/em><\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<h3>3.3 Refaire le graphique (exercice demand\u00e9)<\/h3>\n<ol>\n<li>\n<p>Clique l\u2019ancien graphique \u2192 <strong>Suppr<\/strong>.<\/p>\n<\/li>\n<li>\n<p>Recr\u00e9e le graphique <strong>exactement<\/strong> comme en \u00a72 (s\u00e9lection <strong>A3:C6<\/strong> \u2192 <strong>Ins\u00e9rer &gt; Histogramme group\u00e9<\/strong>) \u2192 <strong>d\u00e9place-le \u00e0 droite<\/strong>.<\/p>\n<\/li>\n<li>\n<p>Titre : <strong>Pr\u00e9f\u00e9rences \u2014 [ton sujet] (Feuille 2)<\/strong>.<\/p>\n<\/li>\n<\/ol>\n<p><strong>Enregistre<\/strong> (Ctrl+S).<\/p>\n<hr \/>\n<h2>4) Feuille 3 \u2014 M\u00eame chose, nouvelle s\u00e9rie de chiffres et nouveau graphique<\/h2>\n<ol>\n<li>\n<p><strong>Clic droit<\/strong> sur l\u2019onglet <strong>Feuille 2<\/strong> \u2192 <strong>D\u00e9placer ou copier\u2026<\/strong> \u2192 <strong>Cr\u00e9er une copie<\/strong> \u2192 <strong>OK<\/strong> \u2192 renomme <strong>Feuille 3<\/strong>.<\/p>\n<\/li>\n<li>\n<p>Dans <strong>B3:C6<\/strong>, saisis <strong>8 nouveaux nombres<\/strong>, tous <strong>diff\u00e9rents<\/strong> (et diff\u00e9rents des autres feuilles).<\/p>\n<\/li>\n<li>\n<p>Supprime le graphique existant \u2192 recr\u00e9e-le depuis <strong>A3:C6<\/strong> \u2192 place-le \u00e0 c\u00f4t\u00e9 \u2192 titre <strong>Pr\u00e9f\u00e9rences \u2014 [ton sujet] (Feuille 3)<\/strong>.<\/p>\n<\/li>\n<li>\n<p>V\u00e9rifie <strong>A10<\/strong> (=SOMME(D3:D6)) et <strong>A12<\/strong> (=SOMME(B3:B6)\/A10 mis en <strong>%<\/strong>).<\/p>\n<\/li>\n<li>\n<p><strong>Enregistre<\/strong> (Ctrl+S).<\/p>\n<\/li>\n<\/ol>\n<hr \/>\n<h2>5) R\u00e9capitulatif des cellules\/formules attendues (Feuille 1, identique ensuite)<\/h2>\n<ul>\n<li>\n<p><strong>A1<\/strong> : <code>R\u00e9ponses du sondage<\/code><\/p>\n<\/li>\n<li>\n<p><strong>A3:A6<\/strong> : <code>Neuvi\u00e8me ann\u00e9e<\/code>, <code>Dixi\u00e8me ann\u00e9e<\/code>, <code>Onzi\u00e8me ann\u00e9e<\/code>, <code>Douzi\u00e8me ann\u00e9e<\/code><\/p>\n<\/li>\n<li>\n<p><strong>B2<\/strong> : <code>Aiment [ton sujet]<\/code>\u2003\u2003<strong>C2<\/strong> : <code>N\u2019aiment pas [ton sujet]<\/code>\u2003\u2003<strong>D2<\/strong> : <code>Total par niveau<\/code><\/p>\n<\/li>\n<li>\n<p><strong>B3:C6<\/strong> : 8 nombres <strong>tous diff\u00e9rents<\/strong> (entiers)<\/p>\n<\/li>\n<li>\n<p><strong>D3<\/strong> : <code>=B3+C3<\/code> puis recopie jusqu\u2019\u00e0 <strong>D6<\/strong><\/p>\n<\/li>\n<li>\n<p><strong>A9<\/strong> : <code>Nombre d\u2019\u00e9l\u00e8ves dans l\u2019\u00e9cole<\/code><\/p>\n<\/li>\n<li>\n<p><strong>A10<\/strong> : <code>=SOMME(D3:D6)<\/code><\/p>\n<\/li>\n<li>\n<p><strong>A11<\/strong> : <code>Pourcentage d\u2019\u00e9l\u00e8ves qui [aiment ton sujet]<\/code><\/p>\n<\/li>\n<li>\n<p><strong>A12<\/strong> : <code>=SOMME(B3:B6)\/A10<\/code> \u2192 format <strong>Pourcentage<\/strong> (0\u20131 d\u00e9cimale)<\/p>\n<\/li>\n<\/ul>\n<p>Graphique (par feuille) : s\u00e9lection <strong>A3:C6<\/strong> \u2192 <strong>Ins\u00e9rer &gt; Histogramme group\u00e9<\/strong> \u2192 d\u00e9placer \u00e0 droite \u2192 titrer.<\/p>\n<hr \/>\n<h2>6) Conseils rapides (qualit\u00e9 et rigueur)<\/h2>\n<ul>\n<li>\n<p><strong>Coh\u00e9rence des \u00e9tiquettes<\/strong> : <em>Aiment \/ N\u2019aiment pas<\/em> doivent correspondre <strong>au m\u00eame sujet<\/strong> sur une feuille. Tu peux changer de sujet d\u2019une feuille \u00e0 l\u2019autre.<\/p>\n<\/li>\n<li>\n<p><strong>Diff\u00e9renciation des chiffres<\/strong> : 8 valeurs <strong>toutes distinctes<\/strong> sur chaque feuille.<\/p>\n<\/li>\n<li>\n<p><strong>Lisibilit\u00e9<\/strong> : titres en gras, colonnes auto-ajust\u00e9es, pourcentage format\u00e9.<\/p>\n<\/li>\n<li>\n<p><strong>Sauvegardes fr\u00e9quentes<\/strong> : <strong>Ctrl+S<\/strong>.<\/p>\n<\/li>\n<\/ul>\n<hr \/>\n<h2>7) \u00c0 remettre<\/h2>\n<ul>\n<li>\n<p>Un <strong>classeur .xlsx<\/strong> contenant <strong>Feuille 1<\/strong>, <strong>Feuille 2<\/strong>, <strong>Feuille 3<\/strong> avec :<\/p>\n<ul>\n<li>\n<p>Les donn\u00e9es <strong>B3:C6<\/strong> remplies (8 valeurs diff\u00e9rentes par feuille),<\/p>\n<\/li>\n<li>\n<p>Les formules <strong>D3:D6<\/strong>, <strong>A10<\/strong>, <strong>A12<\/strong> correctes,<\/p>\n<\/li>\n<li>\n<p>Un <strong>graphique<\/strong> par feuille plac\u00e9 \u00e0 droite,<\/p>\n<\/li>\n<li>\n<p>Les titres\/\u00e9tiquettes conformes.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n\n\n\n<p><!--nextpage--><\/p>\n<h1 data-start=\"230\" data-end=\"286\">Travail 2 \u2014 Bulletin de notes &amp; statistiques de classe<\/h1>\n<h2 data-start=\"288\" data-end=\"307\">0) Mise en route<\/h2>\n<ol data-start=\"308\" data-end=\"445\">\n<li data-start=\"308\" data-end=\"351\">\n<p data-start=\"311\" data-end=\"351\">Ouvre <strong data-start=\"317\" data-end=\"326\">Excel<\/strong> \u2192 <strong data-start=\"329\" data-end=\"348\">Classeur vierge<\/strong>.<\/p>\n<\/li>\n<li data-start=\"352\" data-end=\"445\">\n<p data-start=\"355\" data-end=\"445\"><strong data-start=\"355\" data-end=\"365\">Ctrl+S<\/strong> \u2192 nomme le fichier <code data-start=\"385\" data-end=\"404\">Bulletin_[Pr\u00e9nom]<\/code> \u2192 choisis ton dossier \u2192 <strong data-start=\"429\" data-end=\"444\">Enregistrer<\/strong>.<\/p>\n<\/li>\n<\/ol>\n<hr data-start=\"447\" data-end=\"450\" \/>\n<h2 data-start=\"452\" data-end=\"503\">1) Feuille \u00ab Classe A \u00bb \u2014 Structurer le bulletin<\/h2>\n<h3 data-start=\"505\" data-end=\"531\">1.1 Titres et en-t\u00eates<\/h3>\n<ol data-start=\"532\" data-end=\"850\">\n<li data-start=\"532\" data-end=\"605\">\n<p data-start=\"535\" data-end=\"605\">Clique <strong data-start=\"542\" data-end=\"548\">A1<\/strong> \u2192 \u00e9cris <strong data-start=\"557\" data-end=\"589\">Bulletin de notes \u2014 Classe A<\/strong> \u2192 <strong data-start=\"592\" data-end=\"602\">Entr\u00e9e<\/strong>.<\/p>\n<\/li>\n<li data-start=\"606\" data-end=\"800\">\n<p data-start=\"609\" data-end=\"635\">Ligne 3 (les en-t\u00eates) :<\/p>\n<ul data-start=\"639\" data-end=\"800\">\n<li data-start=\"639\" data-end=\"659\">\n<p data-start=\"641\" data-end=\"659\"><strong data-start=\"641\" data-end=\"647\">A3<\/strong> : <code data-start=\"650\" data-end=\"657\">\u00c9l\u00e8ve<\/code><\/p>\n<\/li>\n<li data-start=\"663\" data-end=\"684\">\n<p data-start=\"665\" data-end=\"684\"><strong data-start=\"665\" data-end=\"671\">B3<\/strong> : <code data-start=\"674\" data-end=\"682\">Test 1<\/code><\/p>\n<\/li>\n<li data-start=\"688\" data-end=\"709\">\n<p data-start=\"690\" data-end=\"709\"><strong data-start=\"690\" data-end=\"696\">C3<\/strong> : <code data-start=\"699\" data-end=\"707\">Test 2<\/code><\/p>\n<\/li>\n<li data-start=\"713\" data-end=\"734\">\n<p data-start=\"715\" data-end=\"734\"><strong data-start=\"715\" data-end=\"721\">D3<\/strong> : <code data-start=\"724\" data-end=\"732\">Test 3<\/code><\/p>\n<\/li>\n<li data-start=\"738\" data-end=\"771\">\n<p data-start=\"740\" data-end=\"771\"><strong data-start=\"740\" data-end=\"746\">E3<\/strong> : <code data-start=\"749\" data-end=\"769\">Moyenne (arrondie)<\/code><\/p>\n<\/li>\n<li data-start=\"775\" data-end=\"800\">\n<p data-start=\"777\" data-end=\"800\"><strong data-start=\"777\" data-end=\"783\">F3<\/strong> : <code data-start=\"786\" data-end=\"800\">Mention (SI)<\/code><\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li data-start=\"802\" data-end=\"850\">\n<p data-start=\"805\" data-end=\"850\">Mets <strong data-start=\"810\" data-end=\"819\">A3:F3<\/strong> en <strong data-start=\"823\" data-end=\"831\">Gras<\/strong> (Accueil \u2192 <strong data-start=\"843\" data-end=\"848\">G<\/strong>).<\/p>\n<\/li>\n<\/ol>\n<h3 data-start=\"852\" data-end=\"885\">1.2 Liste des \u00e9l\u00e8ves (A4:A15)<\/h3>\n<ul data-start=\"886\" data-end=\"950\">\n<li data-start=\"886\" data-end=\"950\">\n<p data-start=\"888\" data-end=\"950\"><strong data-start=\"888\" data-end=\"894\">A4<\/strong> \u00e0 <strong data-start=\"897\" data-end=\"904\">A15<\/strong> : inscris 12 noms ou <code data-start=\"926\" data-end=\"936\">\u00c9l\u00e8ve 01<\/code> \u2026 <code data-start=\"939\" data-end=\"949\">\u00c9l\u00e8ve 12<\/code>.<\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"952\" data-end=\"985\">1.3 Saisir les notes (B4:D15)<\/h3>\n<ul data-start=\"986\" data-end=\"1140\">\n<li data-start=\"986\" data-end=\"1140\">\n<p data-start=\"988\" data-end=\"1061\">Dans <strong data-start=\"993\" data-end=\"1003\">B4:D15<\/strong>, saisis des <strong data-start=\"1016\" data-end=\"1049\">notes enti\u00e8res entre 0 et 100<\/strong> (au choix).<\/p>\n<ul data-start=\"1064\" data-end=\"1140\">\n<li data-start=\"1064\" data-end=\"1140\">\n<p data-start=\"1066\" data-end=\"1140\">Ex. pour tester : B4=72, C4=61, D4=85 (mais <strong data-start=\"1110\" data-end=\"1138\">mets tes propres valeurs<\/strong>).<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h3 data-start=\"1142\" data-end=\"1186\">1.4 Moyenne par \u00e9l\u00e8ve + arrondi (E4:E15)<\/h3>\n<ol data-start=\"1187\" data-end=\"1433\">\n<li data-start=\"1187\" data-end=\"1339\">\n<p data-start=\"1190\" data-end=\"1339\">Clique <strong data-start=\"1197\" data-end=\"1203\">E4<\/strong> \u2192 tape la formule suivante puis <strong data-start=\"1236\" data-end=\"1246\">Entr\u00e9e<\/strong> :<br data-start=\"1248\" data-end=\"1251\" \/><code data-start=\"1254\" data-end=\"1282\">=ARRONDI(MOYENNE(B4:D4);1)<\/code><br data-start=\"1282\" data-end=\"1285\" \/><em data-start=\"1288\" data-end=\"1337\">(FR Excel : <strong data-start=\"1301\" data-end=\"1306\">;<\/strong> comme s\u00e9parateur, 1 d\u00e9cimale)<\/em><\/p>\n<\/li>\n<li data-start=\"1340\" data-end=\"1433\">\n<p data-start=\"1343\" data-end=\"1433\">Recopie <strong data-start=\"1351\" data-end=\"1357\">E4<\/strong> vers <strong data-start=\"1363\" data-end=\"1373\">E5:E15<\/strong> avec la <strong data-start=\"1382\" data-end=\"1404\">poign\u00e9e de recopie<\/strong> (petit carr\u00e9 en bas-droite).<\/p>\n<\/li>\n<\/ol>\n<h3 data-start=\"1435\" data-end=\"1480\">1.5 Mention R\u00e9ussi\/\u00c9chec avec SI (F4:F15)<\/h3>\n<ol data-start=\"1481\" data-end=\"1592\">\n<li data-start=\"1481\" data-end=\"1557\">\n<p data-start=\"1484\" data-end=\"1557\">Clique <strong data-start=\"1491\" data-end=\"1497\">F4<\/strong> \u2192 tape :<br data-start=\"1506\" data-end=\"1509\" \/><code data-start=\"1512\" data-end=\"1542\">=SI(E4&gt;=60;\"R\u00e9ussi\";\"\u00c9chec\")<\/code> \u2192 <strong data-start=\"1545\" data-end=\"1555\">Entr\u00e9e<\/strong><\/p>\n<\/li>\n<li data-start=\"1558\" data-end=\"1592\">\n<p data-start=\"1561\" data-end=\"1592\">Recopie <strong data-start=\"1569\" data-end=\"1575\">F4<\/strong> jusqu\u2019\u00e0 <strong data-start=\"1584\" data-end=\"1591\">F15<\/strong>.<\/p>\n<\/li>\n<\/ol>\n<h3 data-start=\"1594\" data-end=\"1627\">1.6 Ajustements de lisibilit\u00e9<\/h3>\n<ul data-start=\"1628\" data-end=\"1819\">\n<li data-start=\"1628\" data-end=\"1701\">\n<p data-start=\"1630\" data-end=\"1701\"><strong data-start=\"1630\" data-end=\"1651\">Ajuste la largeur<\/strong> des colonnes : double-clic entre A\/B, B\/C, etc.<\/p>\n<\/li>\n<li data-start=\"1702\" data-end=\"1788\">\n<p data-start=\"1704\" data-end=\"1788\">Formate <strong data-start=\"1712\" data-end=\"1722\">E4:E15<\/strong> en <strong data-start=\"1726\" data-end=\"1740\">1 d\u00e9cimale<\/strong> (Accueil \u2192 <strong data-start=\"1752\" data-end=\"1784\">Augmenter\/Diminuer d\u00e9cimales<\/strong>).<\/p>\n<\/li>\n<li data-start=\"1789\" data-end=\"1819\">\n<p data-start=\"1791\" data-end=\"1819\"><strong data-start=\"1791\" data-end=\"1801\">Ctrl+S<\/strong> pour enregistrer.<\/p>\n<\/li>\n<\/ul>\n<hr data-start=\"1821\" data-end=\"1824\" \/>\n<h2 data-start=\"1826\" data-end=\"1863\">2) Bloc \u00ab Statistiques de classe \u00bb<\/h2>\n<h3 data-start=\"1865\" data-end=\"1904\">2.1 En-t\u00eates de stats (ligne 17\u201320)<\/h3>\n<ol data-start=\"1905\" data-end=\"2087\">\n<li data-start=\"1905\" data-end=\"1952\">\n<p data-start=\"1908\" data-end=\"1952\"><strong data-start=\"1908\" data-end=\"1915\">A17<\/strong> : <code data-start=\"1918\" data-end=\"1942\">Statistiques de classe<\/code> (Gras).<\/p>\n<\/li>\n<li data-start=\"1953\" data-end=\"2014\">\n<p data-start=\"1956\" data-end=\"2014\"><strong data-start=\"1956\" data-end=\"1963\">B17<\/strong> : <code data-start=\"1966\" data-end=\"1974\">Test 1<\/code>\u2003<strong data-start=\"1975\" data-end=\"1982\">C17<\/strong> : <code data-start=\"1985\" data-end=\"1993\">Test 2<\/code>\u2003<strong data-start=\"1994\" data-end=\"2001\">D17<\/strong> : <code data-start=\"2004\" data-end=\"2012\">Test 3<\/code><\/p>\n<\/li>\n<li data-start=\"2015\" data-end=\"2087\">\n<p data-start=\"2018\" data-end=\"2087\"><strong data-start=\"2018\" data-end=\"2025\">A18<\/strong> : <code data-start=\"2028\" data-end=\"2037\">Moyenne<\/code><br data-start=\"2037\" data-end=\"2040\" \/><strong data-start=\"2043\" data-end=\"2050\">A19<\/strong> : <code data-start=\"2053\" data-end=\"2062\">Minimum<\/code><br data-start=\"2062\" data-end=\"2065\" \/><strong data-start=\"2068\" data-end=\"2075\">A20<\/strong> : <code data-start=\"2078\" data-end=\"2087\">Maximum<\/code><\/p>\n<\/li>\n<\/ol>\n<h3 data-start=\"2089\" data-end=\"2125\">2.2 Moyenne \/ Min \/ Max par test<\/h3>\n<ul data-start=\"2126\" data-end=\"2386\">\n<li data-start=\"2126\" data-end=\"2218\">\n<p data-start=\"2128\" data-end=\"2218\"><strong data-start=\"2128\" data-end=\"2135\">B18<\/strong> : <code data-start=\"2138\" data-end=\"2156\">=MOYENNE(B4:B15)<\/code>\u2003\u2003<strong data-start=\"2158\" data-end=\"2165\">C18<\/strong> : <code data-start=\"2168\" data-end=\"2186\">=MOYENNE(C4:C15)<\/code>\u2003\u2003<strong data-start=\"2188\" data-end=\"2195\">D18<\/strong> : <code data-start=\"2198\" data-end=\"2216\">=MOYENNE(D4:D15)<\/code><\/p>\n<\/li>\n<li data-start=\"2219\" data-end=\"2303\">\n<p data-start=\"2221\" data-end=\"2303\"><strong data-start=\"2221\" data-end=\"2228\">B19<\/strong> : <code data-start=\"2231\" data-end=\"2245\">=MIN(B4:B15)<\/code>\u2003\u2003\u2003\u2003<strong data-start=\"2249\" data-end=\"2256\">C19<\/strong> : <code data-start=\"2259\" data-end=\"2273\">=MIN(C4:C15)<\/code>\u2003\u2003\u2003\u2003<strong data-start=\"2277\" data-end=\"2284\">D19<\/strong> : <code data-start=\"2287\" data-end=\"2301\">=MIN(D4:D15)<\/code><\/p>\n<\/li>\n<li data-start=\"2304\" data-end=\"2386\">\n<p data-start=\"2306\" data-end=\"2386\"><strong data-start=\"2306\" data-end=\"2313\">B20<\/strong> : <code data-start=\"2316\" data-end=\"2330\">=MAX(B4:B15)<\/code>\u2003\u2003\u2003\u2003<strong data-start=\"2334\" data-end=\"2341\">C20<\/strong> : <code data-start=\"2344\" data-end=\"2358\">=MAX(C4:C15)<\/code>\u2003\u2003\u2003\u2003<strong data-start=\"2362\" data-end=\"2369\">D20<\/strong> : <code data-start=\"2372\" data-end=\"2386\">=MAX(D4:D15)<\/code><\/p>\n<\/li>\n<\/ul>\n<h3 data-start=\"2388\" data-end=\"2436\">2.3 Comptages &amp; taux de r\u00e9ussite (colonne A)<\/h3>\n<ul data-start=\"2437\" data-end=\"2890\">\n<li data-start=\"2437\" data-end=\"2494\">\n<p data-start=\"2439\" data-end=\"2494\"><strong data-start=\"2439\" data-end=\"2446\">A21<\/strong> : <code data-start=\"2449\" data-end=\"2466\">Nombre d\u2019\u00e9l\u00e8ves<\/code> \u2192 <strong data-start=\"2469\" data-end=\"2476\">B21<\/strong> : <code data-start=\"2479\" data-end=\"2492\">=NB(B4:B15)<\/code><\/p>\n<\/li>\n<li data-start=\"2495\" data-end=\"2571\">\n<p data-start=\"2497\" data-end=\"2571\"><strong data-start=\"2497\" data-end=\"2504\">A22<\/strong> : <code data-start=\"2507\" data-end=\"2533\">R\u00e9ussites (moyenne \u2265 60)<\/code> \u2192 <strong data-start=\"2536\" data-end=\"2543\">B22<\/strong> : <code data-start=\"2546\" data-end=\"2569\">=NB.SI(E4:E15;\"&gt;=60\")<\/code><\/p>\n<\/li>\n<li data-start=\"2572\" data-end=\"2644\">\n<p data-start=\"2574\" data-end=\"2644\"><strong data-start=\"2574\" data-end=\"2581\">A23<\/strong> : <code data-start=\"2584\" data-end=\"2607\">\u00c9checs (moyenne &lt; 60)<\/code> \u2192 <strong data-start=\"2610\" data-end=\"2617\">B23<\/strong> : <code data-start=\"2620\" data-end=\"2642\">=NB.SI(E4:E15;\"&lt;60\")<\/code><\/p>\n<\/li>\n<li data-start=\"2645\" data-end=\"2731\">\n<p data-start=\"2647\" data-end=\"2731\"><strong data-start=\"2647\" data-end=\"2654\">A24<\/strong> : <code data-start=\"2657\" data-end=\"2675\">Taux de r\u00e9ussite<\/code> \u2192 <strong data-start=\"2678\" data-end=\"2685\">B24<\/strong> : <code data-start=\"2688\" data-end=\"2698\">=B22\/B21<\/code> \u2192 <strong data-start=\"2701\" data-end=\"2716\">Accueil &gt; %<\/strong> (0 d\u00e9cimale)<\/p>\n<\/li>\n<li data-start=\"2732\" data-end=\"2806\">\n<p data-start=\"2734\" data-end=\"2806\"><strong data-start=\"2734\" data-end=\"2741\">A25<\/strong> : <code data-start=\"2744\" data-end=\"2773\">Moyenne g\u00e9n\u00e9rale (moyennes)<\/code> \u2192 <strong data-start=\"2776\" data-end=\"2783\">B25<\/strong> : <code data-start=\"2786\" data-end=\"2804\">=MOYENNE(E4:E15)<\/code><\/p>\n<\/li>\n<li data-start=\"2807\" data-end=\"2890\">\n<p data-start=\"2809\" data-end=\"2890\"><strong data-start=\"2809\" data-end=\"2816\">A26<\/strong> : <code data-start=\"2819\" data-end=\"2840\">Moyenne des r\u00e9ussis<\/code> \u2192 <strong data-start=\"2843\" data-end=\"2850\">B26<\/strong> : <code data-start=\"2853\" data-end=\"2890\">=MOYENNE.SI(F4:F15;\"R\u00e9ussi\";E4:E15)<\/code><\/p>\n<\/li>\n<\/ul>\n<p data-start=\"2892\" data-end=\"2978\"><em data-start=\"2892\" data-end=\"2978\">(Astuce : si Excel n\u2019actualise pas, <strong data-start=\"2929\" data-end=\"2975\">Formules &gt; Options de calcul &gt; Automatique<\/strong>.)<\/em><\/p>\n<hr data-start=\"2980\" data-end=\"2983\" \/>\n<h2 data-start=\"2985\" data-end=\"3020\">3) Graphiques (2 visualisations)<\/h2>\n<h3 data-start=\"3022\" data-end=\"3075\">3.1 Graphique 1 \u2014 <strong data-start=\"3044\" data-end=\"3064\">Moyenne par test<\/strong> (colonnes)<\/h3>\n<ol data-start=\"3076\" data-end=\"3416\">\n<li data-start=\"3076\" data-end=\"3151\">\n<p data-start=\"3079\" data-end=\"3151\">S\u00e9lectionne <strong data-start=\"3091\" data-end=\"3102\">B17:D18<\/strong> (la ligne des titres + la ligne des moyennes).<\/p>\n<\/li>\n<li data-start=\"3152\" data-end=\"3208\">\n<p data-start=\"3155\" data-end=\"3208\"><strong data-start=\"3155\" data-end=\"3180\">Ins\u00e9rer &gt; Histogramme<\/strong> \u2192 <strong data-start=\"3183\" data-end=\"3205\">Histogramme group\u00e9<\/strong>.<\/p>\n<\/li>\n<li data-start=\"3209\" data-end=\"3284\">\n<p data-start=\"3212\" data-end=\"3284\"><strong data-start=\"3212\" data-end=\"3234\">Titre du graphique<\/strong> : clique et tape <code data-start=\"3252\" data-end=\"3281\">Moyenne par test \u2014 Classe A<\/code>.<\/p>\n<\/li>\n<li data-start=\"3285\" data-end=\"3353\">\n<p data-start=\"3288\" data-end=\"3353\"><strong data-start=\"3288\" data-end=\"3299\">D\u00e9place<\/strong> le graphique \u00e0 droite du tableau (glisser-d\u00e9poser).<\/p>\n<\/li>\n<li data-start=\"3354\" data-end=\"3416\">\n<p data-start=\"3357\" data-end=\"3416\">(Optionnel) Bouton <strong data-start=\"3376\" data-end=\"3381\">+<\/strong> \u2192 coche <strong data-start=\"3390\" data-end=\"3415\">\u00c9tiquettes de donn\u00e9es<\/strong>.<\/p>\n<\/li>\n<\/ol>\n<h3 data-start=\"3418\" data-end=\"3484\">3.2 Graphique 2 \u2014 <strong data-start=\"3440\" data-end=\"3472\">R\u00e9partition R\u00e9ussites\/\u00c9checs<\/strong> (camembert)<\/h3>\n<ol data-start=\"3485\" data-end=\"3794\">\n<li data-start=\"3485\" data-end=\"3616\">\n<p data-start=\"3488\" data-end=\"3522\">Pr\u00e9pare 2 cellules de synth\u00e8se :<\/p>\n<ul data-start=\"3526\" data-end=\"3616\">\n<li data-start=\"3526\" data-end=\"3570\">\n<p data-start=\"3528\" data-end=\"3570\"><strong data-start=\"3528\" data-end=\"3535\">A28<\/strong> : <code data-start=\"3538\" data-end=\"3549\">R\u00e9ussites<\/code>\u2003\u2192 <strong data-start=\"3552\" data-end=\"3559\">B28<\/strong> : <code data-start=\"3562\" data-end=\"3568\">=B22<\/code><\/p>\n<\/li>\n<li data-start=\"3574\" data-end=\"3616\">\n<p data-start=\"3576\" data-end=\"3616\"><strong data-start=\"3576\" data-end=\"3583\">A29<\/strong> : <code data-start=\"3586\" data-end=\"3594\">\u00c9checs<\/code>\u2003\u2003\u2192 <strong data-start=\"3598\" data-end=\"3605\">B29<\/strong> : <code data-start=\"3608\" data-end=\"3614\">=B23<\/code><\/p>\n<\/li>\n<\/ul>\n<\/li>\n<li data-start=\"3617\" data-end=\"3700\">\n<p data-start=\"3620\" data-end=\"3700\">S\u00e9lectionne <strong data-start=\"3632\" data-end=\"3643\">A28:B29<\/strong> \u2192 <strong data-start=\"3646\" data-end=\"3668\">Ins\u00e9rer &gt; Secteurs<\/strong> \u2192 <strong data-start=\"3671\" data-end=\"3685\">Secteur 2D<\/strong> (camembert).<\/p>\n<\/li>\n<li data-start=\"3701\" data-end=\"3745\">\n<p data-start=\"3704\" data-end=\"3745\"><strong data-start=\"3704\" data-end=\"3713\">Titre<\/strong> : <code data-start=\"3716\" data-end=\"3742\">R\u00e9partition des mentions<\/code>.<\/p>\n<\/li>\n<li data-start=\"3746\" data-end=\"3794\">\n<p data-start=\"3749\" data-end=\"3794\">Ajoute <strong data-start=\"3756\" data-end=\"3781\">\u00c9tiquettes de donn\u00e9es<\/strong> si souhait\u00e9.<\/p>\n<\/li>\n<\/ol>\n<p data-start=\"3796\" data-end=\"3807\"><strong data-start=\"3796\" data-end=\"3806\">Ctrl+S<\/strong>.<\/p>\n<hr data-start=\"3809\" data-end=\"3812\" \/>\n<h2 data-start=\"3814\" data-end=\"3891\">4) Feuilles \u00ab Classe B \u00bb et \u00ab Classe C \u00bb (duplication + nouveaux chiffres)<\/h2>\n<ol data-start=\"3892\" data-end=\"4355\">\n<li data-start=\"3892\" data-end=\"4008\">\n<p data-start=\"3895\" data-end=\"4008\"><strong data-start=\"3895\" data-end=\"3909\">Clic droit<\/strong> sur l\u2019onglet en bas (<strong data-start=\"3931\" data-end=\"3941\">Feuil1<\/strong> ou renomme d\u2019abord en <strong data-start=\"3964\" data-end=\"3976\">Classe A<\/strong>) \u2192 <strong data-start=\"3980\" data-end=\"3992\">Renommer<\/strong> : <code data-start=\"3995\" data-end=\"4005\">Classe A<\/code>.<\/p>\n<\/li>\n<li data-start=\"4009\" data-end=\"4128\">\n<p data-start=\"4012\" data-end=\"4128\"><strong data-start=\"4012\" data-end=\"4026\">Clic droit<\/strong> sur <code data-start=\"4031\" data-end=\"4041\">Classe A<\/code> \u2192 <strong data-start=\"4044\" data-end=\"4067\">D\u00e9placer ou copier\u2026<\/strong> \u2192 coche <strong data-start=\"4076\" data-end=\"4095\">Cr\u00e9er une copie<\/strong> \u2192 <strong data-start=\"4098\" data-end=\"4104\">OK<\/strong> \u2192 renomme <code data-start=\"4115\" data-end=\"4125\">Classe B<\/code>.<\/p>\n<\/li>\n<li data-start=\"4129\" data-end=\"4167\">\n<p data-start=\"4132\" data-end=\"4167\">Recommence pour cr\u00e9er <code data-start=\"4154\" data-end=\"4164\">Classe C<\/code>.<\/p>\n<\/li>\n<li data-start=\"4168\" data-end=\"4355\">\n<p data-start=\"4171\" data-end=\"4272\">Dans chaque nouvelle feuille, <strong data-start=\"4201\" data-end=\"4258\">remplace toutes les notes B4:D15 par d\u2019autres valeurs<\/strong> (au choix).<\/p>\n<ul data-start=\"4276\" data-end=\"4355\">\n<li data-start=\"4276\" data-end=\"4355\">\n<p data-start=\"4278\" data-end=\"4355\">Toutes les <strong data-start=\"4289\" data-end=\"4298\">stats<\/strong> et <strong data-start=\"4302\" data-end=\"4316\">graphiques<\/strong> se mettent \u00e0 jour <strong data-start=\"4335\" data-end=\"4354\">automatiquement<\/strong>.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<hr data-start=\"4357\" data-end=\"4360\" \/>\n<h2 data-start=\"4362\" data-end=\"4396\">5) R\u00e9cap des formules attendues<\/h2>\n<p data-start=\"4398\" data-end=\"4415\"><strong data-start=\"4398\" data-end=\"4413\">Par \u00e9l\u00e8ve :<\/strong><\/p>\n<ul data-start=\"4416\" data-end=\"4553\">\n<li data-start=\"4416\" data-end=\"4484\">\n<p data-start=\"4418\" data-end=\"4484\"><strong data-start=\"4418\" data-end=\"4424\">E4<\/strong> : <code data-start=\"4427\" data-end=\"4455\">=ARRONDI(MOYENNE(B4:D4);1)<\/code> \u2192 recopier jusqu\u2019\u00e0 <strong data-start=\"4475\" data-end=\"4482\">E15<\/strong><\/p>\n<\/li>\n<li data-start=\"4485\" data-end=\"4553\">\n<p data-start=\"4487\" data-end=\"4553\"><strong data-start=\"4487\" data-end=\"4493\">F4<\/strong> : <code data-start=\"4496\" data-end=\"4526\">=SI(E4&gt;=60;\"R\u00e9ussi\";\"\u00c9chec\")<\/code> \u2192 recopier jusqu\u2019\u00e0 <strong data-start=\"4546\" data-end=\"4553\">F15<\/strong><\/p>\n<\/li>\n<\/ul>\n<p data-start=\"4555\" data-end=\"4576\"><strong data-start=\"4555\" data-end=\"4574\">Stats de test :<\/strong><\/p>\n<ul data-start=\"4577\" data-end=\"4699\">\n<li data-start=\"4577\" data-end=\"4633\">\n<p data-start=\"4579\" data-end=\"4633\"><strong data-start=\"4579\" data-end=\"4594\">B18\/C18\/D18<\/strong> : <code data-start=\"4597\" data-end=\"4612\">=MOYENNE(...)<\/code> des colonnes B\/C\/D<\/p>\n<\/li>\n<li data-start=\"4634\" data-end=\"4667\">\n<p data-start=\"4636\" data-end=\"4667\"><strong data-start=\"4636\" data-end=\"4651\">B19\/C19\/D19<\/strong> : <code data-start=\"4654\" data-end=\"4665\">=MIN(...)<\/code><\/p>\n<\/li>\n<li data-start=\"4668\" data-end=\"4699\">\n<p data-start=\"4670\" data-end=\"4699\"><strong data-start=\"4670\" data-end=\"4685\">B20\/C20\/D20<\/strong> : <code data-start=\"4688\" data-end=\"4699\">=MAX(...)<\/code><\/p>\n<\/li>\n<\/ul>\n<p data-start=\"4701\" data-end=\"4729\"><strong data-start=\"4701\" data-end=\"4727\">Comptages &amp; agr\u00e9gats :<\/strong><\/p>\n<ul data-start=\"4730\" data-end=\"4960\">\n<li data-start=\"4730\" data-end=\"4757\">\n<p data-start=\"4732\" data-end=\"4757\"><strong data-start=\"4732\" data-end=\"4739\">B21<\/strong> : <code data-start=\"4742\" data-end=\"4755\">=NB(B4:B15)<\/code><\/p>\n<\/li>\n<li data-start=\"4758\" data-end=\"4795\">\n<p data-start=\"4760\" data-end=\"4795\"><strong data-start=\"4760\" data-end=\"4767\">B22<\/strong> : <code data-start=\"4770\" data-end=\"4793\">=NB.SI(E4:E15;\"&gt;=60\")<\/code><\/p>\n<\/li>\n<li data-start=\"4796\" data-end=\"4832\">\n<p data-start=\"4798\" data-end=\"4832\"><strong data-start=\"4798\" data-end=\"4805\">B23<\/strong> : <code data-start=\"4808\" data-end=\"4830\">=NB.SI(E4:E15;\"&lt;60\")<\/code><\/p>\n<\/li>\n<li data-start=\"4833\" data-end=\"4877\">\n<p data-start=\"4835\" data-end=\"4877\"><strong data-start=\"4835\" data-end=\"4842\">B24<\/strong> : <code data-start=\"4845\" data-end=\"4855\">=B22\/B21<\/code> (formater en <strong data-start=\"4869\" data-end=\"4874\">%<\/strong>)<\/p>\n<\/li>\n<li data-start=\"4878\" data-end=\"4910\">\n<p data-start=\"4880\" data-end=\"4910\"><strong data-start=\"4880\" data-end=\"4887\">B25<\/strong> : <code data-start=\"4890\" data-end=\"4908\">=MOYENNE(E4:E15)<\/code><\/p>\n<\/li>\n<li data-start=\"4911\" data-end=\"4960\">\n<p data-start=\"4913\" data-end=\"4960\"><strong data-start=\"4913\" data-end=\"4920\">B26<\/strong> : <code data-start=\"4923\" data-end=\"4960\">=MOYENNE.SI(F4:F15;\"R\u00e9ussi\";E4:E15)<\/code><\/p>\n<\/li>\n<\/ul>\n<p data-start=\"4962\" data-end=\"4980\"><strong data-start=\"4962\" data-end=\"4978\">Graphiques :<\/strong><\/p>\n<ul data-start=\"4981\" data-end=\"5093\">\n<li data-start=\"4981\" data-end=\"5040\">\n<p data-start=\"4983\" data-end=\"5040\"><strong data-start=\"4983\" data-end=\"4998\">Histogramme<\/strong> depuis <strong data-start=\"5006\" data-end=\"5017\">B17:D18<\/strong> (Moyennes par test).<\/p>\n<\/li>\n<li data-start=\"5041\" data-end=\"5093\">\n<p data-start=\"5043\" data-end=\"5093\"><strong data-start=\"5043\" data-end=\"5054\">Secteur<\/strong> depuis <strong data-start=\"5062\" data-end=\"5073\">A28:B29<\/strong> (R\u00e9ussites\/\u00c9checs).<\/p>\n<\/li>\n<\/ul>\n<hr data-start=\"5095\" data-end=\"5098\" \/>\n<h2 data-start=\"5100\" data-end=\"5116\">6) \u00c0 remettre<\/h2>\n<ul data-start=\"5117\" data-end=\"5383\">\n<li data-start=\"5117\" data-end=\"5383\">\n<p data-start=\"5119\" data-end=\"5190\">Un fichier <strong data-start=\"5130\" data-end=\"5139\">.xlsx<\/strong> avec <strong data-start=\"5145\" data-end=\"5177\">Classe A, Classe B, Classe C<\/strong>, chacune :<\/p>\n<ul data-start=\"5193\" data-end=\"5383\">\n<li data-start=\"5193\" data-end=\"5230\">\n<p data-start=\"5195\" data-end=\"5230\">Les 12 \u00e9l\u00e8ves + notes <strong data-start=\"5217\" data-end=\"5227\">B4:D15<\/strong>,<\/p>\n<\/li>\n<li data-start=\"5233\" data-end=\"5268\">\n<p data-start=\"5235\" data-end=\"5268\">Les formules <strong data-start=\"5248\" data-end=\"5255\">E\/F<\/strong> correctes,<\/p>\n<\/li>\n<li data-start=\"5271\" data-end=\"5327\">\n<p data-start=\"5273\" data-end=\"5327\">Le bloc <strong data-start=\"5281\" data-end=\"5297\">Statistiques<\/strong> rempli (B17:D20 + B21:B26),<\/p>\n<\/li>\n<li data-start=\"5330\" data-end=\"5383\">\n<p data-start=\"5332\" data-end=\"5383\">Les <strong data-start=\"5336\" data-end=\"5352\">2 graphiques<\/strong> \u00e0 droite, titr\u00e9s correctement.<\/p>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Guide pas-\u00e0-pas \u2014 Excel 365 (Windows) \u00a0 ASSUREZ-VOUS D&rsquo;UTILISER LA VERSION BUREAU ET NON LA VERSION WEB 0) Mise en route et sauvegarde Ouvre Excel \u2192 Classeur vierge. Sauvegarde tout de suite : Ctrl+S \u2192 nomme le fichier Sondage_[Pr\u00e9nom] \u2192 choisis ton dossier \u2192 Enregistrer.(Raccourcis utiles : Ctrl+S = enregistrer, Ctrl+Z = annuler, Ctrl+Y = &hellip; <a href=\"https:\/\/technoesn.com\/pl\/tache-excel\/\" class=\"more-link\">Continuer la lecture de <span class=\"screen-reader-text\">T\u00e2che Excel<\/span>  <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-1454","page","type-page","status-publish","hentry"],"featured_image_src":null,"_links":{"self":[{"href":"https:\/\/technoesn.com\/pl\/wp-json\/wp\/v2\/pages\/1454","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/technoesn.com\/pl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/technoesn.com\/pl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/technoesn.com\/pl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/technoesn.com\/pl\/wp-json\/wp\/v2\/comments?post=1454"}],"version-history":[{"count":2,"href":"https:\/\/technoesn.com\/pl\/wp-json\/wp\/v2\/pages\/1454\/revisions"}],"predecessor-version":[{"id":1470,"href":"https:\/\/technoesn.com\/pl\/wp-json\/wp\/v2\/pages\/1454\/revisions\/1470"}],"wp:attachment":[{"href":"https:\/\/technoesn.com\/pl\/wp-json\/wp\/v2\/media?parent=1454"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}