MS EXCEL Multiple Choice Questions and Answers

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