{"id":502,"date":"2016-05-17T11:48:37","date_gmt":"2016-05-17T08:48:37","guid":{"rendered":"http:\/\/helia.ee\/koolitus\/?page_id=502"},"modified":"2016-05-17T12:02:44","modified_gmt":"2016-05-17T09:02:44","slug":"microsoft-excel-2016-andmete-valideerimine-loendi-koostamine-harjutus-15","status":"publish","type":"page","link":"https:\/\/helia.ee\/koolitus\/?page_id=502","title":{"rendered":"Microsoft Excel 2016 &#8211; Andmete valideerimine Loendi koostamine (Harjutus 15)"},"content":{"rendered":"<p>Valideeri andmed loendiks kasutades allolevat tabelit<\/p>\n<p id=\"zsQkZEn\"><img loading=\"lazy\" decoding=\"async\" width=\"635\" height=\"380\" class=\"alignnone size-full wp-image-504 \" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/05\/img_573adc02678a2.png\" alt=\"\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/05\/img_573adc02678a2.png 635w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/05\/img_573adc02678a2-300x180.png 300w\" sizes=\"auto, (max-width: 635px) 100vw, 635px\" \/><\/p>\n<ol>\n<li>Kliki kauba koodi all oleval lahtril, kuhu loend tuleb<\/li>\n<li>Liigu men\u00fc\u00fcsse Andmed<\/li>\n<li>Sildi peal andmeriistad on k\u00e4sk Valideeri andmed<\/li>\n<li>Sealt vali valideeri andmed<\/li>\n<li>Avanenud aknast vali <strong>S\u00e4tted<\/strong> ja siis <strong>Luba:<\/strong> alt vali <strong>Loend<\/strong><\/li>\n<li>\n<p id=\"FmJSbqN\"><img loading=\"lazy\" decoding=\"async\" width=\"407\" height=\"333\" class=\"alignnone size-full wp-image-506 \" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/05\/img_573adca46d63e.png\" alt=\"\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/05\/img_573adca46d63e.png 407w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/05\/img_573adca46d63e-300x245.png 300w\" sizes=\"auto, (max-width: 407px) 100vw, 407px\" \/><\/p>\n<\/li>\n<li>Allikas: reale on vaja lahtrite vahemik millest teha loend, selleks kliki real\u00f5pus oleval nupul<\/li>\n<li>\n<p id=\"fcCbWSS\"><img loading=\"lazy\" decoding=\"async\" width=\"309\" height=\"58\" class=\"alignnone size-full wp-image-508 \" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/05\/img_573adcf02c494.png\" alt=\"\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/05\/img_573adcf02c494.png 309w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/05\/img_573adcf02c494-300x56.png 300w\" sizes=\"auto, (max-width: 309px) 100vw, 309px\" \/><\/p>\n<\/li>\n<li>peale seda vea hiire lahtri vahemik olemas olevasse lahtrisse<\/li>\n<li>\n<p id=\"rGZzyzd\"><img loading=\"lazy\" decoding=\"async\" width=\"825\" height=\"402\" class=\"alignnone size-full wp-image-509 \" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/05\/img_573add511f051.png\" alt=\"\" srcset=\"https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/05\/img_573add511f051.png 825w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/05\/img_573add511f051-300x146.png 300w, https:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/05\/img_573add511f051-768x374.png 768w\" sizes=\"auto, (max-width: 825px) 100vw, 825px\" \/><\/p>\n<\/li>\n<li>Vajuta enter klahvi ja kliki OK nupul.<\/li>\n<li>N\u00fc\u00fcd peaks saama lahtrist paremal oleval noole pealt valida loendit<\/li>\n<li>\n<p id=\"KwWMGEa\"><img loading=\"lazy\" decoding=\"async\" width=\"171\" height=\"70\" class=\"alignnone size-full wp-image-510 \" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/05\/img_573addab9717a.png\" alt=\"\" \/><\/p>\n<\/li>\n<li>\n<p id=\"IURAgUN\"><img loading=\"lazy\" decoding=\"async\" width=\"190\" height=\"221\" class=\"alignnone size-full wp-image-511 \" src=\"http:\/\/helia.ee\/koolitus\/wp-content\/uploads\/2016\/05\/img_573addc861303.png\" alt=\"\" \/><\/p>\n<p><a href=\"http:\/\/helia.ee\/koolitus\/dokumendid\/valideerimine_loend.xlsx\">Harjutus 15<\/a><\/p>\n<\/li>\n<\/ol>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Valideeri andmed loendiks kasutades allolevat tabelit Kliki kauba koodi all oleval lahtril, kuhu loend tuleb Liigu men\u00fc\u00fcsse Andmed Sildi peal andmeriistad on k\u00e4sk Valideeri andmed Sealt vali valideeri andmed Avanenud aknast vali S\u00e4tted ja siis Luba: alt vali Loend Allikas: reale on vaja lahtrite vahemik millest teha loend, selleks kliki real\u00f5pus oleval nupul peale seda [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":177,"menu_order":36,"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-502","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages\/502","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=502"}],"version-history":[{"count":4,"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages\/502\/revisions"}],"predecessor-version":[{"id":513,"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages\/502\/revisions\/513"}],"up":[{"embeddable":true,"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=\/wp\/v2\/pages\/177"}],"wp:attachment":[{"href":"https:\/\/helia.ee\/koolitus\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=502"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}