MS Excel Questions Answers

• 36. What excel feature can you use if you want to work with one record at a time ?

  1. Auto Complete
  2. Data Form
  3. Set Form
  4. Auto Text

  Answer And Explanation

  Answer: Option B

  Explanation:

  • View Answer
  • Comment on this question

• 37. Which function is used for creating a data table ?

  1. Sum
  2. Table
  3. Add
  4. Count

  Answer And Explanation

  Answer: Option B

  Explanation:

  • View Answer
  • Comment on this question

• 38. The accounting style shows negative numbers in ?

  1. Bold
  2. Italics
  3. Parentheses
  4. Quotes

  Answer And Explanation

  Answer: Option C

  Explanation:

  • View Answer
  • Comment on this question

• 39. 3-D reference in a formula ?

  1. Spans worksheets
  2. Can not be modified
  3. Only appears on summary worksheets
  4. Limits the formatting options

  Answer And Explanation

  Answer: Option A

  Explanation:

  • View Answer
  • Comment on this question

• 40. Auto calculate feature provides a quick way to view the results of an arithmetic operation on a range of cells.

  1. True
  2. False

  Answer And Explanation

  Answer: Option A

  Explanation:

  • View Answer
  • Comment on this question

• 41. Which among following wildcard characters are recognized by excel ?

  1. + and -
  2. ! and ^
  3. * and ?
  4. < and >

  Answer And Explanation

  Answer: Option C

  Explanation:

  • View Answer
  • Comment on this question

• 42. Which among following is divide symbol in excel ?

  1. /
  2. D
  3. Div
  4. \

  Answer And Explanation

  Answer: Option A

  Explanation:

  • View Answer
  • Comment on this question