MS EXCEL MCQ Questions and Answers Quiz

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

  1. Today ()
  2. now ()
  3. time ()
  4. 3

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

  1. Today ()
  2. now ()
  3. time ()
  4. 2

63. Formatting a cell in Currency, you can specify

  1. Currency Symbol
  2. Percentage symbol
  3. None of the above
  4. 2

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

  1. Delete notes
  2. Delete cells
  3. Delete formats
  4. 3

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

  1. Single Accounting
  2. Double Accounting
  3. Single Engineering
  4. 4

66. Comments can be added to cells using …..

  1. Insert -> Comment
  2. File -> Comments
  3. View –> Comments
  4. 2

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

  1. Insert, Chart
  2. Tools, Chart
  3. Format, Chart
  4. 2

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

  1. Place the character T before the number
  2. Place the character TX before the number
  3. Apply the Text format in the cell and type the numbers
  4. 4

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

  1. Alt + Enter
  2. Ctrl + Enter
  3. Shift + Enter
  4. 2

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

  1. Woorksheet
  2. Workbook
  3. Sheet
  4. 3
Tags

MCQ Multiple Choice Questions and Answers on MS EXCEL

MS EXCEL Question and Answer