{"id":215249,"date":"2022-08-12T17:04:00","date_gmt":"2022-08-12T14:04:00","guid":{"rendered":"https:\/\/goodroid.mediadoma.com\/?p=215249"},"modified":"2022-11-09T03:50:45","modified_gmt":"2022-11-09T00:50:45","slug":"3-voimalust-numbrite-uemardamiseks-googlei-arvutustabelites","status":"publish","type":"post","link":"https:\/\/goodroid.mediadoma.com\/et\/3-voimalust-numbrite-uemardamiseks-googlei-arvutustabelites\/","title":{"rendered":"3 v\u00f5imalust numbrite \u00fcmardamiseks Google&#8217;i arvutustabelites"},"content":{"rendered":"\n<p>Arvutustabelid on t\u00f5husad ja h\u00f5lpsasti kasutatavad t\u00f6\u00f6riistad, kui peate sooritama matemaatilisi arvutusi, kasutades erinevaid matemaatilisi valemeid ja funktsioone.<\/p>\n<p>Google'i arvutustabelid on pilvep\u00f5hine tasuta kasutatav arvutustabelirakendus ja see on Microsoft Exceli usaldusv\u00e4\u00e4rne alternatiiv. Vaatamata sellele, et Google'i arvutustabelid on pilvep\u00f5hine rakendus, on see siiski \u00fcsna v\u00f5imas t\u00f6\u00f6riist. Selles artiklis r\u00e4\u00e4gin sellest, kuidas saate Google'i arvutustabelite abil arvu vastavalt oma vajadustele \u00fcmardada.<\/p>\n<h2><strong>\u00dcmarfunktsioonid Google'i arvutustabelites<\/strong><\/h2>\n<p>Numbritega t\u00f6\u00f6tades peate v\u00f5ib-olla k\u00fcmnendarvud \u00fcmardama fikseeritud arvu numbriteni. Google'i arvutustabelites on numbrite \u00fcmardamiseks kolm funktsiooni, need leiate allpool.<\/p>\n<ul>\n<li>RING<\/li>\n<li>\u00dcMAR alla<\/li>\n<li>KOKKU V\u00d5TMA<\/li>\n<\/ul>\n<p>Vaatame esmalt, kuidas funktsioon ROUND t\u00f6\u00f6tab:<\/p>\n<h2><strong>RING<\/strong><\/h2>\n<p>Funktsioonid <strong>ROUND (v\u00e4\u00e4rtus, [kohad])<\/strong> vajavad kahte argumenti, millest esimene on arv, mida soovite \u00fcmardada, v\u00f5i selle lahtriviide. Teine argument on veel \u00fcks arv, mis n\u00e4itab k\u00fcmnendkohtade arvu, mida soovite \u00fcmardada. \u00dcmarfunktsioon \u00fcmardab arvu olenevalt algsest numbrist selle alamv\u00e4\u00e4rtuseni v\u00f5i \u00fclemm\u00e4\u00e4rani. Rakendame seda funktsiooni paarile numbrile.<\/p>\n<p><strong>1 samm:<\/strong> k\u00e4ivitage Google'i arvutustabelid, alustage uue t\u00fchja lehega, nimetage see \u00fcmber &quot;\u00fcmmarguseks&quot; ja valmistage ette andmed, nagu on n\u00e4idatud viitejoonisel.<\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a2107111a.jpg\" data-rel=\"lightbox\" ><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a2107111a.jpg\" alt=\"3 v\u00f5imalust numbrite \u00fcmardamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<p><strong>2 samm:<\/strong> kl\u00f5psake lahtris D7, seej\u00e4rel kl\u00f5psake men\u00fc\u00fcl <strong>&quot;Sisesta&quot;<\/strong> ja viige kursor valikule <strong>Funktsioon<\/strong> &gt; <strong>Matemaatika<\/strong> &gt; <strong>\u00dcMARING<\/strong> ning seej\u00e4rel kl\u00f5psake funktsioonil ROUND. V\u00f5i tippige lihtsalt <strong>valemiribale &quot;=ROUND (&quot;<\/strong><\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a2146f9e7.jpg\" data-rel=\"lightbox\" ><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a2146f9e7.jpg\" alt=\"3 v\u00f5imalust numbrite \u00fcmardamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<p><strong>3 samm:<\/strong> j\u00e4rgmiseks sisestage \u00fcmardatav arv otse v\u00f5i kl\u00f5psake numbrit sisaldaval lahtril (st D6), et saada selle lahtri viitenumber, ja vajutage sisestusklahvi.<\/p>\n<p><strong>4 samm:<\/strong> D7 sisaldab n\u00fc\u00fcd numbrit 12, mis on algse numbri korrus. Selle p\u00f5hjuseks on asjaolu, et <strong>&#8220;=ROUND (D6)&quot;<\/strong> on sama mis <strong>&#8220;=ROUND (D6, 0)&#8221;,<\/strong> st null numbrit p\u00e4rast koma. Sama valemi rakendamine E7-s E6 v\u00e4\u00e4rtuse jaoks annab esialgse arvu \u00fclemm\u00e4\u00e4ra 13.<\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a21890baf.png\" data-rel=\"lightbox\" ><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a21890baf.png\" alt=\"3 v\u00f5imalust numbrite \u00fcmardamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<p><strong>5 samm:<\/strong> kasutage lahtris D8 funktsiooni ROUND, et \u00fcmardada k\u00fcmnendkoha j\u00e4rel \u00fche numbrini k\u00e4suga <strong>\u201e=ROUND (D6, 1)&#8221;,<\/strong> mille tulemuseks on 12.5. E6 v\u00e4\u00e4rtuse korral on tulemus 12,6.<\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a21d1f0e1.jpg\" data-rel=\"lightbox\" ><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a21d1f0e1.jpg\" alt=\"3 v\u00f5imalust numbrite \u00fcmardamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<p><strong>6 samm:<\/strong> kasutage lahtris D9 funktsiooni ROUND, et \u00fcmardada k\u00fcmnendkoht kahe numbrini p\u00e4rast koma. st <strong>&#8220;=ROUND (D6, 2)&#8221;,<\/strong> mille tulemuseks on muudatusi, kuna arvul on p\u00e4rast koma juba kaks numbrit. Sama lugu on E6 sisuga.<\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a21fdf5b8.jpg\" data-rel=\"lightbox\" ><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a21fdf5b8.jpg\" alt=\"3 v\u00f5imalust numbrite \u00fcmardamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<h2><strong>\u00dcMAR alla<\/strong><\/h2>\n<p>ROUNDDOWN (<strong>v\u00e4\u00e4rtus, [kohad])<\/strong> on sarnane funktsiooniga ROUND, kuid nagu nimigi \u00fctleb, \u00fcmardab see arvu allapoole oma alamv\u00e4\u00e4rtuseni. Selle tegevuses n\u00e4gemiseks j\u00e4rgige j\u00e4rgmisi samme.<\/p>\n<p><strong>1 toiming:<\/strong> lisage Google'i arvutustabelites uus leht, nimetage see \u00fcmber allapoole \u00fcmardamiseks ja valmistage andmed ette nagu varem.<\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a222c6be2.jpg\" data-rel=\"lightbox\" ><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a222c6be2.jpg\" alt=\"3 v\u00f5imalust numbrite \u00fcmardamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<p><strong>2 samm:<\/strong> valige lahter D7 ja sisestage funktsioon <strong>\u201eROUNDDOWN&#8221; jaotisest<\/strong> <strong>Lisa<\/strong> &gt; <strong>Funktsioon<\/strong> &gt; <strong>Matemaatika<\/strong> &gt; <strong>\u00dcMARING<\/strong> v\u00f5i tippige <strong>valemiribale \u201e=ROUNDDOWN (&#8220;<\/strong><\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a225f2388.jpg\" data-rel=\"lightbox\" ><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a225f2388.jpg\" alt=\"3 v\u00f5imalust numbrite \u00fcmardamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<p><strong>3 samm:<\/strong> korrake samu katseid nagu varem funktsiooniga ROUNDDOWN. <strong>&#8220;=ROUNDDOWN (D6)&#8221;<\/strong> annab D7-s 12. V\u00e4\u00e4rtuse E6 puhul annab see m\u00f5lemal juhul samad v\u00e4\u00e4rtused.<\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a2292d9f8.jpg\" data-rel=\"lightbox\" ><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a2292d9f8.jpg\" alt=\"3 v\u00f5imalust numbrite \u00fcmardamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<p><strong>4 samm:<\/strong> kasutage lahtris D8 funktsiooni ROUNDDOWN, et \u00fcmardada k\u00fcmnendkoht \u00fche numbrini p\u00e4rast koma. st <strong>&#8220;= RING (D6, 1)&#8221;,<\/strong> mille tulemuseks on 12.4. See \u00fcmardab E6 v\u00e4\u00e4rtuse allapoole 12,5-ni.<\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a22d3e120.jpg\" data-rel=\"lightbox\" ><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a22d3e120.jpg\" alt=\"3 v\u00f5imalust numbrite \u00fcmardamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<p><strong>5 toiming<\/strong>. \u00d6elge lahtris D9 funktsioonile ROUND, et see \u00fcmardaks k\u00fcmnendkoha kahe numbrini p\u00e4rast koma. st <strong>&#8220;=ROUND (D6, 2)&#8221;,<\/strong> mille tulemusel algv\u00e4\u00e4rtus ei muutu. Samamoodi ei muutu ka E6 v\u00e4\u00e4rtus.<\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a2306742c.jpg\" data-rel=\"lightbox\" ><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a2306742c.jpg\" alt=\"3 v\u00f5imalust numbrite \u00fcmardamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<h2><strong>KOKKU V\u00d5TMA<\/strong><\/h2>\n<p>ROUNDUP (<strong>v\u00e4\u00e4rtus, [kohad])<\/strong> on funktsiooni ROUNDDOWN vastand ja \u00fcmardab teise argumendiga n\u00e4idatud arvu selle \u00fclemm\u00e4\u00e4ra v\u00e4\u00e4rtuseni. Erinevuse n\u00e4gemiseks kordame samu n\u00e4iteid samades lahtrites.<\/p>\n<p><strong>1 toiming:<\/strong> lisage Google'i arvutustabelites uus leht ja nimetage see \u00fcmber \u00fcmardamiseks.<\/p>\n<p><strong>2 samm:<\/strong> D7 v\u00e4\u00e4rtuse \u00fclespoole \u00fcmardamine annab 13 v\u00e4\u00e4rtusega <strong>&quot;=ROUNDUP (D6)&quot;<\/strong> ja E6 kordamine annab m\u00f5lemal juhul v\u00e4\u00e4rtuse E7 \u00fclemm\u00e4\u00e4ra 13.<\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a2339d2b7.jpg\" data-rel=\"lightbox\" ><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a2339d2b7.jpg\" alt=\"3 v\u00f5imalust numbrite \u00fcmardamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<p><strong>3 toiming<\/strong>. \u00dcmardage lahtris D8 k\u00fcmnendkoha j\u00e4rel \u00fche numbrini \u00fclespoole sisestage <strong>\u201e=ROUNDUP (D6, 1)&#8221;,<\/strong> mille tulemuseks on 12,5. See \u00fcmardab E6 v\u00e4\u00e4rtuse \u00fclespoole 12,6-ni E8-s.<\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a236b9f28.jpg\" data-rel=\"lightbox\" ><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a236b9f28.jpg\" alt=\"3 v\u00f5imalust numbrite \u00fcmardamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<p><strong>4 toiming:<\/strong> lahtris D9 \u00fcmardage kahe numbrini p\u00e4rast <strong>komat\u00fc\u00fcpi \u201e=ROUNDUP (D6, 2)&#8221;<\/strong>, mille tulemuseks on 12,45 ilma muudatusteta. Samamoodi ei muutu ka E6 v\u00e4\u00e4rtus.<\/p>\n<p><a href=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a23a8035e.jpg\" data-rel=\"lightbox\" ><img decoding=\"async\" class=\"SDStudio-light-box-enable SDStudio-editor-tools-md-imp\" src=\"https:\/\/goodroid.mediadoma.com\/wp-content\/uploads\/2022\/08\/post-205862-62f0a23a8035e.jpg\" alt=\"3 v\u00f5imalust numbrite \u00fcmardamiseks Google&#039;i arvutustabelites\" ><\/a><\/p>\n<h2><strong>J\u00e4reldus<\/strong><\/h2>\n<p>Selles artiklis olen n\u00e4idanud, kuidas saate p\u00f5hifunktsiooni ROUND ja selle variante (RUNDOWN, ROUNDUP) kasutada Google'i arvutustabelite h\u00f5lpsaks \u00fcmardamiseks. Korrake seda harjutust ja katsetage nende funktsioonide negatiivsete argumentidega ning jagage meiega oma tulemusi kommentaaride jaotises.<\/p>\n<p><div id=\"PostUnique_PostSource\" style=\"padding-top: 50px\">:  <a target=\"_blank\" rel=\"noopener nofollow\" href=\"\/\/www.gtricks.com\" class=\"external external_icon\">www.gtricks.com<\/a><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Arvutustabelid on t\u00f5husad ja h\u00f5lpsasti kasutatavad t\u00f6\u00f6riistad, kui peate sooritama matemaatilisi arvutusi, kasutades erinevaid matemaatilisi valemeid ja funktsioone.<\/p>\n","protected":false},"author":1,"featured_media":205863,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","_wp_rev_ctl_limit":""},"categories":[676,636,825],"tags":[],"class_list":["post-215249","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-docs-3","category-kindral","category-opikud"],"_links":{"self":[{"href":"https:\/\/goodroid.mediadoma.com\/et\/wp-json\/wp\/v2\/posts\/215249","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/goodroid.mediadoma.com\/et\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/goodroid.mediadoma.com\/et\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/goodroid.mediadoma.com\/et\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/goodroid.mediadoma.com\/et\/wp-json\/wp\/v2\/comments?post=215249"}],"version-history":[{"count":0,"href":"https:\/\/goodroid.mediadoma.com\/et\/wp-json\/wp\/v2\/posts\/215249\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/goodroid.mediadoma.com\/et\/wp-json\/wp\/v2\/media\/205863"}],"wp:attachment":[{"href":"https:\/\/goodroid.mediadoma.com\/et\/wp-json\/wp\/v2\/media?parent=215249"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/goodroid.mediadoma.com\/et\/wp-json\/wp\/v2\/categories?post=215249"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/goodroid.mediadoma.com\/et\/wp-json\/wp\/v2\/tags?post=215249"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}