{"id":214,"date":"2016-09-01T14:20:25","date_gmt":"2016-09-01T12:20:25","guid":{"rendered":"http:\/\/www.jterraz.net\/wordpress\/?p=214"},"modified":"2016-09-01T14:58:56","modified_gmt":"2016-09-01T12:58:56","slug":"tuto-fonctions-de-base","status":"publish","type":"post","link":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/2016\/09\/01\/tuto-fonctions-de-base\/","title":{"rendered":"Tuto &#8211; Fonctions de base"},"content":{"rendered":"<p>Une fonction est une <span class=\"glossary autolink concept glossaryid1\">formule<\/span> particuli\u00e8re qui a un nom et des arguments<br \/>\nentre parenth\u00e8ses. =somme(A1:A12) fait la somme des cellules de A1<br \/>\njusqu&rsquo;\u00e0 A12<\/p>\n<p>1. Les fonctions statistiques les plus courantes<br \/>\nsont disponibles notamment sous le bouton \u00ab\u00a0Sigma\u00a0\u00bb (qui symbolise souvent<br \/>\nla somme en math\u00e9matiques).<br \/>\n2. Par d\u00e9faut, Excel va tenter d&rsquo;appliquer la fonction \u00e0 une s\u00e9rie de cellules adjacentes (en colonne ou en ligne)<br \/>\n3. Quand la zone sugg\u00e9r\u00e9e par Excel clignote, vous pouvez faire une autre s\u00e9lection pour votre fonction<br \/>\n4. Si vous connaissez le nom de la fonction, vous pouvez aussi la taper simplement dans une cellule<br \/>\n5. =max(I1:I3) renvoie la valeur maximale sur cette plage de cellules<br \/>\n6. Vous pouvez aussi m\u00e9langer les m\u00e9thodes : taper le nom de la fonction et cliquer sur la plage de cellules<\/p>\n<p><a href=\"http:\/\/www.jterraz.net\/wordpress\/wp-content\/uploads\/2016\/08\/fonctions.gif\" data-rel=\"lightbox-image-0\" data-imagelightbox=\"0\" data-rl_title=\"\" data-rl_caption=\"\" title=\"\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-100\" src=\"http:\/\/www.jterraz.net\/wordpress\/wp-content\/uploads\/2016\/08\/fonctions.gif\" alt=\"fonctions\" width=\"551\" height=\"263\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Une <a href=\"https:\/\/www.cours-info.ch\/wordpress\/index.php\/2016\/09\/01\/tuto-fonctions-de-base\/\" 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":[24],"tags":[],"class_list":["post-214","post","type-post","status-publish","format-standard","hentry","category-formules-et-fonctions"],"_links":{"self":[{"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/214","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=214"}],"version-history":[{"count":1,"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/214\/revisions"}],"predecessor-version":[{"id":215,"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/214\/revisions\/215"}],"wp:attachment":[{"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=214"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=214"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cours-info.ch\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}