MS EXCEL MCQs Quiz Multiple Choice Questions & Answers

MS EXCEL MCQs questions answers

Test Your Skills in MS EXCEL Quiz Online

Delve into the world of MS Excel MCQ Multiple Choice Questions and Answers (MCQs), accessible online and downloadable in PDF format. Whether you're gearing up for exams or preparing for job interviews, our extensive MS Excel MCQs cover a broad spectrum of topics, including functions, formulas, data analysis, charting, macros, and more. Tailored to enhance your understanding and mastery of Excel, our MCQ resources provide a convenient platform to assess your knowledge, pinpoint areas for improvement, and bolster your confidence. Each question is accompanied by detailed explanations, empowering you to deepen your comprehension and excel in spreadsheet management. Access our online MS Excel MCQs anytime, anywhere, or download the PDF version for offline study sessions. Embark on your journey to Excel proficiency and unlock new opportunities in academia and career advancement with our invaluable MCQ resources today!

MS EXCEL Questions with Answers

1. What is the short cut key to highlight the entire column ?

2. How do you rearrange the data in ascending or descending order ?

3. If 4/6 entered in a cell without applying any formats, Excel will treat this as

4. How do you display current date and time in MS Excel?

5. How do you display current date only in MS Excel?

6. Formatting a cell in Currency, you can specify

7. Which is not the function of “Edit, Clear” command?

8. Which of the following is not an underline option in the format cells dialog box?

9. Comments can be added to cells using

10. Which would you choose to create a bar diagram?

11. Which of the following options is appropriate to show the numbers 9779851089510 in a cell?

12. Which of the following shortcuts can be used to insert a new line in the same cell?

13. An Excel file is generally called a / an :

14. Which of the following is the oldest spreadsheet package ?

15. Which key do you press to check spelling?

16. What is the keyboard shortcut for creating a chart from the selected cell range ?

17. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts ?

18. MS-EXCEL can be used to automate

19. Which of the following format you can decide to apply or not in AutoFormat dialog box ?

20. Which menu option can be used to split windows into two?

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

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

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

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

25. What do you mean by a Workspace?

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

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

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

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

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

31. The active cell:

32. What is the AutoComplete feature of Excel?

33. What does the NOW() function return?

34. Long text can be broken down into many lines within a cell. You can do this through

35. In Excel, by default Numeric Values appears in.

36. What are the tabs that appear at the bottom of each workbook called ?

37. To record a sequence of keystrokes and mouse actions to play back later we use

38. A function inside another function is called

39. Which functionin Excel tells how many numeric entries are there ?

40. Which of the following is not a valid data type in Excel ?

41. Which setting you must modify to print a worksheet using letterhead?

42. What type of chart is useful for comparing parts of a whole ?

43. What type of chart is useful for comparing vaues over categories ?

44. What type of chart is useful for showing trends or changes over time ?

45. What do you use to create a chart?

46. Which function is not available in the Consolidate dialog box?

47. Which of the following methods will not enter data in a cell?

48. Getting data from a cell located in a different sheet is called

49. If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?

50. Text formula:


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

United States, United Kingdom, India, Nigeria, Philippines, Pakistan, Nepal, Singapore, Indonesia, Bangladesh, Ghana, United Arab Emirates, Kenya, Canada, Malaysia, Australia, Iran, South Africa, Uganda, France, Ireland, Egypt, Tanzania, Ethiopia, Thailand, Sri Lanka, Cameroon, Hong Kong, Spain, Vietnam, New Zealand, Japan, Brazil, Saudi Arabia, Zambia, Czechia, Italy, Russia, Myanmar (Burma), Netherlands, Germany, Romania, Mexico, Rwanda, Sierra Leone, Turkey, Zimbabwe, Poland, Iraq, Cyprus, Algeria, Liberia, Greece, Jamaica, Malawi, Qatar, Portugal, South Korea, Argentina, Colombia, Morocco, Peru, Kuwait, Lithuania, Finland, Somalia, Israel, Bulgaria, Chile, Hungary, Trinidad & Tobago, Uzbekistan, Ukraine, Sweden, Kazakhstan, Norway, Macedonia, Benin, Switzerland, Oman, Botswana, Belgium, Ecuador, Slovakia, China, Croatia, Brunei, Serbia, Papua New Guinea, Bahrain, Guyana, Denmark, Lesotho, Lebanon, Jordan, Azerbaijan, Latvia, Cambodia, Namibia, Mauritius, Austria, Mongolia, Albania, Libya, Gambia, Taiwan, Bhutan, Venezuela, Dominican Republic, Tunisia, Luxembourg, Bosnia & Herzegovina, Guatemala, Solomon Islands, Guam, Costa Rica, Yemen, Bolivia, and many more ...