{"id":2430,"date":"2024-04-12T08:28:40","date_gmt":"2024-04-12T07:28:40","guid":{"rendered":"https:\/\/mcqsadda.com\/?p=2430"},"modified":"2024-07-17T10:52:46","modified_gmt":"2024-07-17T09:52:46","slug":"microsoft-excel-set-3","status":"publish","type":"post","link":"https:\/\/mcqsadda.com\/index.php\/2024\/04\/12\/microsoft-excel-set-3\/","title":{"rendered":"Microsoft Excel Set -3"},"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-3c52de2bd4d174039598d74ca96bae58\"><a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/12\/microsoft-excel-set-2\/\" 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-4\/\" 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-3\/\">mock test<\/a><\/div>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>21. <strong>\u00a0Which function is used to match multiple values and returns the first match?<\/strong><\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. <strong><strong>IF()<\/strong><\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. IFS()<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. IIF()<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. SWITCH()<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:D<BR>\nSOLUTION : The SWITCH() function is used to match multiple values and returns the first match.\n <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>22. Which function is used to create a date with year, month, and day?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. DATE()<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong><strong><strong><strong><strong>&nbsp;DATEDIF()<\/strong><\/strong><\/strong><\/strong><\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. <strong>DATEVALUE()<\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. &nbsp;CURDATE()<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:A<BR>\nSOLUTION: The DATE() function is used to create a date with year, month, and day.\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>23. Which function is used to get days, months, or years between two dates?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. DATE()<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong>DATEDIF()<\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. DATEVALUE()<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. <strong>CURDATE()<\/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 DATEDIF() function is used to get days, months, or years between two dates.\n  <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>24. What is the keyboard shortcut to insert a SUM formula in MS Excel?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. &nbsp;CTRL + =<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. &nbsp;ALT + =<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C.<\/strong> <strong>ALT + S<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. &nbsp;CTRL + ALT + =<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:B<BR>\nSOLUTION: The keyboard shortcut to insert a SUM formula is &#8220;ALT + =&#8221;. For this, select the cell range and press &#8220;ALT+=&#8221;. You will get the SUM of the values of the selected range.\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>25. <strong><strong>\u00a0<strong>What is the keyboard shortcut to switch between open Excel windows?<\/strong><\/strong><\/strong><\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. &nbsp;CTRL + TAB<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. ALT + TAB<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. CTRL + ALT + TAB<\/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: The keyboard shortcut to switch between open Excel windows is &#8220;CTRL + TAB&#8221;.\n <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>26. <strong>\u00a0<\/strong>\u00a0What is the keyboard shortcut to display the Format Cells dialog box in MS Excel?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. <strong><strong>CTRL + F<\/strong><\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. ALT + 1<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. CTRL + SHIFT + F<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. CTRL + 1<\/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 display the Format Cells dialog box is &#8220;CTRL + 1&#8221;.\n <\/p> \n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>27. \u00a0What is the keyboard shortcut to copy the value from the cell above the active cell into the cell or the Formula Bar in MS Excel?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. &nbsp;CTRL + SHIFT + C<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. CTRL + ALT + &#8220;<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. CTRL + SHIFT + &#8220;<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. ALT + SHIFT + &#8220;<\/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 to copy the value from the cell above the active cell into the cell or the Formula Bar is &#8220;CTRL + SHIFT + &#8220;&#8221;.\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>28. \u00a0What is the keyboard shortcut to copy a formula from the cell above the active cell into the cell or the Formula Bar in MS Excel?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. <\/strong>&nbsp;<strong>CTRL + &#8216;<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong>&nbsp;ALT + &#8216;<\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. CTRL + ALT + &#8216;<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. <strong> <strong>CTRL + SHIFT + F<\/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:The keyboard shortcut to copy a formula from the cell above the active cell into the cell or the Formula Bar is CTRL + &#8216;.\n\n\n  <\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>29. What is the keyboard shortcut to view formulas instead of values in MS Excel?<\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. CTRL + `<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. <strong>ALT + `<\/strong><\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. &nbsp;CTRL + ALT + `<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. CTRL + SHIFT + F<\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:A<BR>\nSOLUTION:  The keyboard shortcut to view formulas instead of values is CTRL + `.\n<\/p>\n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>30. <strong>Which symbol is used to specify the fixed columns or rows in the formula?<\/strong><\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>A. =<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>B. *<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>C. $<\/strong><\/h3>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>D. <strong>%<\/strong><\/strong><\/h3>\n\n\n\n<button class=\"acc\">ANSWER &#038; SOLUTION<\/button>\n<div class=\"pnl\">\n  <p>ANSWER:C<BR>\nSOLUTION: The $ symbol is used to specify the fixed columns or rows in the formula.\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-3\/\">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-3c52de2bd4d174039598d74ca96bae58\"><a href=\"https:\/\/mcqsadda.com\/index.php\/2024\/04\/12\/microsoft-excel-set-2\/\" 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-4\/\" title=\"\">Next<\/a><\/h1>\n","protected":false},"excerpt":{"rendered":"<p>Prev 1 2 3 4 5 Next 21. \u00a0Which function is used to match multiple values and returns the first match? A. IF() B. IFS() C. IIF() D. SWITCH() ANSWER &#038; SOLUTION ANSWER:D SOLUTION : The SWITCH() function is used to match multiple values and returns the first match. 22. Which function is used to<\/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,1570,1569,1568,1566,1567,1571,1564,1565,1563,1572],"class_list":{"0":"post-2430","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-what-is-the-keyboard-shortcut-to-copy-a-formula-from-the-cell-above-the-active-cell-into-the-cell-or-the-formula-bar-in-ms-excel","9":"tag-what-is-the-keyboard-shortcut-to-copy-the-value-from-the-cell-above-the-active-cell-into-the-cell-or-the-formula-bar-in-ms-excel","10":"tag-what-is-the-keyboard-shortcut-to-display-the-format-cells-dialog-box-in-ms-excel","11":"tag-what-is-the-keyboard-shortcut-to-insert-a-sum-formula-in-ms-excel","12":"tag-what-is-the-keyboard-shortcut-to-switch-between-open-excel-windows","13":"tag-what-is-the-keyboard-shortcut-to-view-formulas-instead-of-values-in-ms-excel","14":"tag-which-function-is-used-to-create-a-date-with-year-month-and-day","15":"tag-which-function-is-used-to-get-days-months-or-years-between-two-dates","16":"tag-which-function-is-used-to-match-multiple-values-and-returns-the-first-match","17":"tag-which-symbol-is-used-to-specify-the-fixed-columns-or-rows-in-the-formula"},"_links":{"self":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2430","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=2430"}],"version-history":[{"count":2,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2430\/revisions"}],"predecessor-version":[{"id":3521,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/posts\/2430\/revisions\/3521"}],"wp:attachment":[{"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/media?parent=2430"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/categories?post=2430"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mcqsadda.com\/index.php\/wp-json\/wp\/v2\/tags?post=2430"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}