{"id":3450,"date":"2020-05-02T15:20:38","date_gmt":"2020-05-02T13:20:38","guid":{"rendered":"https:\/\/www.fiatluxefel.info\/?page_id=3450"},"modified":"2022-08-07T17:04:42","modified_gmt":"2022-08-07T15:04:42","slug":"ecdl-tablazatkezeles-10-vizsgafeladat-microsoft-excel-2016","status":"publish","type":"page","link":"https:\/\/www.fiatluxefel.info\/?page_id=3450","title":{"rendered":"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 10. vizsgafeladat (#200\ud83e\uddaf)"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"3450\" class=\"elementor elementor-3450\" data-elementor-post-type=\"page\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-05d0b52 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"05d0b52\" 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-3c27b7d\" data-id=\"3c27b7d\" 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-9ed8b5d elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"9ed8b5d\" 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>\u00a0Friss\u00edtve: 2022 j\u00falius 24.<\/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-f33482e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f33482e\" 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-de8716d\" data-id=\"de8716d\" 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-fb1f6d8 elementor-invisible elementor-widget elementor-widget-image\" data-id=\"fb1f6d8\" 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\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/BejegyzesFaceTwitter_CikkFrissitveECDL_M04_S6_Vizsgafeladatok_1.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"Bejegyz\u00e9s, Facebook, Twitter: Cikk friss\u00edtve ECDL T\u00e1bl\u00e1zatkezel\u00e9s\/S6\/Vizsgafeladatok megold\u00e1sa, #1\" data-elementor-lightbox-description=\"Bejegyz\u00e9s, Facebook, Twitter: Cikk friss\u00edtve ECDL T\u00e1bl\u00e1zatkezel\u00e9s\/S6\/Vizsgafeladatok megold\u00e1sa, #1\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6MjUyMTcsInVybCI6Imh0dHBzOlwvXC93d3cuZmlhdGx1eGVmZWwuaW5mb1wvd3AtY29udGVudFwvdXBsb2Fkc1wvMjAyMlwvMDdcL0JlamVneXplc0ZhY2VUd2l0dGVyX0Npa2tGcmlzc2l0dmVFQ0RMX00wNF9TNl9WaXpzZ2FmZWxhZGF0b2tfMS5wbmcifQ%3D%3D\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"420\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/BejegyzesFaceTwitter_CikkFrissitveECDL_M04_S6_Vizsgafeladatok_1-1024x538.png\" class=\"elementor-animation-buzz-out attachment-large size-large wp-image-25217\" alt=\"Bejegyz\u00e9s, Facebook, Twitter: Cikk friss\u00edtve ECDL T\u00e1bl\u00e1zatkezel\u00e9s\/S6\/Vizsgafeladatok megold\u00e1sa, #1\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/BejegyzesFaceTwitter_CikkFrissitveECDL_M04_S6_Vizsgafeladatok_1-1024x538.png 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/BejegyzesFaceTwitter_CikkFrissitveECDL_M04_S6_Vizsgafeladatok_1-300x158.png 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/BejegyzesFaceTwitter_CikkFrissitveECDL_M04_S6_Vizsgafeladatok_1-768x404.png 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/BejegyzesFaceTwitter_CikkFrissitveECDL_M04_S6_Vizsgafeladatok_1-150x79.png 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/BejegyzesFaceTwitter_CikkFrissitveECDL_M04_S6_Vizsgafeladatok_1-250x131.png 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/BejegyzesFaceTwitter_CikkFrissitveECDL_M04_S6_Vizsgafeladatok_1.png 1231w\" 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\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-1658837 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1658837\" 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-dabb376\" data-id=\"dabb376\" 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-da7f971 elementor-widget elementor-widget-text-editor\" data-id=\"da7f971\" 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 l\u00e1t\u00e1ss\u00e9r\u00fcltek sz\u00e1m\u00e1ra k\u00e9sz\u00fclt Microsoft Excel oktat\u00f3anyagban az ECDL T\u00e1bl\u00e1zatkezel\u00e9s modulhoz kiadott Vizsgap\u00e9ldat\u00e1r 10. feladat\u00e1t dolgozzuk fel a Windows 10 oper\u00e1ci\u00f3s rendszer \u00e9s a Microsoft Office 2016 irodai alkalmaz\u00e1scsomag aktu\u00e1lis kiad\u00e1s\u00e1nak felhaszn\u00e1l\u00e1s\u00e1val.<br \/>A vizsgafeladat megold\u00e1sa sor\u00e1n kiz\u00e1r\u00f3lag a billenty\u0171zetet haszn\u00e1ljuk.<\/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-8a272b0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8a272b0\" 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-3360df6\" data-id=\"3360df6\" 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-2a2f756 elementor-toc--minimized-on-tablet elementor-widget elementor-widget-table-of-contents\" data-id=\"2a2f756\" 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__2a2f756\" 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__2a2f756\" 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__2a2f756\" 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-229d891 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"229d891\" 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-da4693b\" data-id=\"da4693b\" 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-8ea1374 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"8ea1374\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><strong>Felhaszn\u00e1lt forr\u00e1sok:<\/strong><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/njszt.hu\/hu\/ecdl\/modul\/tablazatkezeles\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A T\u00e1bl\u00e1zatkezel\u00e9s modul tartalma az NJSzT oldal\u00e1n.<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2019\/syllabus6_tablazatkezeles.pdf\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A 2019 febru\u00e1r 1-t\u0151l \u00e9rv\u00e9nyes T\u00e1bl\u00e1zatkezel\u00e9s Syllabus 6 (PDF f\u00e1jl).<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2019\/vizsgafeladat_syllabus6_tablazatkezeles.pdf\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A 2019 m\u00e1rcius 1-t\u0151l \u00e9rv\u00e9nyes ECDL Vizsgap\u00e9ldat\u00e1r T\u00e1bl\u00e1zatkezel\u00e9s (PDF f\u00e1jl).<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2018\/munkafajl_tablazatkezeles.zip\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">A feladatokhoz tartoz\u00f3 munkaf\u00fczetek t\u00f6m\u00f6r\u00edtv\u00e9nye (ZIP f\u00e1jl).<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/05\/200-K-ECDLM04S6-Vizsgafeladat10.txt\" target=\"_blank\" rel=\"noopener noreferrer\">A 10. feladatsor Egyszer\u0171 sz\u00f6veg (*.txt) form\u00e1tumban.<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-bookmark\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/05\/200-K-ECDLM04S6-Vizsgafeladat10.jpg\" target=\"_blank\" rel=\"noopener noreferrer\">A 11. l\u00e9p\u00e9sben besz\u00farand\u00f3 k\u00e9p (200-K-ECDLM04S6-Vizsgafeladat#10.jpg) \u2013 a k\u00e9p forr\u00e1sa a <strong>Besz\u00far\u00e1s \/ K\u00e9pek \/ T\u00e1rolt k\u00e9pek<\/strong> parancs gal\u00e9ri\u00e1ja.<\/a><\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7fae1cf elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7fae1cf\" 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-d2b0ac5\" data-id=\"d2b0ac5\" 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-be9fbc2 elementor-headline--style-highlight elementor-widget elementor-widget-global elementor-global-17352 elementor-widget-animated-headline\" data-id=\"be9fbc2\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;1. El\\u0151k\\u00e9sz\\u00fcletek&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. El\u0151k\u00e9sz\u00fcletek<\/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-556ac06 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"556ac06\" 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-de516b5\" data-id=\"de516b5\" 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-9c73d9d elementor-widget elementor-widget-text-editor\" data-id=\"9c73d9d\" 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 ECDL Excel vizsgafeladat megold\u00e1sa el\u0151tt a megjel\u00f6lt forr\u00e1sok k\u00f6z\u00fcl t\u00f6lts\u00fck le sz\u00fcks\u00e9g szerint az <a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2019\/vizsgafeladat_syllabus6_tablazatkezeles.pdf\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">ECDL Vizsgap\u00e9ldat\u00e1r T\u00e1bl\u00e1zatkezel\u00e9s 6.0<\/a> dokumentumot \u00e9s a <a href=\"https:\/\/njszt.hu\/sites\/default\/files\/tests\/2018\/munkafajl_tablazatkezeles.zip\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">munkaf\u00e1jlokat<\/a> \u2013 az el\u0151bbit nyissuk meg, az ut\u00f3bbit pedig csomagoljuk ki c\u00e9lszer\u0171en a Dokumentumok mapp\u00e1ba. A vizsgap\u00e9ldat\u00e1r PDF dokumentum, amit a legt\u00f6bb internet b\u00f6ng\u00e9sz\u0151 k\u00e9pes megnyitni, de haszn\u00e1lhatjuk b\u00e1rmelyik PDF olvas\u00f3 alkalmaz\u00e1st is, p\u00e9ld\u00e1ul az Adobe Acrobat Readert. L\u00e1t\u00e1ss\u00e9r\u00fclt sorst\u00e1rsaink <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/05\/200-K-ECDLM04S6-Vizsgafeladat10.txt\" target=\"_blank\" rel=\"noreferrer noopener\">Egyszer\u0171 sz\u00f6veg (*.txt) form\u00e1tumban<\/a> is let\u00f6lthetik a feladatsort.<\/p><p>Tekints\u00fck \u00e1t a feladat elv\u00e9gz\u00e9s\u00e9hez sz\u00fcks\u00e9ges ismereteket \u00e9s a felhaszn\u00e1lt f\u00fcggv\u00e9nyeket:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-1eb594e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1eb594e\" 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-92c77f3\" data-id=\"92c77f3\" 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-ea65817 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"ea65817\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><strong>A feladat elv\u00e9gz\u00e9s\u00e9hez sz\u00fcks\u00e9ges ismeretek: <\/strong>abszol\u00fat hivatkoz\u00e1s, adatr\u00f6gz\u00edt\u00e9s, akt\u00edv cella \u00e1thelyez\u00e9se, diagram k\u00e9sz\u00edt\u00e9s \u00e9s form\u00e1z\u00e1s, export\u00e1l\u00e1s PDF form\u00e1tumban, k\u00e9p besz\u00far\u00e1sa \u00e9s form\u00e1z\u00e1sa, k\u00e9plet sokszoros\u00edt\u00e1sa, k\u00e9pletk\u00e9sz\u00edt\u00e9s, m\u00e1sol\u00e1s kiv\u00e1g\u00e1s \u00e9s beilleszt\u00e9s, men\u00fcszalag kezel\u00e9s, munkaf\u00fczet megnyit\u00e1sa \u00e9s ment\u00e9se m\u00e1s n\u00e9ven, munkalap kezel\u00e9se, nett\u00f3 \u00c1FA brutt\u00f3 sz\u00e1m\u00edt\u00e1s, nyomtat\u00e1s, nyomtat\u00e1si k\u00e9p, nyomtat\u00e1si ter\u00fclet kijel\u00f6l\u00e9se, oldalbe\u00e1ll\u00edt\u00e1s, oszlopok \u00e9s sorok kezel\u00e9se, panelkezel\u00e9s, sorba rendez\u00e9s, rel\u00e1ci\u00f3s oper\u00e1torok, t\u00e1bl\u00e1zat k\u00e9sz\u00edt\u00e9s \u00e9s form\u00e1z\u00e1s, tartom\u00e1nyok kijel\u00f6l\u00e9se.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><strong>A feladat sor\u00e1n alkalmazand\u00f3 f\u00fcggv\u00e9nyek: <\/strong><a class=\"rank-math-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=3137\">\u00c1TLAG<\/a>, DARABTELI, SZUM.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-18e637c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"18e637c\" 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-e9c95d4\" data-id=\"e9c95d4\" 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-bb14d90 elementor-widget elementor-widget-text-editor\" data-id=\"bb14d90\" 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 feladat v\u00e9grehajt\u00e1sa el\u0151tt, k\u00f6zben \u00e9s ut\u00e1n vess\u00fck \u00f6ssze munk\u00e1nkat az al\u00e1bbi \u00e1br\u00e1k tartalm\u00e1val, amelyeken egy-egy szakasz (elk\u00e9sz\u00fclt t\u00e1bl\u00e1zat, diagram, export stb.) \u00e1llapot\u00e1t tekinthetj\u00fck meg.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-38267e1 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"38267e1\" 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-68449bc\" data-id=\"68449bc\" 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-30be570 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"30be570\" 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\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_1_Tablazat.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\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_1_Tablazat-1024x576.jpg\" class=\"attachment-large size-large wp-image-25870\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 10. vizsgafeladat, 1. megold\u00e1s, 1. \u00e1bra: A k\u00e9sz t\u00e1bl\u00e1zat.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_1_Tablazat-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_1_Tablazat-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_1_Tablazat-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_1_Tablazat-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_1_Tablazat-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_1_Tablazat-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_1_Tablazat.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 k\u00e9sz t\u00e1bl\u00e1zat.<\/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-b3ee8ce elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b3ee8ce\" 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-76ea3de\" data-id=\"76ea3de\" 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-c4670f7 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"c4670f7\" 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\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_2_Diagram.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\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_2_Diagram-1024x576.jpg\" class=\"attachment-large size-large wp-image-25871\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 10. vizsgafeladat, 1. megold\u00e1s, 2. \u00e1bra: A k\u00e9sz seg\u00e9dt\u00e1bl\u00e1zat a vonaldiagrammal.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_2_Diagram-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_2_Diagram-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_2_Diagram-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_2_Diagram-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_2_Diagram-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_2_Diagram-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_2_Diagram.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: A k\u00e9sz seg\u00e9dt\u00e1bl\u00e1zat a vonaldiagrammal.<\/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-072dc6c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"072dc6c\" 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-d73db13\" data-id=\"d73db13\" 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-dcd9dbc elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"dcd9dbc\" 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\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_3_Kep.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\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_3_Kep-1024x576.jpg\" class=\"attachment-large size-large wp-image-25872\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 10. vizsgafeladat, 1. megold\u00e1s, 3. \u00e1bra: A beillesztett \u00e9s a legal\u00e1bb h\u00e1rom oszlop sz\u00e9less\u00e9g\u0171re nagy\u00edtott k\u00e9p.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_3_Kep-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_3_Kep-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_3_Kep-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_3_Kep-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_3_Kep-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_3_Kep-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_3_Kep.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: A beillesztett \u00e9s a legal\u00e1bb h\u00e1rom oszlop sz\u00e9less\u00e9g\u0171re nagy\u00edtott k\u00e9p.<\/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-3a64a70 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3a64a70\" 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-8af6c8a\" data-id=\"8af6c8a\" 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-7eb3c7e elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"7eb3c7e\" 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\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_4_PDF.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\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_4_PDF-1024x576.jpg\" class=\"attachment-large size-large wp-image-25873\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 10. vizsgafeladat, 1. megold\u00e1s, 4. \u00e1bra: A PDF export a Microsoft Edge b\u00f6ng\u00e9sz\u0151 ablak\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_4_PDF-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_4_PDF-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_4_PDF-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_4_PDF-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_4_PDF-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_4_PDF-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_4_PDF.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: A PDF export a Microsoft Edge b\u00f6ng\u00e9sz\u0151 ablak\u00e1ban.<\/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-065ac58 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"065ac58\" 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-11ae0ec\" data-id=\"11ae0ec\" 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-8ad12d8 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"8ad12d8\" 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\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_5_Fajlok.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\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_5_Fajlok-1024x576.jpg\" class=\"attachment-large size-large wp-image-25874\" alt=\"ECDL T\u00e1bl\u00e1zatkezel\u00e9s 10. vizsgafeladat, 1. megold\u00e1s, 5. \u00e1bra: A feladat megold\u00e1sa sor\u00e1n l\u00e9trehozott 2 db f\u00e1jl a Dokumentumok mapp\u00e1ban.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_5_Fajlok-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_5_Fajlok-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_5_Fajlok-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_5_Fajlok-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_5_Fajlok-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_5_Fajlok-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_5_Fajlok.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: A feladat megold\u00e1sa sor\u00e1n l\u00e9trehozott 2 db f\u00e1jl a Dokumentumok mapp\u00e1ban.<\/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-4b24175 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4b24175\" 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-da26b0e\" data-id=\"da26b0e\" 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-58fa3d6 elementor-headline--style-highlight elementor-widget elementor-widget-global elementor-global-17360 elementor-widget-animated-headline\" data-id=\"58fa3d6\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;marker&quot;:&quot;curly&quot;,&quot;highlighted_text&quot;:&quot;2. A vizsgafeladat megold\\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 vizsgafeladat megold\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-bd9f2f2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bd9f2f2\" 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-a7cffaa\" data-id=\"a7cffaa\" 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-7cd44af elementor-widget elementor-widget-text-editor\" data-id=\"7cd44af\" 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>Egy javaslat a v\u00e9grehajt\u00e1s menet\u00e9re a billenty\u0171zet haszn\u00e1lat\u00e1val (77 l\u00e9p\u00e9s):<\/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-57b74ef elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"57b74ef\" 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-4e81310\" data-id=\"4e81310\" 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-ac71b0c elementor-widget elementor-widget-text-editor\" data-id=\"ac71b0c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol><li>Nyissuk meg szerkeszt\u00e9sre az M4-10.xlsx munkaf\u00fczetet!<\/li><li>Nyomjuk le az <em>F12<\/em> funkci\u00f3billenty\u0171t a <strong>Ment\u00e9s m\u00e1sk\u00e9nt<\/strong> p\u00e1rbesz\u00e9dablak megjelen\u00edt\u00e9s\u00e9hez!<\/li><li>G\u00e9pelj\u00fck be a <strong>F\u00e1jln\u00e9v<\/strong> <em>(Alt+N)<\/em> kombin\u00e1lt szerkeszt\u0151mez\u0151be a nev\u00fcnket, majd ments\u00fck el a munkaf\u00fczetet a <strong>Ment\u00e9s<\/strong> <em>(Alt+S)<\/em> gombot v\u00e1lasztva!<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-31ed98e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"31ed98e\" 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-039421b\" data-id=\"039421b\" 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-56f8dc3 elementor-widget elementor-widget-global elementor-global-16830 elementor-widget-text-editor\" data-id=\"56f8dc3\" 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> Jegyezz\u00fck meg, ha egy l\u00e9tez\u0151 munkaf\u00fczetet nyitunk meg, akkor a ment\u00e9s m\u00e1sk\u00e9nt funkci\u00f3 a munkaf\u00fczet mapp\u00e1j\u00e1t k\u00edn\u00e1lja fel a ment\u00e9shez. Azt is \u00e9rdemes megjegyezni, hogy a <strong>F\u00e1jln\u00e9v<\/strong> szerkeszt\u0151mez\u0151 tartalma, vagyis a munkaf\u00fczet neve kijel\u00f6lt \u00e1llapotban van, teh\u00e1t egy m\u00e1sik, teljesen m\u00e1s n\u00e9v megad\u00e1sakor azonnal fel\u00fclg\u00e9pelhetj\u00fck azt, nem kell el\u0151tte t\u00f6r\u00f6lni a <i>Del<\/i> vagy a <i>Backspace<\/i> billenty\u0171vel a szerkeszt\u0151mez\u0151 tartalm\u00e1t.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-4c3f898 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4c3f898\" 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-c59a0aa\" data-id=\"c59a0aa\" 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-a6cb5da elementor-widget elementor-widget-text-editor\" data-id=\"a6cb5da\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"4\">\n<li>Els\u0151 teend\u0151nk, hogy megismerkedj\u00fcnk az M4-10 munkalap tartalm\u00e1val: a t\u00e1bl\u00e1zat az A1:C48 tartom\u00e1nyban egy k\u00e9pzeletbeli k\u00f6nyvesbolt CD-ROM \u00e1rlist\u00e1j\u00e1t tartalmazza. A\u00a0lista h\u00e1rom kateg\u00f3ri\u00e1ra, vagyis r\u00e9szre osztott: Angol nyelv\u0171 oktat\u00f3 CD-k, Magyar nyelv\u0171 oktat\u00f3 CD-k \u00e9s J\u00e1t\u00e9kok. Az egyes kateg\u00f3ri\u00e1kat az A oszlopban tal\u00e1lhat\u00f3, az el\u0151bb felsorolt c\u00edmk\u00e9k vezetik be, amiket az A1, A20 \u00e9s A40 cell\u00e1kban tal\u00e1lunk. A B oszlopban tal\u00e1ljuk a CD-ROM lemezek neveit \u2013 a h\u00e1rom kateg\u00f3ri\u00e1hoz tartoz\u00f3 tartom\u00e1nyhivatkoz\u00e1s a k\u00f6vetkez\u0151: B2:B18, B21:B38 \u00e9s B41:B48. A C oszlopban pedig a nett\u00f3 \u00e1rakat tal\u00e1ljuk \u2013 a tartom\u00e1nyhivatkoz\u00e1sok a k\u00f6vetkez\u0151k: C2:C18, C21:C38 \u00e9s C41:C48.<\/li>\n<li>Az els\u0151 feladat szerint a D oszlopban meg kell jelen\u00edten\u00fcnk az \u00e1rak \u00c1F\u00c1-val n\u00f6velt \u00e9rt\u00e9keit, vagyis a brutt\u00f3 \u00e1rat. Az \u00c1FA a feladat szerint 20%, \u00e9s a J1 cell\u00e1ban kell megjelen\u00edten\u00fcnk. L\u00e9pj\u00fcnk a J1 cell\u00e1ra, \u00e9s g\u00e9pelj\u00fck be az \u00c1FA \u00e9rt\u00e9k\u00e9t: 20%<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-eb97d82 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"eb97d82\" 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-bd7d546\" data-id=\"bd7d546\" 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-c2b2954 elementor-widget elementor-widget-global elementor-global-17107 elementor-widget-text-editor\" data-id=\"c2b2954\" 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> Ha fel szeretn\u00e9nk eleven\u00edteni a nett\u00f3, \u00c1FA \u00e9s brutt\u00f3 sz\u00e1m\u00edt\u00e1ssal kapcsolatos ismereteinket, akkor keress\u00fck fel a <a href=\"https:\/\/www.fiatluxefel.info\/?page_id=1861\">Nett\u00f3, \u00c1FA, Brutt\u00f3 sz\u00e1m\u00edt\u00e1s (#170)<\/a> c\u00edm\u0171 cikket!<\/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-1fe6a72 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1fe6a72\" 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-9a36698\" data-id=\"9a36698\" 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-4ecca03 elementor-widget elementor-widget-text-editor\" data-id=\"4ecca03\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"6\">\n<li>Helyezz\u00fck az akt\u00edv cell\u00e1t a D1 cell\u00e1ra, majd g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: Brutt\u00f3 (Ft)<\/li>\n<li>L\u00e9pj\u00fcnk a D2 cell\u00e1ra, g\u00e9pelj\u00fck be az <strong>=C2*(1+$J$1)<\/strong> k\u00e9pletet! Az\u00a0abszol\u00fat hivatkoz\u00e1sra az\u00e9rt van sz\u00fcks\u00e9g\u00fcnk, mert a beg\u00e9pelt k\u00e9pletet \u00e1t kell m\u00e1solnunk a t\u00f6bbi CD-ROM nett\u00f3 \u00e1ra mell\u00e9. Emiatt meg kell akad\u00e1lyoznunk, hogy a J1 cell\u00e1ra mutat\u00f3 hivatkoz\u00e1s m\u00f3dosuljon.<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-a9666f0 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"a9666f0\" 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-f99b2e7\" data-id=\"f99b2e7\" 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-f30333d elementor-widget elementor-widget-text-editor\" data-id=\"f30333d\" 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> A pontoss\u00e1g kedv\u00e9\u00e9rt jegyezz\u00fck meg, hogy elegend\u0151 lenne a vegyes hivatkoz\u00e1s, vagyis a J$1 haszn\u00e1lata, mivel a k\u00e9plet lefel\u00e9 m\u00e1sol\u00e1sa sor\u00e1n az oszlop nem, csak a sorsz\u00e1m v\u00e1ltozik.<\/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-71de780 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"71de780\" 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-883bd70\" data-id=\"883bd70\" 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-0669b55 elementor-widget elementor-widget-text-editor\" data-id=\"0669b55\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"8\">\n<li>M\u00e1soljuk a V\u00e1g\u00f3lapra a D2 cella tartalm\u00e1t a <em>Ctrl+C<\/em> billenty\u0171kombin\u00e1ci\u00f3val!<\/li>\n<li>Mivel a t\u00e1bl\u00e1zat h\u00e1rom r\u00e9szre osztott, \u00fcres sorok tagolj\u00e1k, nem tudjuk egyben kijel\u00f6lni a D oszlop t\u00f6bbi cell\u00e1j\u00e1t, hanem seg\u00edts\u00e9g\u00fcl kell h\u00edvnunk az <strong>Ugr\u00e1s<\/strong> p\u00e1rbesz\u00e9dablakot. Nyomjuk le az <em>F5<\/em> funkci\u00f3billenty\u0171t az <strong>Ugr\u00e1s<\/strong> p\u00e1rbesz\u00e9dablak megjelen\u00edt\u00e9s\u00e9hez, \u00e9s a <strong>Hivatkoz\u00e1s<\/strong> szerkeszt\u0151mez\u0151be g\u00e9pelj\u00fck be a D3:D18;D21:D38;D41:D48 tartom\u00e1nyhivatkoz\u00e1sokat, v\u00e9g\u00fcl \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li>\n<li>\u00dcss\u00fck le a <em>Ctrl+V<\/em> billenty\u0171kombin\u00e1ci\u00f3t a k\u00e9pletek besz\u00far\u00e1s\u00e1hoz! A kijel\u00f6lt tartom\u00e1ny cell\u00e1iban megjelennek az eredm\u00e9nyek.<\/li>\n<\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5539e7c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5539e7c\" 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-76c955b\" data-id=\"76c955b\" 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-06671a4 elementor-widget elementor-widget-global elementor-global-16861 elementor-widget-text-editor\" data-id=\"06671a4\" 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> Az <i>F5<\/i> funkci\u00f3billenty\u0171t nem csak egy adott cell\u00e1ra ugr\u00e1sra, hanem cell\u00e1k, tartom\u00e1nyok, teljes sor, sorok, oszlop, illetve oszlopok kijel\u00f6l\u00e9s\u00e9re is haszn\u00e1lhatjuk, ak\u00e1r vegyesen is. Tartom\u00e1ny kijel\u00f6l\u00e9s\u00e9hez a tartom\u00e1nyhivatkoz\u00e1st, t\u00f6bb tartom\u00e1ny kijel\u00f6l\u00e9s\u00e9hez azok pontosvessz\u0151vel elv\u00e1lasztott hivatkoz\u00e1sait, sorn\u00e1l csak a sorsz\u00e1mot, sorokn\u00e1l a sorokat, oszlopn\u00e1l az oszlop bet\u0171jel\u00e9t, oszlopokn\u00e1l a bet\u0171jelekb\u0151l k\u00e9pzett tartom\u00e1nyhivatkoz\u00e1st kell megadnunk, p\u00e9ld\u00e1ul A1:C3 vagy A1:C3;E20:E22 vagy 5:5 vagy 5:10 vagy B:B vagy B:N.<\/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-c1e2a6c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c1e2a6c\" 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-8ace919\" data-id=\"8ace919\" 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-2e74713 elementor-widget elementor-widget-text-editor\" data-id=\"2e74713\" 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> Az el\u0151z\u0151 l\u00e9p\u00e9sben hogyan tudtuk meghat\u00e1rozni, mely cell\u00e1kat kell kijel\u00f6ln\u00fcnk? \u00dagy, hogy a t\u00e1bl\u00e1zat felder\u00edt\u00e9s\u00e9hez felhaszn\u00e1ltuk az Excel akt\u00edv cell\u00e1t l\u00e9ptet\u0151 tr\u00fckkj\u00e9t:<br \/>R\u00e1l\u00e9pt\u00fcnk a C2 cell\u00e1ra, amely az els\u0151 kateg\u00f3ria els\u0151 term\u00e9k\u00e9nek \u00e1r\u00e1t tartalmazza. Le\u00fct\u00f6tt\u00fck az <i>End<\/i>, majd a <i>le ny\u00edlbillenty\u0171t<\/i>. Lejutottunk az adatoszlop legals\u00f3 \u00e9rt\u00e9k\u00e9t tartalmaz\u00f3 cell\u00e1ra, a C18 cell\u00e1ra. \u00cdgy megtudtuk az els\u0151 tartom\u00e1ny c\u00edm\u00e9t, ami a D2:D18.<br \/>Ism\u00e9t le\u00fct\u00f6tt\u00fck az <i>End, le ny\u00edlbillenty\u0171t<\/i> \u2013 a m\u00e1sodik kateg\u00f3ria els\u0151 adatcell\u00e1j\u00e1ra, a C21-re l\u00e9pt\u00fcnk. \u00dajra le\u00fct\u00f6tt\u00fck az <i>End, le ny\u00edlbillenty\u0171t<\/i>. Lejutottunk a kateg\u00f3ria utols\u00f3 cell\u00e1j\u00e1ra, a C38-ra. Megkaptuk a m\u00e1sodik tartom\u00e1nyt, a D21:D38-at.<br \/>Megint le\u00fct\u00f6tt\u00fck az <i>End, le ny\u00edlbillenty\u0171t<\/i> \u2013 a harmadik kateg\u00f3ria els\u0151 adatcell\u00e1j\u00e1ra, a C41-re l\u00e9pt\u00fcnk. Ism\u00e9t le\u00fct\u00f6tt\u00fck az <i>End, le ny\u00edlbillenty\u0171t<\/i>, \u00edgy lejutottunk a kateg\u00f3ria utols\u00f3 cell\u00e1j\u00e1ra, a C48-ra. Megkaptuk a harmadik tartom\u00e1nyt, a D41:D48-at.<br \/>Az <i>End, ny\u00edlbillenty\u0171<\/i> billenty\u0171paranccsal az adatot tartalmaz\u00f3 tartom\u00e1nyok k\u00f6z\u00f6tt l\u00e9pkedhet\u00fcnk, \u00edgy nem csak egy \u00f6sszef\u00fcgg\u0151, hanem \u00fcres sort \u00e9s\/vagy oszlopot tartalmaz\u00f3 t\u00e1bl\u00e1zatban is k\u00e9nyelmesen tudunk mozogni, sz\u00fcks\u00e9g eset\u00e9n a kijel\u00f6lend\u0151 tartom\u00e1nyokat felfedezni.<\/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-811806d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"811806d\" 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-852c022\" data-id=\"852c022\" 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-e209ae6 elementor-widget elementor-widget-text-editor\" data-id=\"e209ae6\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"11\"><li>K\u00f6vetkez\u0151 feladatunk, hogy t\u00fcntess\u00fck fel a G oszlopban a C oszlop nett\u00f3 \u00e1rainak 20%-al cs\u00f6kkentett \u00e9rt\u00e9keit, vagyis egy 20%-os \u00e1rengedm\u00e9nyt. A kedvezm\u00e9nyes \u00e1rat \u00fagy kapjuk meg, hogy a nett\u00f3 \u00e1rb\u00f3l kivonjuk a nett\u00f3 \u00e1r 20%-\u00e1t. A nett\u00f3 \u00e1r 20%-\u00e1t a k\u00f6vetkez\u0151 sz\u00e1m\u00edt\u00e1ssal kapjuk meg: Nett\u00f3*0,2 vagy Nett\u00f3*20%. Ezt kell kivonnunk a Nett\u00f3 \u00e9rt\u00e9kb\u0151l: Nett\u00f3-Nett\u00f3*0,2 vagy Nett\u00f3-Nett\u00f3*20%. N\u00e9zz\u00fck, majd hogyan n\u00e9z ki ez a k\u00e9t k\u00e9plet a G2 cell\u00e1ban:<br \/><strong>=C2-C2*0,2 <\/strong>vagy<strong> =C2-C2*20%<\/strong>.<\/li><li>L\u00e9pj\u00fcnk a G1 cell\u00e1ra, \u00e9s g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: Akci\u00f3s \u00e1r<\/li><li>L\u00e9pj\u00fcnk a G2 cell\u00e1ra, g\u00e9pelj\u00fck be vagy az <strong>=C2-C2*0,2 <\/strong>vagy az<strong> =C2-C2*20%<\/strong> k\u00e9pletet!<\/li><li>M\u00e1soljuk a V\u00e1g\u00f3lapra a G2 cella tartalm\u00e1t a <em>Ctrl+C<\/em> billenty\u0171kombin\u00e1ci\u00f3val!<\/li><li>Nyomjuk le az <em>F5<\/em> funkci\u00f3billenty\u0171t az <strong>Ugr\u00e1s<\/strong> p\u00e1rbesz\u00e9dablak megjelen\u00edt\u00e9s\u00e9hez, \u00e9s a <strong>Hivatkoz\u00e1s<\/strong> szerkeszt\u0151mez\u0151be g\u00e9pelj\u00fck be a G3:G18;G21:G38;G41:G48 tartom\u00e1nyhivatkoz\u00e1sokat, v\u00e9g\u00fcl \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li><li>\u00dcss\u00fck le a <em>Ctrl+V<\/em> billenty\u0171kombin\u00e1ci\u00f3t a k\u00e9pletek besz\u00far\u00e1s\u00e1hoz! A kijel\u00f6lt tartom\u00e1ny cell\u00e1iban megjelennek az eredm\u00e9nyek.<\/li><li>Mivel m\u00e1r ismerj\u00fck a h\u00e1rom kateg\u00f3ria nett\u00f3 \u00e1rait tartalmaz\u00f3 cell\u00e1k hivatkoz\u00e1sait (C2:C18, C21:C38 \u00e9s C41:C48), k\u00f6nnyen \u00f6ssze tudjuk adni az \u00e1rakat. Helyezz\u00fck az akt\u00edv cell\u00e1t a K1 cell\u00e1ra, majd g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 k\u00e9pletet: <strong>=SZUM(C2:C18)<\/strong><\/li><li>Helyezz\u00fck az akt\u00edv cell\u00e1t a K2 cell\u00e1ra, majd g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 k\u00e9pletet: <strong>=SZUM(C21:C38)<\/strong><\/li><li>Helyezz\u00fck az akt\u00edv cell\u00e1t a K3 cell\u00e1ra, majd g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 k\u00e9pletet: <strong>=SZUM(C41:C48)<\/strong><\/li><li>A h\u00e1rom kateg\u00f3ria nett\u00f3 \u00e1rainak (C oszlop) \u00e1tlagsz\u00e1m\u00edt\u00e1sa k\u00f6vetkezik. Mindegyik k\u00e9plethez beg\u00e9pelj\u00fck a c\u00edmk\u00e9t is.<\/li><li>Helyezz\u00fck az akt\u00edv cell\u00e1t a B19 cell\u00e1ra, majd g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: \u00c1tlag<\/li><li>L\u00e9ptess\u00fck az akt\u00edv cell\u00e1t a C19 cell\u00e1ra, majd g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 k\u00e9pletet: <strong>=\u00c1TLAG(C2:C18)<\/strong><\/li><li>L\u00e9pj\u00fcnk a B39 cell\u00e1ra, majd g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: \u00c1tlag<\/li><li>Helyezz\u00fck az akt\u00edv cell\u00e1t a C39 cell\u00e1ra, majd g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 k\u00e9pletet: <strong>=\u00c1TLAG(C21:C38)<\/strong><\/li><li>L\u00e9pj\u00fcnk a B49 cell\u00e1ra, majd g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: \u00c1tlag<\/li><li>Helyezz\u00fck az akt\u00edv cell\u00e1t a C49 cell\u00e1ra, majd g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 k\u00e9pletet: <strong>=\u00c1TLAG(C41:C48)<\/strong><\/li><li>A k\u00f6vetkez\u0151 l\u00e9p\u00e9sben egy seg\u00e9dt\u00e1bl\u00e1zatot kell k\u00e9sz\u00edten\u00fcnk, amit egy grafikon k\u00e9sz\u00edt\u00e9s\u00e9hez fogunk felhaszn\u00e1lni.<\/li><li>Helyezz\u00fck az akt\u00edv cell\u00e1t a C53 cell\u00e1ra, majd g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: Oktat\u00f3 CD-k<\/li><li>Helyezz\u00fck az akt\u00edv cell\u00e1t a C54 cell\u00e1ra, majd g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 c\u00edmk\u00e9t: J\u00e1t\u00e9kok<\/li><li>A D52:G52 cell\u00e1kba g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 h\u00f3napneveket: janu\u00e1r, febru\u00e1r, m\u00e1rcius, \u00e1prilis<\/li><li>A D53:G53 cell\u00e1kba g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 \u00e9rt\u00e9keket: 95, 125, 140, 145<\/li><li>A D54:G54 cell\u00e1kba g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 \u00e9rt\u00e9keket: 140, 200, 240, 270<\/li><li>Egy vonaldiagramot kell k\u00e9sz\u00edten\u00fcnk a munkalapra a janu\u00e1ri adatok kihagy\u00e1s\u00e1val. Mivel a c\u00edmk\u00e9kre is sz\u00fcks\u00e9g\u00fcnk van, \u00edgy a diagramon a C52:C54 \u00e9s az E52:G54 tartom\u00e1nyokra lesz sz\u00fcks\u00e9g\u00fcnk. Az F5 funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel jel\u00f6lj\u00fck ki ez a k\u00e9t tartom\u00e1nyt: C52:C54;E52:G54<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-6e58777 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"6e58777\" 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-7f988ae\" data-id=\"7f988ae\" 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-cd89325 elementor-widget elementor-widget-text-editor\" data-id=\"cd89325\" 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> Amikor a diagramon megjelen\u00edtend\u0151 \u00e9rt\u00e9kek k\u00f6r\u00e9t meghat\u00e1rozzuk, \u00e1t kell gondolnunk, mely tartom\u00e1nyt kell kijel\u00f6ln\u00fcnk a diagram l\u00e9trehoz\u00e1sa el\u0151tt. T\u00f6bbnyire nem csak az \u00e9rt\u00e9keket, hanem az oszlopok, illetve sorok c\u00edmk\u00e9it is l\u00e1ttatni akarjuk a diagramon, \u00edgy ezeket is ki kell jel\u00f6ln\u00fcnk. Egyszer\u0171 esetben ez \u00e1ltal\u00e1ban a teljes t\u00e1bl\u00e1zat kijel\u00f6l\u00e9s\u00e9t jelenti.<br \/>Igen \u00e1m, de mi a helyzet akkor, mint a mostani feladatban is, ha ki kell hagynunk egy vagy t\u00f6bb sort \u00e9s\/vagy oszlopot \u2013 ebben a feladatban a D oszlopot.<br \/><strong>A megold\u00e1s, hogy csak az \u00e1br\u00e1zolni k\u00edv\u00e1nt cell\u00e1kat jel\u00f6lj\u00fck ki, p\u00e9ld\u00e1ul az <i>F5<\/i> funkci\u00f3billenty\u0171 seg\u00edts\u00e9g\u00e9vel \u00fcgyelve arra, hogy a megadott tartom\u00e1nyhivatkoz\u00e1sok egy folytonos t\u00e9glalap alak\u00fa ter\u00fcletet adjanak eredm\u00e9ny\u00fcl.<\/strong> \u00cdgy kellett tenn\u00fcnk a mostani feladatban is, kijel\u00f6lve a C52:C54;E52:G54 tartom\u00e1nyokat. Ha figyelmen k\u00edv\u00fcl hagyjuk a kihagyott ter\u00fcletet, l\u00e1thatjuk, hogy a kijel\u00f6lt r\u00e9szek val\u00f3ban egy folytonos t\u00e9glalapot mint\u00e1znak.<\/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-5b91986 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5b91986\" 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-e273a43\" data-id=\"e273a43\" 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-05143a5 elementor-widget elementor-widget-text-editor\" data-id=\"05143a5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"34\"><li>Adjuk ki a <strong>Besz\u00far\u00e1s \/ Vonal- \u00e9s ter\u00fcletdiagram besz\u00far\u00e1sa <\/strong><em>(Alt+E, T1)<\/em> parancsot, majd \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t, mivel a palett\u00e1n az els\u0151 elem, a <strong>Vonal<\/strong> a kijel\u00f6lt. A munkalap l\u00e1that\u00f3 ter\u00fclet\u00e9nek k\u00f6zep\u00e9n a t\u00e1bl\u00e1zat felett megjelenik a diagram.<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-bbefddb elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"bbefddb\" 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-19bad2a\" data-id=\"19bad2a\" 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-3c12ebc elementor-widget elementor-widget-global elementor-global-16884 elementor-widget-text-editor\" data-id=\"3c12ebc\" 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> A diagram beilleszt\u00e9s\u00e9t k\u00f6vet\u0151en annak szerkeszt\u00e9s\u00e9hez kapunk egy <strong>Diagrameszk\u00f6z\u00f6k \/ Diagramtervez\u00e9s <\/strong><i>(Alt+JC)<\/i> \u00e9s egy <strong>Diagrameszk\u00f6z\u00f6k \/\u00a0<\/strong><strong>Form\u00e1tum<\/strong> <i>(Alt+JZ)<\/i> nev\u0171 men\u00fcszalag f\u00fclet. Term\u00e9szetesen rendelkez\u00e9s\u00fcnkre \u00e1ll a <i>Shift+F10<\/i>-el el\u00e9rhet\u0151 helyi men\u00fc 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-b2a77d7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b2a77d7\" 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-6c06c53\" data-id=\"6c06c53\" 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-0888704 elementor-widget elementor-widget-global elementor-global-16913 elementor-widget-text-editor\" data-id=\"0888704\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00c1lljunk meg egy sz\u00f3ra!<\/strong><br \/>A k\u00e9p, \u00e9s m\u00e1s grafikus elem, mint p\u00e9ld\u00e1ul a diagram, \u00fagynevezett lebeg\u0151 objektumk\u00e9nt a munkalap cell\u00e1i felett, azokat eltakarva helyezkedik el. Egy lebeg\u0151 objektumot \u00fagy tudunk kijel\u00f6lni, illetve t\u00f6bb objektum eset\u00e9n k\u00f6z\u00fcl\u00fck v\u00e1lasztani, ha kiadjuk a <strong>Kezd\u0151lap \/ Keres\u00e9s \u00e9s kijel\u00f6l\u00e9s \/ Objektumok kijel\u00f6l\u00e9se<\/strong> <i>(Alt+\u0150, \u00d6E, O)<\/i> parancsot. Az Excel kijel\u00f6ltt\u00e9 teszi az els\u0151 objektumot, majd a <i>Tab<\/i> \u00e9s <i>Shift+Tab<\/i> billenty\u0171kombin\u00e1ci\u00f3kkal r\u00e1nk b\u00edzza a kezelni k\u00edv\u00e1nt objektum kijel\u00f6l\u00e9s\u00e9t. A munkalap cell\u00e1ihoz az <i>Esc<\/i> billenty\u0171 le\u00fct\u00e9s\u00e9vel t\u00e9rhet\u00fcnk vissza.<\/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-4e6861c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4e6861c\" 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-89d404e\" data-id=\"89d404e\" 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-1466fb4 elementor-widget elementor-widget-text-editor\" data-id=\"1466fb4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"35\"><li>A diagram eltakarhatja a t\u00e1bl\u00e1zatot, ami nagyon zavar\u00f3 lehet. Helyezz\u00fck \u00e1t p\u00e9ld\u00e1ul a C56 cell\u00e1ba: \u00fcss\u00fck le a <em>Ctrl+X<\/em> billenty\u0171kombin\u00e1ci\u00f3t, majd l\u00e9ptess\u00fck az akt\u00edv cell\u00e1t a C56 cell\u00e1ra, v\u00e9g\u00fcl \u00fcss\u00fck le a <em>Ctrl+V<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-49229ac elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"49229ac\" 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-ff5b14f\" data-id=\"ff5b14f\" 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-1a01535 elementor-widget elementor-widget-global elementor-global-16948 elementor-widget-text-editor\" data-id=\"1a01535\" 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> Ha feladatunk egy diagram besz\u00far\u00e1sa az aktu\u00e1lis munkalapra, akkor az t\u00f6bbnyire eltakarja a t\u00e1bl\u00e1zatot. Ez\u00e9rt c\u00e9lszer\u0171 sz\u00e1m\u00e1ra m\u00e1sik helyet keresni, p\u00e9ld\u00e1ul a t\u00e1bl\u00e1zat alatt: a <em>Ctrl+X<\/em> le\u00fct\u00e9s\u00e9vel helyezz\u00fck a V\u00e1g\u00f3lapra a diagramot, majd a visszakapott akt\u00edv cell\u00e1t mozgassuk a diagram bal fels\u0151 sark\u00e1nak helyet ad\u00f3 cell\u00e1ra, v\u00e9g\u00fcl \u00fcss\u00fck le a <em>Ctrl+V<\/em> billenty\u0171kombin\u00e1ci\u00f3t! A diagram kijel\u00f6lt \u00e1llapotban marad.<br \/>Persze, ha a vizsg\u00e1n ezt nem k\u00e9rik, vagy kifejezetten tiltj\u00e1k, akkor hagyjuk ki ezt a l\u00e9p\u00e9st.<\/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-022b26f elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"022b26f\" 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-bec219c\" data-id=\"bec219c\" 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-26e025f elementor-widget elementor-widget-text-editor\" data-id=\"26e025f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"36\"><li>V\u00e1lasszuk ki a <strong>Diagramtervez\u00e9s \/ Diagram-\u00f6sszetev\u0151 hozz\u00e1ad\u00e1sa \/ Diagramc\u00edm \/ A diagram felett <\/strong>parancsot <em>(Alt+JC, D, C, A)<\/em>! Ezzel a c\u00edmet a diagram f\u00f6l\u00e9, k\u00f6z\u00e9pre helyezz\u00fck, egyben kijel\u00f6ltt\u00e9 tessz\u00fck azt a szerkeszt\u00e9shez.<\/li><li>Nyomjuk le az <em>F2<\/em> funkci\u00f3billenty\u0171t, az \u00edgy aktiv\u00e1lt <strong>Szerkeszt\u0151l\u00e9cbe<\/strong> g\u00e9pelj\u00fck be az \u00c9rt\u00e9kes\u00edtett mennyis\u00e9gek c\u00edmet, majd \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li><li>Az x tengely h\u00f3napneveit 45\u00b0-al elforgat\u00e1s\u00e1hoz el\u0151sz\u00f6r adjuk ki a <strong>Form\u00e1tum \/ Diagramelemek <\/strong><em>(Alt+JZ, I)<\/em> parancsot, majd a kombin\u00e1lt listamez\u0151ben keress\u00fck meg a <strong>V\u00edzszintes (Kateg\u00f3ria) tengely<\/strong> elemet, v\u00e9g\u00fcl v\u00e1lasszuk ki az <em>Enter<\/em> billenty\u0171t le\u00fctve!<\/li><li>Az elforgat\u00e1shoz meg kell jelen\u00edten\u00fcnk a <strong>Tengely form\u00e1z\u00e1sa<\/strong> panelt, a munkater\u00fclet jobb sz\u00e9l\u00e9n. Ehhez adjuk ki a <strong>Form\u00e1tum \/ Kijel\u00f6l\u00e9s form\u00e1z\u00e1sa <\/strong><em>(Alt+JZ, B)<\/em> parancsot!<\/li><li>A f\u00f3kusz a panel <strong>Tengely be\u00e1ll\u00edt\u00e1sai<\/strong> gombj\u00e1ra ker\u00fcl, de ha m\u00e9gsem, akkor a panelra l\u00e9p\u00e9shez addig \u00fct\u00f6gess\u00fck az <em>F6<\/em> funkci\u00f3billenty\u0171t, am\u00edg a <strong>Tengely be\u00e1ll\u00edt\u00e1sa<\/strong> gombot ki nem v\u00e1lasztjuk!<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f115257 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f115257\" 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-02a543b\" data-id=\"02a543b\" 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-9060942 elementor-widget elementor-widget-global elementor-global-17123 elementor-widget-text-editor\" data-id=\"9060942\" 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 m\u00e1r r\u00e9gen alkalmazza a be\u00e1ll\u00edt\u00e1spaneleket, amelyek a munkater\u00fclet (munkalap, diagramlap) jobb sz\u00e9l\u00e9n foglalnak el egy terjedelmes sz\u00e9less\u00e9g\u0171 ter\u00fcletet. Alkalmasint t\u00f6bb panelt is nyithatunk, nyitnak egyes parancsok, amelyek egym\u00e1s mellett helyezkednek el, \u00edgy a munkater\u00fclet egy kisebb felbont\u00e1s\u00fa k\u00e9perny\u0151n nagyon \u00f6sszesz\u0171k\u00fclhet.<br \/>A panelek, valamint az Excel alkalmaz\u00e1sablak\u00e1nak r\u00e9szei k\u00f6z\u00f6tt (men\u00fcszalag, akt\u00edv cella vagy diagramlap, lapf\u00fcl, panelek stb.) az <i>F6<\/i> \u00e9s a <i>Shift+F6<\/i> seg\u00edts\u00e9g\u00e9vel l\u00e9pkedhet\u00fcnk. A panelb\u00f3l a munkalapra vagy a diagramlapra t\u00f6rt\u00e9n\u0151 visszal\u00e9p\u00e9shez haszn\u00e1ljuk az <i>Esc<\/i> billenty\u0171t!<br \/>A panelben val\u00f3 mozg\u00e1sra a <i>Tab<\/i> \u00e9s <i>Shift+Tab<\/i> billenty\u0171ket haszn\u00e1lhatjuk.<br \/>A panelek billenty\u0171zettel t\u00f6rt\u00e9n\u0151 kezel\u00e9s\u00e9r\u0151l k\u00fcl\u00f6n cikkben olvashatunk.<\/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-f5cceb2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f5cceb2\" 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-f987ccf\" data-id=\"f987ccf\" 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-f691df5 elementor-widget elementor-widget-text-editor\" data-id=\"f691df5\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"41\"><li>\u00dct\u00f6gess\u00fck a <em>Tab<\/em> billenty\u0171t, am\u00edg nem tal\u00e1lunk egy \u00fajabb <strong>Tengely be\u00e1ll\u00edt\u00e1sai<\/strong> gombot! Itt n\u00e9gy gombot tal\u00e1lunk egym\u00e1s mellett (<strong>Kit\u00f6lt\u00e9s \u00e9s vonal<\/strong>, <strong>Effektusok<\/strong>, <strong>M\u00e9ret \u00e9s tulajdons\u00e1gok<\/strong>, <strong>Tengely be\u00e1ll\u00edt\u00e1sai<\/strong>), amelyek k\u00f6z\u00fcl az utols\u00f3ra l\u00e9pt\u00fcnk az el\u0151bb. A gombok k\u00f6z\u00fcl a <em>ny\u00edlbillenty\u0171kkel<\/em> v\u00e1laszthatunk. L\u00e9pj\u00fcnk egyet balra a <strong>M\u00e9ret \u00e9s tulajdons\u00e1gok<\/strong> gombot kijel\u00f6lve!<\/li><li>\u00dcss\u00fck le a <em>Tab<\/em> billenty\u0171t az <strong>Igaz\u00edt\u00e1s<\/strong> gombra l\u00e9p\u00e9shez!<\/li><li>Ha becsukott \u00e1llapotban tal\u00e1ljuk, akkor a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171vel nyissuk ki!<\/li><li>A <em>Tab<\/em> billenty\u0171vel keress\u00fck meg az <strong>Egy\u00e9ni sz\u00f6g<\/strong> szerkeszt\u0151mez\u0151t, majd g\u00e9pelj\u00fck be a -45 \u00e9rt\u00e9ket, \u00e9s \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t! (A 45\u00b0 jobbra lefel\u00e9, a -45\u00b0 jobbra felfel\u00e9 d\u00f6nti meg a feliratokat.)<\/li><li>A f\u00fcgg\u0151leges y (\u00c9rt\u00e9k) tengelyen meg kell jelen\u00edten\u00fcnk a Ft jelet. Adjuk ki a <strong>Tervez\u00e9s \/ Diagram-\u00f6sszetev\u0151 hozz\u00e1ad\u00e1sa \/ Tengelyc\u00edmek \/ Els\u0151dleges f\u00fcgg\u0151leges <\/strong><em>(Alt+JV, D, M, E)<\/em> parancsot! A diagram y tengely\u00e9t\u0151l balra egy keretben l\u00e1that\u00f3v\u00e1 v\u00e1lik a kijel\u00f6lt <strong>Tengelyc\u00edm<\/strong> felirat.<\/li><li>A sz\u00f6veg \u00e1t\u00edr\u00e1s\u00e1hoz \u00fcss\u00fck le az <em>F2<\/em> billenty\u0171t, majd a <strong>Szerkeszt\u0151l\u00e9cbe<\/strong> g\u00e9pelj\u00fck be a db r\u00f6vid\u00edt\u00e9st, v\u00e9g\u00fcl \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t! A k\u00e9sz seg\u00e9dt\u00e1bl\u00e1zatot \u00e9s a diagramot mutatja a <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_2_Diagram.jpg\" target=\"_blank\" rel=\"noopener\">2. \u00e1bra<\/a>.<\/li><li>\u00dct\u00f6gess\u00fck az <em>Esc<\/em> billenty\u0171t, hogy otthagyhassuk a diagramot, \u00e9s visszat\u00e9rj\u00fcnk az akt\u00edv cell\u00e1hoz!<\/li><li>A k\u00f6vetkez\u0151 feladatban az egys\u00e9g\u00e1rakhoz (C oszlop) <strong>K\u00f6nyvel\u00e9si sz\u00e1mform\u00e1tumot<\/strong> \u00e9s ezres tagol\u00e1st kell be\u00e1ll\u00edtanunk. A <strong>K\u00f6nyvel\u00e9si sz\u00e1mform\u00e1tum <\/strong>m\u00e1r ezres tagol\u00e1st alkalmaz, ez\u00e9rt el\u00e9g ezt a form\u00e1tumjegyet a cell\u00e1khoz rendelni. Jel\u00f6lj\u00fck ki a C2:C49 tartom\u00e1nyt!<\/li><li>A sz\u00e1mform\u00e1tum be\u00e1ll\u00edt\u00e1s\u00e1hoz v\u00e1lasszuk ki a <strong>Kezd\u0151lap \/ K\u00f6nyvel\u00e9si sz\u00e1mform\u00e1tum \/ Ft magyar<\/strong> <em>(Alt+\u0150, AN, Enter)<\/em> parancsot!<\/li><li>Mivel a megform\u00e1zott \u00e9rt\u00e9kek t\u00f6bbs\u00e9ge nem f\u00e9r el a cell\u00e1ban, n\u00f6velj\u00fck meg az oszlopok sz\u00e9less\u00e9g\u00e9t: hagyjuk kijel\u00f6lve a tartom\u00e1nyt, majd adjuk ki a <strong>Kezd\u0151lap \/ Form\u00e1tum \/ Automatikus oszlopsz\u00e9less\u00e9g <\/strong><em>(Alt+\u0150, FF, U)<\/em> parancsot!<\/li><li>Sorba kell rendezn\u00fcnk a h\u00e1rom kateg\u00f3ria CD-ROM c\u00edmeit. Mivel a feladat nem \u00edrja el\u0151 a sorrendis\u00e9get, emelked\u0151 \u00e1b\u00e9c\u00e9 sorrendet fogunk be\u00e1ll\u00edtani. Jel\u00f6lj\u00fck ki az els\u0151 kateg\u00f3ri\u00e1hoz tartoz\u00f3 B2:C18 tartom\u00e1nyt!<\/li><li>Adjuk ki a <strong>Kezd\u0151lap \/ Rendez\u00e9s \u00e9s sz\u0171r\u00e9s \/ Rendez\u00e9s (A-Z)<\/strong> <em>(Alt+\u0150, \u00da, A)<\/em> vagy az <strong>Adatok \/ Rendez\u00e9s (A-Z)<\/strong> <em>(Alt+G, N)<\/em> parancsot!<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-d2bb05d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d2bb05d\" 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-4995fcb\" data-id=\"4995fcb\" 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-a7d7958 elementor-widget elementor-widget-global elementor-global-17117 elementor-widget-text-editor\" data-id=\"a7d7958\" 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 \/>Tipikus feladat feliratokat \u00e9s\/vagy sz\u00e1m\u00edt\u00e1sokat tartalmaz\u00f3 t\u00e1bl\u00e1zatok adatsorainak rendez\u00e9se egy vagy t\u00f6bb oszlop szerint. Sokan elfelejtik a rendez\u00e9s el\u0151tt a megfelel\u0151 sorokat kijel\u00f6lni, teljesen \u00f6sszekeverve a sorokat. Ha azonnal lenyomjuk a <i>Ctrl+Z<\/i> billenty\u0171kombin\u00e1ci\u00f3t, meg nem t\u00f6rt\u00e9ntt\u00e9 tehetj\u00fck t\u00e9ved\u00e9s\u00fcnket, \u00e9s gyorsan elolvashatjuk a k\u00f6vetkez\u0151 bekezd\u00e9st, mit is kell ilyenkor tenn\u00fcnk.<\/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-b50759e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"b50759e\" 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-d17d253\" data-id=\"d17d253\" 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-88a8d48 elementor-widget elementor-widget-global elementor-global-17149 elementor-widget-text-editor\" data-id=\"88a8d48\" 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> Ha egy t\u00e1bl\u00e1zat sorait rendezn\u00fcnk kell az egyik oszlop alapj\u00e1n, akkor csak a rendezni k\u00edv\u00e1nt adatokat tartalmaz\u00f3 tartom\u00e1nyt szabad kijel\u00f6ln\u00fcnk \u2013 ki kell hagynunk a k\u00e9pleteket, oszlopc\u00edmk\u00e9ket \u00e9s egy\u00e9b sz\u00e1rmaztatott adatokat tartalmaz\u00f3 cell\u00e1kat. Ezt szem el\u0151tt tartva, egy \u00f6sszef\u00fcgg\u0151 tartom\u00e1nyt fogunk kijel\u00f6lni.<br \/>Ha egy oszlop szerint kell rendezn\u00fcnk a sorokat, akkor a <i>Tab<\/i> billenty\u0171vel l\u00e9ptess\u00fck a tartom\u00e1ny akt\u00edv cell\u00e1j\u00e1t abba az oszlopba, amely szerint rendezni akarunk. Ezt k\u00f6vet\u0151en m\u00e1r haszn\u00e1lhatjuk a <strong>Kezd\u0151lap \/ Rendez\u00e9s \u00e9s sz\u0171r\u00e9s<\/strong> <i>(Alt+\u0150, \u00da)<\/i> men\u00fc vagy az <strong>Adatok \/Rendez\u00e9s \u00e9s sz\u0171r\u00e9s<\/strong><strong> csoport parancsait. Ha a helyi men\u00fct r\u00e9szes\u00edtj\u00fck el\u0151nyben, akkor a <i>Shift+F10<\/i> lenyom\u00e1s\u00e1t k\u00f6vet\u0151en a <\/strong><strong>Rendez\u00e9s<\/strong> almen\u00fc parancsaib\u00f3l v\u00e1logathatunk.<br \/>Ha t\u00f6bb oszlop szerint kell rendezn\u00fcnk, akkor m\u00e1r sz\u00fcks\u00e9g\u00fcnk lesz a <strong>Rendez\u00e9s<\/strong> (<i>Alt+\u0150, \u00da, E<\/i> vagy <i>Alt+G, R<\/i> vagy <i>Shift+F10, D, E<\/i>) p\u00e1rbesz\u00e9dablakra.<\/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-f20980d elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f20980d\" 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-be2fc0c\" data-id=\"be2fc0c\" 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-fd1ccad elementor-widget elementor-widget-text-editor\" data-id=\"fd1ccad\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"53\"><li>Jel\u00f6lj\u00fck ki a m\u00e1sodik kateg\u00f3ri\u00e1hoz tartoz\u00f3 B21:C38 tartom\u00e1nyt!<\/li><li>Adjuk ki a <strong>Kezd\u0151lap \/ Rendez\u00e9s \u00e9s sz\u0171r\u00e9s \/ Rendez\u00e9s (A-Z)<\/strong> <em>(Alt+\u0150, \u00da, A)<\/em> vagy az <strong>Adatok \/ Rendez\u00e9s (A-Z)<\/strong> <em>(Alt+G, N)<\/em> parancsot!<\/li><li>Jel\u00f6lj\u00fck ki a m\u00e1sodik kateg\u00f3ri\u00e1hoz tartoz\u00f3 B41:C48 tartom\u00e1nyt!<\/li><li>Adjuk ki a <strong>Kezd\u0151lap \/ Rendez\u00e9s \u00e9s sz\u0171r\u00e9s \/ Rendez\u00e9s (A-Z)<\/strong> <em>(Alt+\u0150, \u00da, A)<\/em> vagy az <strong>Adatok \/ Rendez\u00e9s (A-Z)<\/strong> <em>(Alt+G, N)<\/em> parancsot!<\/li><li>A CD-ROM-ok c\u00edmeit tartalmaz\u00f3 cell\u00e1k kijel\u00f6l\u00e9s\u00e9hez ism\u00e9t h\u00edvjuk seg\u00edts\u00e9g\u00fcl az <strong>Ugr\u00e1s<\/strong> p\u00e1rbesz\u00e9dablakot, \u00e9s a <strong>Hivatkoz\u00e1s<\/strong> szerkeszt\u0151mez\u0151be g\u00e9pelj\u00fck be a k\u00f6vetkez\u0151 tartom\u00e1nyhivatkoz\u00e1sokat: B2:B18;B21:B38;B41:B48<\/li><li>A f\u00e9lk\u00f6v\u00e9r st\u00edlus be\u00e1ll\u00edt\u00e1s\u00e1hoz \u00fcss\u00fck le a <em>Ctrl+B<\/em> billenty\u0171kombin\u00e1ci\u00f3t!<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-0cd1efa elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0cd1efa\" 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-48a8d51\" data-id=\"48a8d51\" 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-0bfbdd3 elementor-widget elementor-widget-global elementor-global-17100 elementor-widget-text-editor\" data-id=\"0bfbdd3\" 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> A k\u00f6vetkez\u0151 billenty\u0171kombin\u00e1ci\u00f3kat haszn\u00e1lhatjuk az elemi st\u00edlusok be\u00e1ll\u00edt\u00e1s\u00e1ra vagy kikapcsol\u00e1s\u00e1ra: f\u00e9lk\u00f6v\u00e9r <i>Ctrl+B<\/i> vagy <i>Ctrl+2<\/i>, d\u0151lt <i>Ctrl+I<\/i> vagy <i>Ctrl+3<\/i>, al\u00e1h\u00fazott <i>Ctrl+U<\/i> vagy <i>Ctrl+4<\/i>, \u00e1th\u00faz\u00e1s <i>Ctrl+5<\/i>.<\/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-edcbe1b elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"edcbe1b\" 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-79d5594\" data-id=\"79d5594\" 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-1924a9e elementor-widget elementor-widget-text-editor\" data-id=\"1924a9e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"59\"><li>\u00c1ll\u00edtsuk be a <strong>K\u00e9k <\/strong>bet\u0171sz\u00ednt a <strong>Kezd\u0151lap \/ Bet\u0171sz\u00edn <\/strong><em>(Alt+\u0150, \u0170E)<\/em> parancs palett\u00e1j\u00e1nak seg\u00edts\u00e9g\u00e9vel! A paletta <strong>Alapsz\u00ednek<\/strong> r\u00e9sz\u00e9ben nyolcadik a <strong>K\u00e9k <\/strong>sz\u00edn, amit a ny\u00edlbillenty\u0171kkel l\u00e9pkedve kereshet\u00fcnk meg. Ha megtal\u00e1ltuk, nyomjuk le az <em>Enter<\/em> vagy a <em>Sz\u00f3k\u00f6z<\/em> billenty\u0171t a kiv\u00e1laszt\u00e1s\u00e1hoz \u00e9s a paletta becsuk\u00e1s\u00e1hoz!<\/li><li>A munkalap nev\u00e9nek m\u00f3dos\u00edt\u00e1s\u00e1hoz adjuk ki a <strong>Kezd\u0151lap \/ Form\u00e1tum \/ Munkalap \u00e1tnevez\u00e9se <\/strong><em>(Alt+\u0150, FF, N)<\/em> parancsot!<\/li><li>A munkalap neve szerkeszt\u0151mez\u0151v\u00e9 v\u00e1lik, benne a kijel\u00f6lt M4-10 munkalapn\u00e9vvel. G\u00e9pelj\u00fck \u00e1t CD-re, majd \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t!<\/li><li>A H1 cell\u00e1ban meg kell jelen\u00edten\u00fcnk az els\u0151 kateg\u00f3ria nett\u00f3 \u00e1rai k\u00f6z\u00fcl a 4000 Ft-n\u00e1l olcs\u00f3bbak darabsz\u00e1m\u00e1t. Mivel felt\u00e9teles darabsz\u00e1ml\u00e1l\u00e1sra van sz\u00fcks\u00e9g, a DARABTELI f\u00fcggv\u00e9nyt h\u00edvjuk seg\u00edts\u00e9g\u00fcl. Az els\u0151 kateg\u00f3ria nett\u00f3 \u00e1rait a C2:C18 tartom\u00e1nyban tal\u00e1ljuk. A felt\u00e9tel pedig a k\u00f6vetkez\u0151: &lt;4000. \u00c1ll\u00edtsuk \u00f6ssze a k\u00e9pletet: <strong>=DARABTELI(C2:C18;&#8221;&lt;4000&#8243;)<\/strong>. Helyezz\u00fck az akt\u00edv cell\u00e1t a H1 cell\u00e1ra, \u00e9s g\u00e9pelj\u00fck be ezt a k\u00e9pletet! Eredm\u00e9ny\u00fcl 14-et kell kapnunk. A k\u00e9sz t\u00e1bl\u00e1zatot mutatja az <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_1_Tablazat.jpg\" target=\"_blank\" rel=\"noopener\">1. \u00e1bra<\/a>.<\/li><li>A k\u00f6vetkez\u0151 feladat egy k\u00e9p besz\u00far\u00e1sa a munkalapra. A feladat nem mell\u00e9kel k\u00e9pet, azt sem \u00edrja el\u0151 honnan, mekkora k\u00e9pet, pontosan hova kell beilleszten\u00fcnk \u2013 ennek mik\u00e9ntj\u00e9t val\u00f3sz\u00edn\u0171leg a vizsg\u00e1n k\u00f6zlik. Ami val\u00f3sz\u00edn\u0171s\u00edthet\u0151, a k\u00e9p h\u00e1rom oszlopn\u00e1l kisebb sz\u00e9less\u00e9ge, mivel meg kell n\u00f6veln\u00fcnk a m\u00e9ret\u00e9t legal\u00e1bb h\u00e1rom oszlopnyi sz\u00e9less\u00e9gre. Mell\u00e9kelt\u00fcnk egy ennek megfelel\u0151 k\u00e9pet, amit a cikk elej\u00e9n, a forr\u00e1sok k\u00f6z\u00f6tt tal\u00e1lunk meg. T\u00f6lts\u00fck le \u00e9s ments\u00fck a munkaf\u00fczet mapp\u00e1j\u00e1ba, ha m\u00e9g nem tett\u00fck meg!<\/li><li>A k\u00e9p bal fels\u0151 sark\u00e1ul az M1 cell\u00e1t jel\u00f6lj\u00fck ki, teh\u00e1t helyezz\u00fck ide az akt\u00edv cell\u00e1t!<\/li><li>Adjuk ki a <strong>Besz\u00far\u00e1s \/ K\u00e9pek \/ Ez az eszk\u00f6z <\/strong><em>(Alt+E, E, E)<\/em> parancsot!<\/li><li>A k\u00e9perny\u0151n megjelen\u0151 <strong>K\u00e9p besz\u00far\u00e1sa<\/strong> p\u00e1rbesz\u00e9dablakban keress\u00fck meg a k\u00e9pet, jel\u00f6lj\u00fck ki, \u00e9s sz\u00farjuk be a <strong>Besz\u00far\u00e1s<\/strong> <em>(Alt+B)<\/em> gombot v\u00e1lasztva! A k\u00e9p megjelenik az M1 cell\u00e1t\u00f3l jobbra \u00e9s lefel\u00e9.<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-9d83018 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"9d83018\" 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-7772901\" data-id=\"7772901\" 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-4e561f1 elementor-widget elementor-widget-global elementor-global-17247 elementor-widget-text-editor\" data-id=\"4e561f1\" 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> A k\u00e9p beilleszt\u00e9s\u00e9t k\u00f6vet\u0151en annak szerkeszt\u00e9s\u00e9hez kapunk egy <strong>K\u00e9peszk\u00f6z\u00f6k \/ K\u00e9pform\u00e1tum<\/strong>\u00a0<i>(Alt+JP)<\/i> nev\u0171 men\u00fcszalag f\u00fclet. Term\u00e9szetesen rendelkez\u00e9s\u00fcnkre \u00e1ll a <i>Shift+F10<\/i>-el el\u00e9rhet\u0151 helyi men\u00fc 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-012b166 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"012b166\" 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-9ab792f\" data-id=\"9ab792f\" 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-a97dadf elementor-widget elementor-widget-global elementor-global-16913 elementor-widget-text-editor\" data-id=\"a97dadf\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00c1lljunk meg egy sz\u00f3ra!<\/strong><br \/>A k\u00e9p, \u00e9s m\u00e1s grafikus elem, mint p\u00e9ld\u00e1ul a diagram, \u00fagynevezett lebeg\u0151 objektumk\u00e9nt a munkalap cell\u00e1i felett, azokat eltakarva helyezkedik el. Egy lebeg\u0151 objektumot \u00fagy tudunk kijel\u00f6lni, illetve t\u00f6bb objektum eset\u00e9n k\u00f6z\u00fcl\u00fck v\u00e1lasztani, ha kiadjuk a <strong>Kezd\u0151lap \/ Keres\u00e9s \u00e9s kijel\u00f6l\u00e9s \/ Objektumok kijel\u00f6l\u00e9se<\/strong> <i>(Alt+\u0150, \u00d6E, O)<\/i> parancsot. Az Excel kijel\u00f6ltt\u00e9 teszi az els\u0151 objektumot, majd a <i>Tab<\/i> \u00e9s <i>Shift+Tab<\/i> billenty\u0171kombin\u00e1ci\u00f3kkal r\u00e1nk b\u00edzza a kezelni k\u00edv\u00e1nt objektum kijel\u00f6l\u00e9s\u00e9t. A munkalap cell\u00e1ihoz az <i>Esc<\/i> billenty\u0171 le\u00fct\u00e9s\u00e9vel t\u00e9rhet\u00fcnk vissza.<\/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-18b5c03 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"18b5c03\" 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-56c70d3\" data-id=\"56c70d3\" 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-93edfa3 elementor-widget elementor-widget-text-editor\" data-id=\"93edfa3\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"67\"><li>Ha a k\u00e9p sz\u00e9less\u00e9g\u00e9t legal\u00e1bb 8-10 cm-re n\u00f6velj\u00fck, akkor annak \u00faj m\u00e9rete biztosan legal\u00e1bb 3 oszlopnyi lesz. Adjuk ki a <strong>Form\u00e1tum \/ Sz\u00e9less\u00e9g <\/strong><em>(Alt+JU, \u00dc)<\/em> parancsot a <strong>Sz\u00e9less\u00e9g<\/strong> szerkeszt\u0151mez\u0151 kiv\u00e1laszt\u00e1s\u00e1hoz, \u00e9s g\u00e9pelj\u00fck \u00e1t az ott tal\u00e1lhat\u00f3 \u00e9rt\u00e9ket 10-re, majd \u00fcss\u00fck le az <em>Enter<\/em> billenty\u0171t! A beillesztett k\u00e9pet l\u00e1tjuk a <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_3_Kep.jpg\" target=\"_blank\" rel=\"noopener\">3. \u00e1br\u00e1n<\/a>.<\/li><li>Az <em>F5<\/em> funkci\u00f3billenty\u0171vel jel\u00f6lj\u00fck ki az A1:D48 tartom\u00e1nyt!<\/li><li>A t\u00e1bl\u00e1zatot nyomtat\u00e1si ter\u00fcletk\u00e9nt a <strong>Lapelrendez\u00e9s \/ Nyomtat\u00e1si ter\u00fclet \/ Nyomtat\u00e1si ter\u00fclet kijel\u00f6l\u00e9se <\/strong><em>(Alt+P, I, K)<\/em> paranccsal tudjuk kijel\u00f6lni.<\/li><li>Adjuk ki a <strong>Lapelrendez\u00e9s \/ Oldalbe\u00e1ll\u00edt\u00e1s<\/strong> <em>(Alt+P, O)<\/em> parancsot!<\/li><li>A <em>Ctrl+Tab<\/em> seg\u00edts\u00e9g\u00e9vel l\u00e9pj\u00fcnk \u00e1t a <strong>Marg\u00f3k<\/strong> f\u00fclre!<\/li><li>\u00c1ll\u00edtsunk be 1-1 cm sz\u00e9les marg\u00f3kat!<\/li><li>\u00dcss\u00fck le az <em>Enter<\/em> billenty\u0171t az <strong>Oldalbe\u00e1ll\u00edt\u00e1s<\/strong> ablakb\u00f3l val\u00f3 kil\u00e9p\u00e9shez!<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-8802395 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"8802395\" 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-e1d8181\" data-id=\"e1d8181\" 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-ecb399f elementor-widget elementor-widget-global elementor-global-16989 elementor-widget-text-editor\" data-id=\"ecb399f\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p><strong>\u00c1lljunk meg egy sz\u00f3ra!<\/strong><br \/>A pap\u00edrtakar\u00e9koss\u00e1g jegy\u00e9ben, valamint az elt\u00e9r\u0151 nyomtat\u00e1si k\u00f6rnyezetek miatt mi a gyakorlatok sor\u00e1n a nyomtat\u00e1si k\u00e9r\u00e9seket PDF exporttal helyettes\u00edtj\u00fck, term\u00e9szetesen az esetlegesen el\u0151\u00edrt oldalbe\u00e1ll\u00edt\u00e1sokkal. Aki tov\u00e1bbra is nyomtatni akar, az a <i>Ctrl+P<\/i>-vel ind\u00edthatja a <strong>F\u00e1jl \/ Nyomtat\u00e1s<\/strong> parancsot <i>(Alt+F, P)<\/i>.<\/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-3484994 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"3484994\" 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-5b47856\" data-id=\"5b47856\" 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-3dde18c elementor-widget elementor-widget-text-editor\" data-id=\"3dde18c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"74\"><li>Adjuk ki a <strong>F\u00e1jl \/ Export\u00e1l\u00e1s<\/strong> parancsot, \u00e9s keress\u00fck meg a <strong>PDF\/XPS l\u00e9trehoz\u00e1sa<\/strong> <em>(Alt+F, E, A) <\/em>gombot!<\/li><li>A k\u00e9perny\u0151n megjelenik a <strong>K\u00f6zz\u00e9t\u00e9tel PDF vagy XPS form\u00e1tumban<\/strong> p\u00e1rbesz\u00e9dablak, amelynek <strong>F\u00e1jln\u00e9v<\/strong> kombin\u00e1lt szerkeszt\u0151mez\u0151j\u00e9ben l\u00e1tjuk a munkaf\u00fczet nev\u00e9t, amit el is fogadhatunk: ments\u00fcnk a <strong>K\u00f6zz\u00e9t\u00e9tel<\/strong> <em>(Alt+K)<\/em> gombot v\u00e1lasztva!<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-f85c7f8 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"f85c7f8\" 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-0fb3596\" data-id=\"0fb3596\" 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-f2f2a72 elementor-widget elementor-widget-global elementor-global-17036 elementor-widget-text-editor\" data-id=\"f2f2a72\" 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> Az oper\u00e1ci\u00f3s rendszer \u00e9s az Excel kor\u00e1bbi haszn\u00e1lat\u00e1t\u00f3l f\u00fcgg\u0151en vagy azonnal megjelenik a tartalom az alap\u00e9rtelmezett PDF olvas\u00f3 alkalmaz\u00e1sban, vagy el\u0151tte r\u00e1k\u00e9rdez a Windows, hogy melyik alkalmaz\u00e1ssal akarjuk azt megnyitni. Ut\u00f3bbi esetben \u2013 ha m\u00e1s PDF olvas\u00f3 alkalmaz\u00e1s nincs telep\u00edtve \u2013, a Microsoft Edge b\u00f6ng\u00e9sz\u0151t k\u00edn\u00e1lja fel, amit egy <i>Enter<\/i> le\u00fct\u00e9ssel el is fogadhatunk.<\/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-7ac92ea elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7ac92ea\" 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-86d1ad8\" data-id=\"86d1ad8\" 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-5b8c89c elementor-widget elementor-widget-text-editor\" data-id=\"5b8c89c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<ol start=\"76\"><li>Ha sz\u00e1m\u00edt\u00f3g\u00e9p\u00fcnk\u00f6n van PDF kezel\u0151 alkalmaz\u00e1s vagy b\u00f6ng\u00e9sz\u0151, akkor azt az Excel megpr\u00f3b\u00e1lja elind\u00edtani \u00e9s megjelen\u00edteni a f\u00e1jl tartalm\u00e1t <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_4_PDF.jpg\" target=\"_blank\" rel=\"noopener\">(4. \u00e1bra)<\/a>.<\/li><li>A feladattal v\u00e9gezt\u00fcnk, ments\u00fcnk \u00e9s z\u00e1rjunk be minden f\u00e1jlt \u00e9s alkalmaz\u00e1st!<\/li><\/ol>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-abbb364 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"abbb364\" 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-bb0e1be\" data-id=\"bb0e1be\" 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-a89890a elementor-widget elementor-widget-text-editor\" data-id=\"a89890a\" 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 feladat megold\u00e1sa sor\u00e1n 2 db f\u00e1jlt hoztunk l\u00e9tre: egy Excel munkaf\u00fczetet, valamint egy PDF dokumentumot <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/200-K-ECDLM04S6-Vizsgafeladat10_Megoldas1_5_Fajlok.jpg\" target=\"_blank\" rel=\"noopener\">(5. \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-246e8ed elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"246e8ed\" 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-87cc774\" data-id=\"87cc774\" 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-e2ae120 elementor-widget elementor-widget-global elementor-global-15494 elementor-widget-text-editor\" data-id=\"e2ae120\" 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-5df86ca elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5df86ca\" 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-80c2077\" data-id=\"80c2077\" 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-f5ffdf8 elementor-widget elementor-widget-text-editor\" data-id=\"f5ffdf8\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p style=\"text-align: left;\"><strong>Infopanel<br \/>K\u00e9sz\u00fclt: 2020 m\u00e1jus 2.<br \/>Oper\u00e1ci\u00f3s rendszer: Windows 10 (21H2, 2111b19044)<br \/>Irodai programcsomag: Microsoft Office 2016 v2206b15330.20266, Aktu\u00e1lis csatorna<br \/>Szint: kezd\u0151, ECDL modul\/tanmenet: T\u00e1bl\u00e1zatkezel\u00e9s\/S6<br \/>Kateg\u00f3ria: ECDL \u2192 T\u00e1bl\u00e1zatkezel\u00e9s \u2192 Vizsgafeladatok<\/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-2a1e024 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2a1e024\" 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-1897f45\" data-id=\"1897f45\" 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-28316e4 elementor-widget elementor-widget-shortcode\" data-id=\"28316e4\" 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--3450 \"        data-post-id=\"3450\">        <!-- Rating widget -->    <div class=\"rmp-rating-widget js-rmp-rating-widget\" role=\"group\" aria-labelledby=\"rmp-title-3450\">                    <p class=\"rmp-heading rmp-heading--title\" id=\"rmp-title-3450\">                Mennyire tal\u00e1ltad hasznosnak ezt a cikket?            <\/p>                            <p class=\"rmp-heading rmp-heading--subtitle\">                V\u00e1lassz egy csillagot!            <\/p>                <div class=\"rmp-rating-widget__icons\">            <ul class=\"rmp-rating-widget__icons-list js-rmp-rating-icons-list\" role=\"radiogroup\" aria-label=\"Rating from 1 to 5\">                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"Nem \u00e9rintett meg\"                            data-value=\"1\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"1 out of 5: Nem \u00e9rintett meg\"                            tabindex=\"0\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"N\u00e9h\u00e1ny dolgon felcsillant a szemem\"                            data-value=\"2\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"2 out of 5: N\u00e9h\u00e1ny dolgon felcsillant a szemem\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"\u00c9rdekes volt\"                            data-value=\"3\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"3 out of 5: \u00c9rdekes volt\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"T\u00f6bbnyire csillog\u00f3 szemmel olvastam\"                            data-value=\"4\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"4 out of 5: T\u00f6bbnyire csillog\u00f3 szemmel olvastam\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"Hasznos volt minden szava\"                            data-value=\"5\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"5 out of 5: Hasznos volt minden szava\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                            <\/ul>        <\/div>        <p class=\"rmp-rating-widget__hover-text js-rmp-hover-text\" aria-live=\"polite\"><\/p>                <button class=\"rmp-rating-widget__submit-btn rmp-btn js-submit-rating-btn\">            K\u00fcldd el az \u00e9rt\u00e9kel\u00e9st!        <\/button>        <div aria-live=\"polite\" aria-atomic=\"true\">            <p class=\"rmp-rating-widget__results js-rmp-results rmp-rating-widget__results--hidden\">                Szavazatsz\u00e1m: <span class=\"rmp-rating-widget__results__votes js-rmp-vote-count\">0<\/span>, \u00c1tlag: <span class=\"rmp-rating-widget__results__rating js-rmp-avg-rating\">0<\/span>            <\/p>            <p class=\"rmp-rating-widget__not-rated js-rmp-not-rated \">                M\u00e9g nem szavazott senki! Legy\u00e9l az els\u0151, aki \u00e9rt\u00e9keli ezt a bejegyz\u00e9st!            <\/p>            <p class=\"rmp-rating-widget__msg js-rmp-msg\" role=\"status\"><\/p>        <\/div>    <\/div>    <!--Structured data -->                    <!-- Feedback widget -->        <div class=\"rmp-feedback-widget js-rmp-feedback-widget\">  <p class=\"rmp-heading rmp-heading--title\">    Sajn\u00e1lom, hogy ez a cikk nem volt hasznos sz\u00e1modra!  <\/p>  <p class=\"rmp-heading rmp-heading--subtitle\">    Seg\u00edts nekem, hogy jobb legyen ez a cikk!  <\/p>    <div class=\"rmp-feedback-widget__container\">    <p class=\"rmp-feedback-widget__text\">      \u00cdrd le, mit hi\u00e1nyolsz ebb\u0151l a cikkb\u0151l!    <\/p>    <textarea class=\"rmp-feedback-widget__input js-rmp-feedback-input\" rows=\"5\" id=\"feedback-text\"><\/textarea>        <button type=\"button\" class=\"rmp-feedback-widget__btn rmp-btn rmp-btn--large js-rmp-feedback-button\">      Ez a v\u00e9lem\u00e9nyem!    <\/button>    <div class=\"rmp-feedback-widget__loader js-rmp-feedback-loader\">      <div><\/div><div><\/div><div><\/div>    <\/div>    <p class=\"rmp-feedback-widget__msg js-rmp-feedback-msg\"><\/p>  <\/div>  <\/div>        <\/div><\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-e49c6df elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"e49c6df\" 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-2eff094\" data-id=\"2eff094\" 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-d6efa28 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=\"d6efa28\" 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>\u00a0Friss\u00edtve: 2022 j\u00falius 24. Mir\u0151l sz\u00f3l ez a cikk?Ebben a l\u00e1t\u00e1ss\u00e9r\u00fcltek sz\u00e1m\u00e1ra k\u00e9sz\u00fclt Microsoft Excel oktat\u00f3anyagban az ECDL T\u00e1bl\u00e1zatkezel\u00e9s modulhoz kiadott Vizsgap\u00e9ldat\u00e1r 10. feladat\u00e1t dolgozzuk fel a Windows 10 oper\u00e1ci\u00f3s rendszer \u00e9s a Microsoft Office 2016 irodai alkalmaz\u00e1scsomag aktu\u00e1lis kiad\u00e1s\u00e1nak felhaszn\u00e1l\u00e1s\u00e1val.A vizsgafeladat megold\u00e1sa sor\u00e1n kiz\u00e1r\u00f3lag a billenty\u0171zetet haszn\u00e1ljuk. Tartalomjegyz\u00e9k Felhaszn\u00e1lt \u2026 <a class=\"continue-reading-link\" href=\"https:\/\/www.fiatluxefel.info\/?page_id=3450\">Tov\u00e1bb olvasom&#8230; <span class=\"meta-nav\">&rarr; <\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":25217,"parent":2642,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_mc_calendar":[],"footnotes":""},"class_list":["post-3450","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/3450","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=3450"}],"version-history":[{"count":0,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/3450\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/pages\/2642"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/media\/25217"}],"wp:attachment":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}