{"id":3137,"date":"2020-04-19T18:43:52","date_gmt":"2020-04-19T16:43:52","guid":{"rendered":"https:\/\/www.fiatluxefel.info\/?page_id=3137"},"modified":"2021-11-01T12:38:32","modified_gmt":"2021-11-01T11:38:32","slug":"az-atlag-fuggveny","status":"publish","type":"page","link":"https:\/\/www.fiatluxefel.info\/?page_id=3137","title":{"rendered":"Az \u00c1TLAG f\u00fcggv\u00e9ny (#196)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"3137\" class=\"elementor elementor-3137\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e416181 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e416181\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c9da68e\" data-id=\"c9da68e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fce36e6 elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"fce36e6\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;slideInRight&quot;}\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00a0 Friss\u00edtve: 2020 m\u00e1jus 28.<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-596d24f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"596d24f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3356e4a\" data-id=\"3356e4a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-354f9ba elementor-widget elementor-widget-text-editor\" data-id=\"354f9ba\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Mir\u0151l sz\u00f3l ez a cikk?<br \/>Az \u00e1tlagsz\u00e1m\u00edt\u00e1s az egyik olyan \u201ekomolyabb\u201d sz\u00e1mol\u00e1si m\u0171velet, amit m\u00e1r kisiskol\u00e1s korunkban megtan\u00edtanak nek\u00fcnk \u2013 igaz, sz\u00e1mtani k\u00f6z\u00e9p sz\u00e1m\u00edt\u00e1sa n\u00e9ven. Egyben az egyik leggyakrabban haszn\u00e1lt statisztikai sz\u00e1m\u00edt\u00e1s, m\u00e9g az \u00e1ltal\u00e1nos m\u0171velts\u00e9gnek is akt\u00edv r\u00e9sze, valamint a napi h\u00edrekben is gyakori vend\u00e9g.<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b5fb8fd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b5fb8fd\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7e94671\" data-id=\"7e94671\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d6d74b7 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"d6d74b7\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;exclude_headings_by_selector&quot;:[],&quot;marker_view&quot;:&quot;bullets&quot;,&quot;icon&quot;:{&quot;value&quot;:&quot;fas fa-file-excel&quot;,&quot;library&quot;:&quot;fa-solid&quot;},&quot;headings_by_tags&quot;:[&quot;h2&quot;,&quot;h3&quot;,&quot;h4&quot;,&quot;h5&quot;,&quot;h6&quot;],&quot;no_headings_message&quot;:&quot;Ezen az oldalon nem tal\\u00e1lhat\\u00f3 c\\u00edmsor.&quot;,&quot;minimize_box&quot;:&quot;yes&quot;,&quot;minimized_on&quot;:&quot;tablet&quot;,&quot;hierarchical_view&quot;:&quot;yes&quot;,&quot;min_height&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_tablet&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]},&quot;min_height_mobile&quot;:{&quot;unit&quot;:&quot;px&quot;,&quot;size&quot;:&quot;&quot;,&quot;sizes&quot;:[]}}\" data-widget_type=\"table-of-contents.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-toc__header\">\n\t\t\t\t\t\t<h4 class=\"elementor-toc__header-title\">\n\t\t\t\tTartalomjegyz\u00e9k\t\t\t<\/h4>\n\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--expand\" role=\"button\" tabindex=\"0\" aria-controls=\"elementor-toc__d6d74b7\" aria-expanded=\"true\" aria-label=\"Open table of contents\"><i aria-hidden=\"true\" class=\"fas fa-chevron-down\"><\/i><\/div>\n\t\t\t\t<div class=\"elementor-toc__toggle-button elementor-toc__toggle-button--collapse\" role=\"button\" tabindex=\"0\" aria-controls=\"elementor-toc__d6d74b7\" aria-expanded=\"true\" aria-label=\"Close table of contents\"><i aria-hidden=\"true\" class=\"fas fa-chevron-up\"><\/i><\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<div id=\"elementor-toc__d6d74b7\" class=\"elementor-toc__body\">\n\t\t\t<div class=\"elementor-toc__spinner-container\">\n\t\t\t\t<i class=\"elementor-toc__spinner eicon-animation-spin eicon-loading\" aria-hidden=\"true\"><\/i>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f38d160 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f38d160\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d740092\" data-id=\"d740092\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-87bf645 elementor-widget elementor-widget-text-editor\" data-id=\"87bf645\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>A cikkben eml\u00edtett egy\u00e9b Excel f\u00fcggv\u00e9nyek a k\u00f6vetkez\u0151k:<\/strong> \u00c1TLAGA, \u00c1TLAGHA, D\u00c1TUM\u00c9RT\u00c9K, <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=1888\">HI\u00c1NYZIK<\/a>, ID\u0150\u00c9RT\u00c9K, SZ\u00d6VEG.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0981307 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0981307\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-07b182a\" data-id=\"07b182a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6d5bc5e elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"6d5bc5e\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;1. A sz\\u00e1mtani k\\u00f6z\\u00e9p, vagyis az \\u00e1tlag sz\\u00e1m\\u00edt\\u00e1sa&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">1. A sz\u00e1mtani k\u00f6z\u00e9p, vagyis az \u00e1tlag sz\u00e1m\u00edt\u00e1sa<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d88694b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d88694b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e95325b\" data-id=\"e95325b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4b9d01b elementor-widget elementor-widget-text-editor\" data-id=\"4b9d01b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Miel\u0151tt az \u00c1TLAG f\u00fcggv\u00e9nnyel megismerkedn\u00e9nk, fontos \u00e1tism\u00e9teln\u00fcnk a sz\u00e1mtani k\u00f6z\u00e9ppel kapcsolatos tudnival\u00f3kat.<\/p>\n<p><strong>A k\u00f6zismert \u00e1tlag sz\u00f3 val\u00f3j\u00e1ban az aritmetikai, vagyis a sz\u00e1mtani k\u00f6z\u00e9p fogalm\u00e1t takarja. A sz\u00e1mtani k\u00f6z\u00e9p kisz\u00e1m\u00edt\u00e1s\u00e1nak c\u00e9lja, hogy egy sz\u00e1megyenesen elhelyezked\u0151 val\u00f3s sz\u00e1mok sorozat\u00e1nak azt a k\u00f6z\u00e9pen elhelyezked\u0151 \u00e9rt\u00e9k\u00e9t keress\u00fck meg, amely egyenl\u0151 t\u00e1vols\u00e1gra van a sz\u00e1megyenes k\u00e9t sz\u00e9ls\u0151 \u00e9rt\u00e9k\u00e9t\u0151l.<\/strong> <strong>A sz\u00e1mtani k\u00f6z\u00e9p jel\u00f6l\u00e9s\u00e9re a nagy A bet\u0171t haszn\u00e1ljuk. <\/strong>K\u00e9t sz\u00e1mra fel\u00edrva ezt a defin\u00edci\u00f3t, a k\u00f6vetkez\u0151 k\u00e9pletet kapjuk:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-08156f5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"08156f5\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-89e5e88\" data-id=\"89e5e88\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f19428a elementor-widget elementor-widget-text-editor\" data-id=\"f19428a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>A(<em>a<\/em>;<em>b<\/em>)=<em>c<\/em><\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6f3cc7d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6f3cc7d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-cf2cb11\" data-id=\"cf2cb11\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-30a8bc2 elementor-widget elementor-widget-text-editor\" data-id=\"30a8bc2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>ahol <em>a<\/em> \u00e9s <em>b<\/em> k\u00e9t sz\u00e1m, amelyek sz\u00e1mtani k\u00f6zep\u00e9re k\u00edv\u00e1ncsiak vagyunk (ez k\u00e9t sz\u00e1m eset\u00e9ben egyben a sz\u00e1megyenes k\u00e9t v\u00e9g\u00e9n elhelyezked\u0151 sz\u00e1mot is jelenti), a <em>c<\/em> pedig az eredm\u00e9nyt, a sz\u00e1mtani k\u00f6zepet jelenti. <strong>A sz\u00e1mtani k\u00f6z\u00e9p kisz\u00e1m\u00edt\u00e1s\u00e1nak menete a k\u00f6vetkez\u0151: \u00f6sszeadjuk a sz\u00e1megyenes \u00e9rt\u00e9keit, vagyis az \u00e1tlagolni k\u00edv\u00e1nt \u00e9rt\u00e9keket, majd elosztjuk az \u00f6sszeget a sz\u00e1megyenes \u00e9rt\u00e9keinek darabsz\u00e1m\u00e1val.<\/strong> K\u00e9plettel fel\u00edrva ez \u00edgy n\u00e9z ki:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-25fed9f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"25fed9f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d9471f4\" data-id=\"d9471f4\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-564f87d elementor-widget elementor-widget-text-editor\" data-id=\"564f87d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>A(<em>a<sub>1<\/sub><\/em>;<em>a<sub>2<\/sub><\/em>;<em>\u2026a<sub>n-1<\/sub><\/em>;<em>a<sub>n<\/sub><\/em>)=(<em>a<sub>1<\/sub><\/em>+<em>a<sub>2<\/sub><\/em>+<em>\u2026a<sub>n-1<\/sub><\/em>+<em>a<sub>n<\/sub><\/em>)\/<em>n<\/em><\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-321df70 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"321df70\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d3d13ee\" data-id=\"d3d13ee\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-deb64bd elementor-widget elementor-widget-text-editor\" data-id=\"deb64bd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Sz\u00f6rny\u0171! Ink\u00e1bb n\u00e9zz\u00fcnk egy k\u00e9t sz\u00e1mb\u00f3l \u00e1ll\u00f3 p\u00e9ld\u00e1t, amellyel mindez \u00e9rthet\u0151bb\u00e9 v\u00e1lik: legyen egyenl\u0151 az <em>a<\/em> 10-el \u00e9s a <em>b <\/em>20-al! A fenti k\u00e9plet \u00edgy alakul \u00e1t:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3b43967 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3b43967\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5191ce0\" data-id=\"5191ce0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-14d1dab elementor-widget elementor-widget-text-editor\" data-id=\"14d1dab\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>A(<em>10<\/em>;<em>20<\/em>)=(<em>10<\/em>+<em>20<\/em>)\/<em>2<\/em>=15<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-eaea8dd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"eaea8dd\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b358bf9\" data-id=\"b358bf9\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a7a75a5 elementor-widget elementor-widget-text-editor\" data-id=\"a7a75a5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Az eredm\u00e9ny\u00fcl kapott sz\u00e1mtani k\u00f6z\u00e9p, a 15, val\u00f3ban egyenl\u0151 t\u00e1vols\u00e1gra van a 10-t\u0151l \u00e9s a 20-t\u00f3l. N\u00e9zz\u00fcnk egy m\u00e1sik p\u00e9ld\u00e1t \u00f6t sz\u00e1mmal:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7ed344d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7ed344d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a6fb061\" data-id=\"a6fb061\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d4dd271 elementor-widget elementor-widget-text-editor\" data-id=\"d4dd271\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>A(<em>-5<\/em>;<em>-7<\/em>;<em>2<\/em>;<em>8<\/em>;<em>12<\/em>)=(<em>-5-7+2+8+12<\/em>)\/<em>5<\/em>=<em>2<\/em><\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-633a44f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"633a44f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-062b5f5\" data-id=\"062b5f5\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f4b83aa elementor-widget elementor-widget-text-editor\" data-id=\"f4b83aa\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>val\u00f3ban, az eredm\u00e9ny\u00fcl kapott sz\u00e1mtani k\u00f6z\u00e9p, a 2 egyenl\u0151 t\u00e1vols\u00e1gra van a -5-t\u0151l \u00e9s a 12-t\u0151l.<\/p>\n\n<p>A fentiek szerint bel\u00e1thatjuk, hogy a sz\u00e1mtani k\u00f6z\u00e9p megnevez\u00e9s k\u00f6z\u00e9rthet\u0151bben hordozza mag\u00e1ban a sz\u00e1m\u00edt\u00e1s l\u00e9nyeg\u00e9t, mint az elterjedten haszn\u00e1lt \u00e1tlag. Ett\u0151l f\u00fcggetlen\u00fcl b\u00e1tran haszn\u00e1ljuk tov\u00e1bb az \u00e1tlag sz\u00f3t!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-902de9d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"902de9d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3ffd79f\" data-id=\"3ffd79f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-85ecef1 elementor-widget elementor-widget-text-editor\" data-id=\"85ecef1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00c1lljunk meg egy sz\u00f3ra!<\/strong><br \/>Az \u00e1tlaggal kapcsolatban tiszt\u00e1ban kell lenn\u00fcnk azzal, hogy <strong>nagyon \u00e9rz\u00e9keny a sz\u00e9ls\u0151s\u00e9gesen elt\u00e9r\u0151 \u00e9rt\u00e9kekre<\/strong>, vagyis er\u0151sen hatnak r\u00e1 a kil\u00f3g\u00f3 adatok, legyenek azok ak\u00e1r az \u00e9rt\u00e9kek t\u00f6bbs\u00e9g\u00e9hez k\u00e9pest nagyon alacsony vagy magas \u00e9rt\u00e9kek.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1c4ffd2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1c4ffd2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-25ded24\" data-id=\"25ded24\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-4ca10ee elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"4ca10ee\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;2. Az \\u00c1TLAG f\\u00fcggv\\u00e9ny bemutat\\u00e1sa&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">2. Az \u00c1TLAG f\u00fcggv\u00e9ny bemutat\u00e1sa<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-abd82bc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"abd82bc\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b4bf629\" data-id=\"b4bf629\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-087feab elementor-widget elementor-widget-text-editor\" data-id=\"087feab\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Az \u00c1TLAG f\u00fcggv\u00e9ny a statisztikai f\u00fcggv\u00e9nyek k\u00f6z\u00e9 tartozik \u2013 az argumentumk\u00e9nt megadott numerikus \u00e9rt\u00e9kek sz\u00e1mtani k\u00f6zep\u00e9t adja eredm\u00e9ny\u00fcl.<\/strong><\/p>\n<p>A f\u00fcggv\u00e9ny szintaxisa a k\u00f6vetkez\u0151:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-ae8dbdb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ae8dbdb\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bbc08dd\" data-id=\"bbc08dd\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a46a61f elementor-widget elementor-widget-text-editor\" data-id=\"a46a61f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00c1TLAG(<em>arg1[;arg2\u2026]<\/em>)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-cbf5735 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"cbf5735\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bbf7977\" data-id=\"bbf7977\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e644fc0 elementor-widget elementor-widget-text-editor\" data-id=\"e644fc0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>ahol <em>arg1<\/em> \u00e9s <em>arg2 <\/em>a numerikus argumentumokat jelenti. A f\u00fcggv\u00e9ny legal\u00e1bb egy, legfeljebb 255 darab argumentum megad\u00e1s\u00e1t v\u00e1rja. Argumentum lehet konstans (5), cellahivatkoz\u00e1s (A1), tartom\u00e1nyhivatkoz\u00e1s (A1:C10), tartom\u00e1nyn\u00e9v (Oszt\u00e1ly), t\u00f6mb \u00e9s k\u00e9plet, ak\u00e1r vegyesen is.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0fc4ebb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0fc4ebb\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2775707\" data-id=\"2775707\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8ab8665 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"8ab8665\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;3. Az \\u00c1TLAG f\\u00fcggv\\u00e9ny alkalmaz\\u00e1sa numerikus argumentumok eset\\u00e9n&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">3. Az \u00c1TLAG f\u00fcggv\u00e9ny alkalmaz\u00e1sa numerikus argumentumok eset\u00e9n<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a75c68b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a75c68b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2addc53\" data-id=\"2addc53\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-db20055 elementor-widget elementor-widget-text-editor\" data-id=\"db20055\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A f\u00fcggv\u00e9ny teh\u00e1t numerikus adatokat v\u00e1r argumentumk\u00e9nt. Az Excel azonban t\u00f6bb numerikus adatt\u00edpussal rendelkezik, ez\u00e9rt nem haszontalan \u00e1ttekinten\u00fcnk, melyiket hogyan haszn\u00e1lhatjuk, mire kell figyeln\u00fcnk \u00e9s melyikkel milyen eredm\u00e9nyre sz\u00e1m\u00edthatunk!<\/p>\n\n<p>Ha konstans \u00e9rt\u00e9keket adunk meg, akkor egyszer\u0171 k\u00e9pletet kapunk:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-128bc54 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"128bc54\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-cdaf34f\" data-id=\"cdaf34f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8c5476f elementor-widget elementor-widget-text-editor\" data-id=\"8c5476f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=\u00c1TLAG(10;20)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0ce3eea elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0ce3eea\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0943200\" data-id=\"0943200\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8cdca72 elementor-widget elementor-widget-text-editor\" data-id=\"8cdca72\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A k\u00e9plet eredm\u00e9nye 15, ami val\u00f3ban egyenl\u0151 t\u00e1vols\u00e1gra van a k\u00e9t \u00e9rt\u00e9kt\u0151l. Mivel a d\u00e1tum, az id\u0151, a k\u00f6nyvel\u00e9si, a t\u00f6rt, a tudom\u00e1nyos \u00e9s a sz\u00e1zal\u00e9k is numerikus t\u00edpus\u00faak, a f\u00fcggv\u00e9ny ezekn\u00e9l is a fenti p\u00e9ld\u00e1khoz hasonl\u00f3an m\u0171k\u00f6dik. Ha a felsorolt numerikus form\u00e1tumok vegyesen fordulnak el\u0151 argumentumk\u00e9nt, a f\u00fcggv\u00e9ny eredm\u00e9nye akkor is t\u00f6bbnyire mag\u00e1t\u00f3l \u00e9rtet\u0151d\u0151. Az\u00e9rt n\u00e9zz\u00fcnk meg n\u00e9h\u00e1ny esetet!<\/p>\n\n<p>D\u00e1tum \u00e9s id\u0151adatokkal dolgozva tartsuk \u00e9szben, hogy <strong>egy d\u00e1tumot az 1900 janu\u00e1r 1-je \u00f3ta eltelt napok sz\u00e1ma, m\u00edg egy id\u0151pontot egy 0 \u00e9s 1 k\u00f6z\u00f6tti t\u00f6rtsz\u00e1m jelk\u00e9pez<\/strong>! N\u00e9zz\u00fcnk egy p\u00e9ld\u00e1t d\u00e1tum t\u00edpus\u00fa adat kezel\u00e9s\u00e9re:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0f34197 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0f34197\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0e87608\" data-id=\"0e87608\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6970f30 elementor-widget elementor-widget-text-editor\" data-id=\"6970f30\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=\u00c1TLAG(D\u00c1TUM\u00c9RT\u00c9K(&#8222;19\/1\/1&#8221;);43830)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-722beb7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"722beb7\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a4b0884\" data-id=\"a4b0884\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f2aea15 elementor-widget elementor-widget-text-editor\" data-id=\"f2aea15\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A 2019 janu\u00e1r 1-e \u00e9rt\u00e9ke 43466, m\u00edg a 43830 sz\u00e1m 2019 december 31-e sorsz\u00e1ma. Ha a fenti k\u00e9pletet beg\u00e9pelj\u00fck egy cell\u00e1ba, akkor \u00e1tlagk\u00e9nt egy sorsz\u00e1mot, a 43648-at kapjuk eredm\u00e9ny\u00fcl. Rendelj\u00fcnk a cell\u00e1hoz egy d\u00e1tumform\u00e1tumot, \u00e9s m\u00e1ris d\u00e1tumk\u00e9nt l\u00e1tjuk az eredm\u00e9nyt: 2019 j\u00falius 2. Ezen a napon val\u00f3ban egyenl\u0151 t\u00e1vols\u00e1gra volt t\u0151l\u00fcnk janu\u00e1r 1-e \u00e9s december 31-e.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dd1785a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dd1785a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bbf9bb9\" data-id=\"bbf9bb9\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-85af005 elementor-widget elementor-widget-text-editor\" data-id=\"85af005\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>Tipp:<\/strong> \u00c9vente, sz\u00f6k\u0151\u00e9vente elt\u00e9r az \u00e9v napjainak sz\u00e1ma, hol 364, hol 365. Emiatt az \u00e9v napjainak sz\u00e1mtani k\u00f6zepe hol j\u00falius 1-re, hol j\u00falius 2-re esik.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0d54b88 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0d54b88\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5faa9b8\" data-id=\"5faa9b8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-69b37bf elementor-widget elementor-widget-text-editor\" data-id=\"69b37bf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Hasonl\u00f3an egyszer\u0171 az id\u0151pontok kezel\u00e9se, \u00e9rtelmez\u00e9se is:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2b3a51e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2b3a51e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-be5a7d1\" data-id=\"be5a7d1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c7c002e elementor-widget elementor-widget-text-editor\" data-id=\"c7c002e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=\u00c1TLAG(ID\u0150\u00c9RT\u00c9K(&#8222;00:00&#8221;);ID\u0150\u00c9RT\u00c9K(&#8222;23:59:59&#8221;))<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5001fbb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5001fbb\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f5d5609\" data-id=\"f5d5609\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ffad5ad elementor-widget elementor-widget-text-editor\" data-id=\"ffad5ad\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Eredm\u00e9ny\u00fcl 1 m\u00e1sodperc h\u00edj\u00e1n 0,5-et kapunk, amely a d\u00e9li 12 \u00f3r\u00e1t jelenti. A d\u00e9li 12 \u00f3ra val\u00f3ban f\u00e9l\u00faton van az \u00faj nap kezdete \u00e9s az \u00e9jf\u00e9l k\u00f6z\u00f6tt.<\/p>\n\n<p>N\u00e9zz\u00fcnk egy m\u00e1sik numerikus adatt\u00edpust, a sz\u00e1zal\u00e9kot:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-04500e0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"04500e0\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-961f0a2\" data-id=\"961f0a2\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-162178a elementor-widget elementor-widget-text-editor\" data-id=\"162178a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=\u00c1TLAG(10%;70%)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8b605a5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8b605a5\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4f3d29e\" data-id=\"4f3d29e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dbba456 elementor-widget elementor-widget-text-editor\" data-id=\"dbba456\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Tudjuk, hogy a <strong>Sz\u00e1zal\u00e9k Sz\u00e1mform\u00e1tum\u00fa<\/strong> adat val\u00f3j\u00e1ban sz\u00e1zzal osztott \u00e9rt\u00e9ket jelent, \u00edgy az eredm\u00e9ny 0,4, vagyis 40% lesz, ha az eredm\u00e9ny <strong>Sz\u00e1zal\u00e9k<\/strong> form\u00e1tumot kap. A 40% val\u00f3ban egyforma t\u00e1vols\u00e1gra van a k\u00e9t \u00e9rt\u00e9kt\u0151l.<\/p>\n\n<p>K\u00f6vetkezzen a <strong>K\u00f6nyvel\u00e9si Sz\u00e1mform\u00e1tum<\/strong> vegyes alkalmaz\u00e1sa:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f6b79be elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f6b79be\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6ab4d9f\" data-id=\"6ab4d9f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-02cd07f elementor-widget elementor-widget-text-editor\" data-id=\"02cd07f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=\u00c1TLAG(SZ\u00d6VEG(10000;&#8221;0 Ft&#8221;);20000)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e7f231d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e7f231d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e037d79\" data-id=\"e037d79\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a400d2b elementor-widget elementor-widget-text-editor\" data-id=\"a400d2b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Az eredm\u00e9ny 15000. Az ut\u00f3lagos form\u00e1z\u00e1sr\u00f3l itt sem feledkezhet\u00fcnk meg.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-463c3de elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"463c3de\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-83da969\" data-id=\"83da969\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ee085fe elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"ee085fe\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;4. Az \\u00c1TLAG f\\u00fcggv\\u00e9ny alkalmaz\\u00e1sa sz\\u00f6vegk\\u00e9nt megadott numerikus argumentumok eset\\u00e9n&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">4. Az \u00c1TLAG f\u00fcggv\u00e9ny alkalmaz\u00e1sa sz\u00f6vegk\u00e9nt megadott numerikus argumentumok eset\u00e9n<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c3f4e11 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c3f4e11\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-649acaa\" data-id=\"649acaa\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1040e14 elementor-widget elementor-widget-text-editor\" data-id=\"1040e14\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Sz\u00f6vegk\u00e9nt megadott numerikus \u00e9rt\u00e9k argumentumk\u00e9nt val\u00f3 megad\u00e1s\u00e1ra az el\u0151bb l\u00e1ttunk p\u00e9ld\u00e1t. Tapasztaltuk, hogy a f\u00fcggv\u00e9ny k\u00e9pes felismerni az egy\u00e9rtelm\u0171en sz\u00e1mk\u00e9nt \u00e9rtelmezhet\u0151 sz\u00f6veget, azt k\u00e9pes \u00e1talak\u00edtani numerikus \u00e9rt\u00e9kk\u00e9 \u00e9s az \u00e1tlagsz\u00e1m\u00edt\u00e1sba bevonni. De n\u00e9zz\u00fcnk egy kev\u00e9sb\u00e9 \u00f6sszetett p\u00e9ld\u00e1t, mire is gondolunk, amikor sz\u00f6vegk\u00e9nt megadott numerikus adatot adunk meg argumentumk\u00e9nt:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-646d54c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"646d54c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7160b9c\" data-id=\"7160b9c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2160ecc elementor-widget elementor-widget-text-editor\" data-id=\"2160ecc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=\u00c1TLAG(&#8222;10&#8221;;70)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e93dbca elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e93dbca\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-25e0dec\" data-id=\"25e0dec\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8a7c4af elementor-widget elementor-widget-text-editor\" data-id=\"8a7c4af\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A t\u00edzes sz\u00e1mot macskak\u00f6rm\u00f6k <em>(Shift+2)<\/em> k\u00f6z\u00e9 z\u00e1rtuk, vagyis sz\u00f6vegk\u00e9nt adtuk meg. A\u00a0f\u00fcggv\u00e9ny visszaalak\u00edtja sz\u00e1mm\u00e1 a &#8222;10&#8221; karakterl\u00e1ncot, majd ezut\u00e1n v\u00e9gzi el a m\u0171veletet: az eredm\u00e9ny 40 lesz. A tizedes t\u00f6rt alakban fel\u00edrt sz\u00e1mokat is felismeri a f\u00fcggv\u00e9ny, teh\u00e1t a k\u00f6vetkez\u0151 k\u00e9plet is eredm\u00e9nyt fog szolg\u00e1ltatni (40,5):<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8064335 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8064335\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7c6258d\" data-id=\"7c6258d\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3b053bc elementor-widget elementor-widget-text-editor\" data-id=\"3b053bc\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=\u00c1TLAG(&#8222;10,5&#8221;;70,5)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8c4ecaa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8c4ecaa\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d5d4326\" data-id=\"d5d4326\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ab4311e elementor-widget elementor-widget-text-editor\" data-id=\"ab4311e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00c1lljunk meg egy sz\u00f3ra!<\/strong><br \/>A <strong>sz\u00f6vegk\u00e9nt megadott sz\u00e1m<\/strong> \u00e9s a <strong>sz\u00e1mot tartalmaz\u00f3 sz\u00f6veg<\/strong> (p\u00e9ld\u00e1ul 2020.) nem ugyanazt jelenti. Az ut\u00f3bbi esetben az Excel nem k\u00e9pes kiolvasni a karaktersorozatb\u00f3l a sz\u00e1mot, teh\u00e1t ne v\u00e1rjuk el, hogy a &#8222;50.&#8221; vagy a &#8222;5000\u20ac&#8221; helyes eredm\u00e9nyt ad. Ha ilyen adatokkal kell dolgoznunk, akkor el\u0151tte v\u00e9gezz\u00fcnk adattiszt\u00edt\u00e1st, vagyis gondoskodjunk arr\u00f3l, hogy az \u00e9rt\u00e9kek megfelel\u0151 adatt\u00edpus\u00faak legyenek. Ha m\u00e9gis ragaszkodnunk kell az adatok megjelen\u00e9s\u00e9hez, akkor ut\u00f3lag form\u00e1zzunk, alkalmazzunk egy\u00e9ni sz\u00e1mform\u00e1tumot vagy vess\u00fck be az adatt\u00edpusok k\u00f6z\u00f6tti \u00e1talak\u00edt\u00e1st v\u00e9gz\u0151 f\u00fcggv\u00e9nyeket.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4c9acab elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4c9acab\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-a69bd97\" data-id=\"a69bd97\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d180132 elementor-widget elementor-widget-text-editor\" data-id=\"d180132\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Mivel az \u00c1TLAG f\u00fcggv\u00e9ny numerikus t\u00edpus\u00fa argumentumokat v\u00e1r, a k\u00f6vetkez\u0151 adatt\u00edpusok alkalmaz\u00e1sa fokozott \u00f3vatoss\u00e1got ig\u00e9nyel. Logikai \u00e9s sz\u00f6veges argumentumokat val\u00f3sz\u00edn\u0171leg nem fogunk \u00e1tlagolni, ugyanakkor \u00fcres cella \u00e9s hiba\u00e9rt\u00e9k nagyon is el\u0151fordulhat az argumentumok k\u00f6z\u00f6tt.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7d51498 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7d51498\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-1f63037\" data-id=\"1f63037\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-6dd81ae elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"6dd81ae\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;5. Az \\u00c1TLAG f\\u00fcggv\\u00e9ny alkalmaz\\u00e1sa logikai argumentumok eset\\u00e9n&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">5. Az \u00c1TLAG f\u00fcggv\u00e9ny alkalmaz\u00e1sa logikai argumentumok eset\u00e9n<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-41e4349 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"41e4349\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-59b3d26\" data-id=\"59b3d26\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-2854dfb elementor-widget elementor-widget-text-editor\" data-id=\"2854dfb\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A logikai t\u00edpus\u00fa adatokat k\u00e9tf\u00e9le m\u00f3don \u00e9rtelmezi a f\u00fcggv\u00e9ny. <strong>Ha az IGAZ \u00e9s a HAMIS konstansk\u00e9nt, IGAZ vagy HAMIS f\u00fcggv\u00e9nyk\u00e9nt, vagy logikai eredm\u00e9nyt szolg\u00e1ltat\u00f3 be\u00e1gyazott f\u00fcggv\u00e9nyk\u00e9nt vagy k\u00e9pletk\u00e9nt jelenik meg a z\u00e1r\u00f3jelek k\u00f6z\u00f6tt, akkor az IGAZ \u00e9rt\u00e9ket 1-el, a HAMIS \u00e9rt\u00e9ket 0-val helyettes\u00edti az Excel, vagyis numerikus t\u00edpus\u00fa adatt\u00e1 alak\u00edtja ezt a k\u00e9t logikai \u00e9rt\u00e9ket.<\/strong> Gy\u0151z\u0151dj\u00fcnk meg a le\u00edrtakr\u00f3l kipr\u00f3b\u00e1lva az al\u00e1bbi k\u00e9pleteket:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c8d1aa6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c8d1aa6\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-54a3dea\" data-id=\"54a3dea\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9748b56 elementor-widget elementor-widget-text-editor\" data-id=\"9748b56\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=\u00c1TLAG(IGAZ;10)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7aabe58 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7aabe58\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-33e0a10\" data-id=\"33e0a10\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-42c8985 elementor-widget elementor-widget-text-editor\" data-id=\"42c8985\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=\u00c1TLAG(HAMIS;10)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d7007b2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d7007b2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ba4bbab\" data-id=\"ba4bbab\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f0db0de elementor-widget elementor-widget-text-editor\" data-id=\"f0db0de\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Az eredm\u00e9ny v\u00e1rhat\u00f3an 5,5 \u00e9s 5 lett. Vess\u00fcnk egy pillant\u00e1st olyan k\u00e9pletre, amely logikai felt\u00e9teleket tartalmaz:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2eaa13d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2eaa13d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-316205a\" data-id=\"316205a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-010e96d elementor-widget elementor-widget-text-editor\" data-id=\"010e96d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00a0=\u00c1TLAG(5&gt;3;5&lt;3)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2a4e4ea elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2a4e4ea\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-9b33166\" data-id=\"9b33166\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0a2751f elementor-widget elementor-widget-text-editor\" data-id=\"0a2751f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Az eredm\u00e9ny 0,5. De milyen eredm\u00e9nyt kapunk, <strong>ha az argumentum egy hivatkoz\u00e1s logikai \u00e9rt\u00e9ket tartalmaz\u00f3 cell\u00e1ra, vagy az argumentumok k\u00f6z\u00f6tt egy vagy t\u00f6bb ilyen hivatkoz\u00e1s tal\u00e1lhat\u00f3<\/strong>? N\u00e9zz\u00fck csak a k\u00f6vetkez\u0151 k\u00e9pleteket, amelyek az A1:A2 tartom\u00e1nyra hivatkoznak \u2013 a k\u00e9t cell\u00e1ba az IGAZ \u00e9s a HAMIS \u00e9rt\u00e9keket helyezt\u00fck el:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c03dcb2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c03dcb2\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b9cd58b\" data-id=\"b9cd58b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8829f5b elementor-widget elementor-widget-text-editor\" data-id=\"8829f5b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=\u00c1TLAG(A1:A2)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8a3adfb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8a3adfb\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-22fbb52\" data-id=\"22fbb52\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-d1d7a1e elementor-widget elementor-widget-text-editor\" data-id=\"d1d7a1e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A k\u00e9plet eredm\u00e9nye a #Z\u00c9R\u00d3OSZT\u00d3! hiba\u00e9rt\u00e9k. Bizony, <strong>a m\u00e1sik \u00e9rtelmez\u00e9s szerint a hivatkozott cell\u00e1ban vagy tartom\u00e1nyban l\u00e9v\u0151 logikai \u00e9rt\u00e9keket nem veszi figyelembe a f\u00fcggv\u00e9ny<\/strong>. Ez\u00e9rt lett hiba\u00e9rt\u00e9k az eredm\u00e9ny, mivel a semmit nem lehet null\u00e1val osztani \u2013 a semmi ugye nulla sz\u00e1m\u00fa adat, \u00edgy tett k\u00eds\u00e9rletet a f\u00fcggv\u00e9ny null\u00e1val val\u00f3 oszt\u00e1sra. N\u00e9zz\u00fcnk egy m\u00e1sik p\u00e9ld\u00e1t:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-07fe53f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"07fe53f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2d2a374\" data-id=\"2d2a374\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e1a6f67 elementor-widget elementor-widget-text-editor\" data-id=\"e1a6f67\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=\u00c1TLAG(A1:A2;50;30)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3c07af9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3c07af9\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-15893b0\" data-id=\"15893b0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a3ed6d4 elementor-widget elementor-widget-text-editor\" data-id=\"a3ed6d4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A k\u00e9plet eredm\u00e9nye 40, vagyis az 50 \u00e9s a 30 sz\u00e1mtani k\u00f6zepe A f\u00fcggv\u00e9ny nem a (0+50+30)\/3 sz\u00e1m\u00edt\u00e1st v\u00e9gezte el, mivel a logikai \u00e9rt\u00e9keket figyelmen k\u00edv\u00fcl hagyta.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-bc5e2e0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bc5e2e0\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-812d6df\" data-id=\"812d6df\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3d9c906 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"3d9c906\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;6. Az \\u00c1TLAG f\\u00fcggv\\u00e9ny alkalmaz\\u00e1sa sz\\u00f6veg t\\u00edpus\\u00fa argumentumok eset\\u00e9n&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">6. Az \u00c1TLAG f\u00fcggv\u00e9ny alkalmaz\u00e1sa sz\u00f6veg t\u00edpus\u00fa argumentumok eset\u00e9n<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d5002d7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d5002d7\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5a44d46\" data-id=\"5a44d46\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a51cca7 elementor-widget elementor-widget-text-editor\" data-id=\"a51cca7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Ha az argumentumok k\u00f6z\u00f6tt konstans sz\u00f6veg t\u00edpus\u00fa adat tal\u00e1lhat\u00f3, bele\u00e9rtve az \u00fcres karakterl\u00e1ncot (&#8222;&#8221;) is, akkor a f\u00fcggv\u00e9ny az #\u00c9RT\u00c9K! hiba\u00e9rt\u00e9ket adja eredm\u00e9ny\u00fcl:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5dfb39b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5dfb39b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-6e35dfa\" data-id=\"6e35dfa\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-e4829dd elementor-widget elementor-widget-text-editor\" data-id=\"e4829dd\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=\u00c1TLAG(&#8222;Ez egy sz\u00f6veg&#8221;;10;70)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f789fae elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f789fae\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-155e880\" data-id=\"155e880\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7d31335 elementor-widget elementor-widget-text-editor\" data-id=\"7d31335\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=\u00c1TLAG(&#8222;&#8221;;10;70)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4f458cf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4f458cf\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5b723f4\" data-id=\"5b723f4\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ccd491c elementor-widget elementor-widget-text-editor\" data-id=\"ccd491c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Ha sz\u00f6vegre vagy \u00fcres karakterl\u00e1ncra (=&#8221;&#8221;) hivatkozunk, akkor a k\u00f6vetkez\u0151 k\u00e9plet eredm\u00e9nye 40, mivel az A1 cella \u00e9rt\u00e9k\u00e9t (ami b\u00e1rmilyen sz\u00f6veg lehet) a f\u00fcggv\u00e9ny figyelmen k\u00edv\u00fcl hagyja:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c05913a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c05913a\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-8ff736a\" data-id=\"8ff736a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-41da5f0 elementor-widget elementor-widget-text-editor\" data-id=\"41da5f0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=\u00c1TLAG(A1;10;70)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e80c0f9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e80c0f9\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-33a05bd\" data-id=\"33a05bd\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0e47729 elementor-widget elementor-widget-text-editor\" data-id=\"0e47729\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Ha az argumentumok k\u00f6z\u00f6tt csak sz\u00f6veg t\u00edpus\u00fa adatok tal\u00e1lhat\u00f3k, akkor a #Z\u00c9R\u00d3OSZT\u00d3! hiba\u00e9rt\u00e9k a jutalmunk.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c80312b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c80312b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bb25717\" data-id=\"bb25717\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-19a9c90 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"19a9c90\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;7. Az \\u00c1TLAG f\\u00fcggv\\u00e9ny alkalmaz\\u00e1sa \\u00fcres cell\\u00e1kra hivatkoz\\u00f3 argumentumok eset\\u00e9n&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">7. Az \u00c1TLAG f\u00fcggv\u00e9ny alkalmaz\u00e1sa \u00fcres cell\u00e1kra hivatkoz\u00f3 argumentumok eset\u00e9n<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-caf897d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"caf897d\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f918fc6\" data-id=\"f918fc6\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-933929e elementor-widget elementor-widget-text-editor\" data-id=\"933929e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A f\u00fcggv\u00e9ny \u00e1ltal szolg\u00e1ltatott eredm\u00e9nyt az eddig le\u00edrtak alapj\u00e1n sejtj\u00fck. N\u00e9zz\u00fck csak a k\u00f6vetkez\u0151 k\u00e9pletet \u2013 felt\u00e9telezve, hogy a hivatkozott tartom\u00e1ny cell\u00e1i \u00fcresek:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6066236 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6066236\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-dfa1397\" data-id=\"dfa1397\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b72bc2d elementor-widget elementor-widget-text-editor\" data-id=\"b72bc2d\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=\u00c1TLAG(C1:C10;10;70)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3d8ac0e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3d8ac0e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-71c84e0\" data-id=\"71c84e0\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3486e53 elementor-widget elementor-widget-text-editor\" data-id=\"3486e53\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Ha 40-re sz\u00e1m\u00edtottunk, j\u00f3l gondoltuk! <strong>A kor\u00e1bbi fejezetekben l\u00e1ttuk, hogy hivatkoz\u00e1sokban szerepl\u0151 logikai \u00e9rt\u00e9ket, sz\u00f6veget vagy \u00fcres karakterl\u00e1ncot nem veszi figyelembe a f\u00fcggv\u00e9ny, de \u00edgy tesz az \u00fcres cell\u00e1val is.<\/strong> Ez a kett\u0151s \u00e9rtelmez\u00e9s (hol nulla \u00e9s egy a logikai t\u00edpus\u00fa adatokn\u00e1l, hol figyelembe nem vett adat) nagyon zavar\u00f3 tud lenni, nehezen felder\u00edthet\u0151 hib\u00e1t okozhat. \u00c9ppen ez\u00e9rt, ha numerikust\u00f3l elt\u00e9r\u0151 t\u00edpus\u00fa adatokon akarunk \u00e1tlagot sz\u00e1molni, akkor haszn\u00e1ljuk az \u00c1TLAGA f\u00fcggv\u00e9nyt.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-817abd7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"817abd7\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-af62b01\" data-id=\"af62b01\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ae0d7a0 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"ae0d7a0\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;8. Az \\u00c1TLAG f\\u00fcggv\\u00e9ny alkalmaz\\u00e1sa hiba\\u00e9rt\\u00e9ket tartalmaz\\u00f3 argumentum eset\\u00e9n&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">8. Az \u00c1TLAG f\u00fcggv\u00e9ny alkalmaz\u00e1sa hiba\u00e9rt\u00e9ket tartalmaz\u00f3 argumentum eset\u00e9n<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-b1a9c89 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b1a9c89\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f4c30e8\" data-id=\"f4c30e8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a8175c7 elementor-widget elementor-widget-text-editor\" data-id=\"a8175c7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A hiba\u00e9rt\u00e9kre hiba\u00e9rt\u00e9k a v\u00e1lasz. Ha az argumentumlist\u00e1ban t\u00f6bb elt\u00e9r\u0151 hiba\u00e9rt\u00e9k is jelen van, akkor az els\u0151 hiba\u00e9rt\u00e9ket fogjuk eredm\u00e9ny\u00fcl kapni. Az al\u00e1bbi k\u00e9t k\u00e9pletben azt szeml\u00e9ltett\u00fck, hogy a null\u00e1val val\u00f3 oszt\u00e1s k\u00eds\u00e9rlete \u00e9s egy #HI\u00c1NYZIK hiba\u00e9rt\u00e9k felcser\u00e9lve milyen eredm\u00e9nyt ad:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-bc0eee4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bc0eee4\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c2df9cf\" data-id=\"c2df9cf\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9d67447 elementor-widget elementor-widget-text-editor\" data-id=\"9d67447\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=\u00c1TLAG(3\/0;HI\u00c1NYZIK())<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dafe5df elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dafe5df\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4074c9c\" data-id=\"4074c9c\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c9ff426 elementor-widget elementor-widget-text-editor\" data-id=\"c9ff426\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>=\u00c1TLAG(HI\u00c1NYZIK();3\/0)<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9922711 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9922711\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3c49a64\" data-id=\"3c49a64\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-710fd52 elementor-widget elementor-widget-text-editor\" data-id=\"710fd52\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Az els\u0151 k\u00e9plet eredm\u00e9nye a #Z\u00c9R\u00d3OSZT\u00d3!, a m\u00e1sodik\u00e9 a #HI\u00c1NYZIK hiba\u00e9rt\u00e9k lesz. Ha az argumentumlist\u00e1ban a hiba\u00e9rt\u00e9k mellett csupa numerikus \u00e9rt\u00e9k tal\u00e1lhat\u00f3, akkor is hiba\u00e9rt\u00e9ket kapunk eredm\u00e9ny\u00fcl.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-abd3a40 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"abd3a40\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0fd9c0e\" data-id=\"0fd9c0e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9cdb1a9 elementor-widget elementor-widget-text-editor\" data-id=\"9cdb1a9\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00c1lljunk meg egy sz\u00f3ra!<\/strong><br \/>Mivel a #HI\u00c1NYZIK hiba\u00e9rt\u00e9k vagy a HI\u00c1NYZIK f\u00fcggv\u00e9ny jelenl\u00e9te, alkalmaz\u00e1sa javasolt a hi\u00e1nyz\u00f3 adatok jel\u00f6l\u00e9s\u00e9re, az \u00c1TLAG f\u00fcggv\u00e9ny helyett c\u00e9lszer\u0171bb az \u00c1TLAGHA f\u00fcggv\u00e9nyt alkalmazni, p\u00e9ld\u00e1ul: <strong>=\u00c1TLAGHA(C1:C10;&#8221;&lt;&gt;#HI\u00c1NYZIK&#8221;)<\/strong><br \/>Az \u00c1TLAGHA f\u00fcggv\u00e9nnyel figyelmen k\u00edv\u00fcl hagyjuk a hi\u00e1nyz\u00f3 adatokat, \u00edgy re\u00e1lis eredm\u00e9nyt kapunk.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9ed8c1f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9ed8c1f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b7e69e9\" data-id=\"b7e69e9\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b25d995 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"b25d995\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;9. Az \\u00c1TLAG f\\u00fcggv\\u00e9ny alkalmaz\\u00e1s\\u00e1nak \\u00f6sszefoglal\\u00e1sa&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">9. Az \u00c1TLAG f\u00fcggv\u00e9ny alkalmaz\u00e1s\u00e1nak \u00f6sszefoglal\u00e1sa<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-56eb544 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"56eb544\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-4c4b1c3\" data-id=\"4c4b1c3\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-63a42c0 elementor-widget elementor-widget-text-editor\" data-id=\"63a42c0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Az eddig olvasottak alapj\u00e1n bel\u00e1thatjuk, hogy az \u00c1TLAG f\u00fcggv\u00e9ny k\u00f6nnyen haszn\u00e1lhat\u00f3 numerikus adatokkal. \u00d3vatosan akkor kell elj\u00e1rnunk, ha egy\u00e9b adatt\u00edpus\u00fa adat keveredik az argumentumok k\u00f6z\u00e9. A #HI\u00c1NYZIK hiba\u00e9rt\u00e9k tervezett el\u0151fordul\u00e1sa a hi\u00e1nyz\u00f3 adatok jelz\u00e9s\u00e9re mindenk\u00e9ppen v\u00e1rhat\u00f3, illetve alkalmazand\u00f3, a t\u00f6bbi hiba\u00e9rt\u00e9k megjelen\u00e9se eredm\u00e9nyk\u00e9nt azonban jav\u00edtand\u00f3 hib\u00e1t jelez.<\/p>\n<p>A fentiek \u00f6sszefoglal\u00e1s\u00e1hoz seg\u00edts\u00e9g\u00fcnkre lehet az <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny_1_Munka1.jpg\" target=\"_blank\" rel=\"noopener\">1. \u00e1bra<\/a>, amely a <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny.xlsx\">196-K-Excel-\u00c1TLAG f\u00fcggv\u00e9ny.xlsx<\/a> munkaf\u00fczet Munka1 munkalapj\u00e1t mutatja. \u00c9rtelmezz\u00fck az \u00c1TLAG f\u00fcggv\u00e9ny \u00e1ltal a 8. sorban szolg\u00e1ltatott eredm\u00e9nyeket!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5dcbbb6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5dcbbb6\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-f997b8e\" data-id=\"f997b8e\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9c43c2e elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"9c43c2e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Az A oszlopban kiz\u00e1r\u00f3lag sz\u00f6veg t\u00edpus\u00fa adatok tal\u00e1lhat\u00f3k, \u00edgy az eredm\u00e9ny a #Z\u00c9R\u00d3OSZT\u00d3! hiba\u00e9rt\u00e9k.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">A B1 cell\u00e1ban sz\u00f6vegk\u00e9nt tal\u00e1lhat\u00f3 egy numerikus adatt\u00e1 \u00e1talak\u00edthat\u00f3 1-es sz\u00e1m, ezt a f\u00fcggv\u00e9ny sz\u00e1m\u00edt\u00e1sba veszi. A B7 cella tartalma viszont nem \u00e1talak\u00edthat\u00f3 sz\u00f6veg, ezt a f\u00fcggv\u00e9ny nem veszi figyelembe. Az eredm\u00e9ny teh\u00e1t a B1:B6 cell\u00e1k \u00e1tlaga.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">A C oszlop logikai \u00e9rt\u00e9keket \u00e9s \u00fcres cell\u00e1kat tartalmaz, az eredm\u00e9ny emiatt szint\u00e9n a #Z\u00c9R\u00d3OSZT\u00d3! hiba\u00e9rt\u00e9k.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">A D:F oszlopok azonos t\u00edpus\u00fa, emelked\u0151 sorrendbe rendezett numerikus adatokat tartalmaznak, \u00edgy a sz\u00e1mtani k\u00f6z\u00e9p \u00e9rt\u00e9ke szemmel l\u00e1that\u00f3an is leolvashat\u00f3.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">A G oszlop nem rendezett v\u00e9letlensz\u00e1mokat tartalmaz, de az \u00c1TLAG f\u00fcggv\u00e9ny tette a dolg\u00e1t.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">A H oszlop eredm\u00e9nyeinek \u00e9rtelmez\u00e9s\u00e9n\u00e9l der\u00fcl ki, meg\u00e9rtett\u00fck-e a kor\u00e1bban le\u00edrtakat a vegyes adatt\u00edpus\u00fa argumentumokr\u00f3l. A H1:H3 cell\u00e1kat a f\u00fcggv\u00e9ny nem veszi figyelembe, mivel adatt\u00edpusuk nem numerikus: a H1 tartalma sz\u00f6veg; a H2 tartalma \u00fcres karakterl\u00e1nc, szint\u00e9n sz\u00f6veg; \u00e9s a H3 tartalma a HAMIS logikai \u00e9rt\u00e9k. Az \u00e1tlagot a H4:H7 cell\u00e1k tartalma alapj\u00e1n kapjuk: a H4 d\u00e1tum\u00e1nak 43924 az \u00e9rt\u00e9ke; a 16:05 id\u0151pontot a 0,670138889 sz\u00e1m helyettes\u00edti, a 25% sz\u00e1zzal osztott \u00e9rt\u00e9ke 0,25; \u00e9s a 97-es sz\u00e1m.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">V\u00e9g\u00fcl az I oszlop hiba\u00e9rt\u00e9kei szint\u00e9n a v\u00e1rt eredm\u00e9nyt szolg\u00e1ltatj\u00e1k, vagyis a tartom\u00e1ny els\u0151 hiba\u00e9rt\u00e9k\u00e9t kapjuk. Az alattuk tal\u00e1lhat\u00f3 \u00fcres cell\u00e1kat a f\u00fcggv\u00e9ny nem veszi figyelembe.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e781e88 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e781e88\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-0b245b5\" data-id=\"0b245b5\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-acf2e64 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"acf2e64\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInRight&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny_1_Munka1.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny_1_Munka1-1024x576.jpg\" class=\"attachment-large size-large wp-image-3151\" alt=\"1. \u00e1bra: Az \u00c1TLAG f\u00fcggv\u00e9ny \u00e1ltal kezelt adatt\u00edpusok.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny_1_Munka1-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny_1_Munka1-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny_1_Munka1-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny_1_Munka1-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny_1_Munka1-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny_1_Munka1-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny_1_Munka1.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">1. \u00e1bra: Az <strong>\u00c1TLAG <\/strong>f\u00fcggv\u00e9ny \u00e1ltal kezelt adatt\u00edpusok.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8487e2e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8487e2e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-213097f\" data-id=\"213097f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-01bb2f7 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"01bb2f7\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;10. K\\u00e9rd\\u00e9sek \\u00e9s v\\u00e1laszok&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h2 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">10. K\u00e9rd\u00e9sek \u00e9s v\u00e1laszok<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h2>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f9620f7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f9620f7\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-bcf662f\" data-id=\"bcf662f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c85eae0 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"c85eae0\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;10.1. Mi a f\\u00fcggv\\u00e9ny angol nyelv\\u0171 Excelben haszn\\u00e1lhat\\u00f3 neve?&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">10.1. Mi a f\u00fcggv\u00e9ny angol nyelv\u0171 Excelben haszn\u00e1lhat\u00f3 neve?<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8fdd284 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8fdd284\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-c50e003\" data-id=\"c50e003\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-1498a38 elementor-widget elementor-widget-text-editor\" data-id=\"1498a38\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A f\u00fcggv\u00e9ny neve AVERAGE.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-3eb130f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3eb130f\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-e271a99\" data-id=\"e271a99\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-7244ca1 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"7244ca1\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;10.2. Hogyan haszn\\u00e1lom ezt a f\\u00fcggv\\u00e9nyt egy \\u00f6sszef\\u00fcgg\\u0151 t\\u00e1bl\\u00e1zat sorainak \\u00e9s oszlopainak kisz\\u00e1m\\u00edt\\u00e1s\\u00e1ra?&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">10.2. Hogyan haszn\u00e1lom ezt a f\u00fcggv\u00e9nyt egy \u00f6sszef\u00fcgg\u0151 t\u00e1bl\u00e1zat sorainak \u00e9s oszlopainak kisz\u00e1m\u00edt\u00e1s\u00e1ra?<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1faf7ad elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1faf7ad\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5d2dc27\" data-id=\"5d2dc27\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-728aeb2 elementor-widget elementor-widget-text-editor\" data-id=\"728aeb2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Gyakori feladat, amikor egy \u00f6sszef\u00fcgg\u0151, t\u00e9glalap alak\u00fa t\u00e1bl\u00e1zat adatsorait \u00e9s adatoszlopait kell \u00e1tlagolnunk. Az ilyen feladatokban \u00e1ltal\u00e1ban az a k\u00e9r\u00e9s, hogy sz\u00e1m\u00edtsunk \u00e1tlagokat az ilyen-olyan oszlopokban vagy sorokban, \u00e9s jelen\u00edts\u00fck meg azokat az oszlopok alatti sorban, illetve a sorok melletti oszlopban. A\u00a0megfogalmaz\u00e1s els\u0151 hall\u00e1sra bonyolult, pedig csup\u00e1n arr\u00f3l van sz\u00f3, hogy:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d8f8862 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d8f8862\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-deeb83a\" data-id=\"deeb83a\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-567868a elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"567868a\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Az oszlopokban l\u00e9v\u0151 \u00e9rt\u00e9kek \u00e1tlagait az oszlopok alatti sorban kell megjelen\u00edten\u00fcnk.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">A sorokban tal\u00e1lhat\u00f3 \u00e9rt\u00e9kek \u00e1tlagait a sorok melletti oszlopban kell megjelen\u00edten\u00fcnk.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-04ffd91 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"04ffd91\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d705413\" data-id=\"d705413\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f3af6c4 elementor-widget elementor-widget-text-editor\" data-id=\"f3af6c4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>N\u00e9zz\u00fcnk a k\u00e9t f\u00fcggv\u00e9ny haszn\u00e1lat\u00e1ra egy egyszer\u0171 kiz\u00e1r\u00f3lag sz\u00e1mokat tartalmaz\u00f3 p\u00e9ld\u00e1t a <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\">196-K-Excel-\u00c1TLAG f\u00fcggv\u00e9ny.xlsx<\/a> munkaf\u00fczet Munka2 munkalapj\u00e1n <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny_2_Munka2.jpg\" target=\"_blank\" rel=\"noopener\">(2. \u00e1bra)<\/a>! (Vizsg\u00e1ljuk meg a t\u00e1bl\u00e1zatot, miel\u0151tt tov\u00e1bb olvasunk!)<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-01ef574 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"01ef574\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-d9e039b\" data-id=\"d9e039b\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-ce5bfd8 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"ce5bfd8\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInRight&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny_2_Munka2.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny_2_Munka2-1024x576.jpg\" class=\"attachment-large size-large wp-image-3150\" alt=\"2. \u00e1bra: Az \u00c1TLAG f\u00fcggv\u00e9ny tipikus felhaszn\u00e1l\u00e1si k\u00f6rnyezetben.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny_2_Munka2-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny_2_Munka2-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny_2_Munka2-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny_2_Munka2-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny_2_Munka2-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny_2_Munka2-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny_2_Munka2.jpg 1920w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\">2. \u00e1bra: Az <strong>\u00c1TLAG <\/strong>f\u00fcggv\u00e9ny tipikus felhaszn\u00e1l\u00e1si k\u00f6rnyezetben.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-effac84 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"effac84\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3a90831\" data-id=\"3a90831\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-87d6404 elementor-widget elementor-widget-text-editor\" data-id=\"87d6404\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A B:D oszlopokban tal\u00e1lhat\u00f3 \u00e9rt\u00e9kek \u00e1tlag\u00e1t a 13. sorban kellett kisz\u00e1molnunk. Ehhez kijel\u00f6lt\u00fck az oszlopok alatti, 13. sorban l\u00e9v\u0151 cell\u00e1kat, vagyis a B13:D13 tartom\u00e1nyt. A tartom\u00e1ny els\u0151, akt\u00edv cell\u00e1j\u00e1ba, vagyis a B13 cell\u00e1ba beg\u00e9pelt\u00fck a felette l\u00e9v\u0151 oszlop adataival sz\u00e1mol\u00f3 k\u00e9pletet: <strong>=\u00c1TLAG(B3:B12)<\/strong>, majd le\u00fct\u00f6tt\u00fck a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t. Ezzel a billenty\u0171kombin\u00e1ci\u00f3val mindh\u00e1rom cell\u00e1ba a megfelel\u0151 k\u00e9pletet tudtuk bevinni.<\/p>\n<p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p>\n<p>L\u00e1ssuk, hogyan j\u00e1rtunk el a sorok eset\u00e9ben: a t\u00edz term\u00e9k sorai melletti E oszlopban kellett az egyes sorokban tal\u00e1lhat\u00f3 \u00e9rt\u00e9kek \u00e1tlag\u00e1t kisz\u00e1molnunk. Ezen t\u00edz cella tartom\u00e1nyhivatkoz\u00e1sa E3:E12. Kijel\u00f6lt\u00fck ezt a tartom\u00e1nyt, majd az E3 cell\u00e1ba beg\u00e9pelt\u00fck az <strong>=\u00c1TLAG(B3:D3)<\/strong> k\u00e9pletet, v\u00e9g\u00fcl le\u00fct\u00f6tt\u00fck a <em>Ctrl+Enter<\/em> billenty\u0171kombin\u00e1ci\u00f3t! \u00cdgy minden sorhoz siker\u00fclt megjelen\u00edten\u00fcnk az \u00e1tlagot.<\/p>\n<p><!-- \/wp:paragraph --><!-- wp:paragraph --><\/p>\n<p>A c\u00edmben feltett \u201eHogyan haszn\u00e1lom ezt a k\u00e9t f\u00fcggv\u00e9nyt egy \u00f6sszef\u00fcgg\u0151 t\u00e1bl\u00e1zat sorainak \u00e9s oszlopainak kisz\u00e1m\u00edt\u00e1s\u00e1ra?\u201d k\u00e9rd\u00e9sre a v\u00e1lasz teh\u00e1t az, hogy \u00edgy.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1abf678 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1abf678\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-b36a082\" data-id=\"b36a082\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-9d675b9 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"9d675b9\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;10.3. Van valami gyorsabb m\\u00f3dszer az ilyen jelleg\\u0171 feladatokban a f\\u00fcggv\\u00e9nyek, k\\u00e9pletek bevitel\\u00e9re?&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">10.3. Van valami gyorsabb m\u00f3dszer az ilyen jelleg\u0171 feladatokban a f\u00fcggv\u00e9nyek, k\u00e9pletek bevitel\u00e9re?<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-c90471e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c90471e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fbf6604\" data-id=\"fbf6604\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-94b5f33 elementor-widget elementor-widget-text-editor\" data-id=\"94b5f33\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Term\u00e9szetesen van. K\u00e9t m\u00f3dszert is mutatunk \u2013 haszn\u00e1ljuk ism\u00e9t a <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/04\/196-K-Excel-\u00c1TLAG-f\u00fcggv\u00e9ny.xlsx\" target=\"_blank\" rel=\"noreferrer noopener\">196-K-Excel-\u00c1TLAG f\u00fcggv\u00e9ny.xlsx<\/a> munkaf\u00fczetet:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-55cfbcd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"55cfbcd\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5a0db52\" data-id=\"5a0db52\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-822fad7 elementor-widget elementor-widget-text-editor\" data-id=\"822fad7\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol>\n<li>m\u00f3dszer: jel\u00f6lj\u00fck ki ism\u00e9t a B13:D13 tartom\u00e1nyt az oszlopok \u00e1tlagainak kisz\u00e1m\u00edt\u00e1s\u00e1hoz, majd a <em>Delete<\/em> billenty\u0171vel t\u00f6r\u00f6lj\u00fck a kor\u00e1bban bevitt k\u00e9pleteket, v\u00e9g\u00fcl adjuk ki a <strong>Kezd\u0151lap \/ Szum \/ \u00c1tlag <\/strong><em>(Alt+\u0150, D, L)<\/em> parancsot! Jel\u00f6lj\u00fck ki a E3:E12 tartom\u00e1nyt a sorok \u00e1tlagainak kisz\u00e1m\u00edt\u00e1s\u00e1hoz, majd a <em>Delete<\/em> billenty\u0171vel t\u00f6r\u00f6lj\u00fck a kor\u00e1bban bevitt k\u00e9pleteket, v\u00e9g\u00fcl adjuk ki a <strong>Kezd\u0151lap \/ Szum \/ \u00c1tlag <\/strong><em>(Alt+\u0150, D, L)<\/em> parancsot!<\/li>\n<li>m\u00f3dszer: jel\u00f6lj\u00fck ki az <em>F5<\/em> funkci\u00f3billenty\u0171vel megjelen\u00edthet\u0151 <strong>Ugr\u00e1s<\/strong> p\u00e1rbesz\u00e9dablakkal az el\u0151z\u0151 pontban eml\u00edtett k\u00e9t tartom\u00e1nyt, a <strong>Hivatkoz\u00e1s<\/strong> szerkeszt\u0151mez\u0151be beg\u00e9pelve a B13:D13;E3:E12 tartom\u00e1nyhivatkoz\u00e1sokat. Ezut\u00e1n a <em>Delete<\/em> billenty\u0171vel t\u00f6r\u00f6lj\u00fck a kor\u00e1bban bevitt k\u00e9pleteket, v\u00e9g\u00fcl adjuk ki a <strong>Kezd\u0151lap \/ Szum \/ \u00c1tlag <\/strong><em>(Alt+\u0150, D, L)<\/em> parancsot! Minden cell\u00e1ba a megfelel\u0151 k\u00e9plet ker\u00fcl a megfelel\u0151 oszlop, illetve sorhivatkoz\u00e1ssal.<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-655692c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"655692c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-5f8f3e8\" data-id=\"5f8f3e8\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b72e12b elementor-widget elementor-widget-text-editor\" data-id=\"b72e12b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00c1lljunk meg egy sz\u00f3ra!<\/strong><br \/>A fenti m\u00f3dszerek alkalmazhat\u00f3s\u00e1g\u00e1nak az az oka, hogy az Excelt felk\u00e9sz\u00edtett\u00e9k a szokv\u00e1nyos t\u00e1bl\u00e1zatelrendez\u00e9sekre \u00e9s a tipikus sz\u00e1m\u00edt\u00e1si feladatokra.<br \/>Ennek ellen\u00e9re a fenti m\u00f3dszerek korl\u00e1tozottan, csak abban az esetben haszn\u00e1lhat\u00f3k, ha a k\u00e9pletet k\u00f6zvetlen\u00fcl az adatsorok mell\u00e9, illetve az adatoszlopok al\u00e1 akarjuk bevinni. Teh\u00e1t, ha az F oszlopban, illetve a 14. sorban pr\u00f3b\u00e1ln\u00e1nk az \u00c1TLAG f\u00fcggv\u00e9nyt r\u00f6gz\u00edteni a fenti m\u00f3dszerek egyik\u00e9vel, nem lesz j\u00f3 a tartom\u00e1nyhivatkoz\u00e1s. Ennek oka, hogy az Excel beleveszi az E oszlopot \u00e9s a 13. sort is a tartom\u00e1nyba.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-16adc15 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"16adc15\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-3354fd9\" data-id=\"3354fd9\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-59126cf elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"59126cf\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;10.4. A hi\\u00e1nyz\\u00f3 adatok jel\\u00f6l\\u00e9se&quot;,&quot;headline_style&quot;:&quot;highlight&quot;,&quot;loop&quot;:&quot;yes&quot;,&quot;highlight_animation_duration&quot;:1200,&quot;highlight_iteration_delay&quot;:8000}\" data-widget_type=\"animated-headline.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<h3 class=\"elementor-headline\">\n\t\t\t\t<span class=\"elementor-headline-dynamic-wrapper elementor-headline-text-wrapper\">\n\t\t\t\t\t<span class=\"elementor-headline-dynamic-text elementor-headline-text-active\">10.4. A hi\u00e1nyz\u00f3 adatok jel\u00f6l\u00e9se<\/span>\n\t\t\t\t<\/span>\n\t\t\t\t<\/h3>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d6a1062 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d6a1062\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-ac162e4\" data-id=\"ac162e4\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c321435 elementor-widget elementor-widget-text-editor\" data-id=\"c321435\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>Aki nem ismeri a #HI\u00c1NYZIK hiba\u00e9rt\u00e9ket \u00e9s a HI\u00c1NYZIK f\u00fcggv\u00e9nyt, az a hi\u00e1nyz\u00f3 adatait \u00fcres cell\u00e1val, vagy valamilyen m\u00e1s, megegyez\u00e9sen alapul\u00f3 \u00e9rt\u00e9kkel helyettes\u00edti. Ezt nem szabad, mert t\u00f6bb f\u00fcggv\u00e9ny szolg\u00e1ltathat hib\u00e1s, nem v\u00e1rt, f\u00e9lrevezet\u0151 eredm\u00e9nyt, okozhat nehezen felder\u00edthet\u0151 hib\u00e1t, illetve az ilyen adatsorok diagramon \u00e1br\u00e1zol\u00e1sa is f\u00e9lre\u00e9rthet\u0151. Olvassuk el <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=1888\">A # hiba\u00e9rt\u00e9kek (#169)<\/a> cikk <a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=1888#3_HIANYZIK_-_hianyzo_adat_jelzese\">3. #HI\u00c1NYZIK \u2013 hi\u00e1nyz\u00f3 adat jelz\u00e9se<\/a> fejezet\u00e9t, hogy meg\u00e9rts\u00fck, hogyan kell helyesen jel\u00f6lni egy t\u00e1bl\u00e1zatban a hi\u00e1nyz\u00f3 adatot!<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f9cc5e6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f9cc5e6\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-242e278\" data-id=\"242e278\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3d18609 elementor-widget elementor-widget-global elementor-global-15494 elementor-widget-text-editor\" data-id=\"3d18609\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>V\u00c9GE.<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e383e2e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e383e2e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-156f757\" data-id=\"156f757\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-69270f0 elementor-widget elementor-widget-text-editor\" data-id=\"69270f0\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p style=\"text-align: left;\"><strong>Infopanel<br \/>K\u00e9sz\u00fclt: 2020 \u00e1prilis 19.<br \/>Oper\u00e1ci\u00f3s rendszer: Windows 10 (20H1, 2004b19041)<br \/>Irodai programcsomag: Microsoft Office 2016 v2003b12624.20466, Havi csatorna<br \/>Szint: kezd\u0151, ECDL: M04\/S6\/4.2.1<br \/>Kateg\u00f3ria: T\u00e1bl\u00e1zatkezel\u00e9s \u2192 K\u00e9pletek \u00e9s f\u00fcggv\u00e9nyek \u2192 F\u00fcggv\u00e9nyek haszn\u00e1lata<\/strong><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-89ee0e0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"89ee0e0\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-02c1be7\" data-id=\"02c1be7\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-314e09b elementor-widget elementor-widget-shortcode\" data-id=\"314e09b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-shortcode\"><!-- FeedbackWP Plugin --><div        class=\"rmp-widgets-container rmp-wp-plugin rmp-main-container js-rmp-widgets-container js-rmp-widgets-container--3137 \"        data-post-id=\"3137\">        <!-- Rating widget -->    <div class=\"rmp-rating-widget js-rmp-rating-widget\" role=\"group\" aria-labelledby=\"rmp-title-3137\">                    <p class=\"rmp-heading rmp-heading--title\" id=\"rmp-title-3137\">                Mennyire tal\u00e1ltad hasznosnak ezt a cikket?            <\/p>                            <p class=\"rmp-heading rmp-heading--subtitle\">                V\u00e1lassz egy csillagot!            <\/p>                <div class=\"rmp-rating-widget__icons\">            <ul class=\"rmp-rating-widget__icons-list js-rmp-rating-icons-list\" role=\"radiogroup\" aria-label=\"Rating from 1 to 5\">                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"Nem \u00e9rintett meg\"                            data-value=\"1\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"1 out of 5: Nem \u00e9rintett meg\"                            tabindex=\"0\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"N\u00e9h\u00e1ny dolgon felcsillant a szemem\"                            data-value=\"2\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"2 out of 5: N\u00e9h\u00e1ny dolgon felcsillant a szemem\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"\u00c9rdekes volt\"                            data-value=\"3\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"3 out of 5: \u00c9rdekes volt\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"T\u00f6bbnyire csillog\u00f3 szemmel olvastam\"                            data-value=\"4\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"4 out of 5: T\u00f6bbnyire csillog\u00f3 szemmel olvastam\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"Hasznos volt minden szava\"                            data-value=\"5\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"5 out of 5: Hasznos volt minden szava\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                            <\/ul>        <\/div>        <p class=\"rmp-rating-widget__hover-text js-rmp-hover-text\" aria-live=\"polite\"><\/p>                <button class=\"rmp-rating-widget__submit-btn rmp-btn js-submit-rating-btn\">            K\u00fcldd el az \u00e9rt\u00e9kel\u00e9st!        <\/button>        <div aria-live=\"polite\" aria-atomic=\"true\">            <p class=\"rmp-rating-widget__results js-rmp-results rmp-rating-widget__results--hidden\">                Szavazatsz\u00e1m: <span class=\"rmp-rating-widget__results__votes js-rmp-vote-count\">0<\/span>, \u00c1tlag: <span class=\"rmp-rating-widget__results__rating js-rmp-avg-rating\">0<\/span>            <\/p>            <p class=\"rmp-rating-widget__not-rated js-rmp-not-rated \">                M\u00e9g nem szavazott senki! Legy\u00e9l az els\u0151, aki \u00e9rt\u00e9keli ezt a bejegyz\u00e9st!            <\/p>            <p class=\"rmp-rating-widget__msg js-rmp-msg\" role=\"status\"><\/p>        <\/div>    <\/div>    <!--Structured data -->                    <!-- Feedback widget -->        <div class=\"rmp-feedback-widget js-rmp-feedback-widget\">  <p class=\"rmp-heading rmp-heading--title\">    Sajn\u00e1lom, hogy ez a cikk nem volt hasznos sz\u00e1modra!  <\/p>  <p class=\"rmp-heading rmp-heading--subtitle\">    Seg\u00edts nekem, hogy jobb legyen ez a cikk!  <\/p>    <div class=\"rmp-feedback-widget__container\">    <p class=\"rmp-feedback-widget__text\">      \u00cdrd le, mit hi\u00e1nyolsz ebb\u0151l a cikkb\u0151l!    <\/p>    <textarea class=\"rmp-feedback-widget__input js-rmp-feedback-input\" rows=\"5\" id=\"feedback-text\"><\/textarea>        <button type=\"button\" class=\"rmp-feedback-widget__btn rmp-btn rmp-btn--large js-rmp-feedback-button\">      Ez a v\u00e9lem\u00e9nyem!    <\/button>    <div class=\"rmp-feedback-widget__loader js-rmp-feedback-loader\">      <div><\/div><div><\/div><div><\/div>    <\/div>    <p class=\"rmp-feedback-widget__msg js-rmp-feedback-msg\"><\/p>  <\/div>  <\/div>        <\/div><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-89ab82b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"89ab82b\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-aaedb88\" data-id=\"aaedb88\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-8022bec elementor-share-buttons--skin-flat elementor-share-buttons--view-icon-text elementor-share-buttons--shape-square elementor-grid-0 elementor-share-buttons--color-official elementor-widget elementor-widget-global elementor-global-15485 elementor-widget-share-buttons\" data-id=\"8022bec\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-grid\" role=\"list\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_email\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: email\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fas fa-envelope\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tEmail\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_twitter\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: twitter\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-twitter\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tTwitter\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_facebook\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: facebook\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-facebook\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_print\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: print\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fas fa-print\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tNyomtat\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>\u00a0 Friss\u00edtve: 2020 m\u00e1jus 28. Mir\u0151l sz\u00f3l ez a cikk?Az \u00e1tlagsz\u00e1m\u00edt\u00e1s az egyik olyan \u201ekomolyabb\u201d sz\u00e1mol\u00e1si m\u0171velet, amit m\u00e1r kisiskol\u00e1s korunkban megtan\u00edtanak nek\u00fcnk \u2013 igaz, sz\u00e1mtani k\u00f6z\u00e9p sz\u00e1m\u00edt\u00e1sa n\u00e9ven. Egyben az egyik leggyakrabban haszn\u00e1lt statisztikai sz\u00e1m\u00edt\u00e1s, m\u00e9g az \u00e1ltal\u00e1nos m\u0171velts\u00e9gnek is akt\u00edv r\u00e9sze, valamint a napi h\u00edrekben is gyakori vend\u00e9g. \u2026 <a class=\"continue-reading-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=3137\">Tov\u00e1bb olvasom&#8230; <span class=\"meta-nav\">&rarr; <\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"parent":962,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_mc_calendar":[],"footnotes":""},"class_list":["post-3137","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/3137","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3137"}],"version-history":[{"count":0,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/3137\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/962"}],"wp:attachment":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}