{"id":2447,"date":"2024-04-13T05:30:58","date_gmt":"2024-04-13T04:30:58","guid":{"rendered":"https:\/\/mcqsadda.com\/?p=2447"},"modified":"2024-07-17T10:52:31","modified_gmt":"2024-07-17T09:52:31","slug":"microsoft-excel-set-4","status":"publish","type":"post","link":"https:\/\/mcqsadda.com\/index.php\/2024\/04\/13\/microsoft-excel-set-4\/","title":{"rendered":"Microsoft Excel Set -4"},"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-3bcb48be49fcef1fc4d702aab0a7e54e\"><a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/12\/microsoft-excel-set-3\/\" 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>       <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/13\/microsoft-excel-set-5\/\" title=\"\">Next<\/a><\/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-4\/\">mock test<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>31. <strong>\u00a0<strong>The currently selected cell address is displayed in ____.<\/strong><\/strong><\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. <strong><strong>Name Box<\/strong><\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Formula Bar<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Both A and B<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. None of the above<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:A<BR>\nSOLUTION : Currently selected cell address is displayed in the Name Box.\n <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>32. \u00a0Which programming language is used to write a Macro in MS Excel?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. C<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong><strong><strong><strong><strong>&nbsp;C++<\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. <strong>Java<\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. &nbsp;Visual Basic<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:D<BR>\nSOLUTION: Visual Basic is the programming language that is used to write a Macro in MS Excel.\n\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>33. <strong>What is the correct value of the function? =ROUND (1.2345,2)<\/strong><\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. 24<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong>23<\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. <\/strong>25<\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. <\/strong>2<\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:B<BR>\nSOLUTION: The function =ROUND (1.2345,2) will return 1.23\n  <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>34. <strong>What is the correct value of the function? =ROUND (1.9867,2)<\/strong><\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. &nbsp;1.98<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. &nbsp;1.99<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C.<\/strong> <strong>2<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. &nbsp;1.00<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:B<BR>\nSOLUTION: The function =ROUND (1.9867,2) will return 1.99\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>35. <strong><strong>\u00a0<\/strong><\/strong>\u00a0In MS Excel, &#8216;Merge and Center&#8217; is used to ____.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Combine and centre the content of the selected cell<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Combine and centre the content of the current row<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Concatenate the text of the two cells and returns the text<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. None of the above<\/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, &#8216;Merge and Center&#8217; is used to combine and centre the content of the selected cell.\n <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>36. <strong>\u00a0<\/strong>\u00a0Which feature is used to wrap extra-long text into multiple lines in MS Excel?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Word Wrap<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Letter Wrap<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Text Wrap<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Wrap Text<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:D<BR>\nSOLUTION :In MS Excel, &#8216;Wrap Text&#8217; feature is used to wrap extra-long text into multiple lines so that you can see all text.\n\n\n <\/p> \n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>37. \u00a0Which keyboard shortcut is used to apply &#8216;Wrap Text&#8217; on the selected text?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. &nbsp;Ctrl + H + W<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Alt + W + H<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Alt + H + W<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Alt + W<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER: C<BR>\nSOLUTION:The keyboard shortcut used to apply &#8216;Wrap Text&#8217; on the selected text is Alt + H + W\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>38. \u00a0Which feature is used to rotate the text diagonally or vertically of the selected cells in MS Excel?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. <\/strong>&nbsp;<strong>Orientation<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong>&nbsp;Text Layout<\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Text Flip<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. <strong> <strong>Cell Orientation<\/strong><\/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 MS Excel, the &#8216;Orientation&#8217; feature is used to rotate the text diagonally or vertically of the selected cells.\n\n\n  <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>39. <strong>Steps for protecting a sheet by password in MS Excel?<\/strong><\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Under the Review Tab, Click on Protect Current Sheet<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong>Under Insert Tab, Click on Protect Sheet<\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. &nbsp;Under Data Tab, Click on Protect Sheet<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Under the Review Tab, Click on Protect Sheet<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:D<BR>\nSOLUTION:  In MS Excel, to protect a sheet by password. Under the Review Tab, Click on Protect Sheet.\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>40. <strong><strong>Under which Tab, the chart options are available in MS Excel?<\/strong><\/strong><\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. Data<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Insert<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Review<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. <strong>View<\/strong><\/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 chart options are available in Insert Tab.\n\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-4\/\">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-3bcb48be49fcef1fc4d702aab0a7e54e\"><a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/12\/microsoft-excel-set-3\/\" 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>       <a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/13\/microsoft-excel-set-5\/\" title=\"\">Next<\/a><\/h1>\n","protected":false},"excerpt":{"rendered":"<p>Prev 1 2 3 4 5 Next 31. \u00a0The currently selected cell address is displayed in ____. A. Name Box B. Formula Bar C. Both A and B D. None of the above ANSWER &#038; SOLUTION ANSWER:A SOLUTION : Currently selected cell address is displayed in the Name Box. 32. \u00a0Which programming language is used<\/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":[1578,5623,1582,1574,1583,1576,1577,1581,1579,1580,1575],"class_list":{"0":"post-2447","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-computer","7":"tag-in-ms-excel-merge-and-center-is-used-to-____","8":"tag-mcqs-for-sda-fda-pdo-vao-banking-kas-ias-ssc-gd-ssc-chsl-ssc-cgl-for-all-compitative-exams","9":"tag-steps-for-protecting-a-sheet-by-password-in-ms-excel","10":"tag-the-currently-selected-cell-address-is-displayed-in-____","11":"tag-under-which-tab-the-chart-options-are-available-in-ms-excel","12":"tag-what-is-the-correct-value-of-the-function-round-1-23452","13":"tag-what-is-the-correct-value-of-the-function-round-1-98672","14":"tag-which-feature-is-used-to-rotate-the-text-diagonally-or-vertically-of-the-selected-cells-in-ms-excel","15":"tag-which-feature-is-used-to-wrap-extra-long-text-into-multiple-lines-in-ms-excel","16":"tag-which-keyboard-shortcut-is-used-to-apply-wrap-text-on-the-selected-text","17":"tag-which-programming-language-is-used-to-write-a-macro-in-ms-excel"},"_links":{"self":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2447","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=2447"}],"version-history":[{"count":2,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2447\/revisions"}],"predecessor-version":[{"id":3522,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2447\/revisions\/3522"}],"wp:attachment":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/media?parent=2447"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/categories?post=2447"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/tags?post=2447"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}