MS Excel Questions Answers

• 64. Which among following can't be considered as worksheet criterion ?

  1. Efficiency
  2. Auditability
  3. Clarity
  4. Description

  Answer And Explanation

  Answer: Option D

  Explanation:

  • View Answer
  • Comment on this question

• 65. When creating a vertical page break ?

  1. The active cell must be in row 1
  2. The active cell must be A1
  3. The active cell must be in row 10
  4. The active cell must be in column A

  Answer And Explanation

  Answer: Option A

  Explanation:

  • View Answer
  • Comment on this question

• 66. The intersection of row and column is called a ?

  1. dataset
  2. cell
  3. data
  4. set

  Answer And Explanation

  Answer: Option B

  Explanation:

  • View Answer
  • Comment on this question

• 67. You will use which feature in excel, if you want to work with one record at a time ?

  1. Auto Complete
  2. Auto Filter
  3. Sub Totals
  4. Data Form

  Answer And Explanation

  Answer: Option D

  Explanation:

  • View Answer
  • Comment on this question

• 68. Which dialogue box we can use to name a constant ?

  1. Create Name
  2. Define Name
  3. Get Name
  4. Create Constant

  Answer And Explanation

  Answer: Option B

  Explanation:

  • View Answer
  • Comment on this question

• 69. One cell format can be copied to another cell by using ?

  1. Format Painter
  2. Format Setting
  3. Format Showing
  4. Format Checking

  Answer And Explanation

  Answer: Option A

  Explanation:

  • View Answer
  • Comment on this question

• 70. Which among following is types of excel data types ?

  1. Numbers, Formulas, Labels
  2. Data, Words, Numbers
  3. Words, Number, Labels
  4. Equations, Data, Numbers

  Answer And Explanation

  Answer: Option A

  Explanation:

  • View Answer
  • Comment on this question