{"id":1631,"date":"2020-11-15T20:36:33","date_gmt":"2020-11-15T18:36:33","guid":{"rendered":"https:\/\/helia.ee\/koolitus\/?page_id=1631"},"modified":"2020-11-15T20:36:33","modified_gmt":"2020-11-15T18:36:33","slug":"microsoft-excel-2016-matemaatiliste-valemite-kasutamine-erinevate-lehtede-peal-olevate-andmete-liitmine","status":"publish","type":"page","link":"https:\/\/helia.ee\/koolitus\/?page_id=1631","title":{"rendered":"Microsoft Excel 2016 \u2013 Matemaatiliste valemite kasutamine (Erinevate lehtede peal olevate andmete liitmine)"},"content":{"rendered":"<ol>\n<li>Kliki lahtril kuhu tahad valemi luua, kuhu siis korjatakse andmed kokku erinevatelt lehtedelt.<\/li>\n<li>Valem hakkab v\u00f5rdusm\u00e4rgiga =<\/li>\n<li>Edasi liigu sellele lehele ja kliki sellel lahtril kust tahad andmeid kokku korjata, tee nii k\u00f5igil lehtedel. \u00c4ra unusta valmites kasutada + m\u00e4rki.<\/li>\n<li>Peale viimasel lehel ja lahtril klikkimist vajuta enter klahvi. Siis arvutatakse k\u00f5ikide lahtrite tulem sinna lahtrisse kuhu te tahtsite vastuse saada kokku.<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n<p><a href=\"https:\/\/koolitus.helia.ee\/dokumendid\/lehtede_harjutus.xlsx\">\u00dclesanne<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kliki lahtril kuhu tahad valemi luua, kuhu siis korjatakse andmed kokku erinevatelt lehtedelt. Valem hakkab v\u00f5rdusm\u00e4rgiga = Edasi liigu sellele lehele ja kliki sellel lahtril kust tahad andmeid kokku korjata, tee nii k\u00f5igil lehtedel. \u00c4ra unusta valmites kasutada + m\u00e4rki. Peale viimasel lehel ja lahtril klikkimist vajuta enter klahvi. Siis arvutatakse k\u00f5ikide lahtrite tulem sinna [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-1631","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages\/1631","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1631"}],"version-history":[{"count":1,"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages\/1631\/revisions"}],"predecessor-version":[{"id":1632,"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages\/1631\/revisions\/1632"}],"wp:attachment":[{"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1631"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}