MS EXCEL Quiz Question with Answer

21. How do you wrap the text in a cell?

  1. Format, cells, font
  2. Format, cells, protection
  3. format, cells, number
  4. Format, cells, alignment

22. Which of the following you can paste selectively using Paste Special command ?

  1. Formats
  2. Validation
  3. Formulas
  4. All of the above

23. You can check the conditions against …………………………….when applying conditional formatting

  1. Formula
  2. Cell value
  3. Both (A) and (B)
  4. None of the above

24. A features that displays only the data in column (s) according to specified criteria

  1. Formula
  2. Sorting
  3. Filtering
  4. Pivot

25. What do you mean by a Workspace?

  1. Group of Columns
  2. Group of Worksheets
  3. Group of Rows
  4. Group of Workbooks

26. Which of the following function will use to find the highest number in a series of number ?

  1. HIGH (B1:B3)
  2. MAXIMUM (B1:B3)
  3. MAX(B1:B3)
  4. None of the above

27. How to restrict to run a macro automatically when starting Microsoft Excel?

  1. Hold down the SHIFT key during startup
  2. Hold down the CTRL key during startup
  3. Hold down the ESC key during startup
  4. Hold down the ALT key during startup

28. Which of the following is not an option of the spelling dialog box?

  1. Ignore
  2. Ignore all
  3. Edit
  4. Change

29. The spelling dialog box can be involved by choosing spelling from ……………………

  1. insert
  2. file
  3. tools
  4. view

30. You accidentally erased a record in the sheet. What command can be used to restore it immediately?

  1. Insert
  2. Copy
  3. Undo
  4. Replace

Tags :

Multiple Choice Questions and Answers on MS EXCEL

MS EXCEL Multiple Choice Questions and Answers

MS EXCEL Trivia Quiz

MS EXCEL Question and Answer PDF Online

Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  Netherland  Germany  Sweden  South Africa  Ghana  Tanzania  Nigeria  Kenya  Ethiopia  Zambia  Singapore  Malaysia  India  Pakistan  Nepal  Taiwan  Philippines  Libya  Cambodia  Hong Kong  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  and many more....