{"id":2413,"date":"2024-04-12T08:05:19","date_gmt":"2024-04-12T07:05:19","guid":{"rendered":"https:\/\/mcqsadda.com\/?p=2413"},"modified":"2024-07-17T10:53:01","modified_gmt":"2024-07-17T09:53:01","slug":"microsoft-excel-set-2","status":"publish","type":"post","link":"https:\/\/mcqsadda.com\/index.php\/2024\/04\/12\/microsoft-excel-set-2\/","title":{"rendered":"Microsoft Excel Set -2"},"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-4676d603aaa060889dbec82f72a87102\"><a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/12\/microsoft-excel-set-1\/\" 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\/12\/microsoft-excel-set-3\/\" 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\/12\/microsoft-excel-quiz-2\/\">mock test<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>11. How many hyperlinks can be there in a worksheet?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. <strong><strong>32,767<\/strong><\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. 32,768<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. <strong><strong>65,530<\/strong><\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. 65,535<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:C<BR>\nSOLUTION :  There can be a maximum of 65,530 hyperlinks in a worksheet.\n <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>12. <strong><strong>How many times undo levels can be used in a worksheet?<\/strong><\/strong><\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. 25<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong><strong><strong><strong><strong>&nbsp;50<\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. <strong>75<\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. &nbsp;100<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:D<BR>\nSOLUTION:  There are 100 undo levels in a worksheet.\n\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>13. <strong>How many users can open the Excel file at the same time?<\/strong><\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. 64 users<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong>128 users<\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. 256 users<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. <strong>512 users<\/strong><\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:C<BR>\nSOLUTION: A total number of 256 users can open the excel file at the same time. For this, the &#8220;Allow changes by more than one user&#8230;&#8221; setting should be enabled.\n  <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>14. The intersection of a column and a row in a worksheet is called ____.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. &nbsp;<\/strong>Box<\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. &nbsp;Cell<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C.<\/strong> <strong>Range<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. &nbsp;Page Break<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:B<BR>\nSOLUTION: The intersection of a column and a row in a worksheet is called a &#8220;Cell&#8221;.\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>15. <strong><strong>\u00a0The fill function can be ____ to complete formulas in a range.<\/strong><\/strong><\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. &nbsp;Single clicked<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. Double-clicked<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Triple clicked<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. Right clicked<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:B<BR>\nSOLUTION: The fill function can be double-clicked to complete formulas in a range.\n <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>16. <strong>\u00a0Which logical function returns TRUE if all arguments evaluate TRUE; FALSE if not?<\/strong><\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. <strong><strong>OR<\/strong><\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. AND<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. IF<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. <\/strong>ANDIF<\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:B<BR>\nSOLUTION :The AND() function is used to test multiple conditions and returns TRUE if all arguments evaluate TRUE; FALSE if not.\n <\/p> \n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>17. \u00a0Which logical function returns TRUE if one or more arguments evaluates to TRUE; FALSE if all arguments evaluate to FALSE?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. &nbsp;OR<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. AND<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. IF<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. ANDIF<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER: A<BR>\nSOLUTION:The OR() function is used to test multiple conditions and returns TRUE if one or more evaluates to TRUE, and returns FALSE if all arguments evaluate to FALSE.\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>18. \u00a0The Excel ____ function returns the Boolean value FALSE.<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. <\/strong>&nbsp;<strong>TRUEFALSE(0)<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong>&nbsp;FALSE()<\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. Both of the above<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. <strong> <strong>There is no such function<\/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: The Excel FALSE() function returns the Boolean value FALSE.\n  <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>19. Which function is used to trap and handle errors?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. IFERROR()<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong>&nbsp;ERROR()<\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. &nbsp;IFNA()<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. IFTRAP()<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:A<BR>\nSOLUTION:  The IFERROR() function is used to trap and handle errors.\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>20. Which function is used to get a date n working days in the future or past?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. WORKDAY()<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. DAY()<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. WORKDATE()<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. <strong>DAYM()<\/strong><\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:A<BR>\nSOLUTION: The WORKDAY() function is used to get a date n working days in the future or past.\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\/12\/microsoft-excel-quiz-2\/\">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-4676d603aaa060889dbec82f72a87102\"><a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/12\/microsoft-excel-set-1\/\" 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\/12\/microsoft-excel-set-3\/\" title=\"\">Next<\/a><\/h1>\n","protected":false},"excerpt":{"rendered":"<p>Prev 1 2 3 4 5 Next 11. How many hyperlinks can be there in a worksheet? A. 32,767 B. 32,768 C. 65,530 D. 65,535 ANSWER &#038; SOLUTION ANSWER:C SOLUTION : There can be a maximum of 65,530 hyperlinks in a worksheet. 12. How many times undo levels can be used in a worksheet? A.<\/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":[1552,1553,1554,5623,1559,1556,1555,1561,1560,1557,1558],"class_list":{"0":"post-2413","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-computer","7":"tag-how-many-hyperlinks-can-be-there-in-a-worksheet","8":"tag-how-many-times-undo-levels-can-be-used-in-a-worksheet","9":"tag-how-many-users-can-open-the-excel-file-at-the-same-time","10":"tag-mcqs-for-sda-fda-pdo-vao-banking-kas-ias-ssc-gd-ssc-chsl-ssc-cgl-for-all-compitative-exams","11":"tag-the-excel-____-function-returns-the-boolean-value-false","12":"tag-the-fill-function-can-be-____-to-complete-formulas-in-a-range","13":"tag-the-intersection-of-a-column-and-a-row-in-a-worksheet-is-called-____","14":"tag-which-function-is-used-to-get-a-date-n-working-days-in-the-future-or-past","15":"tag-which-function-is-used-to-trap-and-handle-errors","16":"tag-which-logical-function-returns-true-if-all-arguments-evaluate-true-false-if-not","17":"tag-which-logical-function-returns-true-if-one-or-more-arguments-evaluates-to-true-false-if-all-arguments-evaluate-to-false"},"_links":{"self":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2413","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=2413"}],"version-history":[{"count":2,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2413\/revisions"}],"predecessor-version":[{"id":3520,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2413\/revisions\/3520"}],"wp:attachment":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/media?parent=2413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/categories?post=2413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/tags?post=2413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}