القائمة الرئيسية

الصفحات

دورة اكسل علوم وتكنولوجيا

دورة اكسل : شرح إستخدام دالة fonction mode في إكسل

مجلة فراولة

17 يوليو 2016

درس جديد من دروس إكسل حيث سنتعرف في هذا الدرس على كيفية إستخدام دالة أخرى من دوال إكسل.
دالة هذا الدرس هي : fonction mode
هاته الدالة ستسمح لك باستخراج القيمة الأكثر شيوعا(تكراراً) من نطاق بيانتك على الجدول و كمثال تطبيقي على كيفية استخدامها :

المثال التطبيقي : في هذا المثال سوف نستخرج العمر الأكثر تكرارا من جدول المعطيات.
لذلك بعد النقر على الخانة التي ستستقبل النتيجة، أكتب الدالة

= mode(المعطيات)

كما في الصورة و عند فتح القوس الأول قم بإختيار المعطيات التي تمثل بالنسبة لنا الأعمار و بعد إغلاق القوس إضغط على إدخال (Enter) من لوحة المفاتيح.

النتيجة التي حصلنا عليها هي : 13 هو العمر الأكثر شيوعا في الجدول.
أي إستفسار حول هذا الدرس أو أشياء أخرى إطرحها علي في التعليقات، ستجد إن شاء الله الرد المناسب. تحياتي لكم.

دورة اكسل علوم وتكنولوجيا

مجلة فراولة

مجلة فراولة

مدون عربي وصاحب موقع مجلة فراولة، وهي مجلة إجتماعية ترفيهية تهتم بالصور، مواضيع عن الصحة والتغذية، وديكورات وغيرها من المواضيع الأخرى مثل وصفات المطبخ وأقوال وحكم ... رابط الموقع: مجلة فراولة

الملف الشخصي

أخر المواضيع من قسم : دورة اكسل

تعليقات

