{"id":21976,"date":"2020-09-21T11:56:26","date_gmt":"2020-09-21T09:56:26","guid":{"rendered":"https:\/\/agora.xtec.cat\/escolasaavedra\/?page_id=21976"},"modified":"2020-10-30T10:27:08","modified_gmt":"2020-10-30T09:27:08","slug":"excel-i-google-fulls-de-calcul","status":"publish","type":"page","link":"https:\/\/agora.xtec.cat\/escolasaavedra\/formacio\/2020-2021\/nivell-intermig\/excel-i-google-fulls-de-calcul\/","title":{"rendered":"Excel i Google Fulls de C\u00e0lcul"},"content":{"rendered":"<h4>1.-\u00a0Format condicional<\/h4>\n<p>El format condicional, aplicat a una cel\u00b7la o grup de cel\u00b7les, permet modificar-ne l&#8217;aparen\u00e7a en funci\u00f3 del contingut de la mateixa autom\u00e0ticament. Per exemple, si volem que la cel\u00b7la tingui el fons verd si la xifra que cont\u00e9 \u00e9s superior o igual a cinc o tingui el fons de color vermell si la xifra que cont\u00e9 \u00e9s inferior a cinc.<\/p>\n<p>Al seg\u00fcent video s&#8217;explica com es realitza aquesta opci\u00f3 a Google Fulls de C\u00e0lcul, per\u00f2 si ho volem aplicar a Excel, el procediment \u00e9s an\u00e0leg.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li>Seleccionem la cel\u00b7la o cel\u00b7les a les que volem aplicar el format condicionl<\/li>\n<li>Al men\u00fa, seleccionem <strong>FORMAT<\/strong> i dins la llista d&#8217;opcions que apareixen, triarem <strong>FORMAT CONDICIONAL<\/strong><\/li>\n<li>S&#8217;obrir\u00e0 un men\u00fa contextual a la part dreta de la pantalla amb les opcions del format condicional<\/li>\n<li>A l&#8217;apartat <strong>APLICA A L&#8217;INTERVAL<\/strong> hi apareixer\u00e0 la cel\u00b7la o grups de cel\u00b7les que hem triat.<\/li>\n<li>A l&#8217;apartat <strong>REGLES DE FORMAT<\/strong> escollirem la que m\u00e9s ens convingui en cada cas. En el cas del nostre exemple, escollirem <strong>M\u00c9S INFERIOR O IGUAL QUE<\/strong> per a aplicar el format condicional a totes les cel\u00b7les seleccionades amb valors iguals o inferiors a una xifra determinada.<\/li>\n<li>A l&#8217;apartat <strong>ESTIL DE FORMAT<\/strong> escollirem el format que volem per a les cel\u00b7les que compleixin les condicions expressades anteriorment. Si cliquem a <strong>PREDETERMINAT<\/strong> Aja hi ha unes combinacions preestablertes, per\u00f2 si ho volem personalitzar ho podem fer amb les icones de <strong>B<\/strong>\u00a0 (negreta) <strong>I<\/strong> (Cursiva)\u00a0 <strong>U<\/strong> (Subratllat) <strong>S<\/strong> (tatxat) <strong>A<\/strong> (Color de la lletra)\u00a0 i el<strong> POT DE PINTURA<\/strong> (Color de fons de la cel\u00b7la)<\/li>\n<li>Finalment clicarem a <strong>FET<\/strong> per a desar els canvis<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p><strong>Nota<\/strong>: Si volem afegir un altre format condicional haurem de repetir el procediment. Uncop afegides totes les condicions de format les veurem en una llista. La primera condici\u00f3 que de la llista que compleixi cada cel\u00b7la ser\u00e0 l&#8217;aplicada, encara que en compleixi de m\u00e9s avall. Per tal que prevalguin unes sobre les altres les haurem de variar d&#8217;ordre a la llista.<\/p>\n<p style=\"text-align: center;\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/2F5mrs4ggcg\" width=\"560\" height=\"315\" frameborder=\"0\"><\/iframe><\/p>\n<h4><span style=\"font-weight: 400;\">2.- Immobilitzar panell<\/span><\/h4>\n<p>Immobilitzar files o columnes, o totes dues, ens pot ser \u00fatil si volem mantenir a la vista aquesta fila o columnaencara que ens moguem pel full de c\u00e0lcul. \u00c9s com l&#8217;antiga llibreta del mestre on apunt\u00e0vem les notesi anotacions de cada alumne. Hi havia p\u00e0gines que es podien retallar per poder veure els noms del s alumnes d&#8217;unes p\u00e0gines endarrera i estalviar-se de copiar els noms dels nens i nenes a cada p\u00e0gina. Fer-ho amb un full de c\u00e0lcul ens donar\u00e0 m\u00e9s versatilitat i agilitat a l&#8217;hora de fer c\u00e0lculs matem\u00e0tics de notes.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li>Seleccionem la fila o la columna que desitgem immobilitar fent un clica sobre de la lletra (columna) o de la xifra (fila) corresponent a cada columna o fila.<\/li>\n<li>Aquesta columna o fila apareixer\u00e0 a la pantalla amb fons gris.<\/li>\n<li>Anirem al men\u00fa <strong>MOSTRA<\/strong> i escollirem <strong>IMMOBILITZA<\/strong><\/li>\n<li>Escollirem de les opcions, la que m\u00e9s ens convingui a cada cas (\u00cddem amb les columnes)\n<ul>\n<li><span style=\"text-decoration: underline;\">CAP FILA<\/span> \u2192 Allibera files immobilitzades pr\u00e8viament<\/li>\n<li><span style=\"text-decoration: underline;\">UNA FILA<\/span> \u2192 Immobilitza la fila 1<\/li>\n<li><span style=\"text-decoration: underline;\">DUES FILES<\/span> \u2192 Immobilitza les files 1 i 2<\/li>\n<li><span style=\"text-decoration: underline;\">FINS A L&#8217;ACTUAL<\/span> \u2192 Immobilitza totes les files fins a la fila seleccionada<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p style=\"text-align: center;\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/1BK8erlRLnM\" width=\"560\" height=\"315\" frameborder=\"0\"><\/iframe><\/p>\n<h4><span style=\"font-weight: 400;\">3.- Hipervincles entre p\u00e0gines<\/span><\/h4>\n<p>Quan tenim un full de c\u00e0lcul hi podem afegir tantes p\u00e0gines com volguem clicant al + que hi ha a la part inferior esquerra de la pantalla. A aquestes p\u00e0gines se li poden canviar el nom si fem clic amb el bot\u00f3 dret del ratol\u00ed. Anar d&#8217;una p\u00e0gina a una altra \u00e9s tant f\u00e0cil com fer-hi clic a sobre del nom, per\u00f2 si tenim moltes p\u00e0gines, no totes apareixen a la pantalls, i ens pot ajudar fer-hi hipervincles (enlla\u00e7os) entre elles.<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li>\u00a0Seleccionem la cel\u00b7la que volem que tingui l&#8217;enlla\u00e7 a un altra p\u00e0gina i li posem un text o una xifra<\/li>\n<li>Anem al men\u00fa <strong>INSEREIX<\/strong> i escollim<strong> INSEREIX UN ENLLA\u00c7<\/strong><\/li>\n<li>Se&#8217;ns obre un men\u00fa contextual a la cel\u00b7la amb un camp <strong>TEXT<\/strong> i el contingut de la cel\u00b7la i un camp <strong>ENLLA\u00c7<\/strong> on hi haurem de posar el dest\u00ed del nostre hipervincle.\n<ul>\n<li>Hi podem enganxar un enlla\u00e7 a una p\u00e0gina web o clicant a FULLS EN AQUEST FULL DE C\u00c0LCUL ens apareixeran a sota les p\u00e0gines que t\u00e9 aquest full de c\u00e0lcul. Cliquem a sobre de la que ens interessa<\/li>\n<\/ul>\n<\/li>\n<li>Seguidament clicarem a APLICA i autom\u00e0ticament el text de la cel\u00b7la canviar\u00e0 de format a color blau i subratllat, que denota que l&#8217;enlla\u00e7 est\u00e0 fet.<\/li>\n<li>Fent clic a sobre de la cel\u00b7la amb l&#8217;enlla\u00e7, ens portar\u00e0 directament al dest\u00ed que li hem assignat.<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<p style=\"text-align: center;\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/XyohsJO6tcE\" width=\"560\" height=\"315\" frameborder=\"0\"><\/iframe><\/p>\n<h4><span style=\"font-weight: 400;\">4.- \u00das del s\u00edmbol $<\/span><\/h4>\n<p>Com ja hem explicat anteriorment, quan arrastrem el format d&#8217;una cel\u00b7la cap a les dels costats o superior-inferior amb l&#8217;ajuda del quadradet negre que apareix a la part inferior dreta de cada cel\u00b7la o grup de cel\u00b7les quan les seleccionem, les f\u00f3rmules canvien per mantenir la relaci\u00f3 d&#8217;spai amb la cel\u00b7la original.<\/p>\n<p>Si volem que aix\u00f2 no passi i que tot i arrastrar el el format de la cel\u00b7la cap als costat o cap amunt-avall utilitzarem el s\u00edmbol <strong>$<\/strong> (a la tecla del n\u00famero 4 del teclat) per fixar aquella fila o aquella columna que volem que es mantingui estable.<\/p>\n<p>Per fer-hoi haurem d&#8217;escriure el s\u00edmbol $ al davant de la lletra de la columna o al davant del n\u00famero de la fila a la f\u00f3rmula (o a totes dues)\u00a0 per a que aquesta es mantingui inalterable.<\/p>\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li style=\"list-style-type: none;\">\n<ul>\n<li><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><\/strong><span dir=\"auto\"><strong>$C4<\/strong> \u2192 Tot i arrastrar el format de la cel\u00b7la, la columna C es mantindr\u00e0 inalterable, per\u00f2 la fila 4 si que variar\u00e0.<\/span><\/li>\n<li><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><\/strong><span dir=\"auto\"><strong>C<strong>$<\/strong>4<\/strong> \u2192 Tot i arrastrar el format de la cel\u00b7la, la fila 4 es mantindr\u00e0 inalterable, per\u00f2 la columna C si que variar\u00e0.<\/span><\/li>\n<li><strong><span class=\" default-formula-text-color\" dir=\"auto\">=<span dir=\"auto\">$<\/span><\/span><\/strong><span dir=\"auto\"><strong>C<strong>$<\/strong>4<\/strong> \u2192 Tot i arrastrar el format de la cel\u00b7la, la fila 4 es mantindr\u00e0 inalterable, i la columna C tamb\u00e9.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p style=\"text-align: center;\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/UkP7gZTVcrE\" width=\"560\" height=\"315\" frameborder=\"0\"><\/iframe><\/p>\n<h4><span style=\"font-weight: 400;\">5.- F\u00f3rmules m\u00e9s habituals<\/span><\/h4>\n<p>Algunes de les f\u00f3rmules m\u00e9s habituals i \u00fatils dels fulls de c\u00e0lcul s\u00f3n les seg\u00fcents:<\/p>\n<table style=\"width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 50%; text-align: center;\"><strong>Microsoft Excel<\/strong><\/td>\n<td style=\"width: 50%; text-align: center;\"><strong>Google Fulls de C\u00e0lcul<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\">=suma<\/td>\n<td style=\"text-align: center;\">=sum<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\">=concatenar<\/td>\n<td style=\"text-align: center;\">=concatenate<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\">=contar<br \/>\n=contara<br \/>\n=contar.si<\/td>\n<td style=\"text-align: center;\">=count<br \/>\n=counta<br \/>\n=countif<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\">=max<br \/>\n=min<\/td>\n<td style=\"text-align: center;\">=max<br \/>\n=min<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\">=si<\/td>\n<td style=\"text-align: center;\">=if<\/td>\n<\/tr>\n<tr>\n<td style=\"text-align: center;\">=aletorio<br \/>\n=aleatorio.entre<\/td>\n<td style=\"text-align: center;\">=rand<br \/>\n=randbetween<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: right;\">Les f\u00f3rmules s\u00f3n les mateixes, per\u00f2 Microfost Excel permet l&#8217;escrituptura en castell\u00e0,<br \/>\nmentre que Google Fulls de C\u00e0lcul necessita les f\u00f3rmules en angl\u00e8s.<\/p>\n<p>Una f\u00f3rmula comen\u00e7a necess\u00e0riament per un s\u00edmbol <span style=\"color: #0000ff;\"><strong>=<\/strong><\/span>, seguit del nom de la f\u00f3rmula i de dos par\u00e8ntesis<strong><span style=\"color: #0000ff;\"> ( )<\/span>. <\/strong>A l&#8217;interior dels par\u00e8ntesis hi aniran els camps de dades que necessita\u00a0la f\u00f3rmula sempre separats per un <span style=\"color: #0000ff;\"><strong>;<\/strong><\/span>. Respectar aquest ordre i aquesta simbologia ser\u00e0 clau per l&#8217;\u00e8xit de la f\u00f3rmula<\/p>\n<p><strong>SUM<\/strong><\/p>\n<table style=\"width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 13.984461709211987%; text-align: center;\"><strong>Descripci\u00f3<\/strong><\/td>\n<td style=\"width: 17.314095449500556%; text-align: center;\"><strong>Forma<\/strong><\/td>\n<td style=\"width: 17.98002219755827%; text-align: center;\"><strong>Camps necessaris<\/strong><\/td>\n<td style=\"width: 28.301886792452834%; text-align: center;\"><strong>Exemple<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 13.984461709211987%;\">Fer la suma de totes les cel\u00b7les seleccionades.<\/td>\n<td style=\"width: 17.314095449500556%; text-align: center;\"><strong>=sum(camp1;camp2;camp3)<\/strong><br \/>\n<strong>=sum(campInici:campFinal)<\/strong><\/td>\n<td style=\"width: 17.98002219755827%; text-align: center;\">Rang de cel\u00b7les a sumar<\/td>\n<td style=\"width: 28.301886792452834%; text-align: center;\"><strong>=sum(C4:C8)<\/strong><br \/>\nSumar\u00e0 les cel\u00b7les des de la C4 fins la C8<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>CONCATENATE<\/strong><\/p>\n<table style=\"width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 13.984461709211987%; text-align: center;\"><strong>Descripci\u00f3<\/strong><\/td>\n<td style=\"width: 17.314095449500556%; text-align: center;\"><strong>Forma<\/strong><\/td>\n<td style=\"width: 17.98002219755827%; text-align: center;\"><strong>Camps necessaris<\/strong><\/td>\n<td style=\"width: 28.301886792452834%; text-align: center;\"><strong>Exemple<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 13.984461709211987%;\">Escriu en una mateixa cel\u00b7la el contingut de divereses cel\u00b7les<\/td>\n<td style=\"width: 17.314095449500556%; text-align: center;\"><strong>=concatenate(camp1;camp2;camp3)<\/strong><\/td>\n<td style=\"width: 17.98002219755827%; text-align: center;\">Cel\u00b7les a concatenar<\/td>\n<td style=\"width: 28.301886792452834%; text-align: center;\"><strong>=sum(C4;C8;C17)<\/strong><br \/>\nEscriur\u00e0 a la cel\u00b7la on hi hagi la f\u00f3rmula els continguts de la cel\u00b7la C4, seguit de la cel\u00b7la C8 i la cel\u00b7la 17)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>COUNT<\/strong><\/p>\n<table style=\"width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 13.984461709211987%; text-align: center;\"><strong>Descripci\u00f3<\/strong><\/td>\n<td style=\"width: 17.314095449500556%; text-align: center;\"><strong>Forma<\/strong><\/td>\n<td style=\"width: 17.98002219755827%; text-align: center;\"><strong>Camps necessaris<\/strong><\/td>\n<td style=\"width: 28.301886792452834%; text-align: center;\"><strong>Exemple<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 13.984461709211987%;\">Compta el nombre de cel\u00b7les que contenen xifres de les seleccionades<\/td>\n<td style=\"width: 17.314095449500556%; text-align: center;\"><strong>=count(campInici:campFinal)<\/strong><\/td>\n<td style=\"width: 17.98002219755827%; text-align: center;\">Rang de cel\u00b7les a comptar-ne les que contenen xifres<\/td>\n<td style=\"width: 28.301886792452834%; text-align: center;\"><strong>=count(C4:C8)<\/strong><br \/>\nComptar\u00e0 quantes cel\u00b7les que contenen xifres de les compreses al rang des de la C4 fins a la C8<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>COUNTA<\/strong><\/p>\n<table style=\"width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 13.984461709211987%; text-align: center;\"><strong>Descripci\u00f3<\/strong><\/td>\n<td style=\"width: 17.314095449500556%; text-align: center;\"><strong>Forma<\/strong><\/td>\n<td style=\"width: 17.98002219755827%; text-align: center;\"><strong>Camps necessaris<\/strong><\/td>\n<td style=\"width: 28.301886792452834%; text-align: center;\"><strong>Exemple<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 13.984461709211987%;\">Compta el nombre de cel\u00b7les que contenen xifres o lletres de les seleccionades<\/td>\n<td style=\"width: 17.314095449500556%; text-align: center;\"><strong>=counta(campInici:campFinal)<\/strong><\/td>\n<td style=\"width: 17.98002219755827%; text-align: center;\">Rang de cel\u00b7les a comptar-ne les que contenen xifres o lletres<\/td>\n<td style=\"width: 28.301886792452834%; text-align: center;\"><strong>=counta(C4:C8)<\/strong><br \/>\nComptar\u00e0 quantes cel\u00b7les que contenen xifres o lletres de les compreses al rang des de la C4 fins a la C8<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>COUNTIF<\/strong><\/p>\n<table style=\"width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 13.984461709211987%; text-align: center;\"><strong>Descripci\u00f3<\/strong><\/td>\n<td style=\"width: 17.314095449500556%; text-align: center;\"><strong>Forma<\/strong><\/td>\n<td style=\"width: 17.98002219755827%; text-align: center;\"><strong>Camps necessaris<\/strong><\/td>\n<td style=\"width: 28.301886792452834%; text-align: center;\"><strong>Exemple<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 13.984461709211987%;\">Compta el nombre de cel\u00b7les que contenen un criteri preestablert<\/td>\n<td style=\"width: 17.314095449500556%; text-align: center;\"><strong>=countif<bdo dir=\"ltr\"><span class=\"waffle-arguments-paren\">(<\/span><span class=\"waffle-arguments-parameter-holder\"><span class=\"waffle-arguments-help-parameter waffle-arguments-help-parameter-active\" dir=\"auto\">interval<\/span>; <span class=\"waffle-arguments-help-parameter\" dir=\"auto\">criteri<\/span><\/span><span class=\"waffle-arguments-paren\">)<\/span><\/bdo><\/strong><\/td>\n<td style=\"width: 17.98002219755827%; text-align: left;\"><span style=\"text-decoration: underline;\">Interval<\/span> \u2192 Rang de cel\u00b7les a tenir en compte<br \/>\n<span style=\"text-decoration: underline;\">Criteri<\/span> \u2192 Qu\u00e8 ha de contenir la cel\u00b7la per a comptabilitzar-la<\/td>\n<td style=\"width: 28.301886792452834%; text-align: center;\"><strong>=countif(C4:C8;&#8221;8&#8243;)<\/strong><br \/>\nComptar\u00e0 quantes cel\u00b7les que responen al criteri donat (el seu valor \u00e7es igual a 8) de les compreses al rang des de la C4 fins a la C8<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>MAX<\/strong><\/p>\n<table style=\"width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 19.1266%; text-align: center;\"><strong>Descripci\u00f3<\/strong><\/td>\n<td style=\"width: 12.172%; text-align: center;\"><strong>Forma<\/strong><\/td>\n<td style=\"width: 17.98%; text-align: center;\"><strong>Camps necessaris<\/strong><\/td>\n<td style=\"width: 28.3019%; text-align: center;\"><strong>Exemple<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 19.1266%;\">Escriu a la cel\u00b7l on hi ha la f\u00f3rmula la xifra m\u00e9s alta de totes les que hiha a les cel\u00b7les seleccionades<\/td>\n<td style=\"width: 12.172%; text-align: center;\"><strong>=max<bdo dir=\"ltr\"><span class=\"waffle-arguments-paren\">(<\/span><span class=\"waffle-arguments-parameter-holder\"><span class=\"waffle-arguments-help-parameter waffle-arguments-help-parameter-active\" dir=\"auto\">campInici:campFinal<\/span><\/span><span class=\"waffle-arguments-paren\">)<\/span><\/bdo><\/strong><\/td>\n<td style=\"width: 17.98%; text-align: left;\">Rang de cel\u00b7les de les que volem saber la xifra m\u00e9s alta<\/td>\n<td style=\"width: 28.3019%; text-align: center;\"><strong>=max(C4:C8)<\/strong><br \/>\nEscriur\u00e0 quina de les cel\u00b7les compreses entre la cel\u00b7la C4 i C8 quina t\u00e9 el valor de xifra m\u00e9s alt<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>MIN<\/strong><\/p>\n<table style=\"width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 19.1266%; text-align: center;\"><strong>Descripci\u00f3<\/strong><\/td>\n<td style=\"width: 12.172%; text-align: center;\"><strong>Forma<\/strong><\/td>\n<td style=\"width: 17.98%; text-align: center;\"><strong>Camps necessaris<\/strong><\/td>\n<td style=\"width: 28.3019%; text-align: center;\"><strong>Exemple<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 19.1266%;\">Escriu a la cel\u00b7l on hi ha la f\u00f3rmula la xifra m\u00e9s baixa de totes les que hiha a les cel\u00b7les seleccionades<\/td>\n<td style=\"width: 12.172%; text-align: center;\"><strong>=min<bdo dir=\"ltr\"><span class=\"waffle-arguments-paren\">(<\/span><span class=\"waffle-arguments-parameter-holder\"><span class=\"waffle-arguments-help-parameter waffle-arguments-help-parameter-active\" dir=\"auto\">campInici:campFinal<\/span><\/span><span class=\"waffle-arguments-paren\">)<\/span><\/bdo><\/strong><\/td>\n<td style=\"width: 17.98%; text-align: left;\">Rang de cel\u00b7les de les que volem saber la xifra m\u00e9s baixa<\/td>\n<td style=\"width: 28.3019%; text-align: center;\"><strong>=min(C4:C8)<\/strong><br \/>\nEscriur\u00e0 quina de les cel\u00b7les compreses entre la cel\u00b7la C4 i C8 quina t\u00e9 el valor de xifra m\u00e9s baix<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>IF<\/strong><\/p>\n<table style=\"width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 19.1266%; text-align: center;\"><strong>Descripci\u00f3<\/strong><\/td>\n<td style=\"width: 12.172%; text-align: center;\"><strong>Forma<\/strong><\/td>\n<td style=\"width: 17.98%; text-align: center;\"><strong>Camps necessaris<\/strong><\/td>\n<td style=\"width: 28.3019%; text-align: center;\"><strong>Exemple<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 19.1266%;\">Quan es compleix una condici\u00f3 establerta, el contingut de la cel\u00b7la \u00e9s un i si no es compleix \u00e9s un altre<\/td>\n<td style=\"width: 12.172%; text-align: center;\"><strong>=if<bdo dir=\"ltr\"><span class=\"waffle-arguments-paren\">(<\/span><span class=\"waffle-arguments-parameter-holder\"><span class=\"waffle-arguments-help-parameter waffle-arguments-help-parameter-active\" dir=\"auto\">Condici\u00f3;ValorCert;ValorFals<\/span><\/span><span class=\"waffle-arguments-paren\">)<\/span><\/bdo><\/strong><\/td>\n<td style=\"width: 17.98%; text-align: left;\"><span style=\"text-decoration: underline;\">Condici\u00f3<\/span> \u2192 Regla que volem que es compleixi<br \/>\n<span style=\"text-decoration: underline;\">ValorCert<\/span> \u2192 Valor de resultat si la condici\u00f3 \u00e9s certa<br \/>\n<span style=\"text-decoration: underline;\">ValorFals<\/span> \u2192Valor de resultat si la condici\u00f3 \u00e9s falsa<\/td>\n<td style=\"width: 28.3019%; text-align: center;\"><strong>=if(C4=C8;&#8221;SI&#8221;;&#8221;NO&#8221;)<\/strong><br \/>\nEscriur\u00e0 a la cel\u00b7la SI si es compleix que el valor de la cel\u00b7la C4 \u00e9s igual que la Cel\u00b7la C8<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>RAND<\/strong><\/p>\n<table style=\"width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 19.1266%; text-align: center;\"><strong>Descripci\u00f3<\/strong><\/td>\n<td style=\"width: 12.172%; text-align: center;\"><strong>Forma<\/strong><\/td>\n<td style=\"width: 17.98%; text-align: center;\"><strong>Camps necessaris<\/strong><\/td>\n<td style=\"width: 28.3019%; text-align: center;\"><strong>Exemple<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 19.1266%;\">Escriu a la cel\u00b7la on hi ha la f\u00f3rmula una xifra aleatoria entre 0 i 1. Cada cop que s&#8217;actualitzen les f\u00f3rmules, el nombre aleatori canvia<\/td>\n<td style=\"width: 12.172%; text-align: center;\"><strong>=rand<bdo dir=\"ltr\"><span class=\"waffle-arguments-paren\">(<\/span><span class=\"waffle-arguments-paren\">)<\/span><\/bdo><\/strong><\/td>\n<td style=\"width: 17.98%; text-align: left;\">Cap<\/td>\n<td style=\"width: 28.3019%; text-align: center;\"><strong>=rand()<\/strong><br \/>\nEscriur\u00e0, per exemple 0.2548<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p><strong>RANDBETWEEN<\/strong><\/p>\n<table style=\"width: 100%;\">\n<tbody>\n<tr>\n<td style=\"width: 19.1266%; text-align: center;\"><strong>Descripci\u00f3<\/strong><\/td>\n<td style=\"width: 12.172%; text-align: center;\"><strong>Forma<\/strong><\/td>\n<td style=\"width: 17.98%; text-align: center;\"><strong>Camps necessaris<\/strong><\/td>\n<td style=\"width: 28.3019%; text-align: center;\"><strong>Exemple<\/strong><\/td>\n<\/tr>\n<tr>\n<td style=\"width: 19.1266%;\">Escriu a la cel\u00b7la on hi ha la f\u00f3rmula una xifra aleatoria entre dues xifres determinades. Cada cop que s&#8217;actualitzen les f\u00f3rmules, el nombre aleatori canvia<\/td>\n<td style=\"width: 12.172%; text-align: center;\"><strong>=randbetween<bdo dir=\"ltr\"><span class=\"waffle-arguments-paren\">(XifraInferior;XifraSuperior<\/span><span class=\"waffle-arguments-paren\">)<\/span><\/bdo><\/strong><\/td>\n<td style=\"width: 17.98%; text-align: left;\"><u>Xifra Inferior<\/u>\u2192 N\u00famero m\u00e9s petit que donar\u00e0 aleatoriament<br \/>\n<u>Xifra Superior<\/u>\u2192 N\u00famero m\u00e9s alt que donar\u00e0 aleatoriament<\/td>\n<td style=\"width: 28.3019%; text-align: center;\"><strong>=randbetween(1;10)<\/strong><br \/>\nEscriur\u00e0, per exemple 5<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: center;\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/CZRcbPzfmRU\" width=\"560\" height=\"315\" frameborder=\"0\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1.-\u00a0Format condicional El format condicional, aplicat a una cel\u00b7la o grup de cel\u00b7les, permet modificar-ne l&#8217;aparen\u00e7a en funci\u00f3 del contingut de la mateixa autom\u00e0ticament. Per exemple, si volem que la cel\u00b7la tingui el fons verd si la xifra que cont\u00e9 \u00e9s superior o igual a cinc o tingui el fons de color vermell si la [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"parent":21910,"menu_order":6,"comment_status":"closed","ping_status":"closed","template":"page-templates\/side-menu.php","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"class_list":["post-21976","page","type-page","status-publish","hentry"],"post_mailing_queue_ids":[],"_links":{"self":[{"href":"https:\/\/agora.xtec.cat\/escolasaavedra\/wp-json\/wp\/v2\/pages\/21976","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/agora.xtec.cat\/escolasaavedra\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/agora.xtec.cat\/escolasaavedra\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/agora.xtec.cat\/escolasaavedra\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/agora.xtec.cat\/escolasaavedra\/wp-json\/wp\/v2\/comments?post=21976"}],"version-history":[{"count":3,"href":"https:\/\/agora.xtec.cat\/escolasaavedra\/wp-json\/wp\/v2\/pages\/21976\/revisions"}],"predecessor-version":[{"id":22329,"href":"https:\/\/agora.xtec.cat\/escolasaavedra\/wp-json\/wp\/v2\/pages\/21976\/revisions\/22329"}],"up":[{"embeddable":true,"href":"https:\/\/agora.xtec.cat\/escolasaavedra\/wp-json\/wp\/v2\/pages\/21910"}],"wp:attachment":[{"href":"https:\/\/agora.xtec.cat\/escolasaavedra\/wp-json\/wp\/v2\/media?parent=21976"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}