{"id":12643,"date":"2025-07-25T10:36:40","date_gmt":"2025-07-25T10:36:40","guid":{"rendered":"https:\/\/guidance24.in\/?p=12643"},"modified":"2025-07-25T10:36:41","modified_gmt":"2025-07-25T10:36:41","slug":"%e2%9c%85-top-30-microsoft-excel-mcq-questions-with-answers-%e0%a4%b9%e0%a4%bf%e0%a4%82%e0%a4%a6%e0%a5%80-%e0%a4%ae%e0%a5%87%e0%a4%82-%e0%a4%b5%e0%a5%8d%e0%a4%af%e0%a4%be%e0%a4%96%e0%a5%8d%e0%a4%af","status":"publish","type":"post","link":"https:\/\/guidance24.in\/?p=12643","title":{"rendered":"\u2705 Top 30 Microsoft Excel MCQ Questions with Answers (\u0939\u093f\u0902\u0926\u0940 \u092e\u0947\u0902 \u0935\u094d\u092f\u093e\u0916\u094d\u092f\u093e \u0938\u0939\u093f\u0924)"},"content":{"rendered":"\n

\ud83e\uddee Basic Excel Questions (1-20)<\/strong><\/h3>\n\n\n\n
    \n
  1. Excel \u092e\u0947\u0902 formula \u0932\u093f\u0916\u0928\u0947 \u0915\u0940 \u0936\u0941\u0930\u0941\u0906\u0924 \u0915\u093f\u0938 \u091a\u093f\u0928\u094d\u0939 \u0938\u0947 \u0939\u094b\u0924\u0940 \u0939\u0948?<\/strong>
    a) +
    b) =
    c) \u2013
    d) *
    \u2705 \u0909\u0924\u094d\u0924\u0930: b) =<\/strong><\/li>\n\n\n\n
  2. Excel \u092e\u0947\u0902 \u0938\u092c\u0938\u0947 \u0905\u0927\u093f\u0915 \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0928\u0947 \u0935\u093e\u0932\u093e function \u0915\u094c\u0928 \u0938\u093e \u0939\u0948 \u091c\u094b \u092f\u094b\u0917 \u0915\u0930\u0924\u093e \u0939\u0948?<\/strong>
    a) TOTAL()
    b) ADD()
    c) SUM()
    d) COMBINE()
    \u2705 \u0909\u0924\u094d\u0924\u0930: c) SUM()<\/strong><\/li>\n\n\n\n
  3. Excel \u0935\u0930\u094d\u0915\u092c\u0941\u0915 \u0915\u094b \u0938\u0947\u0935 \u0915\u0930\u0928\u0947 \u0915\u093e \u0936\u0949\u0930\u094d\u091f\u0915\u091f \u0915\u094d\u092f\u093e \u0939\u0948?<\/strong>
    a) Ctrl + C
    b) Ctrl + P
    c) Ctrl + S
    d) Ctrl + V
    \u2705 \u0909\u0924\u094d\u0924\u0930: c) Ctrl + S<\/strong><\/li>\n\n\n\n
  4. \u0915\u093f\u0938 function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0914\u0938\u0924 \u0928\u093f\u0915\u093e\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948?<\/strong>
    a) AVERAGE()
    b) AVG()
    c) MEAN()
    d) MID()
    \u2705 \u0909\u0924\u094d\u0924\u0930: a) AVERAGE()<\/strong><\/li>\n\n\n\n
  5. \u0915\u093f\u0938\u0940 \u0938\u0947\u0932 \u0915\u0940 \u092a\u0902\u0915\u094d\u0924\u093f \u0914\u0930 \u0938\u094d\u0924\u0902\u092d \u0915\u094b \u0915\u094d\u092f\u093e \u0915\u0939\u093e \u091c\u093e\u0924\u093e \u0939\u0948?<\/strong>
    a) Address
    b) Cell reference
    c) Label
    d) Name
    \u2705 \u0909\u0924\u094d\u0924\u0930: b) Cell reference<\/strong><\/li>\n\n\n\n
  6. A$1 \u0915\u093f\u0938 \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u0940 \u0930\u0947\u092b\u0930\u0947\u0902\u0938 \u0939\u0948?<\/strong>
    a) Absolute
    b) Relative
    c) Mixed
    d) Dynamic
    \u2705 \u0909\u0924\u094d\u0924\u0930: c) Mixed<\/strong><\/li>\n\n\n\n
  7. Ctrl + N \u0936\u0949\u0930\u094d\u091f\u0915\u091f \u0915\u094d\u092f\u093e \u0915\u0930\u0924\u093e \u0939\u0948?<\/strong>
    a) \u0928\u0908 \u0935\u0930\u094d\u0915\u092c\u0941\u0915 \u0916\u094b\u0932\u0924\u093e \u0939\u0948
    b) \u0921\u093e\u091f\u093e \u0938\u0947\u0935 \u0915\u0930\u0924\u093e \u0939\u0948
    c) \u092a\u094d\u0930\u093f\u0902\u091f \u0915\u0930\u0924\u093e \u0939\u0948
    d) \u0915\u0949\u092a\u0940 \u0915\u0930\u0924\u093e \u0939\u0948
    \u2705 \u0909\u0924\u094d\u0924\u0930: a) \u0928\u0908 \u0935\u0930\u094d\u0915\u092c\u0941\u0915 \u0916\u094b\u0932\u0924\u093e \u0939\u0948<\/strong><\/li>\n\n\n\n
  8. Excel \u092e\u0947\u0902 \u0915\u093f\u0924\u0928\u0947 \u0915\u0949\u0932\u092e \u0939\u094b\u0924\u0947 \u0939\u0948\u0902? (Excel 2016 \u0924\u0915)<\/strong>
    a) 256
    b) 1024
    c) 16384
    d) 1048576
    \u2705 \u0909\u0924\u094d\u0924\u0930: c) 16384<\/strong><\/li>\n\n\n\n
  9. Excel \u0915\u0940 \u090f\u0915 \u0935\u0930\u094d\u0915\u0936\u0940\u091f \u092e\u0947\u0902 \u0915\u093f\u0924\u0928\u0940 \u092a\u0902\u0915\u094d\u0924\u093f\u092f\u093e\u0901 \u0939\u094b\u0924\u0940 \u0939\u0948\u0902?<\/strong>
    a) 65536
    b) 1048576
    c) 16384
    d) 1000000
    \u2705 \u0909\u0924\u094d\u0924\u0930: b) 1048576<\/strong><\/li>\n\n\n\n
  10. Excel \u092e\u0947\u0902 active cell \u0915\u094b \u0915\u0948\u0938\u0947 \u092a\u0939\u091a\u093e\u0928\u093e \u091c\u093e\u0924\u093e \u0939\u0948?<\/strong>
    a) \u0909\u0938\u0915\u093e \u0930\u0902\u0917 \u0932\u093e\u0932 \u0939\u094b\u0924\u093e \u0939\u0948
    b) \u0909\u0938\u092e\u0947\u0902 \u0924\u0940\u0930 \u0939\u094b\u0924\u093e \u0939\u0948
    c) \u0935\u0939 \u092e\u094b\u091f\u0940 \u0938\u0940\u092e\u093e (border) \u092e\u0947\u0902 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0924\u093e \u0939\u0948
    d) \u0935\u0939 \u092c\u094d\u0932\u093f\u0902\u0915 \u0915\u0930\u0924\u093e \u0939\u0948
    \u2705 \u0909\u0924\u094d\u0924\u0930: c) \u0935\u0939 \u092e\u094b\u091f\u0940 \u0938\u0940\u092e\u093e \u092e\u0947\u0902 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0924\u093e \u0939\u0948<\/strong><\/li>\n\n\n\n
  11. \u0921\u0947\u091f\u093e \u0915\u094b \u0906\u0930\u094b\u0939\u0940\/\u0905\u0935\u0930\u094b\u0939\u0940 \u0915\u094d\u0930\u092e \u092e\u0947\u0902 \u0935\u094d\u092f\u0935\u0938\u094d\u0925\u093f\u0924 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u094c\u0928-\u0938\u093e \u091f\u0942\u0932 \u0939\u0948?<\/strong>
    a) Filter
    b) Arrange
    c) Sort
    d) Order
    \u2705 \u0909\u0924\u094d\u0924\u0930: c) Sort<\/strong><\/li>\n\n\n\n
  12. AutoSum \u092c\u091f\u0928 \u0915\u093f\u0938 \u091f\u0948\u092c \u092e\u0947\u0902 \u0939\u094b\u0924\u093e \u0939\u0948?<\/strong>
    a) File
    b) Insert
    c) Data
    d) Home
    \u2705 \u0909\u0924\u094d\u0924\u0930: d) Home<\/strong><\/li>\n\n\n\n
  13. \u0915\u094c\u0928-\u0938\u093e \u091a\u093e\u0930\u094d\u091f \u0938\u092e\u092f \u0915\u0947 \u0938\u093e\u0925 \u0921\u0947\u091f\u093e \u0915\u093e \u0935\u093f\u0936\u094d\u0932\u0947\u0937\u0923 \u0926\u093f\u0916\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0909\u092a\u092f\u0941\u0915\u094d\u0924 \u0939\u0948?<\/strong>
    a) Pie chart
    b) Line chart
    c) Bar chart
    d) Doughnut chart
    \u2705 \u0909\u0924\u094d\u0924\u0930: b) Line chart<\/strong><\/li>\n\n\n\n
  14. Excel \u092e\u0947\u0902 COUNT() function \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u0938 \u0932\u093f\u090f \u0939\u094b\u0924\u093e \u0939\u0948?<\/strong>
    a) \u0915\u0941\u0932 \u092f\u094b\u0917
    b) \u0914\u0938\u0924
    c) \u0915\u0947\u0935\u0932 \u0938\u0902\u0916\u094d\u092f\u093e\u0913\u0902 \u0915\u0940 \u0917\u093f\u0928\u0924\u0940
    d) \u0938\u092d\u0940 \u092a\u094d\u0930\u0915\u093e\u0930 \u0915\u0940 \u090f\u0902\u091f\u094d\u0930\u0940 \u0915\u0940 \u0917\u093f\u0928\u0924\u0940
    \u2705 \u0909\u0924\u094d\u0924\u0930: c) \u0915\u0947\u0935\u0932 \u0938\u0902\u0916\u094d\u092f\u093e\u0913\u0902 \u0915\u0940 \u0917\u093f\u0928\u0924\u0940<\/strong><\/li>\n\n\n\n
  15. Excel \u0915\u0940 \u092b\u093c\u093e\u0907\u0932 \u0915\u094b \u0915\u094d\u092f\u093e \u0915\u0939\u0924\u0947 \u0939\u0948\u0902?<\/strong>
    a) Document
    b) Workbook
    c) Worksheet
    d) Spreadsheet
    \u2705 \u0909\u0924\u094d\u0924\u0930: b) Workbook<\/strong><\/li>\n\n\n\n
  16. \u0915\u093f\u0938 function \u0915\u093e \u092a\u094d\u0930\u092f\u094b\u0917 \u0935\u0930\u094d\u0924\u092e\u093e\u0928 \u0924\u093f\u0925\u093f \u0935 \u0938\u092e\u092f \u0926\u093f\u0916\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948?<\/strong>
    a) DATE()
    b) TODAY()
    c) TIME()
    d) NOW()
    \u2705 \u0909\u0924\u094d\u0924\u0930: d) NOW()<\/strong><\/li>\n\n\n\n
  17. Excel \u092e\u0947\u0902 \u0915\u094b\u0908 row delete \u0915\u0930\u0928\u0947 \u0915\u093e \u0936\u0949\u0930\u094d\u091f\u0915\u091f \u0915\u094d\u092f\u093e \u0939\u0948?<\/strong>
    a) Ctrl + R
    b) Ctrl + \u2013
    c) Ctrl + D
    d) Ctrl + Delete
    \u2705 \u0909\u0924\u094d\u0924\u0930: b) Ctrl + \u2013<\/strong><\/li>\n\n\n\n
  18. Excel \u0915\u093e extension \u0915\u094d\u092f\u093e \u0939\u094b\u0924\u093e \u0939\u0948 (2010+)?<\/strong>
    a) .xls
    b) .docx
    c) .xlsx
    d) .xlt
    \u2705 \u0909\u0924\u094d\u0924\u0930: c) .xlsx<\/strong><\/li>\n\n\n\n
  19. Excel \u092e\u0947\u0902 Filter \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u094d\u092f\u093e \u0915\u0930\u0924\u093e \u0939\u0948?<\/strong>
    a) \u0921\u0947\u091f\u093e \u0915\u094b \u091c\u094b\u0921\u093c\u0924\u093e \u0939\u0948
    b) \u0935\u093f\u0936\u093f\u0937\u094d\u091f \u0921\u0947\u091f\u093e \u0926\u093f\u0916\u093e\u0924\u093e \u0939\u0948
    c) \u0921\u0947\u091f\u093e \u0921\u093f\u0932\u0940\u091f \u0915\u0930\u0924\u093e \u0939\u0948
    d) \u0915\u0941\u091b \u0928\u0939\u0940\u0902
    \u2705 \u0909\u0924\u094d\u0924\u0930: b) \u0935\u093f\u0936\u093f\u0937\u094d\u091f \u0921\u0947\u091f\u093e \u0926\u093f\u0916\u093e\u0924\u093e \u0939\u0948<\/strong><\/li>\n\n\n\n
  20. Excel \u092e\u0947\u0902 ‘Merge & Center’ \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u093f\u0938\u0932\u093f\u090f \u0939\u094b\u0924\u093e \u0939\u0948?<\/strong>
    a) \u0921\u0947\u091f\u093e \u091c\u094b\u0921\u093c\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f
    b) \u0926\u094b \u0935\u0930\u094d\u0915\u092c\u0941\u0915 \u092e\u0930\u094d\u091c \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f
    c) \u0915\u0908 \u0938\u0947\u0932 \u0915\u094b \u092e\u093f\u0932\u093e\u0915\u0930 \u090f\u0915 \u092c\u0928\u093e \u0915\u0930 \u0938\u0947\u0902\u091f\u0930 \u092e\u0947\u0902 \u091f\u0947\u0915\u094d\u0938\u094d\u091f \u0930\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f
    d) \u092a\u094d\u0930\u093f\u0902\u091f \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f
    \u2705 \u0909\u0924\u094d\u0924\u0930: c) \u0915\u0908 \u0938\u0947\u0932 \u0915\u094b \u092e\u093f\u0932\u093e\u0915\u0930 \u0938\u0947\u0902\u091f\u0930 \u092e\u0947\u0902 \u091f\u0947\u0915\u094d\u0938\u094d\u091f \u0930\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f<\/strong><\/li>\n<\/ol>\n\n\n\n
    \n\n\n\n

    \ud83d\udcca Intermediate Excel Questions (21-50)<\/strong><\/h3>\n\n\n\n
      \n
    1. Excel \u092e\u0947\u0902 \u0905\u0927\u093f\u0915\u0924\u092e zoom level \u0915\u093f\u0924\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948?<\/strong>
      a) 100%
      b) 200%
      c) 400%
      d) 500%
      \u2705 \u0909\u0924\u094d\u0924\u0930: c) 400%<\/strong><\/li>\n\n\n\n
    2. Excel \u092e\u0947\u0902 Wrap Text \u0915\u093e \u0915\u093e\u0930\u094d\u092f \u0915\u094d\u092f\u093e \u0939\u0948?<\/strong>
      a) \u091f\u0947\u0915\u094d\u0938\u094d\u091f \u0915\u094b \u0939\u091f\u093e \u0926\u0947\u0924\u093e \u0939\u0948
      b) \u091f\u0947\u0915\u094d\u0938\u094d\u091f \u0915\u094b \u0915\u093e\u091f \u0926\u0947\u0924\u093e \u0939\u0948
      c) \u091f\u0947\u0915\u094d\u0938\u094d\u091f \u0915\u094b \u0932\u093e\u0907\u0928 \u092c\u094d\u0930\u0947\u0915 \u0915\u0947 \u0938\u093e\u0925 \u092b\u093f\u091f \u0915\u0930\u0924\u093e \u0939\u0948
      d) \u091f\u0947\u0915\u094d\u0938\u094d\u091f \u0915\u094b \u092c\u093e\u0939\u0930 \u0928\u093f\u0915\u093e\u0932 \u0926\u0947\u0924\u093e \u0939\u0948
      \u2705 \u0909\u0924\u094d\u0924\u0930: c) \u091f\u0947\u0915\u094d\u0938\u094d\u091f \u0915\u094b \u0932\u093e\u0907\u0928 \u092c\u094d\u0930\u0947\u0915 \u0915\u0947 \u0938\u093e\u0925 \u092b\u093f\u091f \u0915\u0930\u0924\u093e \u0939\u0948<\/strong><\/li>\n\n\n\n
    3. VLOOKUP \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u0915\u092c \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948?<\/strong>
      a) \u0921\u0947\u091f\u093e \u0915\u094b \u091c\u094b\u0921\u093c\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f
      b) \u0938\u0947\u0932 \u092e\u0947\u0902 \u091f\u0947\u0915\u094d\u0938\u094d\u091f \u092c\u0926\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f
      c) \u0935\u0930\u094d\u091f\u093f\u0915\u0932 \u0930\u0942\u092a \u0938\u0947 \u0921\u0947\u091f\u093e \u0916\u094b\u091c\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f
      d) \u091a\u093e\u0930\u094d\u091f \u092c\u0928\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f
      \u2705 \u0909\u0924\u094d\u0924\u0930: c) \u0935\u0930\u094d\u091f\u093f\u0915\u0932 \u0930\u0942\u092a \u0938\u0947 \u0921\u0947\u091f\u093e \u0916\u094b\u091c\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f<\/strong><\/li>\n\n\n\n
    4. Excel \u092e\u0947\u0902 IF function \u0915\u093f\u0938\u0915\u0947 \u0932\u093f\u090f \u092a\u094d\u0930\u092f\u094b\u0917 \u0915\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948?<\/strong>
      a) \u0917\u0923\u0928\u093e \u0915\u0947 \u0932\u093f\u090f
      b) \u0936\u0930\u094d\u0924\u094b\u0902 \u0915\u0940 \u091c\u093e\u0901\u091a \u0915\u0947 \u0932\u093f\u090f
      c) \u091a\u093e\u0930\u094d\u091f \u0915\u0947 \u0932\u093f\u090f
      d) \u0936\u0949\u0930\u094d\u091f\u0915\u091f \u092c\u0928\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f
      \u2705 \u0909\u0924\u094d\u0924\u0930: b) \u0936\u0930\u094d\u0924\u094b\u0902 \u0915\u0940 \u091c\u093e\u0901\u091a \u0915\u0947 \u0932\u093f\u090f<\/strong><\/li>\n\n\n\n
    5. COUNTIF() function \u0915\u094d\u092f\u093e \u0915\u0930\u0924\u093e \u0939\u0948?<\/strong>
      a) \u0938\u092d\u0940 \u0921\u0947\u091f\u093e \u0915\u0940 \u0917\u093f\u0928\u0924\u0940
      b) \u0930\u093f\u0915\u094d\u0924 \u0938\u0947\u0932 \u0915\u0940 \u0917\u093f\u0928\u0924\u0940
      c) \u0915\u093f\u0938\u0940 \u0936\u0930\u094d\u0924 \u0915\u094b \u092a\u0942\u0930\u093e \u0915\u0930\u0928\u0947 \u0935\u093e\u0932\u0947 \u0938\u0947\u0932 \u0915\u0940 \u0917\u093f\u0928\u0924\u0940
      d) \u091f\u0947\u0915\u094d\u0938\u094d\u091f \u091c\u094b\u0921\u093c\u0924\u093e \u0939\u0948
      \u2705 \u0909\u0924\u094d\u0924\u0930: c) \u0915\u093f\u0938\u0940 \u0936\u0930\u094d\u0924 \u0915\u094b \u092a\u0942\u0930\u093e \u0915\u0930\u0928\u0947 \u0935\u093e\u0932\u0947 \u0938\u0947\u0932 \u0915\u0940 \u0917\u093f\u0928\u0924\u0940<\/strong><\/li>\n\n\n\n
    6. Sheet tab \u0915\u094b rename \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0915\u094d\u092f\u093e \u0915\u0930\u0928\u093e \u091a\u093e\u0939\u093f\u090f?<\/strong>
      a) \u0921\u092c\u0932 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947\u0902
      b) \u0930\u093e\u0907\u091f \u0915\u094d\u0932\u093f\u0915 > Rename
      c) \u0926\u094b\u0928\u094b\u0902
      d) Rename \u092c\u091f\u0928 \u0926\u092c\u093e\u090f\u0901
      \u2705 \u0909\u0924\u094d\u0924\u0930: c) \u0926\u094b\u0928\u094b\u0902<\/strong><\/li>\n\n\n\n
    7. Chart insert \u0915\u0930\u0928\u0947 \u0915\u093e \u091f\u0948\u092c \u0915\u094c\u0928 \u0938\u093e \u0939\u0948?<\/strong>
      a) View
      b) Data
      c) Insert
      d) Page Layout
      \u2705 \u0909\u0924\u094d\u0924\u0930: c) Insert<\/strong><\/li>\n\n\n\n
    8. Conditional Formatting \u0915\u093f\u0938\u0915\u0947 \u0932\u093f\u090f \u0939\u094b\u0924\u093e \u0939\u0948?<\/strong>
      a) \u0938\u0947\u0932 delete \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f
      b) \u0935\u093f\u0936\u0947\u0937 \u0938\u094d\u0925\u093f\u0924\u093f \u092e\u0947\u0902 \u0930\u0902\u0917 \u092f\u093e \u092b\u0949\u0930\u094d\u092e\u0947\u091f \u092c\u0926\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f
      c) \u0921\u0947\u091f\u093e \u092e\u0930\u094d\u091c \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f
      d) \u0938\u092d\u0940 \u0915\u094b \u0938\u0949\u0930\u094d\u091f \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f
      \u2705 \u0909\u0924\u094d\u0924\u0930: b) \u0935\u093f\u0936\u0947\u0937 \u0938\u094d\u0925\u093f\u0924\u093f \u092e\u0947\u0902 \u0930\u0902\u0917 \u092f\u093e \u092b\u0949\u0930\u094d\u092e\u0947\u091f \u092c\u0926\u0932\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f<\/strong><\/li>\n\n\n\n
    9. \u0915\u093f\u0938 key \u0938\u0947 current time \u0921\u093e\u0932\u093e \u091c\u093e\u0924\u093e \u0939\u0948?<\/strong>
      a) Ctrl + Shift + ;
      b) Ctrl + ;
      c) Ctrl + T
      d) Ctrl + Shift + T
      \u2705 \u0909\u0924\u094d\u0924\u0930: a) Ctrl + Shift + ;<\/strong><\/li>\n\n\n\n
    10. Freeze Panes \u0915\u093f\u0938 \u0915\u093e\u092e \u0906\u0924\u093e \u0939\u0948?<\/strong>
      a) \u0921\u0947\u091f\u093e \u0932\u0949\u0915 \u0915\u0930\u0928\u0947
      b) \u091f\u0949\u092a row \u092f\u093e \u0915\u0949\u0932\u092e \u0915\u094b \u0938\u094d\u0915\u094d\u0930\u0949\u0932 \u0915\u0947 \u0926\u094c\u0930\u093e\u0928 \u0938\u094d\u0925\u093f\u0930 \u0930\u0916\u0928\u0947
      c) \u092b\u0949\u0930\u094d\u092e\u0947\u091f\u093f\u0902\u0917 \u0932\u0949\u0915 \u0915\u0930\u0928\u0947
      d) \u0921\u0947\u091f\u093e \u091b\u093f\u092a\u093e\u0928\u0947
      \u2705 \u0909\u0924\u094d\u0924\u0930: b) \u091f\u0949\u092a row \u092f\u093e \u0915\u0949\u0932\u092e \u0915\u094b \u0938\u094d\u0925\u093f\u0930 \u0930\u0916\u0928\u0947<\/strong><\/li>\n<\/ol>\n\n\n\n

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

      \ud83e\uddee Basic Excel Questions (1-20) \ud83d\udcca Intermediate Excel Questions (21-50)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[34,8],"tags":[],"class_list":["post-12643","post","type-post","status-publish","format-standard","hentry","category-excel-formula-tutorials","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 Formula Tutorials<\/a> Excel MCQ<\/a>","rttpg_excerpt":"\ud83e\uddee Basic Excel Questions (1-20) \ud83d\udcca Intermediate Excel Questions (21-50)","_links":{"self":[{"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/posts\/12643","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=12643"}],"version-history":[{"count":1,"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/posts\/12643\/revisions"}],"predecessor-version":[{"id":12644,"href":"https:\/\/guidance24.in\/index.php?rest_route=\/wp\/v2\/posts\/12643\/revisions\/12644"}],"wp:attachment":[{"href":"https:\/\/guidance24.in\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12643"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/guidance24.in\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12643"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/guidance24.in\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12643"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}