MS EXCEL Multiple Choice Questions and Answers

51. Which elements of a worksheet can be protected from accidental modification?

1. Objects
2. Scenarios
3. All of the above
4. 4

52. In help menu of Excel, which of the following tabs are found?

1. Answer Wizard tab
2. Index tab
3. all of the above.
4. 4

53. What does COUNTA () function do ?

1. counts selected cells
2. counts empty cells
3. counts non-empty cells
4. 4

54. What is the shortcut key to insert current date in a cell ?

1. CTRL + T
2. CTRL + D
3. CTRL + '
4. 1

55. To select an entire column in MS-EXCEL, press?

1. CTRL + Arrow key
2. CTRL + S
3. None of the above
4. 4

56. What is the short cut key to replace a data with another in sheet ?

1. Ctrl + Shift + R
2. Ctrl + R
3. All of the above
4. 1

57. What is the shortcut key to hide entire column ?

1. CTRL + 0
2. CTRL + -
3. None of the above
4. 2

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

1. Ctrl + Enter
2. Ctrl + Right Arrow key
3. None of the above
4. 1

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

1. Data, Form
2. Data, Table
3. None of the above
4. 1

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

1. Text
2. Fraction
3. None of the above
4. 1