window['__wavt'] = 'AOuZoY7uJZtc13UFUpas7QRuf4KHS5J9OQ:1679839536588';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d1919475202962222507','//www.farawela.com/2016/07/fonction-mode.html','1919475202962222507'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '1919475202962222507', 'title': '\u0645\u062c\u0644\u0629 \u0641\u0631\u0627\u0648\u0644\u0629', 'url': 'https://www.farawela.com/2016/07/fonction-mode.html', 'canonicalUrl': 'https://www.farawela.com/2016/07/fonction-mode.html', 'homepageUrl': 'https://www.farawela.com/', 'searchUrl': 'https://www.farawela.com/search', 'canonicalHomepageUrl': 'https://www.farawela.com/', 'blogspotFaviconUrl': 'https://www.farawela.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'UA-51317459-1', 'encoding': 'UTF-8', 'locale': 'ar', 'localeUnderscoreDelimited': 'ar', 'languageDirection': 'rtl', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22\u0645\u062c\u0644\u0629 \u0641\u0631\u0627\u0648\u0644\u0629 - Atom\x22 href\x3d\x22https://www.farawela.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22\u0645\u062c\u0644\u0629 \u0641\u0631\u0627\u0648\u0644\u0629 - RSS\x22 href\x3d\x22https://www.farawela.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22\u0645\u062c\u0644\u0629 \u0641\u0631\u0627\u0648\u0644\u0629 - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/1919475202962222507/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22\u0645\u062c\u0644\u0629 \u0641\u0631\u0627\u0648\u0644\u0629 - Atom\x22 href\x3d\x22https://www.farawela.com/feeds/2996323592932452262/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-8189496787102279', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': false, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/1f8afafca3463ac3', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'sharing': {'platforms': [{'name': '\u0627\u0644\u062d\u0635\u0648\u0644 \u0639\u0644\u0649 \u0627\u0644\u0631\u0627\u0628\u0637', 'key': 'link', 'shareMessage': '\u0627\u0644\u062d\u0635\u0648\u0644 \u0639\u0644\u0649 \u0627\u0644\u0631\u0627\u0628\u0637', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': '\u0645\u0634\u0627\u0631\u0643\u0629 \u0625\u0644\u0649 Facebook', 'target': 'facebook'}, {'name': '\u0643\u062a\u0627\u0628\u0629 \u0645\u062f\u0648\u0646\u0629 \u062d\u0648\u0644 \u0647\u0630\u0647 \u0627\u0644\u0645\u0634\u0627\u0631\u0643\u0629', 'key': 'blogThis', 'shareMessage': '\u0643\u062a\u0627\u0628\u0629 \u0645\u062f\u0648\u0646\u0629 \u062d\u0648\u0644 \u0647\u0630\u0647 \u0627\u0644\u0645\u0634\u0627\u0631\u0643\u0629', 'target': 'blog'}, {'name': 'Twitter', 'key': 'twitter', 'shareMessage': '\u0645\u0634\u0627\u0631\u0643\u0629 \u0625\u0644\u0649 Twitter', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': '\u0645\u0634\u0627\u0631\u0643\u0629 \u0625\u0644\u0649 Pinterest', 'target': 'pinterest'}, {'name': '\u0628\u0631\u064a\u062f \u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a', 'key': 'email', 'shareMessage': '\u0628\u0631\u064a\u062f \u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27ar\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': '\u0642\u0631\u0627\u0621\u0629 \u0627\u0644\u0645\u0632\u064a\u062f', 'pageType': 'item', 'postId': '2996323592932452262', 'postImageThumbnailUrl': 'https://1.bp.blogspot.com/-eYdSQcY-Jfs/UxzPNWvTEnI/AAAAAAAABqo/WhFNgZr8fQ0/s72-c/fonctionmode.png', 'postImageUrl': 'https://1.bp.blogspot.com/-eYdSQcY-Jfs/UxzPNWvTEnI/AAAAAAAABqo/WhFNgZr8fQ0/s1600/fonctionmode.png', 'pageName': '\u062f\u0648\u0631\u0629 \u0627\u0643\u0633\u0644 : \u0634\u0631\u062d \u0625\u0633\u062a\u062e\u062f\u0627\u0645 \u062f\u0627\u0644\u0629 fonction mode \u0641\u064a \u0625\u0643\u0633\u0644', 'pageTitle': '\u0645\u062c\u0644\u0629 \u0641\u0631\u0627\u0648\u0644\u0629: \u062f\u0648\u0631\u0629 \u0627\u0643\u0633\u0644 : \u0634\u0631\u062d \u0625\u0633\u062a\u062e\u062f\u0627\u0645 \u062f\u0627\u0644\u0629 fonction mode \u0641\u064a \u0625\u0643\u0633\u0644', 'metaDescription': ''}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': '\u062a\u0639\u062f\u064a\u0644', 'linkCopiedToClipboard': '\u062a\u0645 \u0646\u0633\u062e \u0627\u0644\u0631\u0627\u0628\u0637 \u0625\u0644\u0649 \u0627\u0644\u062d\u0627\u0641\u0638\u0629', 'ok': '\u062d\u0633\u0646\u064b\u0627', 'postLink': '\u0631\u0627\u0628\u0637 \u0627\u0644\u0645\u0634\u0627\u0631\u0643\u0629'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': '\u0645\u062e\u0635\u0635', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': '\u062f\u0648\u0631\u0629 \u0627\u0643\u0633\u0644 : \u0634\u0631\u062d \u0625\u0633\u062a\u062e\u062f\u0627\u0645 \u062f\u0627\u0644\u0629 fonction mode \u0641\u064a \u0625\u0643\u0633\u0644', 'description': '', 'featuredImage': 'https://1.bp.blogspot.com/-eYdSQcY-Jfs/UxzPNWvTEnI/AAAAAAAABqo/WhFNgZr8fQ0/s1600/fonctionmode.png', 'url': 'https://www.farawela.com/2016/07/fonction-mode.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 2996323592932452262}}, {'name': 'widgets', 'data': [{'title': '\u0627\u0644\u0635\u0641\u062d\u0627\u062a', 'type': 'PageList', 'sectionId': 'pages', 'id': 'PageList1'}, {'title': '\u0645\u062c\u0644\u0629 \u0641\u0631\u0627\u0648\u0644\u0629 (\u0631\u0623\u0633 \u0627\u0644\u0635\u0641\u062d\u0629)', 'type': 'Header', 'sectionId': 'logo', 'id': 'Header1'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0627\u0633\u0641\u0644 \u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0639\u0644\u0648\u064a\u0629 \u0644\u0644\u062d\u0627\u0633\u0648\u0628', 'type': 'HTML', 'sectionId': 'Topa3lan-sc', 'id': 'HTML100'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0627\u0633\u0641\u0644 \u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0639\u0644\u0648\u064a\u0629 \u0644\u0644\u0647\u0627\u062a\u0641', 'type': 'HTML', 'sectionId': 'Topa3lan-sc2', 'id': 'HTML101'}, {'title': '\u0631\u0633\u0627\u0626\u0644 \u0627\u0644\u0645\u062f\u0648\u0646\u0629 \u0627\u0644\u0625\u0644\u0643\u062a\u0631\u0648\u0646\u064a\u0629', 'type': 'Blog', 'sectionId': 'Tempnec', 'id': 'Blog1', 'posts': [{'id': '2996323592932452262', 'title': '\u062f\u0648\u0631\u0629 \u0627\u0643\u0633\u0644 : \u0634\u0631\u062d \u0625\u0633\u062a\u062e\u062f\u0627\u0645 \u062f\u0627\u0644\u0629 fonction mode \u0641\u064a \u0625\u0643\u0633\u0644', 'featuredImage': 'https://1.bp.blogspot.com/-eYdSQcY-Jfs/UxzPNWvTEnI/AAAAAAAABqo/WhFNgZr8fQ0/s1600/fonctionmode.png', 'showInlineAds': false}], 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'author', 'label': '\u0643\u062a\u0628:'}, {'name': 'timestamp', 'label': '\u0622\u062e\u0631 \u062a\u062d\u062f\u064a\u062b:'}, {'name': 'comments', 'label': 'comments'}, {'name': 'share', 'label': ''}, {'name': 'backlinks', 'label': 'Links to this post'}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': '\u0627\u0644\u0642\u0633\u0645:'}]}], 'allBylineItems': [{'name': 'author', 'label': '\u0643\u062a\u0628:'}, {'name': 'timestamp', 'label': '\u0622\u062e\u0631 \u062a\u062d\u062f\u064a\u062b:'}, {'name': 'comments', 'label': 'comments'}, {'name': 'share', 'label': ''}, {'name': 'backlinks', 'label': 'Links to this post'}, {'name': 'labels', 'label': '\u0627\u0644\u0642\u0633\u0645:'}]}, {'title': '\u0623\u0639\u0644\u0627\u0646 \u0627\u0648\u0644 \u0627\u0644\u0645\u0648\u0636\u0648\u0639', 'type': 'HTML', 'sectionId': 'PostAds', 'id': 'HTML201'}, {'title': '\u0623\u0639\u0644\u0627\u0646 \u0645\u0646\u062a\u0635\u0641 \u0627\u0644\u0645\u0648\u0636\u0648\u0639', 'type': 'HTML', 'sectionId': 'PostAds', 'id': 'HTML202'}, {'title': '\u0623\u0639\u0644\u0627\u0646 \u0623\u062e\u0631 \u0627\u0644\u0645\u0648\u0636\u0648\u0639', 'type': 'HTML', 'sectionId': 'PostAds', 'id': 'HTML203'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0628\u0639\u062f \u0627\u0648\u0644 \u0641\u0642\u0631\u0629', 'type': 'HTML', 'sectionId': 'PostAds', 'id': 'HTML205'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0628\u0639\u062f \u062b\u0627\u0646\u064a \u0641\u0642\u0631\u0629', 'type': 'HTML', 'sectionId': 'PostAds', 'id': 'HTML206'}, {'title': '\u0627\u0639\u0644\u0627\u0646 \u0628\u0639\u062f \u062b\u0627\u0644\u062b \u0641\u0642\u0631\u0629', 'type': 'HTML', 'sectionId': 'PostAds', 'id': 'HTML207'}, {'title': '', 'type': 'PopularPosts', 'sectionId': 'sidepar', 'id': 'PopularPosts1', 'posts': [{'title': '\u0639\u0628\u0627\u0631\u0627\u062a \u0648\u0635\u0648\u0631 \u062a\u0647\u0646\u0626\u0629 \u0628\u0627\u0644\u064a\u0648\u0645 \u0627\u0644\u0639\u0627\u0644\u0645\u064a \u0644\u0644\u0645\u0631\u0623\u0629', 'id': 1804835354827545957}, {'title': '\u0637\u0631\u064a\u0642\u0629 \u0645\u0639\u0631\u0641\u0629 \u0631\u0642\u0645 \u0627\u0644\u0647\u0627\u062a\u0641 inwi \u0628\u0634\u0643\u0644 \u0633\u0647\u0644', 'id': 6265727169397040822}, {'title': '\u0646\u0627\u0641\u0639 \u0628\u0627\u0644\u0641\u0631\u0646\u0633\u064a\u0629 \u0645\u0639 \u0641\u0648\u0627\u0626\u062f\u0647 \u0627\u0644\u0635\u062d\u064a\u0629 \u0648\u0627\u0644\u063a\u0630\u0627\u0626\u064a\u0629', 'id': 5950892114281939492}, {'title': '\u0627\u0644\u0628\u0633\u0628\u0627\u0633 \u0628\u0627\u0644\u0641\u0631\u0646\u0633\u064a\u0629 \u0645\u0639 \u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0645\u0641\u064a\u062f\u0629 \u0639\u0646\u0647', 'id': 6049786124254316903}, {'title': '\u0627\u062f\u0648\u0627\u062a \u0627\u0644\u0637\u0628\u064a\u0628 \u0628\u0627\u0644\u0641\u0631\u0646\u0633\u064a\u0629 \u0641\u064a \u0631\u0633\u0648\u0645\u0627\u062a \u0648\u0635\u0648\u0631 \u062a\u0639\u0644\u064a\u0645\u064a\u0629', 'id': 4429307888201934157}, {'title': '\u062d\u0628\u0629 \u062d\u0644\u0627\u0648\u0629 \u0628\u0627\u0644\u0641\u0631\u0646\u0633\u064a\u0629 \u0648\u0645\u0639\u0644\u0648\u0645\u0627\u062a \u0645\u0641\u064a\u062f\u0629 \u0639\u0646\u0647\u0627', 'id': 5521226699380793442}]}]}]); _WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'pages', document.getElementById('PageList1'), {'title': '\u0627\u0644\u0635\u0641\u062d\u0627\u062a', 'links': [{'isCurrentPage': false, 'href': 'https://rtl-demo.seoplus-template.com/', 'title': '\u0627\u0644\u0635\u0641\u062d\u0629 \u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629'}, {'isCurrentPage': false, 'href': 'https://www.farawela.com/p/neomestafagmail.html', 'id': '1652617688631980730', 'title': '\u0627\u0644\u0625\u062a\u0635\u0627\u0644 \u0628\u0646\u0627 CONTACT US'}, {'isCurrentPage': false, 'href': 'https://www.farawela.com/p/blog-page_23.html', 'id': '5229010835314887409', 'title': '\u0633\u064a\u0627\u0633\u0629 \u0627\u0644\u062e\u0635\u0648\u0635\u064a\u0629 Privacy Policy'}, {'isCurrentPage': false, 'href': 'https://www.farawela.com/p/blog-page_28.html', 'id': '6519037400214557692', 'title': '\u0639\u0646 \u0645\u062f\u0648\u0646\u0629 \u0641\u0631\u0627\u0648\u0644\u0629'}], 'mobile': false}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'logo', document.getElementById('Header1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML100', 'Topa3lan-sc', document.getElementById('HTML100'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML101', 'Topa3lan-sc2', document.getElementById('HTML101'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'Tempnec', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/3855003450-lbx__ar.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/3268905543-lightbox_bundle_rtl.css'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML201', 'PostAds', document.getElementById('HTML201'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML202', 'PostAds', document.getElementById('HTML202'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML203', 'PostAds', document.getElementById('HTML203'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML205', 'PostAds', document.getElementById('HTML205'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML206', 'PostAds', document.getElementById('HTML206'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML207', 'PostAds', document.getElementById('HTML207'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts1', 'sidepar', document.getElementById('PopularPosts1'), {}, 'displayModeFull'));