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 Question and Answer