MS EXCEL MCQ Questions and Answers Quiz

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
Tags

MCQ Multiple Choice Questions and Answers on MS EXCEL

MS EXCEL Question and Answer