{"id":2462,"date":"2024-04-13T05:52:41","date_gmt":"2024-04-13T04:52:41","guid":{"rendered":"https:\/\/mcqsadda.com\/?p=2462"},"modified":"2024-07-17T10:57:10","modified_gmt":"2024-07-17T09:57:10","slug":"microsoft-excel-set-5","status":"publish","type":"post","link":"https:\/\/mcqsadda.com\/index.php\/2024\/04\/13\/microsoft-excel-set-5\/","title":{"rendered":"Microsoft Excel Set -5"},"content":{"rendered":"\n<h1 class=\"wp-block-heading has-text-align-right has-vivid-purple-color has-text-color has-link-color has-larger-font-size wp-elements-b0802d754e08be2329fda82a7559ea25\"><a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/13\/microsoft-excel-set-4\/\" title=\"\">Prev<\/a>       <strong><a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/12\/microsoft-excel-set-1\/\" title=\"\">1<\/a>        <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/12\/microsoft-excel-set-2\/\" title=\"\">2<\/a>        <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/12\/microsoft-excel-set-3\/\" title=\"\">3<\/a>        <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/13\/microsoft-excel-set-4\/\" title=\"\">4<\/a><a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/03\/06\/introduction-to-computer-set-4\/\" title=\"\"> <\/a>       <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/13\/microsoft-excel-set-5\/\" title=\"\">5<\/a><\/strong>       Next<\/h1>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-16018d1d wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-vivid-green-cyan-background-color has-background has-text-align-left wp-element-button\" href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/13\/microsoft-excel-quiz-5\/\">mock test<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>41. <strong>\u00a0<\/strong>Which chart type is used to visually compare values across a few categories?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. <strong><strong>Area Chart<\/strong><\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Bar Chart<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Doughnut Chart<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Hierarchy Chart<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:B<BR>\nSOLUTION : In MS Excel, the Bar Chart is used to visually compare values across a few categories.\n <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>42. \u00a0Which chart type is used to show trends over time and categories?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Area Chart<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong><strong><strong><strong><strong>&nbsp;Bar Chart<\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. <strong>Doughnut Chart<\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. &nbsp;Hierarchy Chart<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:A<BR>\nSOLUTION: In MS Excel, the Bar Chart is used to show trends over time and categories.\n\n\n\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>43. <strong><strong>Which chart type is used to show the proportions of a while?<\/strong><\/strong><\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Area Chart<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong>Bar Chart<\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Doughnut Chart<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Hierarchy Chart<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:C<BR>\nSOLUTION: In MS Excel, the Doughnut Chart is used to show the proportions of a while. It can be used when the total of your numbers is 100%.\n  <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>44. <strong><strong>Which is not a Text function in MS Excel?<\/strong><\/strong><\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. CODE()<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. &nbsp;CLEAN()<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C.<\/strong> <strong>CHAR()<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. DB()<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:D<BR>\nSOLUTION: The DB() is a financial function, not a Text function, the rest of the others are text functions.\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>45. <strong><strong>\u00a0<\/strong><\/strong>\u00a0<strong>Which Excel function is used to get the discount rate for security?<\/strong><\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. DISCOUNT()<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. DISC()<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. DSC()<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. PERC()<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:B<BR>\nSOLUTION: The DISC() function is used to get the discount rate for security.\n <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>46. <strong>\u00a0<\/strong>\u00a0<strong>What is the keyboard shortcut to insert a new comment in a cell in MS Excel?<\/strong><\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. F2<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Ctrl + F2<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Alt + F2<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Shift + F2<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:D<BR>\nSOLUTION :The keyboard shortcut to insert a new comment in a cell is &#8220;Shift + F2&#8221;.\n\n\n <\/p> \n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>47. \u00a0<strong>What is the keyboard shortcut to insert a new sheet in the current workbook in MS Excel?<\/strong><\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. &nbsp;Shift + F9<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Shift + F10<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Shift + F12<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Shift + F11<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER: D<BR>\nSOLUTION:The keyboard shortcut to insert a new sheet in the current workbook is &#8220;Shift + F11&#8221;.\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>48. \u00a0Which option allows you to display all numbers which are less than 0 (negative numbers) in red color in MS Excel?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. <\/strong>&nbsp;<strong>Styling<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong>&nbsp;Conditional Formatting<\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Compare Formatting<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. <strong> <strong>Special Formatting<\/strong><\/strong><\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:B<BR>\nSOLUTION:By using the &#8220;Conditional Formatting&#8221; feature, we can apply special formatting based on the conditions.\n\n\n  <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>49.Under which menu, we can insert Header and Footer on the sheet?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Format<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong>Review<\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. &nbsp;Data<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Insert<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:D<BR>\nSOLUTION: The header and Footer option is available in the &#8220;Insert&#8221; Menu. We can insert the Header and Footer in the sheet by clicking on the &#8220;Header and Footer&#8221; option from &#8220;Text Group&#8221; in the &#8220;Insert&#8221; Menu.\n\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>50. Show\/Hide Gridlines option is available in the ____ Menu.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Page Layout<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Data<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Insert<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. <strong>Format<\/strong><\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:A<BR>\nSOLUTION: In the &#8220;Page Layout&#8221; Menu, the option to show\/hide gridlines available.\n\n<\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-buttons is-content-justification-center is-layout-flex wp-container-core-buttons-is-layout-16018d1d wp-block-buttons-is-layout-flex\">\n<div class=\"wp-block-button\"><a class=\"wp-block-button__link has-vivid-green-cyan-background-color has-background has-text-align-left wp-element-button\" href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/13\/microsoft-excel-quiz-5\/\">mock test<\/a><\/div>\n<\/div>\n\n\n\n<h1 class=\"wp-block-heading has-text-align-right has-vivid-purple-color has-text-color has-link-color has-larger-font-size wp-elements-b0802d754e08be2329fda82a7559ea25\"><a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/13\/microsoft-excel-set-4\/\" title=\"\">Prev<\/a>       <strong><a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/12\/microsoft-excel-set-1\/\" title=\"\">1<\/a>        <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/12\/microsoft-excel-set-2\/\" title=\"\">2<\/a>        <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/12\/microsoft-excel-set-3\/\" title=\"\">3<\/a>        <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/13\/microsoft-excel-set-4\/\" title=\"\">4<\/a><a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/03\/06\/introduction-to-computer-set-4\/\" title=\"\"> <\/a>       <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/13\/microsoft-excel-set-5\/\" title=\"\">5<\/a><\/strong>       Next<\/h1>\n","protected":false},"excerpt":{"rendered":"<p>Prev 1 2 3 4 5 Next 41. \u00a0Which chart type is used to visually compare values across a few categories? A. Area Chart B. Bar Chart C. Doughnut Chart D. Hierarchy Chart ANSWER &#038; SOLUTION ANSWER:B SOLUTION : In MS Excel, the Bar Chart is used to visually compare values across a few categories.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[5623,1594,1593,1590,1591,1587,1586,1585,1589,1588,1592],"class_list":{"0":"post-2462","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-computer","7":"tag-mcqs-for-sda-fda-pdo-vao-banking-kas-ias-ssc-gd-ssc-chsl-ssc-cgl-for-all-compitative-exams","8":"tag-show-hide-gridlines-option-is-available-in-the-____-menu","9":"tag-under-which-menu-we-can-insert-header-and-footer-on-the-sheet","10":"tag-what-is-the-keyboard-shortcut-to-insert-a-new-comment-in-a-cell-in-ms-excel","11":"tag-what-is-the-keyboard-shortcut-to-insert-a-new-sheet-in-the-current-workbook-in-ms-excel","12":"tag-which-chart-type-is-used-to-show-the-proportions-of-a-while","13":"tag-which-chart-type-is-used-to-show-trends-over-time-and-categories","14":"tag-which-chart-type-is-used-to-visually-compare-values-across-a-few-categories","15":"tag-which-excel-function-is-used-to-get-the-discount-rate-for-security","16":"tag-which-is-not-a-text-function-in-ms-excel","17":"tag-which-option-allows-you-to-display-all-numbers-which-are-less-than-0-negative-numbers-in-red-color-in-ms-excel"},"_links":{"self":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2462","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/comments?post=2462"}],"version-history":[{"count":3,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2462\/revisions"}],"predecessor-version":[{"id":3525,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2462\/revisions\/3525"}],"wp:attachment":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/media?parent=2462"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/categories?post=2462"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/tags?post=2462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}