{"id":12755,"date":"2025-09-05T06:43:46","date_gmt":"2025-09-05T06:43:46","guid":{"rendered":"https:\/\/guidance24.in\/?p=12755"},"modified":"2025-09-05T06:43:47","modified_gmt":"2025-09-05T06:43:47","slug":"top-30-excel-mcqs-every-beginner-should-know-2025-guide","status":"publish","type":"post","link":"https:\/\/guidance24.in\/?p=12755","title":{"rendered":"Top 30 Excel MCQs Every Beginner Should Know (2025 Guide)"},"content":{"rendered":"\n

Microsoft Excel \u0939\u0930 student, professional \u0914\u0930 job aspirant<\/strong> \u0915\u0947 \u0932\u093f\u090f important skill \u0939\u0948\u0964 Excel exams, competitive tests \u0914\u0930 interviews \u092e\u0947\u0902 \u0905\u0915\u094d\u0938\u0930 \u092f\u0947 basic \u0914\u0930 frequently asked MCQs<\/strong> \u092a\u0942\u091b\u0947 \u091c\u093e\u0924\u0947 \u0939\u0948\u0902\u0964<\/p>\n\n\n\n

\u0928\u0940\u091a\u0947 top 30 Excel MCQs<\/strong> \u0926\u093f\u090f \u0917\u090f \u0939\u0948\u0902 \u091c\u094b \u0906\u092a\u0915\u0947 \u0932\u093f\u090f exam preparation \u0914\u0930 practice \u0915\u0947 \u0932\u093f\u090f \u092c\u0939\u0941\u0924 useful \u0939\u094b\u0902\u0917\u0947\u0964<\/p>\n\n\n\n

\n\n\n\n

\ud83d\udd39 1\u201310: Excel Basics<\/h2>\n\n\n\n
    \n
  1. Which of the following is used to create a spreadsheet in Microsoft Excel?<\/strong>
    a) Word
    b) Excel \u2705
    c) PowerPoint
    d) Access<\/li>\n\n\n\n
  2. Default extension of Excel file is:<\/strong>
    a) .docx
    b) .xlsx \u2705
    c) .pptx
    d) .txt<\/li>\n\n\n\n
  3. What is the shortcut key to save a workbook in Excel?<\/strong>
    a) Ctrl + P
    b) Ctrl + S \u2705
    c) Ctrl + C
    d) Ctrl + V<\/li>\n\n\n\n
  4. Which key is used to move to the next cell in Excel?<\/strong>
    a) Enter \u2705
    b) Tab
    c) Shift
    d) Esc<\/li>\n\n\n\n
  5. Which of the following is not a data type in Excel?<\/strong>
    a) Text
    b) Number
    c) Formula
    d) Paragraph \u2705<\/li>\n\n\n\n
  6. How can you insert a new worksheet in Excel?<\/strong>
    a) Right-click tab \u2192 Insert \u2705
    b) Ctrl + N
    c) Home \u2192 Format
    d) File \u2192 New<\/li>\n\n\n\n
  7. Which of the following is used to calculate totals in Excel?<\/strong>
    a) SUM \u2705
    b) COUNT
    c) AVERAGE
    d) MAX<\/li>\n\n\n\n
  8. Which feature in Excel is used to arrange data in ascending or descending order?<\/strong>
    a) Filter
    b) Sort \u2705
    c) Freeze Panes
    d) Conditional Formatting<\/li>\n\n\n\n
  9. In Excel, a cell address is defined by:<\/strong>
    a) Column letter + Row number \u2705
    b) Row number + Column letter
    c) Worksheet name
    d) None of the above<\/li>\n\n\n\n
  10. Shortcut to undo an action in Excel is:<\/strong>
    a) Ctrl + C
    b) Ctrl + Z \u2705
    c) Ctrl + Y
    d) Ctrl + X<\/li>\n<\/ol>\n\n\n\n
    \n\n\n\n

    \ud83d\udd39 11\u201320: Formulas & Functions<\/h2>\n\n\n\n
      \n
    1. Which formula is used to calculate average in Excel?<\/strong>
      a) =SUM(A1:A10)
      b) =AVERAGE(A1:A10) \u2705
      c) =COUNT(A1:A10)
      d) =MAX(A1:A10)<\/li>\n\n\n\n
    2. What does VLOOKUP function do in Excel?<\/strong>
      a) Creates charts
      b) Looks for a value in a table \u2705
      c) Counts cells
      d) Adds numbers<\/li>\n\n\n\n
    3. Which formula is used to count cells based on criteria?<\/strong>
      a) SUMIF
      b) COUNTIF \u2705
      c) AVERAGEIF
      d) IF<\/li>\n\n\n\n
    4. Which of the following is used to combine text from multiple cells?<\/strong>
      a) CONCATENATE \u2705
      b) SUM
      c) AVERAGE
      d) LEFT<\/li>\n\n\n\n
    5. Formula to round off a number in Excel is:<\/strong>
      a) =ROUND(A1,2) \u2705
      b) =SUM(A1,2)
      c) =AVERAGE(A1,2)
      d) =TRUNC(A1,2)<\/li>\n\n\n\n
    6. Which function returns the current date?<\/strong>
      a) NOW
      b) TODAY \u2705
      c) DATE
      d) TIME<\/li>\n\n\n\n
    7. Which of the following is used to find maximum value in a range?<\/strong>
      a) MAX \u2705
      b) MIN
      c) SUM
      d) COUNT<\/li>\n\n\n\n
    8. Which function extracts characters from the left of a string?<\/strong>
      a) RIGHT
      b) LEFT \u2705
      c) MID
      d) LEN<\/li>\n\n\n\n
    9. IF formula is used for:<\/strong>
      a) Mathematical calculation
      b) Conditional check \u2705
      c) Sorting
      d) Filtering<\/li>\n\n\n\n
    10. Which symbol is used to start a formula in Excel?<\/strong>
      a) &
      b) = \u2705
      c) +
      d) $<\/li>\n<\/ol>\n\n\n\n
      \n\n\n\n

      \ud83d\udd39 21\u201330: Shortcuts & Advanced Tips<\/h2>\n\n\n\n
        \n
      1. Shortcut to select entire column:<\/strong>
        a) Ctrl + C
        b) Ctrl + Space \u2705
        c) Shift + Space
        d) Alt + C<\/li>\n\n\n\n
      2. Shortcut to select entire row:<\/strong>
        a) Ctrl + Space
        b) Shift + Space \u2705
        c) Ctrl + Shift
        d) Alt + R<\/li>\n\n\n\n
      3. What does Freeze Panes feature do?<\/strong>
        a) Lock header rows or columns \u2705
        b) Delete rows
        c) Hide sheets
        d) Merge cells<\/li>\n\n\n\n
      4. Which chart is used for comparing parts of a whole?<\/strong>
        a) Line
        b) Column
        c) Pie \u2705
        d) Scatter<\/li>\n\n\n\n
      5. Shortcut to insert a new worksheet:<\/strong>
        a) Shift + F11 \u2705
        b) Ctrl + N
        c) Alt + N
        d) Ctrl + T<\/li>\n\n\n\n
      6. What is the use of Conditional Formatting in Excel?<\/strong>
        a) Apply formatting based on conditions \u2705
        b) Freeze rows
        c) Sort data
        d) Count cells<\/li>\n\n\n\n
      7. Which function is used to remove extra spaces in a cell?<\/strong>
        a) CLEAN
        b) TRIM \u2705
        c) LEFT
        d) MID<\/li>\n\n\n\n
      8. Shortcut to open Format Cells window:<\/strong>
        a) Ctrl + 1 \u2705
        b) Ctrl + 2
        c) Ctrl + F
        d) Ctrl + Alt + F<\/li>\n\n\n\n
      9. Which function is used for horizontal lookup?<\/strong>
        a) VLOOKUP
        b) HLOOKUP \u2705
        c) LOOKUP
        d) INDEX<\/li>\n\n\n\n
      10. Which of the following is used to calculate loan EMI in Excel?<\/strong>
        a) PMT \u2705
        b) EMI
        c) LOAN
        d) RATE<\/li>\n<\/ol>\n\n\n\n
        \n\n\n\n

        \u2705 Conclusion<\/h2>\n\n\n\n

        \u092f\u0947 Top 30 Excel MCQs<\/strong> \u0906\u092a\u0915\u0947 exam preparation, interviews \u0914\u0930 competitive exams<\/strong> \u0915\u0947 \u0932\u093f\u090f \u092c\u0939\u0941\u0924 useful \u0939\u0948\u0902\u0964
        \ud83d\udca1 Pro Tip:<\/strong> \u0938\u093f\u0930\u094d\u092b \u092f\u093e\u0926 \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u091c\u093e\u092f \u0907\u0928 MCQs \u0915\u094b Excel \u092e\u0947\u0902 practice \u0915\u0930\u0947\u0902\u0964<\/p>\n\n\n\n

        <\/p>\n","protected":false},"excerpt":{"rendered":"

        Microsoft Excel \u0939\u0930 student, professional \u0914\u0930 job aspirant \u0915\u0947 \u0932\u093f\u090f important skill \u0939\u0948\u0964 Excel exams, competitive tests \u0914\u0930 interviews \u092e\u0947\u0902 \u0905\u0915\u094d\u0938\u0930 \u092f\u0947 basic \u0914\u0930 frequently asked MCQs \u092a\u0942\u091b\u0947 \u091c\u093e\u0924\u0947 \u0939\u0948\u0902\u0964 \u0928\u0940\u091a\u0947 top 30 Excel MCQs \u0926\u093f\u090f \u0917\u090f \u0939\u0948\u0902 \u091c\u094b \u0906\u092a\u0915\u0947 \u0932\u093f\u090f exam preparation \u0914\u0930 practice \u0915\u0947 \u0932\u093f\u090f \u092c\u0939\u0941\u0924 useful \u0939\u094b\u0902\u0917\u0947\u0964 \ud83d\udd39 1\u201310: Excel Basics \ud83d\udd39 11\u201320: Formulas & Functions \ud83d\udd39 21\u201330: Shortcuts & Advanced Tips \u2705 Conclusion \u092f\u0947 Top 30 Excel MCQs \u0906\u092a\u0915\u0947 exam preparation, interviews \u0914\u0930 competitive exams \u0915\u0947 \u0932\u093f\u090f \u092c\u0939\u0941\u0924 useful \u0939\u0948\u0902\u0964\ud83d\udca1 Pro Tip: \u0938\u093f\u0930\u094d\u092b \u092f\u093e\u0926 \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u091c\u093e\u092f \u0907\u0928 MCQs \u0915\u094b Excel \u092e\u0947\u0902 practice \u0915\u0930\u0947\u0902\u0964<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-12755","post","type-post","status-publish","format-standard","hentry","category-excel-mcq"],"rttpg_featured_image_url":null,"rttpg_author":{"display_name":"admin","author_link":"https:\/\/guidance24.in\/?author=1"},"rttpg_comment":0,"rttpg_category":"Excel MCQ<\/a>","rttpg_excerpt":"Microsoft Excel \u0939\u0930 student, professional \u0914\u0930 job aspirant \u0915\u0947 \u0932\u093f\u090f important skill \u0939\u0948\u0964 Excel exams, competitive tests \u0914\u0930 interviews \u092e\u0947\u0902 \u0905\u0915\u094d\u0938\u0930 \u092f\u0947 basic \u0914\u0930 frequently asked MCQs \u092a\u0942\u091b\u0947 \u091c\u093e\u0924\u0947 \u0939\u0948\u0902\u0964 \u0928\u0940\u091a\u0947 top 30 Excel MCQs \u0926\u093f\u090f \u0917\u090f \u0939\u0948\u0902 \u091c\u094b \u0906\u092a\u0915\u0947 \u0932\u093f\u090f exam preparation \u0914\u0930 practice \u0915\u0947 \u0932\u093f\u090f \u092c\u0939\u0941\u0924 useful \u0939\u094b\u0902\u0917\u0947\u0964 \ud83d\udd39 1\u201310: Excel Basics \ud83d\udd39…","_links":{"self":[{"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/posts\/12755","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/guidance24.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12755"}],"version-history":[{"count":1,"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/posts\/12755\/revisions"}],"predecessor-version":[{"id":12756,"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/posts\/12755\/revisions\/12756"}],"wp:attachment":[{"href":"https:\/\/guidance24.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12755"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/guidance24.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12755"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guidance24.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}