{"id":1371,"date":"2019-02-09T10:43:49","date_gmt":"2019-02-09T09:43:49","guid":{"rendered":"https:\/\/www.cours-info.ch\/wordpress\/?p=1371"},"modified":"2019-02-09T10:48:57","modified_gmt":"2019-02-09T09:48:57","slug":"ex-ca-for-05-tableau-de-vos-moyennes-au-gymnase","status":"publish","type":"post","link":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/2019\/02\/09\/ex-ca-for-05-tableau-de-vos-moyennes-au-gymnase\/","title":{"rendered":"Ex. Ca.FOR.05 \u2013 Tableau de vos moyennes au gymnase"},"content":{"rendered":"\n<p><strong>Utile (voire indispensable)<\/strong><br>La fonction arrondi.au.multiple permet de faire un arrondi au multiple qu&rsquo;on veut, par exemple =arrondi.au.multiple(3.1415;2) nous arrondit la valeur (3.1415) \u00e0 4 parce que c&rsquo;est le multiple de 2 le plus proche. Contrairement au formatage de cellule qui d\u00e9finit le nombre de d\u00e9cimale, cet arrondi change la valeur, cette diff\u00e9rence est fondamentale dans un tableur.<\/p>\n\n\n\n<p><strong>Situation<\/strong><br>Vous souhaitez cr\u00e9er un tableau de vos notes au gymnase.<br><br><strong>Consignes<\/strong><br>1. Utilisez tout ce que vous savez pour en faire un tableau enti\u00e8rement automatique (les moyennes notamment)<br>2. Vous souhaitez pouvoir entrer vos notes et que le tableau indique vos moyennes<br>3. La fonction MOYENNE doit \u00e9videmment \u00eatre utilis\u00e9e<br>4. Quand vous avez fini, enregistrez-le sous&nbsp;<strong>Mes moyennes<\/strong>&nbsp;et d\u00e9posez-le dans votre dossier personnel dans le dossier \u00ab\u00a0Calc\u00a0\u00bb<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Utile <a href=\"https:\/\/www.cours-info.ch\/wordpress\/index.php\/2019\/02\/09\/ex-ca-for-05-tableau-de-vos-moyennes-au-gymnase\/\" class=\"read-more\">Cliquez pour voir la suite<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54],"tags":[],"class_list":["post-1371","post","type-post","status-publish","format-standard","hentry","category-formules-et-fonctions-calc"],"_links":{"self":[{"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/1371","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=1371"}],"version-history":[{"count":2,"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/1371\/revisions"}],"predecessor-version":[{"id":1379,"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/1371\/revisions\/1379"}],"wp:attachment":[{"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=1371"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=1371"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=1371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}