{"id":196,"date":"2025-02-25T07:24:08","date_gmt":"2025-02-25T07:24:08","guid":{"rendered":"https:\/\/www.infomega.ro\/a10a\/?page_id=196"},"modified":"2025-02-25T07:24:09","modified_gmt":"2025-02-25T07:24:09","slug":"m4-tic-l2-formule-in-foaia-de-calcul","status":"publish","type":"page","link":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l2-formule-in-foaia-de-calcul\/","title":{"rendered":"M4 TIC L2 Formule \u00een foaia de calcul"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">O colec\u021bie de date stocat\u0103 \u00een memoria extern\u0103 \u0219i av\u00e2nd un sistem de management se nume\u0219te BAZ\u0102 DE DATE.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Baz\u0103 de date<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Foaia de calcul este cel mai simplu model de baz\u0103 de date unde:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Coloanele se numesc c\u00e2mpuri<\/li>\n\n\n\n<li>Liniile se numesc \u00eenregistr\u0103ri<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">O tabel\u0103 a bazei de date con\u021bine \u00eenregistr\u0103ri formate din c\u00e2mpuri asupra c\u0103rora se pot efectua calcule \u0219i opera\u021bii complexe.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/infmix.ro\/wp-content\/uploads\/2021\/05\/campuri_intregistrari.jpg\" alt=\"\" class=\"wp-image-448\"\/><figcaption class=\"wp-element-caption\">img 01 coloanele se numesc c\u00e2mpuri iar r\u00e2ndurile \u00eenregistr\u0103ri.<\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Formule<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">O formul\u0103 \u00een foaia de calcul este o expresie introdus\u0103 de utilizator folosind bara de formule dup\u0103 ce a selectat celuilalt \u00een care va ap\u0103rea rezultatul formulei. A se evita introducerea formule direct \u00een celul\u0103, mai bine doare select\u0103m celule \u0219i apoi introducem formula folosind bara de adrese.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">ORICE FORMUL\u0102 \u00ceNCEPE CU SEMNUL =<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Apoi urmeaz\u0103 adresele celulelor \u00een care se afl\u0103 valorile numerice de calcul denumite argumentele formulei. \u00centre aceste adrese se folosesc operatorii cunoscu\u021bi de la matematic\u0103 +,-,* etc.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Dac\u0103 \u00een celula C2 avem o valoare numeric\u0103 ce reprezint\u0103 pre\u021bul f\u0103r\u0103 TVA, \u00een celula D2 introducem formula =C2*0,19 \u0219i afl\u0103m pre\u021bul f\u0103r\u0103 TVA iar \u00een celula E2 introducem formula =C2*1,19. Aten\u021bie c\u0103 \u00een limba englez\u0103 virgula este punct. A se evita s\u0103 se foloseasc\u0103 =C2+D2 pentru a afla pre\u021bul cu TVA deoarece o gre\u0219eal\u0103 din formula din D2 se va propaga \u00een E2. Pe c\u00e2t posibil \u00een Excel o formul\u0103 trebuie s\u0103 nu depind\u0103 de alte formule \u0219i doar de valori numerice.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Exemplu de formule de calcul \u00eentr-o foaie de calcul unde se calculeaz\u0103 TVA \u0219i pre\u021bul cu TVA c\u00e2nd avem date pre\u021bul f\u0103r\u0103 TVA.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/infmix.ro\/wp-content\/uploads\/2021\/05\/TVA-1024x521.png\" alt=\"\" class=\"wp-image-450\"\/><figcaption class=\"wp-element-caption\">img 02 \u00cen celula D2 se calculeaz\u0103 TVA \u00eenmul\u021bind con\u021binutul celulei C2 cu 0,19.<\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/infmix.ro\/wp-content\/uploads\/2021\/05\/pret-cu-TVA-1024x522.png\" alt=\"\" class=\"wp-image-451\"\/><figcaption class=\"wp-element-caption\">img 03 \u00cen celula E2 se calculeaz\u0103 pre\u021bul cu TVA \u00eenmul\u021bind con\u021binutul celulei C2 cu 1,19.<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u00centregul proces se explic\u0103 \u00een video 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.81 Foi de calcul, exemplu.\" width=\"729\" height=\"410\" src=\"https:\/\/www.youtube.com\/embed\/tTXkOg5zqOM?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 class=\"wp-block-paragraph\">\u00centreb\u0103ri:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Ce este o baz\u0103 de date?<\/li>\n\n\n\n<li>Ce este o formul\u0103?<\/li>\n\n\n\n<li>Cu ce semn \u00eencepe orice formul\u0103?<\/li>\n\n\n\n<li>Cine sunt argumentele formulei?<\/li>\n\n\n\n<li>De cine nu trebuie s\u0103 depind\u0103 o formul\u0103?<\/li>\n<\/ol>\n\n\n\n<p class=\"wp-block-paragraph\">Aplica\u021bie:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>S\u0103 se realizeze foaia de calcul de mai sus.<\/li>\n\n\n\n<li>S\u0103 se ata\u0219eze registrul de lucru al foii de calcul la un mesaj de e-mail pe care-l trimite\u021bi pe adresa profesorului.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>O colec\u021bie de date stocat\u0103 \u00een memoria extern\u0103 \u0219i av\u00e2nd un sistem de management se nume\u0219te BAZ\u0102 DE DATE. Baz\u0103 de date Foaia de calcul este cel mai simplu model de baz\u0103 de date unde: O tabel\u0103 a bazei de date con\u021bine \u00eenregistr\u0103ri formate din c\u00e2mpuri asupra c\u0103rora se pot efectua calcule \u0219i opera\u021bii complexe. [&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-196","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>M4 TIC L2 Formule \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-l2-formule-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 L2 Formule \u00een foaia de calcul - Clasa a X-a InfoMega\" \/>\n<meta property=\"og:description\" content=\"O colec\u021bie de date stocat\u0103 \u00een memoria extern\u0103 \u0219i av\u00e2nd un sistem de management se nume\u0219te BAZ\u0102 DE DATE. Baz\u0103 de date Foaia de calcul este cel mai simplu model de baz\u0103 de date unde: O tabel\u0103 a bazei de date con\u021bine \u00eenregistr\u0103ri formate din c\u00e2mpuri asupra c\u0103rora se pot efectua calcule \u0219i opera\u021bii complexe. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l2-formule-in-foaia-de-calcul\/\" \/>\n<meta property=\"og:site_name\" content=\"Clasa a X-a InfoMega\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-25T07:24:09+00:00\" \/>\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=\"3 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-l2-formule-in-foaia-de-calcul\\\/\",\"url\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m4-t-i-c\\\/m4-tic-l2-formule-in-foaia-de-calcul\\\/\",\"name\":\"M4 TIC L2 Formule \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-l2-formule-in-foaia-de-calcul\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m4-t-i-c\\\/m4-tic-l2-formule-in-foaia-de-calcul\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/infmix.ro\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/campuri_intregistrari.jpg\",\"datePublished\":\"2025-02-25T07:24:08+00:00\",\"dateModified\":\"2025-02-25T07:24:09+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m4-t-i-c\\\/m4-tic-l2-formule-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-l2-formule-in-foaia-de-calcul\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ro-RO\",\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m4-t-i-c\\\/m4-tic-l2-formule-in-foaia-de-calcul\\\/#primaryimage\",\"url\":\"https:\\\/\\\/infmix.ro\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/campuri_intregistrari.jpg\",\"contentUrl\":\"https:\\\/\\\/infmix.ro\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/campuri_intregistrari.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.infomega.ro\\\/a10a\\\/t-i-c\\\/m4-t-i-c\\\/m4-tic-l2-formule-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 L2 Formule \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 L2 Formule \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-l2-formule-in-foaia-de-calcul\/","og_locale":"ro_RO","og_type":"article","og_title":"M4 TIC L2 Formule \u00een foaia de calcul - Clasa a X-a InfoMega","og_description":"O colec\u021bie de date stocat\u0103 \u00een memoria extern\u0103 \u0219i av\u00e2nd un sistem de management se nume\u0219te BAZ\u0102 DE DATE. Baz\u0103 de date Foaia de calcul este cel mai simplu model de baz\u0103 de date unde: O tabel\u0103 a bazei de date con\u021bine \u00eenregistr\u0103ri formate din c\u00e2mpuri asupra c\u0103rora se pot efectua calcule \u0219i opera\u021bii complexe. [&hellip;]","og_url":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l2-formule-in-foaia-de-calcul\/","og_site_name":"Clasa a X-a InfoMega","article_modified_time":"2025-02-25T07:24:09+00:00","twitter_card":"summary_large_image","twitter_misc":{"Timp estimat pentru citire":"3 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l2-formule-in-foaia-de-calcul\/","url":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l2-formule-in-foaia-de-calcul\/","name":"M4 TIC L2 Formule \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-l2-formule-in-foaia-de-calcul\/#primaryimage"},"image":{"@id":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l2-formule-in-foaia-de-calcul\/#primaryimage"},"thumbnailUrl":"https:\/\/infmix.ro\/wp-content\/uploads\/2021\/05\/campuri_intregistrari.jpg","datePublished":"2025-02-25T07:24:08+00:00","dateModified":"2025-02-25T07:24:09+00:00","breadcrumb":{"@id":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l2-formule-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-l2-formule-in-foaia-de-calcul\/"]}]},{"@type":"ImageObject","inLanguage":"ro-RO","@id":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l2-formule-in-foaia-de-calcul\/#primaryimage","url":"https:\/\/infmix.ro\/wp-content\/uploads\/2021\/05\/campuri_intregistrari.jpg","contentUrl":"https:\/\/infmix.ro\/wp-content\/uploads\/2021\/05\/campuri_intregistrari.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.infomega.ro\/a10a\/t-i-c\/m4-t-i-c\/m4-tic-l2-formule-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 L2 Formule \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\/196","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=196"}],"version-history":[{"count":1,"href":"https:\/\/www.infomega.ro\/a10a\/wp-json\/wp\/v2\/pages\/196\/revisions"}],"predecessor-version":[{"id":197,"href":"https:\/\/www.infomega.ro\/a10a\/wp-json\/wp\/v2\/pages\/196\/revisions\/197"}],"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=196"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}