{"id":14655,"date":"2024-04-15T04:36:46","date_gmt":"2024-04-15T04:36:46","guid":{"rendered":"https:\/\/exam.pscnotes.com\/mcq\/?p=14655"},"modified":"2024-04-15T04:36:46","modified_gmt":"2024-04-15T04:36:46","slug":"which-function-is-not-available-in-the-consolidate-dialog-box-a-pmt-b-average-c-max-d-sum","status":"publish","type":"post","link":"https:\/\/exam.pscnotes.com\/mcq\/which-function-is-not-available-in-the-consolidate-dialog-box-a-pmt-b-average-c-max-d-sum\/","title":{"rendered":"Which function is not available in the Consolidate dialog box? A. Pmt B. Average C. Max D. Sum"},"content":{"rendered":"<p>[amp_mcq option1=&#8221;Pmt&#8221; option2=&#8221;Average&#8221; option3=&#8221;Max&#8221; option4=&#8221;Sum&#8221; correct=&#8221;option1&#8243;]<!--more--><\/p>\n<p>The correct answer is A. Pmt.<\/p>\n<p>The Pmt function is used to calculate the periodic payment for a loan. It takes into account the loan amount, interest rate, and number of payments. The Consolidate dialog box is used to combine data from multiple worksheets into a single worksheet. It does not include the Pmt function because it is not a function that is used to consolidate data.<\/p>\n<p>The other options, B. Average, C. Max, and D. Sum, are all functions that are available in the Consolidate dialog box. They can be used to calculate the average, maximum, or sum of the values in a range of cells.<\/p>\n<p>I hope this helps!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>[amp_mcq option1=&#8221;Pmt&#8221; option2=&#8221;Average&#8221; option3=&#8221;Max&#8221; option4=&#8221;Sum&#8221; correct=&#8221;option1&#8243;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[668],"tags":[],"class_list":["post-14655","post","type-post","status-publish","format-standard","hentry","category-ms-excel","no-featured-image-padding"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.2 (Yoast SEO v23.3) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Which function is not available in the Consolidate dialog box? A. Pmt B. Average C. Max D. Sum<\/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\/which-function-is-not-available-in-the-consolidate-dialog-box-a-pmt-b-average-c-max-d-sum\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Which function is not available in the Consolidate dialog box? A. Pmt B. Average C. Max D. Sum\" \/>\n<meta property=\"og:description\" content=\"[amp_mcq option1=&#8221;Pmt&#8221; option2=&#8221;Average&#8221; option3=&#8221;Max&#8221; option4=&#8221;Sum&#8221; correct=&#8221;option1&#8243;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exam.pscnotes.com\/mcq\/which-function-is-not-available-in-the-consolidate-dialog-box-a-pmt-b-average-c-max-d-sum\/\" \/>\n<meta property=\"og:site_name\" content=\"MCQ and Quiz for Exams\" \/>\n<meta property=\"article:published_time\" content=\"2024-04-15T04:36:46+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":"Which function is not available in the Consolidate dialog box? A. Pmt B. Average C. Max D. Sum","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\/which-function-is-not-available-in-the-consolidate-dialog-box-a-pmt-b-average-c-max-d-sum\/","og_locale":"en_US","og_type":"article","og_title":"Which function is not available in the Consolidate dialog box? A. Pmt B. Average C. Max D. Sum","og_description":"[amp_mcq option1=&#8221;Pmt&#8221; option2=&#8221;Average&#8221; option3=&#8221;Max&#8221; option4=&#8221;Sum&#8221; correct=&#8221;option1&#8243;]","og_url":"https:\/\/exam.pscnotes.com\/mcq\/which-function-is-not-available-in-the-consolidate-dialog-box-a-pmt-b-average-c-max-d-sum\/","og_site_name":"MCQ and Quiz for Exams","article_published_time":"2024-04-15T04:36:46+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\/which-function-is-not-available-in-the-consolidate-dialog-box-a-pmt-b-average-c-max-d-sum\/","url":"https:\/\/exam.pscnotes.com\/mcq\/which-function-is-not-available-in-the-consolidate-dialog-box-a-pmt-b-average-c-max-d-sum\/","name":"Which function is not available in the Consolidate dialog box? A. Pmt B. Average C. Max D. Sum","isPartOf":{"@id":"https:\/\/exam.pscnotes.com\/mcq\/#website"},"datePublished":"2024-04-15T04:36:46+00:00","dateModified":"2024-04-15T04:36:46+00:00","author":{"@id":"https:\/\/exam.pscnotes.com\/mcq\/#\/schema\/person\/5807dafeb27d2ec82344d6cbd6c3d209"},"breadcrumb":{"@id":"https:\/\/exam.pscnotes.com\/mcq\/which-function-is-not-available-in-the-consolidate-dialog-box-a-pmt-b-average-c-max-d-sum\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exam.pscnotes.com\/mcq\/which-function-is-not-available-in-the-consolidate-dialog-box-a-pmt-b-average-c-max-d-sum\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/exam.pscnotes.com\/mcq\/which-function-is-not-available-in-the-consolidate-dialog-box-a-pmt-b-average-c-max-d-sum\/#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 excel","item":"https:\/\/exam.pscnotes.com\/mcq\/category\/mcq\/computer-fundamentals\/ms-excel\/"},{"@type":"ListItem","position":5,"name":"Which function is not available in the Consolidate dialog box? A. Pmt B. Average C. Max D. Sum"}]},{"@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\/14655","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=14655"}],"version-history":[{"count":0,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/posts\/14655\/revisions"}],"wp:attachment":[{"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/media?parent=14655"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/categories?post=14655"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/exam.pscnotes.com\/mcq\/wp-json\/wp\/v2\/tags?post=14655"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}