{"id":300,"date":"2022-08-22T04:24:34","date_gmt":"2022-08-22T01:24:34","guid":{"rendered":"https:\/\/kompiuteriu-kursai.lt\/?p=300"},"modified":"2023-05-12T23:35:27","modified_gmt":"2023-05-12T20:35:27","slug":"kaip-ivesti-informacija-i-excel-mazos-bet-naudingos-gudrybes","status":"publish","type":"post","link":"https:\/\/kompiuteriu-kursai.lt\/?p=300","title":{"rendered":"Kaip \u012fvesti informacij\u0105 \u012f Excel: ma\u017eos, bet naudingos gudryb\u0117s"},"content":{"rendered":"\n

<\/p>\n\n\n\n

Programos\u00a0Excel<\/strong>\u00a0i\u0161skirtin\u0117 savyb\u0117 – bet koki\u0173 \u012fvedam\u0173 duomen\u0173 formatavimo interpretacija.\u00a0Excel<\/strong>\u00a0formatavimas \u2013 tai informacija programai apie duomen\u0173 paskirt\u012f: j\u0173 laikymo atmintyje b\u016bd\u0105, kiek atminties skirti duomenims saugoti ir atvaizdavimo ekrane b\u016bd\u0105. D\u0117l \u0161ios prie\u017easties gali kilti keblum\u0173. Pavyzd\u017eiui, \u012fvestas telefono numeris gali b\u016bti suprantamas kaip data. \u012evedate:<\/p>\n\n\n\n

\"\"Spustelite Enter ir matote:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u0160iuo konkre\u010diu atveju jokios gudryb\u0117s nepad\u0117s langelyje atstatyti telefono numerio.\u00a0

Langelio formatui nustatyti i\u0161 kontekstinio meniu parenkama komanda\u00a0Format Cell<\/strong>\u00a0arba kortel\u0117je\u00a0Home<\/strong>\u00a0pasirenkama juostel\u0117\u00a0Number<\/strong>.

Ta\u010diau egzistuoja keletas gudrybi\u0173:<\/p>\n\n\n\n

    \n
  • \u012evedus 90% \u2013 tai suprantama kaip procentai; 5 Eur \u2013 pinigin\u0117 i\u0161rai\u0161ka; (24) \u2013 neigiamas skai\u010dius.<\/li>\n\n\n\n
  • Kai b\u016btina skaitin\u0119 reik\u0161m\u0119 \u012fvesti tik kaip tekst\u0105, jei su skai\u010diumi nebus atliekami jokie veiksmai (pavyzd\u017eiui, u\u017esakym\u0173 arba telefon\u0173 numeriai), prie\u0161 tokias reik\u0161mes u\u017etenka \u012fra\u0161yti apostrofo simbol\u012f (\u2018).<\/li>\n\n\n\n
  • Norint \u012fvesti trupmen\u0105, reikia \u012fra\u0161yti sveik\u0105j\u0105 trupmenos dal\u012f ir b\u016btinai pad\u0117ti tarp\u0105 prie\u0161 trupmenin\u0119 dal\u012f, pavyzd\u017eiui: 0 4\/5. To nepadarius, 4\/5 bus suprasta kaip data.<\/li>\n\n\n\n
  • Einamoji data \u012fvedama klavi\u0161ais\u00a0Ctrl+;<\/strong>. Einamajam laikui \u012fvesti naudojama Ctrl+Shift+;<\/strong> klavi\u0161\u0173 kombinacija.<\/li>\n\n\n\n
  • Excel<\/strong>\u00a0saugo skai\u010dius tokius, kokius \u012fved\u0117te, bet atvaizduoja pagal nustatyt\u0105 format\u0105. Pvz., norite langelyje i\u0161skirti PVM ir nustat\u0117te format\u0105, kuris pinigin\u0119 i\u0161rai\u0161k\u0105 pateikia su dviem skai\u010diais po kablelio, gaunate 100,35 Eur. Paspaudus\u00a0Enter<\/strong> teikiamas skai\u010dius 100,35 Eur. Ta\u010diau visuose skai\u010diavimuose, kuriuose dalyvaus \u0161io langelio reik\u0161m\u0117, ji bus 100,345 Eur. Galutinis vis\u0173 j\u016bs\u0173 skai\u010diavim\u0173 rezultatas nesutaps vienu ar dviem centais ir sudarydami balans\u0105 bei ie\u0161kodami klaidos praleisite ne vien\u0105 bemieg\u0119 nakt\u012f. Tod\u0117l patariame \u2013 apvalinkite naudodami funkcij\u0105\u00a0ROUND<\/strong>.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

    Programos\u00a0Excel\u00a0i\u0161skirtin\u0117 savyb\u0117 – bet koki\u0173 \u012fvedam\u0173 duomen\u0173 formatavimo interpretacija.\u00a0Excel\u00a0formatavimas \u2013 tai informacija programai apie duomen\u0173 paskirt\u012f: j\u0173 laikymo atmintyje b\u016bd\u0105, kiek atminties skirti duomenims saugoti ir atvaizdavimo ekrane b\u016bd\u0105. D\u0117l \u0161ios prie\u017easties gali kilti keblum\u0173. Pavyzd\u017eiui, \u012fvestas telefono numeris gali b\u016bti suprantamas kaip data. \u012evedate: Spustelite Enter ir matote: \u0160iuo konkre\u010diu atveju jokios gudryb\u0117s nepad\u0117s […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[22],"tags":[],"class_list":["post-300","post","type-post","status-publish","format-standard","hentry","category-ekspertai-pataria"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/300","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=300"}],"version-history":[{"count":9,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/300\/revisions"}],"predecessor-version":[{"id":3471,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=\/wp\/v2\/posts\/300\/revisions\/3471"}],"wp:attachment":[{"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=300"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=300"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kompiuteriu-kursai.lt\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=300"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}