{"id":1713,"date":"2020-01-09T19:38:32","date_gmt":"2020-01-09T18:38:32","guid":{"rendered":"https:\/\/www.fiatluxefel.info\/?page_id=1713"},"modified":"2021-11-01T10:52:33","modified_gmt":"2021-11-01T09:52:33","slug":"a-vel-fuggveny","status":"publish","type":"page","link":"https:\/\/www.fiatluxefel.info\/?page_id=1713","title":{"rendered":"A V\u00c9L f\u00fcggv\u00e9ny (#166)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"1713\" class=\"elementor elementor-1713\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-786e915 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"786e915\" 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-dd7fcc1\" data-id=\"dd7fcc1\" 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-0ac17dd elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"0ac17dd\" 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: 2021 november 1.<\/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-99a1559 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"99a1559\" 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-5aab79d\" data-id=\"5aab79d\" 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-bbb45f6 elementor-widget elementor-widget-text-editor\" data-id=\"bbb45f6\" 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 \/>Ebben a cikkben egy olyan matematikai \u00e9s trigonometriai f\u00fcggv\u00e9nyt mutatunk be, amelyet gyakran haszn\u00e1lhatunk v\u00e9letlenszer\u0171 val\u00f3s sz\u00e1mok automatikus gener\u00e1l\u00e1s\u00e1ra.<\/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-6dc8ace elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6dc8ace\" 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-e02714d\" data-id=\"e02714d\" 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-b900984 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"b900984\" 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__b900984\" 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__b900984\" 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__b900984\" 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-8625a4c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8625a4c\" 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-ee15b3e\" data-id=\"ee15b3e\" 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-125ca1c elementor-widget elementor-widget-text-editor\" data-id=\"125ca1c\" 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>HA, HAMIS, IGAZ, INT.<\/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-5dcd758 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5dcd758\" 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-523c5d7\" data-id=\"523c5d7\" 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-a2e756a elementor-widget elementor-widget-text-editor\" data-id=\"a2e756a\" 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 Excel haszn\u00e1lat\u00e1t tanulva sokszor \u00fctk\u00f6z\u00fcnk abba a probl\u00e9m\u00e1ba, hogy a gyakorl\u00e1shoz sz\u00fcks\u00e9g\u00fcnk volna sok-sok adatra, p\u00e9ld\u00e1ul sz\u00e1mokra. Mintap\u00e9ld\u00e1kat ugyan beszerezhet\u00fcnk m\u00e1s forr\u00e1sb\u00f3l, ak\u00e1r a munk\u00e1nkhoz kapcsol\u00f3d\u00f3, ak\u00e1r az internetr\u0151l sz\u00e1rmaz\u00f3 adatokat felhaszn\u00e1lva, ezek alkalmaz\u00e1sa azonban sokszor id\u0151rabl\u00f3 \u00e9s f\u00e1radts\u00e1gos.<\/p>\n<p>Ehelyett ismerkedj\u00fcnk meg a V\u00c9L f\u00fcggv\u00e9nnyel, amellyel igen k\u00f6nnyen lesz\u00fcnk k\u00e9pesek tetsz\u0151leges mennyis\u00e9g\u0171 v\u00e9letlen sz\u00e1mmal felt\u00f6lteni gyakorl\u00f3 t\u00e1bl\u00e1zatainkat.<\/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-39b8966 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"39b8966\" 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-48e7272\" data-id=\"48e7272\" 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-5bc7e53 elementor-widget elementor-widget-text-editor\" data-id=\"5bc7e53\" 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 Excel egy speci\u00e1lis matematikai elj\u00e1r\u00e1s felhaszn\u00e1l\u00e1s\u00e1val gener\u00e1l v\u00e9letlenszer\u0171 val\u00f3s sz\u00e1mokat. Ennek az elj\u00e1r\u00e1snak <strong>Mersenne Twister-algoritmus<\/strong> a neve, \u00e9s az angol <strong><a href=\"https:\/\/en.wikipedia.org\/wiki\/Mersenne_Twister\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Wikip\u00e9di\u00e1n<\/a><\/strong> olvashatunk r\u00f3la.<\/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-4f2d089 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4f2d089\" 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-1477b7f\" data-id=\"1477b7f\" 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-0b42d63 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"0b42d63\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;1. A V\\u00c9L f\\u00fcggv\\u00e9ny ismertet\\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<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 V\u00c9L f\u00fcggv\u00e9ny ismertet\u00e9se<\/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-ba02099 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ba02099\" 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-59a33ed\" data-id=\"59a33ed\" 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-08bafa8 elementor-widget elementor-widget-text-editor\" data-id=\"08bafa8\" 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 V\u00c9L matematikai \u00e9s trigonometriai f\u00fcggv\u00e9ny 0 \u00e9s 1 k\u00f6z\u00f6tti egyenletes eloszl\u00e1s\u00fa \u00e9s v\u00e9letlenszer\u0171 val\u00f3s \u00e1lv\u00e9letlen sz\u00e1mot ad eredm\u00e9ny\u00fcl, amelynek \u00e9rt\u00e9ke 0 lehet, de 1 nem. Az \u00e1br\u00e1zol\u00e1s pontoss\u00e1ga \u00f6sszesen 10 sz\u00e1mjegy, bele\u00e9rtve a tizedesvessz\u0151 el\u0151tti \u00e9s ut\u00e1ni sz\u00e1mjegyeket is. Az \u00e1lv\u00e9letlen sz\u00e1m k\u00e9pz\u00e9s\u00e9re az \u00fan. <a href=\"https:\/\/en.wikipedia.org\/wiki\/Mersenne_Twister\" rel=\"nofollow noopener\" target=\"_blank\">Mersenne Twister-algoritmust<\/a> haszn\u00e1lja.<\/strong><\/p>\n<p><strong>\u00a0<\/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-829da6e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"829da6e\" 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-3a59c54\" data-id=\"3a59c54\" 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-97f9311 elementor-widget elementor-widget-text-editor\" data-id=\"97f9311\" 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\u00c9L()<\/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-883d92e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"883d92e\" 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-63dc570\" data-id=\"63dc570\" 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-7bb9d67 elementor-widget elementor-widget-text-editor\" data-id=\"7bb9d67\" 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>teh\u00e1t nem tartalmaz argumentumo(ka)t. A f\u00fcggv\u00e9ny jellemz\u0151je, hogy a munkaf\u00fczet minden \u00fajrasz\u00e1mol\u00e1sakor \u2013 ak\u00e1r automatikusan t\u00f6rt\u00e9nik, ak\u00e1r az <em>F9 <\/em>funkci\u00f3billenty\u0171vel magunk kezdem\u00e9nyezz\u00fck azt \u2013 \u00faj v\u00e9letlenszer\u0171 val\u00f3s sz\u00e1mot 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-243037f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"243037f\" 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-e441ebf\" data-id=\"e441ebf\" 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-dafd961 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"dafd961\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;2. A V\\u00c9L f\\u00fcggv\\u00e9ny alkalmaz\\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. A V\u00c9L f\u00fcggv\u00e9ny alkalmaz\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-2d63a85 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2d63a85\" 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-8002846\" data-id=\"8002846\" 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-616f8a5 elementor-widget elementor-widget-text-editor\" data-id=\"616f8a5\" 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\u00fck meg, hogy hogyan haszn\u00e1lhat\u00f3 ez a f\u00fcggv\u00e9ny! Ehhez g\u00e9pelj\u00fck be az <strong>A1 <\/strong>cell\u00e1ba az<\/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-7db53f6 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7db53f6\" 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-f5f604e\" data-id=\"f5f604e\" 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-4348840 elementor-widget elementor-widget-text-editor\" data-id=\"4348840\" 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\u00c9L()<\/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-ec57d41 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ec57d41\" 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-9050eb2\" data-id=\"9050eb2\" 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-993dea1 elementor-widget elementor-widget-text-editor\" data-id=\"993dea1\" 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>k\u00e9pletet, majd \u00fcss\u00fck le az <em>Enter <\/em>billenty\u0171t! L\u00e1tni fogunk egy nulla eg\u00e9sz ak\u00e1rmennyi \u00e9rt\u00e9ket <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_1_VEL.jpg\" target=\"_blank\" rel=\"noopener\">(1. \u00e1bra)<\/a>, vagyis egy egyn\u00e9l kisebb nem szakaszos, v\u00e9ges hossz\u00fas\u00e1g\u00fa t\u00f6rtsz\u00e1mot.<\/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-daaa815 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"daaa815\" 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-72f20be\" data-id=\"72f20be\" 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-deb6a95 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"deb6a95\" 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\/2021\/11\/166-K-Excel-VEL_1_VEL.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\/2021\/11\/166-K-Excel-VEL_1_VEL-1024x576.jpg\" class=\"attachment-large size-large wp-image-21017\" alt=\"1. \u00e1bra: A V\u00c9L f\u00fcggv\u00e9ny \u00e1ltal szolg\u00e1ltatott v\u00e9letlen sz\u00e1m.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_1_VEL-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_1_VEL-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_1_VEL-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_1_VEL-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_1_VEL-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_1_VEL-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_1_VEL.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: A <strong>V\u00c9L <\/strong>f\u00fcggv\u00e9ny \u00e1ltal szolg\u00e1ltatott v\u00e9letlen sz\u00e1m.<\/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-0abd976 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0abd976\" 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-b7a351a\" data-id=\"b7a351a\" 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-fc9ec3e elementor-widget elementor-widget-text-editor\" data-id=\"fc9ec3e\" 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 le\u00fctj\u00fck az <em>F9 <\/em>funkci\u00f3billenty\u0171t, akkor tapasztalni fogjuk, hogy m\u00e1s \u00e9rt\u00e9ket fogunk kapni. Ezt tapasztaljuk akkor is, ha tov\u00e1bb dolgozunk a munkalapon, szerkesztett\u00fck az <strong>A1 <\/strong>cella \u00e9rt\u00e9k\u00e9t stb.<\/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-3213101 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3213101\" 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-40d1555\" data-id=\"40d1555\" 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-9aed437 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"9aed437\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;3. V\\u00e9letlen sz\\u00e1mok gener\\u00e1l\\u00e1sa egy adott tartom\\u00e1nyban&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. V\u00e9letlen sz\u00e1mok gener\u00e1l\u00e1sa egy adott tartom\u00e1nyban<\/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-5083ec8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5083ec8\" 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-789bbbd\" data-id=\"789bbbd\" 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-2a3c36e elementor-widget elementor-widget-text-editor\" data-id=\"2a3c36e\" 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>Rendben, ez \u00edgy tetszet\u0151s, de ilyen kis \u00e9rt\u00e9kkekkel nem szoktunk, nem tudunk j\u00f3l gyakorolni. Hogyan tudn\u00e1nk m\u00e1sf\u00e9le \u00e9rt\u00e9keket kapni, hogyan alak\u00edtsuk \u00e1t ezt a k\u00e9pletet, ha p\u00e9ld\u00e1ul 100 \u00e9s 200 k\u00f6z\u00f6tti eg\u00e9sz sz\u00e1mokkal akarunk gyakorolni?<\/p>\n\n<p>Nos, a megold\u00e1s egyszer\u0171, \u00e1ltal\u00e1noss\u00e1gban a k\u00f6vetkez\u0151 k\u00e9plet szerint j\u00e1rhatunk 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-7a85372 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7a85372\" 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-c8f6ca6\" data-id=\"c8f6ca6\" 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-1d51a26 elementor-widget elementor-widget-text-editor\" data-id=\"1d51a26\" 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\u00c9L()*(<em>fels\u0151<\/em>&#8211;<em>als\u00f3<\/em>)+<em>als\u00f3<\/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-56df37b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"56df37b\" 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-ef9c633\" data-id=\"ef9c633\" 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-b0fa8d4 elementor-widget elementor-widget-text-editor\" data-id=\"b0fa8d4\" 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 egy t\u00f3l-ig tartom\u00e1nyb\u00f3l szeretn\u00e9nk v\u00e9letlen eg\u00e9sz sz\u00e1mokat kapni, akkor a fenti k\u00e9plet szerint az <em>als\u00f3 <\/em>hely\u00e9re a kezd\u0151\u00e9rt\u00e9ket, a <em>fels\u0151 <\/em>hely\u00e9re a v\u00e9g\u00e9rt\u00e9ket helyettes\u00edts\u00fck be. Teh\u00e1t, ha a fenti ig\u00e9ny\u00fcnknek akarunk megfelelni, akkor a k\u00e9plet\u00fcnk a k\u00f6vetkez\u0151k\u00e9ppen m\u00f3dosul:<\/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-408717f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"408717f\" 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-ebcf4af\" data-id=\"ebcf4af\" 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-32aab0b elementor-widget elementor-widget-text-editor\" data-id=\"32aab0b\" 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\u00c9L()*(200-100)+100<\/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-5731509 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5731509\" 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-fe73291\" data-id=\"fe73291\" 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-9ad7251 elementor-widget elementor-widget-text-editor\" data-id=\"9ad7251\" 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>Pr\u00f3b\u00e1ljuk ki: k\u00e9sz\u00edts\u00fcnk a fenti k\u00e9plettel t\u00edz v\u00e9letlen sz\u00e1mot! P\u00e9ld\u00e1ul, jel\u00f6lj\u00fck ki a <strong>B1:B10 <\/strong>tartom\u00e1nyt, g\u00e9pelj\u00fck be a <strong>B1 <\/strong>cell\u00e1ba a fenti k\u00e9pletet, majd \u00fcss\u00fck le a <em>Ctrl+Enter <\/em>billenty\u0171kombin\u00e1ci\u00f3t <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_2_VEL.jpg\" target=\"_blank\" rel=\"noopener\">(2. \u00e1bra)<\/a>! Kapni fogunk t\u00edz darab v\u00e9letlen sz\u00e1mot, amelyek nagy val\u00f3sz\u00edn\u0171s\u00e9ggel k\u00fcl\u00f6nb\u00f6znek egym\u00e1st\u00f3l, vagyis nincs k\u00f6z\u00f6tt\u00fck k\u00e9t egyforma sz\u00e1m.<\/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-1a0f88a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1a0f88a\" 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-2846a3b\" data-id=\"2846a3b\" 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-22f5a3e elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"22f5a3e\" 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\/2021\/11\/166-K-Excel-VEL_2_VEL.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\/2021\/11\/166-K-Excel-VEL_2_VEL-1024x576.jpg\" class=\"attachment-large size-large wp-image-21018\" alt=\"2. \u00e1bra: V\u00e9letlen sz\u00e1mok 100 \u00e9s 200 k\u00f6z\u00f6tt a B1:B10 tartom\u00e1nyban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_2_VEL-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_2_VEL-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_2_VEL-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_2_VEL-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_2_VEL-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_2_VEL-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_2_VEL.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: V\u00e9letlen sz\u00e1mok 100 \u00e9s 200 k\u00f6z\u00f6tt a B1:B10 tartom\u00e1nyban.<\/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-1b2660d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1b2660d\" 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-6b7ca85\" data-id=\"6b7ca85\" 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-18629af elementor-widget elementor-widget-text-editor\" data-id=\"18629af\" 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 a sz\u00e1mok t\u00f6rt r\u00e9sz\u00e9re nincs sz\u00fcks\u00e9g\u00fcnk, akkor a k\u00e9pletet eg\u00e9sz\u00edts\u00fck ki az <strong>INT <\/strong>f\u00fcggv\u00e9nnyel:<\/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-310f80f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"310f80f\" 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-fc4b18d\" data-id=\"fc4b18d\" 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-42b1ceb elementor-widget elementor-widget-text-editor\" data-id=\"42b1ceb\" 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>=INT(V\u00c9L()*(200-100)+100)<\/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-b9b35e8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b9b35e8\" 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-956bf0f\" data-id=\"956bf0f\" 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-f35b275 elementor-widget elementor-widget-text-editor\" data-id=\"f35b275\" 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>Nos, \u00edgy m\u00e1r tetsz\u0151leges sz\u00e1mban \u00e9s tartom\u00e1nyban vagyunk k\u00e9pesek v\u00e9letlen eg\u00e9sz sz\u00e1mokat gener\u00e1lni.<\/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-5e7bd3c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5e7bd3c\" 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-02b0d6e\" data-id=\"02b0d6e\" 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-47f9a60 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"47f9a60\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;4. A V\\u00c9L \\u00e1ltal gener\\u00e1lt sz\\u00e1mok lecser\\u00e9l\\u00e9se konstans eredm\\u00e9nyekre&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. A V\u00c9L \u00e1ltal gener\u00e1lt sz\u00e1mok lecser\u00e9l\u00e9se konstans eredm\u00e9nyekre<\/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-c0136cd elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c0136cd\" 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-71dc3ae\" data-id=\"71dc3ae\" 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-b649b55 elementor-widget elementor-widget-text-editor\" data-id=\"b649b55\" 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>Rendben, de mit tegy\u00fcnk, ha a tov\u00e1bbiakban el akarjuk ker\u00fclni, hogy minden \u00fajrasz\u00e1mol\u00e1sn\u00e1l m\u00e1s-m\u00e1s \u00e9rt\u00e9keket kapjunk?<\/p>\n\n<p>Ebben az esetben a V\u00c9L f\u00fcggv\u00e9nyt haszn\u00e1l\u00f3 k\u00e9pletet cser\u00e9lj\u00fck le az eredm\u00e9nyre. A fenti p\u00e9ld\u00e1t felhaszn\u00e1lva, jel\u00f6lj\u00fck ki a <strong>B1:B10 <\/strong>tartom\u00e1nyt, m\u00e1soljuk v\u00e1g\u00f3lapra, majd adjuk ki a <strong>Kezd\u0151lap\/Beilleszt\u00e9s\/\u00c9rt\u00e9kek <\/strong>parancsot, vagy alkalmazzuk az <em>Alt+\u0150, V, \u00c9, Enter <\/em>billenty\u0171parancsot! A <strong>Szerkeszt\u0151l\u00e9cen <\/strong>a k\u00e9plet helyett minden cell\u00e1ban az eredm\u00e9nyt fogjuk l\u00e1tni.<\/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-e2c62de elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e2c62de\" 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-be5ef2b\" data-id=\"be5ef2b\" 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-ff15906 elementor-widget elementor-widget-text-editor\" data-id=\"ff15906\" 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> Gyakran sz\u00fcks\u00e9g\u00fcnk van a kapott \u00e9rt\u00e9kek sorba rendez\u00e9s\u00e9re. Ha nem cser\u00e9lj\u00fck le a k\u00e9pleteket az eredm\u00e9nyekre az itt le\u00edrt m\u00f3don, akkor csal\u00f3dni fogunk, mert a sorba rendez\u00e9st k\u00f6vet\u0151en ism\u00e9telten \u00faj \u00e9rt\u00e9keket sz\u00e1molnak ki a k\u00e9pletek, \u00edgy nem csak m\u00e1s \u00e9rt\u00e9keket fogunk kapni, hanem a sorrend se nem emelked\u0151, se nem cs\u00f6kken\u0151 nem lesz.<\/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-5b7969e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5b7969e\" 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-a808513\" data-id=\"a808513\" 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-8eb884f elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"8eb884f\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;5. Egy darab v\\u00e9letlen sz\\u00e1m gener\\u00e1l\\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\">5. Egy darab v\u00e9letlen sz\u00e1m gener\u00e1l\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-c91687b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c91687b\" 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-b9e21da\" data-id=\"b9e21da\" 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-65ee2ac elementor-widget elementor-widget-text-editor\" data-id=\"65ee2ac\" 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 mind\u00f6ssze egy cell\u00e1ba akarunk v\u00e9letlen sz\u00e1mot \u00edrni, akkor tegy\u00fck a k\u00f6vetkez\u0151t: g\u00e9pelj\u00fck be a k\u00edv\u00e1nt k\u00e9pletet a cell\u00e1ba vagy a <strong>Szerkeszt\u0151l\u00e9cbe<\/strong>, majd \u00fcss\u00fck le az <em>F9 <\/em>funkci\u00f3billenty\u0171t! Az Excel a k\u00e9pletet lecser\u00e9li az eredm\u00e9nyre, amit kijel\u00f6lt \u00e1llapotban kapunk meg, m\u00f6g\u00f6tte pedig villog a kurzor, lehet\u0151v\u00e9 t\u00e9ve a cella tartalm\u00e1nak tov\u00e1bbi szerkeszt\u00e9s\u00e9t. Ha elfogadjuk az \u00e9rt\u00e9ket, akkor \u00fcss\u00fck le az <em>Enter <\/em>billenty\u0171t!<\/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-34715d8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"34715d8\" 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-6dd8878\" data-id=\"6dd8878\" 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-4b9ba75 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"4b9ba75\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;6. De nekem kell a fels\\u0151 hat\\u00e1r\\u00e9rt\\u00e9k is!&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. De nekem kell a fels\u0151 hat\u00e1r\u00e9rt\u00e9k is!<\/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-a4dd257 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a4dd257\" 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-8652dbc\" data-id=\"8652dbc\" 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-762a0eb elementor-widget elementor-widget-text-editor\" data-id=\"762a0eb\" 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 defin\u00edci\u00f3 szerint a V\u00c9L f\u00fcggv\u00e9ny \u00e1ltal gener\u00e1lt v\u00e9letlen val\u00f3s sz\u00e1m soha nem lehet 1, vagyis egy t\u00f3l-ig sz\u00e1mtartom\u00e1ny megad\u00e1s\u00e1val a fels\u0151 \u00e9rt\u00e9ket soha nem kapjuk meg. Teh\u00e1t, a kor\u00e1bbi p\u00e9ld\u00e1kban megadott 100-200 k\u00f6z\u00f6tti sz\u00e1mok val\u00f3j\u00e1ban 100 \u00e9s 199 k\u00f6z\u00f6ttiek lesznek. Hogyan kaphatjuk meg m\u00e9gis a fels\u0151 hat\u00e1r\u00e9rt\u00e9ket? \u00dagy, hogy a fels\u0151 hat\u00e1r\u00e9rt\u00e9khez hozz\u00e1adunk egyet:<\/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-bf54979 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bf54979\" 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-68742ca\" data-id=\"68742ca\" 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-25e6bf0 elementor-widget elementor-widget-text-editor\" data-id=\"25e6bf0\" 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\u00c9L()*(fels\u0151+1-als\u00f3)+als\u00f3<\/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-22e03f7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"22e03f7\" 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-44705c8\" data-id=\"44705c8\" 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-d18fbd6 elementor-widget elementor-widget-text-editor\" data-id=\"d18fbd6\" 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>vagyis<\/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-c1d9ed4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c1d9ed4\" 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-beeb63d\" data-id=\"beeb63d\" 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-f56fc02 elementor-widget elementor-widget-text-editor\" data-id=\"f56fc02\" 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>=INT(V\u00c9L()*(201-100)+100)<\/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-8cf75a5 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8cf75a5\" 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-be33bf0\" data-id=\"be33bf0\" 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-ccc0ea1 elementor-widget elementor-widget-text-editor\" data-id=\"ccc0ea1\" 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>k\u00e9pletet kell beg\u00e9peln\u00fcnk a cell\u00e1kba <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_3_VEL.jpg\" target=\"_blank\" rel=\"noopener\">(3. \u00e1bra)<\/a>.<\/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-b424e29 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b424e29\" 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-77c3640\" data-id=\"77c3640\" 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-e93142c elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"e93142c\" 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\/2021\/11\/166-K-Excel-VEL_3_VEL.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\/2021\/11\/166-K-Excel-VEL_3_VEL-1024x576.jpg\" class=\"attachment-large size-large wp-image-21019\" alt=\"3. \u00e1bra: Az \u00faj k\u00e9plettel m\u00e1r nem csak az als\u00f3, vagyis a 100, hanem a fels\u0151 hat\u00e1r\u00e9rt\u00e9ket is megkaphatjuk. A C8 cell\u00e1ban l\u00e1that\u00f3 a 200-as \u00e9rt\u00e9k.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_3_VEL-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_3_VEL-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_3_VEL-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_3_VEL-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_3_VEL-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_3_VEL-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_3_VEL.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\">3. \u00e1bra: Az \u00faj k\u00e9plettel m\u00e1r nem csak az als\u00f3, vagyis a 100, hanem a fels\u0151 hat\u00e1r\u00e9rt\u00e9ket is megkaphatjuk. A C8 cell\u00e1ban l\u00e1that\u00f3 a 200-as \u00e9rt\u00e9k.<\/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-bbd0533 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bbd0533\" 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-ad56d8d\" data-id=\"ad56d8d\" 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-db4b052 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"db4b052\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;7. A cellatartom\\u00e1ny m\\u00e9rete \\u00e9s a sz\\u00e1mtartom\\u00e1ny k\\u00f6z\\u00f6tti \\u00f6sszef\\u00fcgg\\u00e9s&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. A cellatartom\u00e1ny m\u00e9rete \u00e9s a sz\u00e1mtartom\u00e1ny k\u00f6z\u00f6tti \u00f6sszef\u00fcgg\u00e9s<\/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-d202c94 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d202c94\" 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-4a10cbd\" data-id=\"4a10cbd\" 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-0285a5e elementor-widget elementor-widget-text-editor\" data-id=\"0285a5e\" 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 feladatt\u00f3l f\u00fcgg\u0151en \u00e9rdemes \u00e1tgondolni a tartom\u00e1ny m\u00e9rete, vagyis a gener\u00e1lni k\u00edv\u00e1nt \u00e9rt\u00e9kek sz\u00e1ma, valamint a sz\u00e1mtartom\u00e1ny k\u00f6z\u00f6tti \u00f6sszef\u00fcgg\u00e9st.<\/p>\n<p>Mire gondolunk? T\u00e9telezz\u00fck fel, hogy olyan v\u00e9letlen sz\u00e1mokra van sz\u00fcks\u00e9g\u00fcnk, amelyek gyakoris\u00e1ga egyt\u0151l elt\u00e9r\u0151, vagyis egyn\u00e9l t\u00f6bbsz\u00f6r fordulnak el\u0151. Ez akkor fordulhat el\u0151, ha a cellatartom\u00e1ny cell\u00e1inak sz\u00e1ma kell\u0151en nagy, \u00e9s a gener\u00e1land\u00f3 sz\u00e1mtartom\u00e1ny kell\u0151en kicsi.<\/p>\n<p>P\u00e9ld\u00e1ul szeretn\u00e9nk 1 \u00e9s 10 k\u00f6z\u00f6tti eg\u00e9sz sz\u00e1mokat kapni, mondjuk az <strong>E1:F10 <\/strong>tartom\u00e1nyban. Mivel a tartom\u00e1ny m\u00e9rete k\u00e9tszer nagyobb (20db cella) mint a gener\u00e1lni k\u00edv\u00e1nt \u00e9rt\u00e9kek sz\u00e1ma (10db sz\u00e1m), v\u00e1rhat\u00f3an lesznek olyan \u00e9rt\u00e9kek 1 \u00e9s 10 k\u00f6z\u00f6tt, amelyek ism\u00e9tl\u0151dni fognak. A <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_4_VEL.jpg\" target=\"_blank\" rel=\"noopener\">4. \u00e1br\u00e1n<\/a> l\u00e1thatjuk, hogy egyes sz\u00e1mjegyek egyn\u00e9l t\u00f6bbsz\u00f6r fordulnak el\u0151. Az alkalmazott k\u00e9plet 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-1fbf32c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1fbf32c\" 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-2769265\" data-id=\"2769265\" 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-16fc238 elementor-widget elementor-widget-text-editor\" data-id=\"16fc238\" 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>=INT(V\u00c9L()*(11-1)+1)<\/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-c5036cc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c5036cc\" 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-fc11a71\" data-id=\"fc11a71\" 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-2fab25c elementor-widget elementor-widget-text-editor\" data-id=\"2fab25c\" 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 viszont a t\u00f6meges ism\u00e9tl\u0151d\u00e9seket el akarjuk ker\u00fclni, akkor a sz\u00e1mtartom\u00e1nynak nagyobbnak kell lennie a cellatartom\u00e1nyn\u00e1l. P\u00e9ld\u00e1ul, ha a H1:I10 tartom\u00e1nyban az els\u0151 ezer sz\u00e1m k\u00f6z\u00fcl akarunk v\u00e1logatni, akkor val\u00f3sz\u00edn\u0171leg nem fogunk k\u00e9t egyforma \u00e9rt\u00e9ket kapni <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_5_VEL.jpg\" target=\"_blank\" rel=\"noopener\">(5. \u00e1bra)<\/a>. Pr\u00f3b\u00e1ljuk ki! Az alkalmazott k\u00e9plet 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-6799f2d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6799f2d\" 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-10f1b41\" data-id=\"10f1b41\" 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-373001f elementor-widget elementor-widget-text-editor\" data-id=\"373001f\" 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>=INT(V\u00c9L()*(1001-1)+1)<\/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-12f4d84 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"12f4d84\" 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-d7817ea\" data-id=\"d7817ea\" 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-27e94b3 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"27e94b3\" 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\/2021\/11\/166-K-Excel-VEL_4_VEL.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_4_VEL-1024x576.jpg\" class=\"attachment-large size-large wp-image-21020\" alt=\"4. \u00e1bra: 1 \u00e9s 10 k\u00f6z\u00f6tti v\u00e9letlen eg\u00e9sz sz\u00e1mok, egyes \u00e9rt\u00e9kek t\u00f6bbsz\u00f6r el\u0151fordulva.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_4_VEL-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_4_VEL-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_4_VEL-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_4_VEL-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_4_VEL-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_4_VEL-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_4_VEL.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\">4. \u00e1bra: 1 \u00e9s 10 k\u00f6z\u00f6tti v\u00e9letlen eg\u00e9sz sz\u00e1mok, egyes \u00e9rt\u00e9kek t\u00f6bbsz\u00f6r el\u0151fordulva.<\/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-167ffb9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"167ffb9\" 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-7459c3c\" data-id=\"7459c3c\" 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-0e42b58 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"0e42b58\" 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\/2021\/11\/166-K-Excel-VEL_5_VEL.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img loading=\"lazy\" decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_5_VEL-1024x576.jpg\" class=\"attachment-large size-large wp-image-21021\" alt=\"5. \u00e1bra: 1 \u00e9s 1000 k\u00f6z\u00f6tti v\u00e9letlen eg\u00e9sz sz\u00e1mok. Nem l\u00e1tunk k\u00e9tszer el\u0151fordul\u00f3 sz\u00e1mot.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_5_VEL-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_5_VEL-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_5_VEL-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_5_VEL-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_5_VEL-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_5_VEL-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2021\/11\/166-K-Excel-VEL_5_VEL.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\">5. \u00e1bra: 1 \u00e9s 1000 k\u00f6z\u00f6tti v\u00e9letlen eg\u00e9sz sz\u00e1mok. Nem l\u00e1tunk k\u00e9tszer el\u0151fordul\u00f3 sz\u00e1mot.<\/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-b6c4f7a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b6c4f7a\" 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-fcd985e\" data-id=\"fcd985e\" 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-85bef5f elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"85bef5f\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;8. 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\">8. 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-a35021f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a35021f\" 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-1a67a75\" data-id=\"1a67a75\" 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-badc05b elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"badc05b\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;8.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\">8.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-0a5d25b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0a5d25b\" 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-6cbcd45\" data-id=\"6cbcd45\" 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-9433a31 elementor-widget elementor-widget-text-editor\" data-id=\"9433a31\" 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 RAND, a szintaxis 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-3041bf9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3041bf9\" 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-024c81a\" data-id=\"024c81a\" 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-45eb9e0 elementor-widget elementor-widget-text-editor\" data-id=\"45eb9e0\" 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 class=\"Kplet\"><strong>RAND()<\/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-43f5661 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"43f5661\" 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-040dbce\" data-id=\"040dbce\" 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-ec4a256 elementor-headline--style-highlight elementor-widget elementor-widget-animated-headline\" data-id=\"ec4a256\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;8.2. V\\u00e9letlen logikai \\u00e9rt\\u00e9ket (IGAZ, HAMIS) akarok gener\\u00e1lni.&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\">8.2. V\u00e9letlen logikai \u00e9rt\u00e9ket (IGAZ, HAMIS) akarok gener\u00e1lni.<\/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-a4273d2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a4273d2\" 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-4a41e28\" data-id=\"4a41e28\" 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-32bd781 elementor-widget elementor-widget-text-editor\" data-id=\"32bd781\" 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>Kombin\u00e1ld a HA f\u00fcggv\u00e9nnyel! Az els\u0151 argumentumban add meg a V\u00c9L()&gt;=0,5 felt\u00e9telt, majd hat\u00e1rozd meg, hogy a 0,5 alatti vagy a feletti vagy azzal egyenl\u0151 eredm\u00e9nyhez akarod-e rendelni a HAMIS \u00e9s IGAZ \u00e9rt\u00e9ket. \u00cdme egy p\u00e9lda:<\/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-ddeb75e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"ddeb75e\" 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-dd2e908\" data-id=\"dd2e908\" 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-e41788d elementor-widget elementor-widget-text-editor\" data-id=\"e41788d\" 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 class=\"Kplet\"><strong>=HA(V\u00c9L()&gt;=0,5;IGAZ;HAMIS)<\/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-4196db8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4196db8\" 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-74f3cb2\" data-id=\"74f3cb2\" 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-4f3a1af elementor-widget elementor-widget-text-editor\" data-id=\"4f3a1af\" 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>Haszn\u00e1lhatod az IGAZ \u00e9s a HAMIS f\u00fcggv\u00e9nyt 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-a4bbba9 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a4bbba9\" 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-cf09702\" data-id=\"cf09702\" 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-f96ff39 elementor-widget elementor-widget-text-editor\" data-id=\"f96ff39\" 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 class=\"Kplet\"><strong>=HA(V\u00c9L()&gt;=0,5;IGAZ();HAMIS())<\/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-2af74fc elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2af74fc\" 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-b79318c\" data-id=\"b79318c\" 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-ac2823e elementor-widget elementor-widget-global elementor-global-15494 elementor-widget-text-editor\" data-id=\"ac2823e\" 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-95d0c7d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"95d0c7d\" 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-e7d54e5\" data-id=\"e7d54e5\" 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-a8ff5f3 elementor-widget elementor-widget-text-editor\" data-id=\"a8ff5f3\" 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><b>Infopanel<br \/>K\u00e9sz\u00fclt: 2020 janu\u00e1r 9.<br \/>Oper\u00e1ci\u00f3s rendszer: Windows 10 (21H1, 2105b19043)<br \/>Irodai programcsomag: Microsoft 365 v2110b14527.20234, Aktu\u00e1lis 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<\/b><\/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-7e5c4f0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7e5c4f0\" 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-4097d2c\" data-id=\"4097d2c\" 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-96a5721 elementor-widget elementor-widget-shortcode\" data-id=\"96a5721\" 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--1713 \"        data-post-id=\"1713\">        <!-- Rating widget -->    <div class=\"rmp-rating-widget js-rmp-rating-widget\" role=\"group\" aria-labelledby=\"rmp-title-1713\">                    <p class=\"rmp-heading rmp-heading--title\" id=\"rmp-title-1713\">                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 rmp-icon--full-highlight\" 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 rmp-icon--full-highlight\" 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 rmp-icon--full-highlight\" 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 rmp-icon--full-highlight\" 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 rmp-icon--full-highlight\" 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 \">                Szavazatsz\u00e1m: <span class=\"rmp-rating-widget__results__votes js-rmp-vote-count\">2<\/span>, \u00c1tlag: <span class=\"rmp-rating-widget__results__rating js-rmp-avg-rating\">5<\/span>            <\/p>            <p class=\"rmp-rating-widget__not-rated js-rmp-not-rated rmp-rating-widget__not-rated--hidden\">                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-6b828e3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6b828e3\" 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-dd5f92b\" data-id=\"dd5f92b\" 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-8d80a61 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=\"8d80a61\" 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: 2021 november 1. Mir\u0151l sz\u00f3l ez a cikk?Ebben a cikkben egy olyan matematikai \u00e9s trigonometriai f\u00fcggv\u00e9nyt mutatunk be, amelyet gyakran haszn\u00e1lhatunk v\u00e9letlenszer\u0171 val\u00f3s sz\u00e1mok automatikus gener\u00e1l\u00e1s\u00e1ra. Tartalomjegyz\u00e9k A cikkben eml\u00edtett egy\u00e9b Excel f\u00fcggv\u00e9nyek a k\u00f6vetkez\u0151k: HA, HAMIS, IGAZ, INT. Az Excel haszn\u00e1lat\u00e1t tanulva sokszor \u00fctk\u00f6z\u00fcnk abba a probl\u00e9m\u00e1ba, \u2026 <a class=\"continue-reading-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=1713\">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-1713","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/1713","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=1713"}],"version-history":[{"count":0,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/1713\/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=1713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}