{"id":17707,"date":"2022-04-08T10:56:03","date_gmt":"2022-04-08T05:26:03","guid":{"rendered":"https:\/\/scholarsclasses.com\/blog\/?p=17707"},"modified":"2025-01-03T12:18:09","modified_gmt":"2025-01-03T06:48:09","slug":"mcqs-on-ms-excel","status":"publish","type":"post","link":"https:\/\/scholarsclasses.com\/blog\/mcqs-on-ms-excel\/","title":{"rendered":"50+ MCQ&#8217;s On MS-Excel | Computer Systems and Applications"},"content":{"rendered":"\n<h2 class=\"wp-block-heading has-text-align-center\"><strong style=\"white-space: normal;\"><strong style=\"white-space: normal;\">MCQ&#8217;s On MS-Exce<\/strong><\/strong>l<\/h2>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"1024\" height=\"576\" data-src=\"https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/04\/MCQ_s-On-MS-Excel-1024x576.webp\" alt=\"MCQ&#039;s On MS-Excel\" class=\"wp-image-17722 lazyload\" title=\"\" data-srcset=\"https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/04\/MCQ_s-On-MS-Excel-1024x576.webp 1024w, https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/04\/MCQ_s-On-MS-Excel-300x169.webp 300w, https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/04\/MCQ_s-On-MS-Excel-768x432.webp 768w, https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/04\/MCQ_s-On-MS-Excel-1536x864.webp 1536w, https:\/\/scholarsclasses.com\/blog\/wp-content\/uploads\/2022\/04\/MCQ_s-On-MS-Excel.webp 1920w\" data-sizes=\"(max-width: 1024px) 100vw, 1024px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 1024px; --smush-placeholder-aspect-ratio: 1024\/576;\" \/><figcaption class=\"wp-element-caption\">MCQ&#8217;s On MS-Excel<\/figcaption><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/scholarsclasses.com\/blog\/tybcom-sem-6-computer-systems-and-applications-mcq\/\"><strong>MCQs on other topics of Computer Systems and Applications<\/strong><\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/www.icsi.edu\/media\/webmodules\/modelquestionpaper\/CMA-MCQ%20100.pdf\" data-type=\"URL\" data-id=\"https:\/\/www.icsi.edu\/media\/webmodules\/modelquestionpaper\/CMA-MCQ%20100.pdf\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>Cost Accounting MCQs pdf <\/strong><\/a><\/li>\n<\/ul>\n\n\n\n<p><strong>1. 15-August-2020 was Saturday. Answer of =WEEKDAY(\u201c15-August-2020\u201d) will be_____<br><\/strong>(a) Saturday <br>(b) Sat <br>(c) 7 <br>(d) 6<\/p>\n\n\n\n<p><strong>2. 15-August-2020 was Saturday. Answer of =MONTH(\u201c15-August-2020\u201d) will be ________<br><\/strong>(a) August <br>(b) Aug <br>(c) 8 <br>(d) 7<\/p>\n\n\n\n<p><strong>3. 15-August-2020 was Saturday. Answer of =YEAR(\u201c15-August-2020\u201d) will be ________<br><\/strong>(a) 2020 <br>(b)1920 <br>(c) 20 <br>(d) 2200<\/p>\n\n\n\n<p><strong>4. Answer of =DAYS360(\u201c1-Jan-2020\u201d, \u201c31-Dec-2020\u201d) will be ________<br><\/strong>(a) 365 <br>(b) 366 <br>(c) 360 <br>(d) 364<\/p>\n\n\n\n<p><strong>5. Answer of =YEAR(\u201c15-Aug-20\u201d) will be<br><\/strong>(a) 20 <br>(b) 2020 <br>(c) 1920 <br>(d) 2200<\/p>\n\n\n\n<p><strong>6. Answer of =TIMEVALUE(\u201c6:00 PM\u201d) will be ________<br><\/strong>(a) 6:00 <br>(b) 6:00 AM <br>(c) 18:00 <br>(d) 0.75<\/p>\n\n\n\n<p><strong>7. TODAY( ) returns current ______<br><\/strong>(a) Date <br>(b) Time <br>(c) Day <br>(d) Date &amp; Time<\/p>\n\n\n\n<p><strong>8. Answer of =DAYS360(\u201c31-Dec-2020\u201d, \u201c1-Jan-2020\u201d) will be ________<br><\/strong>(a) 365 <br>(b) 366 <br>(c) 360 <br>(d) -360<\/p>\n\n\n\n<p><strong>9. To extract 3 characters starting from 2nd&nbsp;character of a string \u201cEXCEL\u201d we use _______<br><\/strong>(a) =MID(\u201cEXCEL\u201d,3,2) <br>(b) =MID(\u201cEXCEL\u201d,2,3) <br>(c) =MID(\u201cEXCEL\u201d,2,5)<br>(d) =MID(\u201cEXCEL\u201d,5,2)<\/p>\n\n\n\n<p><strong>10. To convert uppercase alphabets to lowercase we use _____<br><\/strong>(a) LCASE( ) <br>(b) LOWER( ) <br>(c) UPPER( ) <br>(d) UCASE( )<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>Answers:<\/strong> <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\"><strong>1-c, 2-c, 3-a, 4-c, 5-b, 6-d, 7-a, 8-d, 9-b, 10-b<\/strong><\/mark><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>11. To find number of characters in a string we use _____<br><\/strong>(a) COUNT( ) <br>(b) LEN( ) <br>(c) LENGTH( ) <br>(d) SUM( )<\/p>\n\n\n\n<p><strong>12. To search a value in the leftmost column of a given range, we use _______<br><\/strong>(a) VLOOKUP( ) <br>(b) HLOOKUP( ) <br>(c) SEARCH( ) <br>(d) LOCATE( )<\/p>\n\n\n\n<p><strong>13. To search a value in the first row of a given range, we use _______.<br><\/strong>(a)VLLOKUP( ) <br>(b) HLOOKUP( ) <br>(c) SEARCH( ) <br>(d) LOCATE( )<\/p>\n\n\n\n<p><strong>14. To count non blank cells, we use _____.<br><\/strong>(a) COUNT( ) <br>(b) COUNTA( ) <br>(c) COUNTBLANK( ) <br>(d) COUNTNONBLANK( )&nbsp;<\/p>\n\n\n\n<p><strong>15. To count number of cells that contains numbers, we use _____.<br><\/strong>(a) COUNT( ) <br>(b) COUNTA( ) <br>(c) SUM( ) <br>(d) COUNTIF( )<\/p>\n\n\n\n<p><strong>16. Which of the following is not a valid chart type in Excel.<br><\/strong>(a) Line <br>(b) Bar <br>(c) Pie <br>(d) Graph<\/p>\n\n\n\n<p><strong>17. Axis Title is not allowed in this type of graphs.<br><\/strong>(a) Line <br>(b) Bar <br>(c) Column <br>(d) Pie<\/p>\n\n\n\n<p><strong>18. Select odd man out from the following graph types.<br><\/strong>(a) Line <br>(b) Bar <br>(c) Column <br>(d) Pie<\/p>\n\n\n\n<p><strong>19. Charts are available under _______ Ribbon\/Menu.<br><\/strong>(a) Home <br>(b) Insert <br>(c) Data <br>(d) View<\/p>\n\n\n\n<p><strong>20. Goal Seek Option is available under ____ Ribbon\/Menu.<br><\/strong>(a) Home <br>(b) Insert <br>(c) Data <br>(d) View<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>Answers:<\/strong> <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">11-b, 12-a, 13-b, 14-b, 15-a, 16-d, 17-d, 18-d, 19-b, 20-c<\/mark><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>21.Number of changing cells for a Scenario is limited to ____<br><\/strong>(a) 16 <br>(b) 32 <br>(c) 1 <br>(d) 2<\/p>\n\n\n\n<p><strong>22. Number of changing cells for a Goal Seek is limited to ______<br><\/strong>(a) 16 <br>(b) 32 <br>(c) 1 <br>(d) 2<\/p>\n\n\n\n<p><strong>23. Solver Option is available under ____ Ribbon\/Menu.<br><\/strong>(a) Developer <br>(b) Data <br>(c) Insert <br>(d) Home<\/p>\n\n\n\n<p><strong>24. Record Macro option is available under ____ Ribbon\/Menu.<br><\/strong>(a) Developer <br>(b) Data <br>(c) Insert <br>(d) Home<\/p>\n\n\n\n<p><strong>25. Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2)?&nbsp;<br><\/strong>(a) A2 <br>(b) A <br>(c) CO <br>(d) C<\/p>\n\n\n\n<p><strong>26. Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(\u201cA2\u201d)?&nbsp;<br><\/strong>(a) A2 <br>(b) A <br>(c) CO<br>(d) C<\/p>\n\n\n\n<p><strong>27. Cell A2 contains a text COMPUTER. What will be the answer of =LEFT(A2, 3)?&nbsp;<br><\/strong>(a) A2 <br>(b) ER <br>(c) CO <br>(d) COM<\/p>\n\n\n\n<p><strong>28. What will be the answer of =DAYS360(\u201c1-Feb-2020\u201d, \u201c1-Mar-2020\u201d)?<br><\/strong>(a) 28 <br>(b) 29 <br>(c) 30 <br>(d) 31<\/p>\n\n\n\n<p><strong>29. What will be the answer of =DATEVALUE(\u201c1-Feb-1900\u201d)?<br><\/strong>(a) 1 <br>(b) 32 <br>(c) 30 <br>(d) One<\/p>\n\n\n\n<p><strong>30. What will be the answer of =TIMEVALUE(\u201c12:00 PM\u201d)?<br><\/strong>(a) 12.00 <br>(b) 12 <br>(c) 0.5 <br>(d) 0.25<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>Answers:<\/strong> <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">21-b, 22-c, 23-b, 24-a, 25-d, 26-b, 27-d, 28-c, 29-b, 30-c<\/mark><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>31. What will be the answer of =MONTH(32)?<br><\/strong>(a) 2 <br>(b) 3 <br>(c) 8 <br>(d) 9<\/p>\n\n\n\n<p><strong>32. What will be the answer of =DAY(32)?<br><\/strong>(a) 1 <br>(b) 2 <br>(c) 3 <br>(d) 4&nbsp;<\/p>\n\n\n\n<p><strong>33. What will be the answer of =YEAR(32)?<br><\/strong>(a) 1932 <br>(b) 2032 <br>(c) 1990 <br>(d) 1900<\/p>\n\n\n\n<p><strong>34. If cell B1 contains text MUMBAI then what will be the answer of =LOWER(B1)?<br><\/strong>(a) Mumbai <br>(b) mumbai <br>(c) b1 <br>(d) b<\/p>\n\n\n\n<p><strong>35. What will be the answer of =PROPER(\u201cverus d\u2019sa\u201d)?<br><\/strong>(a) Verus d\u2019sa <br>(b) Verus D\u2019sa <br>(c) Verus D\u2019Sa <br>(d) VERUS D\u2019SA<\/p>\n\n\n\n<p><strong>36. What will be the answer of =MID(\u201cCOMMERCE\u201d,3,2)?<br><\/strong>(a) OMM <br>(b) MME <br>(c) MM <br>(d) ER<\/p>\n\n\n\n<p><strong>37. Excel formula cannot start with ____<br><\/strong>(a) + <br>(b) &#8211; <br>(c) * <br>(d) =<\/p>\n\n\n\n<p><strong>38. Which of the following is an invalid arithmetic operator?<br><\/strong>(a) + <br>(b) &#8211; <br>(c)&nbsp;\uf0b8&nbsp;<br>(d) ^<\/p>\n\n\n\n<p><strong>39. Which of the following is an invalid comparison operator?<br><\/strong>(a) &gt; <br>(b) &lt; <br>(c) &lt;&gt; <br>(d)&nbsp;\uf0b9<\/p>\n\n\n\n<p><strong>40. If cell A1 contains a number 100, then what will be the answer of =IF(A1&lt; 200, A1+10, A1-10)?<br><\/strong>(a) 90 <br>(b) 110 <br>(c) 190 <br>(d) 210<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>Answers:<\/strong> <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">31-a, 32-a, 33-d, 34-b, 35-c, 36-c, 37-c, 38-c, 39-d, 40-b<\/mark><\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><strong>41. When we want to hide the records which are not satisfying a given condition, then we use________ command.<br><\/strong>(a) Sort <br>(b) Filter <br>(c) Goal Seek <br>(d) Solver<\/p>\n\n\n\n<p><strong>42. We can add constraints while using __________ command.<br><\/strong>(a) Goal Seek <br>(b) Solver <br>(c) Scenario Manager <br>(d) Data Table<\/p>\n\n\n\n<p><strong>43. By default extension for template file is _______<br><\/strong>(a) .temp <br>(b) .xltx <br>(c) .tem <br>(d). xlsx<\/p>\n\n\n\n<p><strong>44. Excel macros can be edited using _______ editor.<br><\/strong>(a) Visual Basic <br>(b) Excel <br>(c) C <br>(d) Java<\/p>\n\n\n\n<p><strong>45. To make data interesting, attractive and easy to read and evaluate, we use ______<br><\/strong>(a) Graphs <br>(b) Filter <br>(c) Scenario <br>(d) Solver<\/p>\n\n\n\n<p><strong>46. _____ graph allows only one range of values.<br><\/strong>(a) Bar <br>(b) Line <br>(c) Column <br>(d) Pie<\/p>\n\n\n\n<p><strong>47. Gridlines are not allowed for ___ type of graphs.<br><\/strong>(a) Bar <br>(b) Line <br>(c) Column <br>(d) Pie<\/p>\n\n\n\n<p><strong>48. With Numeric Filters ______ operation is not allowed.<br><\/strong>(a) Top 10 <br>(b) Above Average <br>(c) Greater Than <br>(d) Begins With<\/p>\n\n\n\n<p><strong>49. With Text Filters _____ operation is not allowed.<br><\/strong>(a) Begins With <br>(b) Ends With <br>(c) Above Average <br>(d) Contains<\/p>\n\n\n\n<p><strong>50. Which of the following function is invalid.<br><\/strong>(a) SUMIF( ) <br>(b) AVGIF( ) <br>(c) COUNTIF( ) <br>(d) IF( )<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\"><strong>Answers:<\/strong> <mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-vivid-red-color\">41-b, 42-b, 43-b, 44-a, 45-a, 46-d, 47-d, 48-d, 49-c, 50-b<\/mark><\/td><\/tr><\/tbody><\/table><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":17722,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2,7],"tags":[4813],"class_list":["post-17707","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bcom","category-degree-college","tag-mcqs-on-ms-excel"],"_links":{"self":[{"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/posts\/17707","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/comments?post=17707"}],"version-history":[{"count":2,"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/posts\/17707\/revisions"}],"predecessor-version":[{"id":36225,"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/posts\/17707\/revisions\/36225"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/media\/17722"}],"wp:attachment":[{"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/media?parent=17707"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/categories?post=17707"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scholarsclasses.com\/blog\/wp-json\/wp\/v2\/tags?post=17707"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}