MS EXCEL MCQ Questions and Answers Quiz

31. In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in ……………

  1. descending order
  2. alphabetical order
  3. random order
  4. 2

32. The ………………………… feature of MS Excel quickly completes a series of data

  1. Auto Fill
  2. Fill Handle
  3. Sorting
  4. 2

33. In Excel, you can sum a large range of data by simply selecting a tool button called ....

  1. Auto correct
  2. AutoFill
  3. None of the above
  4. 1

34. In Excel, which one denoted a range from B1 through E5

  1. B1:E5
  2. B1 to E5
  3. B1$E5
  4. 2

35. What is represented by the small, black square in the lower-right corner of an active cell or range ?

  1. Copy handle
  2. Fill handle
  3. None of the above
  4. 3

36. How do you tell one cell from another ?

  1. By numbers
  2. By letters
  3. All of the above
  4. 1

37. How to remove the unwanted action from recorded macro without recording the whole macro again?

  1. By clicking on the Refresh button in the Macro toolbar
  2. By edit the macro in the Visual Basic Editor
  3. Macro cannot be edited.
  4. 3

38. In a report, you need to show the monthly rainfall in Nepal. The best way to do this is to insert a

  1. photograph of rainfall
  2. chart showing rainfall amounts
  3. database of rainfall
  4. 3

39. The box on the chart that contains the name of each individual record is called the ………………………………

  1. title
  2. axis
  3. legend
  4. 4

40. The basic unit of a worksheet into which you enter data in Excel is called a

  1. table
  2. box
  3. column
  4. 1
Tags

MCQ Multiple Choice Questions and Answers on MS EXCEL

MS EXCEL Trivia Questions and Answers PDF

MS EXCEL Question and Answer

Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  Netherland  South Africa  Ethiopia  Zambia  Singapore  Malaysia  India  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  and many more....