{"id":16143,"date":"2024-04-15T04:56:42","date_gmt":"2024-04-15T04:56:42","guid":{"rendered":"https:\/\/exam.pscnotes.com\/mcq\/?p=16143"},"modified":"2024-04-15T04:56:42","modified_gmt":"2024-04-15T04:56:42","slug":"how-do-you-filter-by-selection-a-right-click-the-field-value-and-select-filter-by-selection-from-the-shortcut-menu-b-find-and-double-click-the-value-on-which-you-want-to-base-the-filter-c-find-and","status":"publish","type":"post","link":"https:\/\/exam.pscnotes.com\/mcq\/how-do-you-filter-by-selection-a-right-click-the-field-value-and-select-filter-by-selection-from-the-shortcut-menu-b-find-and-double-click-the-value-on-which-you-want-to-base-the-filter-c-find-and\/","title":{"rendered":"how do you filter by selection? A. Right click the field value and select filter by selection from the shortcut menu B. Find and double click the value on which you want to base the filter C. Find and select the value on which you want to base the filter and select tools>filter by selection from the menu D. None"},"content":{"rendered":"

[amp_mcq option1=”Right click the field value and select filter by selection from the shortcut menu” option2=”Find and double click the value on which you want to base the filter” option3=”Find and select the value on which you want to base the filter and select tools>filter by selection from the menu” option4=”nan” correct=”option3″]<\/p>\n

The correct answer is: C. Find and select the value on which you want to base the filter and select tools>filter by selection from the menu.<\/p>\n

To filter by selection, follow these steps:<\/p>\n

    \n
  1. In the table, find the value that you want to use to filter the data.<\/li>\n
  2. Select the value.<\/li>\n
  3. On the Data tab, in the Sort & Filter group, click Filter.<\/li>\n
  4. In the Filter by Selection list, click the value that you want to filter the data by.<\/li>\n<\/ol>\n

    The following are the other options and their explanations:<\/p>\n

    A. Right click the field value and select filter by selection from the shortcut menu. This option is incorrect because you need to select the value first before you can right-click it.
    \nB. Find and double click the value on which you want to base the filter. This option is incorrect because you need to select the value first before you can double-click it.
    \nD. None. This option is incorrect because it is not a valid way to filter by selection.<\/p>\n","protected":false},"excerpt":{"rendered":"

    [amp_mcq option1=”Right click the field value and select filter by selection from the shortcut menu” option2=”Find and double click the value on which you want to base the filter” option3=”Find and select the value on which you want to base the filter and select tools>filter by selection from the menu” option4=”nan” correct=”option3″]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[672],"tags":[],"class_list":["post-16143","post","type-post","status-publish","format-standard","hentry","category-ms-access","no-featured-image-padding"],"yoast_head":"\nhow do you filter by selection? A. Right click the field value and select filter by selection from the shortcut menu B. Find and double click the value on which you want to base the filter C. Find and select the value on which you want to base the filter and select tools>filter by selection from the menu D. None<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exam.pscnotes.com\/mcq\/how-do-you-filter-by-selection-a-right-click-the-field-value-and-select-filter-by-selection-from-the-shortcut-menu-b-find-and-double-click-the-value-on-which-you-want-to-base-the-filter-c-find-and\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"how do you filter by selection? A. Right click the field value and select filter by selection from the shortcut menu B. Find and double click the value on which you want to base the filter C. Find and select the value on which you want to base the filter and select tools>filter by selection from the menu D. None\" \/>\n<meta property=\"og:description\" content=\"[amp_mcq option1=”Right click the field value and select filter by selection from the shortcut menu” option2=”Find and double click the value on which you want to base the filter” option3=”Find and select the value on which you want to base the filter and select tools>filter by selection from the menu” option4=”nan” correct=”option3″]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exam.pscnotes.com\/mcq\/how-do-you-filter-by-selection-a-right-click-the-field-value-and-select-filter-by-selection-from-the-shortcut-menu-b-find-and-double-click-the-value-on-which-you-want-to-base-the-filter-c-find-and\/\" \/>\n<meta property=\"og:site_name\" content=\"MCQ and Quiz for Exams\" \/>\n<meta property=\"article:published_time\" content=\"2024-04-15T04:56:42+00:00\" \/>\n<meta name=\"author\" content=\"rawan239\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"rawan239\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"how do you filter by selection? A. Right click the field value and select filter by selection from the shortcut menu B. Find and double click the value on which you want to base the filter C. Find and select the value on which you want to base the filter and select tools>filter by selection from the menu D. None","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exam.pscnotes.com\/mcq\/how-do-you-filter-by-selection-a-right-click-the-field-value-and-select-filter-by-selection-from-the-shortcut-menu-b-find-and-double-click-the-value-on-which-you-want-to-base-the-filter-c-find-and\/","og_locale":"en_US","og_type":"article","og_title":"how do you filter by selection? A. Right click the field value and select filter by selection from the shortcut menu B. Find and double click the value on which you want to base the filter C. Find and select the value on which you want to base the filter and select tools>filter by selection from the menu D. None","og_description":"[amp_mcq option1=”Right click the field value and select filter by selection from the shortcut menu” option2=”Find and double click the value on which you want to base the filter” option3=”Find and select the value on which you want to base the filter and select tools>filter by selection from the menu” option4=”nan” correct=”option3″]","og_url":"https:\/\/exam.pscnotes.com\/mcq\/how-do-you-filter-by-selection-a-right-click-the-field-value-and-select-filter-by-selection-from-the-shortcut-menu-b-find-and-double-click-the-value-on-which-you-want-to-base-the-filter-c-find-and\/","og_site_name":"MCQ and Quiz for Exams","article_published_time":"2024-04-15T04:56:42+00:00","author":"rawan239","twitter_card":"summary_large_image","twitter_misc":{"Written by":"rawan239","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exam.pscnotes.com\/mcq\/how-do-you-filter-by-selection-a-right-click-the-field-value-and-select-filter-by-selection-from-the-shortcut-menu-b-find-and-double-click-the-value-on-which-you-want-to-base-the-filter-c-find-and\/","url":"https:\/\/exam.pscnotes.com\/mcq\/how-do-you-filter-by-selection-a-right-click-the-field-value-and-select-filter-by-selection-from-the-shortcut-menu-b-find-and-double-click-the-value-on-which-you-want-to-base-the-filter-c-find-and\/","name":"how do you filter by selection? A. Right click the field value and select filter by selection from the shortcut menu B. Find and double click the value on which you want to base the filter C. Find and select the value on which you want to base the filter and select tools>filter by selection from the menu D. None","isPartOf":{"@id":"https:\/\/exam.pscnotes.com\/mcq\/#website"},"datePublished":"2024-04-15T04:56:42+00:00","dateModified":"2024-04-15T04:56:42+00:00","author":{"@id":"https:\/\/exam.pscnotes.com\/mcq\/#\/schema\/person\/5807dafeb27d2ec82344d6cbd6c3d209"},"breadcrumb":{"@id":"https:\/\/exam.pscnotes.com\/mcq\/how-do-you-filter-by-selection-a-right-click-the-field-value-and-select-filter-by-selection-from-the-shortcut-menu-b-find-and-double-click-the-value-on-which-you-want-to-base-the-filter-c-find-and\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exam.pscnotes.com\/mcq\/how-do-you-filter-by-selection-a-right-click-the-field-value-and-select-filter-by-selection-from-the-shortcut-menu-b-find-and-double-click-the-value-on-which-you-want-to-base-the-filter-c-find-and\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/exam.pscnotes.com\/mcq\/how-do-you-filter-by-selection-a-right-click-the-field-value-and-select-filter-by-selection-from-the-shortcut-menu-b-find-and-double-click-the-value-on-which-you-want-to-base-the-filter-c-find-and\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/exam.pscnotes.com\/mcq\/"},{"@type":"ListItem","position":2,"name":"mcq","item":"https:\/\/exam.pscnotes.com\/mcq\/category\/mcq\/"},{"@type":"ListItem","position":3,"name":"Computer fundamentals","item":"https:\/\/exam.pscnotes.com\/mcq\/category\/mcq\/computer-fundamentals\/"},{"@type":"ListItem","position":4,"name":"Ms access","item":"https:\/\/exam.pscnotes.com\/mcq\/category\/mcq\/computer-fundamentals\/ms-access\/"},{"@type":"ListItem","position":5,"name":"how do you filter by selection? A. Right click the field value and select filter by selection from the shortcut menu B. Find and double click the value on which you want to base the filter C. Find and select the value on which you want to base the filter and select tools>filter by selection from the menu D. None"}]},{"@type":"WebSite","@id":"https:\/\/exam.pscnotes.com\/mcq\/#website","url":"https:\/\/exam.pscnotes.com\/mcq\/","name":"MCQ and Quiz for Exams","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exam.pscnotes.com\/mcq\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/exam.pscnotes.com\/mcq\/#\/schema\/person\/5807dafeb27d2ec82344d6cbd6c3d209","name":"rawan239","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/exam.pscnotes.com\/mcq\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/761a7274f9cce048fa5b921221e7934820d74514df93ef195a9d22af0c1c9001?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/761a7274f9cce048fa5b921221e7934820d74514df93ef195a9d22af0c1c9001?s=96&d=mm&r=g","caption":"rawan239"},"sameAs":["https:\/\/exam.pscnotes.com"],"url":"https:\/\/exam.pscnotes.com\/mcq\/author\/rawan239\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/posts\/16143","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/comments?post=16143"}],"version-history":[{"count":0,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/posts\/16143\/revisions"}],"wp:attachment":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/media?parent=16143"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/categories?post=16143"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/tags?post=16143"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}