{"id":16617,"date":"2019-01-01T18:32:56","date_gmt":"2019-01-01T18:32:56","guid":{"rendered":"https:\/\/prepistan.com\/blog\/?p=16617"},"modified":"2019-01-01T18:32:56","modified_gmt":"2019-01-01T18:32:56","slug":"excel-mcqs-quiz-computer-science-vol-2","status":"publish","type":"post","link":"https:\/\/prepistan.com\/blog\/excel-mcqs-quiz-computer-science-vol-2\/","title":{"rendered":"Excel MCQs Quiz Computer Science vol 2"},"content":{"rendered":"<p>Excel MCQs Quiz. This MCQs set of Computer Science on Microsoft Excel covers objective type questions important information about excel spreadsheet its history, shortcut keys and all its versions which\u00a0 will be helpful\u00a0 in preparation of public and civil service exams .<\/p>\n<p>&nbsp;<\/p>\n<p><strong>1.<\/strong>\u00a0<strong> Which shortcut Keys are used to select all contents of Excel Sheet?<\/strong><br \/>\n<strong>(A) CTRL+A<\/strong><br \/>\n(B) CTRL+B<br \/>\n(C) CTRL+C<br \/>\n(D) CTRL+V<\/p>\n<p><strong>2. Which shortcut Key is used to save the opened Work Sheet?<\/strong><br \/>\n(A) CTRL+D<br \/>\n<strong>(B) CTRL+S<\/strong><br \/>\n(C) SHIFT+S<br \/>\n(D) None of These<\/p>\n<p><strong>3. Which shortcut keys are used to undo the last action?<\/strong><br \/>\n<strong>(A) CTRL+Z<\/strong><br \/>\n(B) CTRL+Y<br \/>\n(C) Both A &amp; B<br \/>\n(D) all of the above<\/p>\n<p><strong>4<\/strong>.\u00a0 <strong>Which shortcut keys are used to Bold the highlighted Selection?<\/strong><br \/>\n(A) CTRL+A<br \/>\n<strong>(B) CTRL+B<\/strong><br \/>\n(C) CTRL+C<br \/>\n(D) None of the above<\/p>\n<p><strong>5.<\/strong>\u00a0<strong>Which shortcut keys are used to underline the highlighted selection?<\/strong><br \/>\n<strong>(A) CTRL+U<\/strong><br \/>\n(B) CTRL+B<br \/>\n(C) CTRL+S<br \/>\n(D) None of the above<\/p>\n<p><strong>6.<\/strong>\u00a0<strong> In Excel 2016 which shortcut Keys are used to change the format of selected cells?\u00a0<\/strong><br \/>\n(A) CTRL+100<br \/>\n(B) CTRL+10<br \/>\n<strong>(C) CTRL+1<\/strong><br \/>\n(D) None of the above<\/p>\n<p><strong>7. Which shortcut keys are used to insert a hyperlink in Microsoft Excel?<\/strong><br \/>\n(A) Ctrl+T<br \/>\n(B) Ctrl+M<br \/>\n<strong>(C) Ctrl+K<\/strong><br \/>\n(D) None of the above<\/p>\n<p><strong>8. Which Shortcut keys are used to strikethrough highlighted selection in Excel?<\/strong><br \/>\n(A) Ctrl+4<br \/>\n<strong>(B) Ctrl+5<\/strong><br \/>\n(C) Ctrl+6<br \/>\n(D) None of the above<\/p>\n<p><strong>9.\u00a0 Which shortcut keys are used to create a formula for addition of the contents of above cells?<\/strong><br \/>\n<strong>(A) Alt+=<\/strong><br \/>\n(B) Ctrl+=<br \/>\n(C) Shift+=<br \/>\n(D) None of these<\/p>\n<p><strong>10. In Ms Excel 2016 Ctrl+Space shortcut keys are used to _______?<\/strong><br \/>\n(A) Select Entire Row<br \/>\n<strong>(B) Select Entire Column<\/strong><br \/>\n(C) Selection Entire Rows and Columns<br \/>\n(D) None of the above<\/p>\n<p><strong>11.<\/strong>\u00a0 <strong>In\u00a0MS Excel 2016 Shift+Space shortcut Keys are used to _______\u00a0?<\/strong><br \/>\n<strong>(A) Select Entire Row<\/strong><br \/>\n(B) Select Entire Column<br \/>\n(C) Both A &amp; B<br \/>\n(D) None of These<\/p>\n<p><strong>12. ctrl+-\u00a0 shortcut keys in MS Excel are used to _____?<\/strong><br \/>\n(A) delete selected column<br \/>\n(B) delete selected row<br \/>\n<strong>(C) Both A &amp; B<\/strong><br \/>\n(D) None of These<\/p>\n<p><strong>13. Ctrl+Shift+1 shortcut Keys in excel are used to ______?<\/strong><br \/>\n<strong>(A) format number in comma format<\/strong><br \/>\n(B) format number in currency format<br \/>\n(C) format number in date format<br \/>\n(D) format number in time format<\/p>\n<p><strong>14<\/strong>.\u00a0 <strong>Ctrl+Shift+2 Shortcut Keys in excel are used to ________?<\/strong><br \/>\n(A) format number in percentage format<br \/>\n(B) format number in currency format<br \/>\n<strong>(C) format number in time format<\/strong><br \/>\n(D) None of the above<\/p>\n<p><strong>15.<\/strong>\u00a0<strong>Which shortcut keys are used to move the cursor to cell A1 in Excel?<\/strong><br \/>\n(A) Ctrl+Windows Key<br \/>\n(B) Ctrl+ end Key<br \/>\n<strong>(C) Ctrl+Home Key<\/strong><br \/>\n(D) All of the above<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel MCQs Quiz. This MCQs set of Computer Science on Microsoft Excel covers objective type questions important information about excel spreadsheet its history, shortcut keys and all its versions which\u00a0 will be helpful\u00a0 in preparation of public and civil service exams . &nbsp; 1.\u00a0 Which shortcut Keys are used to select all contents of Excel [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[68],"tags":[759],"class_list":{"0":"post-16617","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-computer-mcqs","7":"tag-ms-excel-quiz"},"_links":{"self":[{"href":"https:\/\/prepistan.com\/blog\/wp-json\/wp\/v2\/posts\/16617","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prepistan.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prepistan.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prepistan.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/prepistan.com\/blog\/wp-json\/wp\/v2\/comments?post=16617"}],"version-history":[{"count":0,"href":"https:\/\/prepistan.com\/blog\/wp-json\/wp\/v2\/posts\/16617\/revisions"}],"wp:attachment":[{"href":"https:\/\/prepistan.com\/blog\/wp-json\/wp\/v2\/media?parent=16617"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prepistan.com\/blog\/wp-json\/wp\/v2\/categories?post=16617"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prepistan.com\/blog\/wp-json\/wp\/v2\/tags?post=16617"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}