{"id":200,"date":"2025-03-14T06:47:40","date_gmt":"2025-03-14T06:47:40","guid":{"rendered":"https:\/\/www.infomega.ro\/a10a\/?page_id=200"},"modified":"2025-03-14T06:47:40","modified_gmt":"2025-03-14T06:47:40","slug":"m4-tic-l3-formule-si-functii-in-foaia-de-calcul","status":"publish","type":"page","link":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\/","title":{"rendered":"M4 TIC L3 Formule \u0219i func\u021bii \u00een foaia de calcul"},"content":{"rendered":"\n<p>O formul\u0103 este o expresie matematic\u0103 ce calculeaz\u0103 valoarea \u00eentr-o celul\u0103.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/infmix.ro\/wp-content\/uploads\/2021\/05\/formula-example.png\" alt=\"\" class=\"wp-image-459\"\/><figcaption class=\"wp-element-caption\">Img 01 Orice formul\u0103 se editeaz\u0103 \u00een bara de formule din dreapta lui fx.<\/figcaption><\/figure>\n\n\n\n<p>\u2022 O func\u021bie este o formul\u0103 predefinit\u0103 deja existent\u0103 program.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/infmix.ro\/wp-content\/uploads\/2021\/05\/function-example.png\" alt=\"\" class=\"wp-image-460\"\/><figcaption class=\"wp-element-caption\">Img 02 O func\u021bie predefinit\u0103 odat\u0103 inserat\u0103 se editeaz\u0103 tot \u00een bara de formule.<\/figcaption><\/figure>\n\n\n\n<p>Preceden\u021ba operatorilor: \u2022Reprezint\u0103 ordinea opera\u021biilor de la matematic\u0103 adic\u0103 programul rezolv\u0103 opera\u021biile din paranteze apoi \u00eenmul\u021birile\/\u00eemp\u0103r\u021birile apoi adun\u0103rile\/sc\u0103derile.<\/p>\n\n\n\n<p>Copierea unei formule: \u2022La copierea formulei programul ajusteaz\u0103 automat referin\u021bele pentru fiecare celul\u0103. Referin\u021bele reprezint\u0103 adresele celulelor din formule sau func\u021bii.<\/p>\n\n\n\n<p>\u2022 <strong>Orice func\u021bie are un nume urmat de paranteze \u00eentre care se afl\u0103 ca argumente adresele celulelor participante la formul\u0103.<\/strong> Exemplu =SUM(A1:C2) este func\u021bia SUM care face suma tuturor valorilor g\u0103site \u00een domeniul format de celulele de la A1 p\u00e2n\u0103 la C2 inclusiv.<\/p>\n\n\n\n<p>Pentru exemplificare viziona\u021bi videoclipul de mai jos:<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<iframe loading=\"lazy\" title=\"12.82 Foi de calcul - formule \u0219i func\u021bii.\" width=\"729\" height=\"410\" src=\"https:\/\/www.youtube.com\/embed\/UsiGG9FEAmc?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n<\/div><\/figure>\n\n\n\n<p>\u00centreb\u0103ri:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Ce este o formul\u0103?<\/li>\n\n\n\n<li>Ce este o func\u021bie?<\/li>\n\n\n\n<li>Ce reprezint\u0103 preceden\u021ba operatorilor?<\/li>\n\n\n\n<li>Din ce este format\u0103 o func\u021bie?<\/li>\n<\/ol>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>O formul\u0103 este o expresie matematic\u0103 ce calculeaz\u0103 valoarea \u00eentr-o celul\u0103. \u2022 O func\u021bie este o formul\u0103 predefinit\u0103 deja existent\u0103 program. Preceden\u021ba operatorilor: \u2022Reprezint\u0103 ordinea opera\u021biilor de la matematic\u0103 adic\u0103 programul rezolv\u0103 opera\u021biile din paranteze apoi \u00eenmul\u021birile\/\u00eemp\u0103r\u021birile apoi adun\u0103rile\/sc\u0103derile. Copierea unei formule: \u2022La copierea formulei programul ajusteaz\u0103 automat referin\u021bele pentru fiecare celul\u0103. Referin\u021bele reprezint\u0103 adresele [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":177,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_FSMCFIC_featured_image_caption":"","_FSMCFIC_featured_image_nocaption":"","_FSMCFIC_featured_image_hide":"","footnotes":""},"class_list":["post-200","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>M4 TIC L3 Formule \u0219i func\u021bii \u00een foaia de calcul - Clasa a X-a InfoMega<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\/\" \/>\n<meta property=\"og:locale\" content=\"ro_RO\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"M4 TIC L3 Formule \u0219i func\u021bii \u00een foaia de calcul - Clasa a X-a InfoMega\" \/>\n<meta property=\"og:description\" content=\"O formul\u0103 este o expresie matematic\u0103 ce calculeaz\u0103 valoarea \u00eentr-o celul\u0103. \u2022 O func\u021bie este o formul\u0103 predefinit\u0103 deja existent\u0103 program. Preceden\u021ba operatorilor: \u2022Reprezint\u0103 ordinea opera\u021biilor de la matematic\u0103 adic\u0103 programul rezolv\u0103 opera\u021biile din paranteze apoi \u00eenmul\u021birile\/\u00eemp\u0103r\u021birile apoi adun\u0103rile\/sc\u0103derile. Copierea unei formule: \u2022La copierea formulei programul ajusteaz\u0103 automat referin\u021bele pentru fiecare celul\u0103. Referin\u021bele reprezint\u0103 adresele [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\/\" \/>\n<meta property=\"og:site_name\" content=\"Clasa a X-a InfoMega\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Timp estimat pentru citire\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m4-t-i-c\\\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\\\/\",\"url\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m4-t-i-c\\\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\\\/\",\"name\":\"M4 TIC L3 Formule \u0219i func\u021bii \u00een foaia de calcul - Clasa a X-a InfoMega\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m4-t-i-c\\\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m4-t-i-c\\\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/infmix.ro\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/formula-example.png\",\"datePublished\":\"2025-03-14T06:47:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m4-t-i-c\\\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\\\/#breadcrumb\"},\"inLanguage\":\"ro-RO\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m4-t-i-c\\\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ro-RO\",\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m4-t-i-c\\\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\\\/#primaryimage\",\"url\":\"https:\\\/\\\/infmix.ro\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/formula-example.png\",\"contentUrl\":\"https:\\\/\\\/infmix.ro\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/formula-example.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m4-t-i-c\\\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Prima pagin\u0103\",\"item\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"T.I.C.\",\"item\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"M4 T.I.C.\",\"item\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m4-t-i-c\\\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"M4 TIC L3 Formule \u0219i func\u021bii \u00een foaia de calcul\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/#website\",\"url\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/\",\"name\":\"Clasa a X-a InfoMega\",\"description\":\"Informa\u021bia a\u0219a cum o po\u021bi imagina\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/#\\\/schema\\\/person\\\/9694de2962f527a4ed763694fd74245e\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ro-RO\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/#\\\/schema\\\/person\\\/9694de2962f527a4ed763694fd74245e\",\"name\":\"2nf0\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ro-RO\",\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/11\\\/150colorchanger.png\",\"url\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/11\\\/150colorchanger.png\",\"contentUrl\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/11\\\/150colorchanger.png\",\"width\":150,\"height\":150,\"caption\":\"2nf0\"},\"logo\":{\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2024\\\/11\\\/150colorchanger.png\"},\"sameAs\":[\"https:\\\/\\\/www.infomega.ro\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"M4 TIC L3 Formule \u0219i func\u021bii \u00een foaia de calcul - Clasa a X-a InfoMega","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\/","og_locale":"ro_RO","og_type":"article","og_title":"M4 TIC L3 Formule \u0219i func\u021bii \u00een foaia de calcul - Clasa a X-a InfoMega","og_description":"O formul\u0103 este o expresie matematic\u0103 ce calculeaz\u0103 valoarea \u00eentr-o celul\u0103. \u2022 O func\u021bie este o formul\u0103 predefinit\u0103 deja existent\u0103 program. Preceden\u021ba operatorilor: \u2022Reprezint\u0103 ordinea opera\u021biilor de la matematic\u0103 adic\u0103 programul rezolv\u0103 opera\u021biile din paranteze apoi \u00eenmul\u021birile\/\u00eemp\u0103r\u021birile apoi adun\u0103rile\/sc\u0103derile. Copierea unei formule: \u2022La copierea formulei programul ajusteaz\u0103 automat referin\u021bele pentru fiecare celul\u0103. Referin\u021bele reprezint\u0103 adresele [&hellip;]","og_url":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\/","og_site_name":"Clasa a X-a InfoMega","twitter_card":"summary_large_image","twitter_misc":{"Timp estimat pentru citire":"2 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\/","url":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\/","name":"M4 TIC L3 Formule \u0219i func\u021bii \u00een foaia de calcul - Clasa a X-a InfoMega","isPartOf":{"@id":"https:\/\/www.infomega.ro\/a10a\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\/#primaryimage"},"image":{"@id":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\/#primaryimage"},"thumbnailUrl":"https:\/\/infmix.ro\/wp-content\/uploads\/2021\/05\/formula-example.png","datePublished":"2025-03-14T06:47:40+00:00","breadcrumb":{"@id":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\/#breadcrumb"},"inLanguage":"ro-RO","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\/"]}]},{"@type":"ImageObject","inLanguage":"ro-RO","@id":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\/#primaryimage","url":"https:\/\/infmix.ro\/wp-content\/uploads\/2021\/05\/formula-example.png","contentUrl":"https:\/\/infmix.ro\/wp-content\/uploads\/2021\/05\/formula-example.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l3-formule-si-functii-in-foaia-de-calcul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Prima pagin\u0103","item":"https:\/\/www.infomega.ro\/a10a\/"},{"@type":"ListItem","position":2,"name":"T.I.C.","item":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/"},{"@type":"ListItem","position":3,"name":"M4 T.I.C.","item":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/"},{"@type":"ListItem","position":4,"name":"M4 TIC L3 Formule \u0219i func\u021bii \u00een foaia de calcul"}]},{"@type":"WebSite","@id":"https:\/\/www.infomega.ro\/a10a\/#website","url":"https:\/\/www.infomega.ro\/a10a\/","name":"Clasa a X-a InfoMega","description":"Informa\u021bia a\u0219a cum o po\u021bi imagina","publisher":{"@id":"https:\/\/www.infomega.ro\/a10a\/#\/schema\/person\/9694de2962f527a4ed763694fd74245e"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.infomega.ro\/a10a\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ro-RO"},{"@type":["Person","Organization"],"@id":"https:\/\/www.infomega.ro\/a10a\/#\/schema\/person\/9694de2962f527a4ed763694fd74245e","name":"2nf0","image":{"@type":"ImageObject","inLanguage":"ro-RO","@id":"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2024\/11\/150colorchanger.png","url":"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2024\/11\/150colorchanger.png","contentUrl":"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2024\/11\/150colorchanger.png","width":150,"height":150,"caption":"2nf0"},"logo":{"@id":"https:\/\/www.infomega.ro\/a10a\/wp-content\/uploads\/sites\/2\/2024\/11\/150colorchanger.png"},"sameAs":["https:\/\/www.infomega.ro"]}]}},"_links":{"self":[{"href":"https:\/\/www.infomega.ro\/a10a\/wp-json\/wp\/v2\/pages\/200","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.infomega.ro\/a10a\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.infomega.ro\/a10a\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.infomega.ro\/a10a\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.infomega.ro\/a10a\/wp-json\/wp\/v2\/comments?post=200"}],"version-history":[{"count":1,"href":"https:\/\/www.infomega.ro\/a10a\/wp-json\/wp\/v2\/pages\/200\/revisions"}],"predecessor-version":[{"id":201,"href":"https:\/\/www.infomega.ro\/a10a\/wp-json\/wp\/v2\/pages\/200\/revisions\/201"}],"up":[{"embeddable":true,"href":"https:\/\/www.infomega.ro\/a10a\/wp-json\/wp\/v2\/pages\/177"}],"wp:attachment":[{"href":"https:\/\/www.infomega.ro\/a10a\/wp-json\/wp\/v2\/media?parent=200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}