MS EXCEL Question and Answer


91. What is the AutoComplete feature of Excel?

  1. It automatically completes abbreviated words
  2. It completes text entries that match an existing entry in the same column
  3. It completes text and numeric entries that match an existing entry in the same column
  4. It completes text entries that match an existing entry in the same worksheet

92. What does the NOW() function return?

  1. It returns the serial number of the current date and time
  2. It returns the serial number of the current date
  3. It returns the serial number of the current time
  4. None of the above

93. Long text can be broken down into many lines within a cell. You can do this through

  1. Justify
  2. Wrap Text
  3. Conditional Formatting
  4. None of the above

94. In Excel, by default Numeric Values appears in.

  1. Left aligned
  2. Right aligned
  3. Center aligned
  4. Justify aligned

95. What are the tabs that appear at the bottom of each workbook called ?

  1. Location tabs
  2. Sheet tabs
  3. Reference tabs
  4. None of the above

96. To record a sequence of keystrokes and mouse actions to play back later we use

  1. Media player
  2. Sound Recorder
  3. Calculator
  4. Macro Recorder

97. A function inside another function is called

  1. Nested function
  2. Round function
  3. Inner function
  4. None of the above

98. Which functionin Excel tells how many numeric entries are there ?

  1. NUM
  2. COUNT
  3. SUM
  4. CHKNUM

99. Which of the following is not a valid data type in Excel ?

  1. Number
  2. Character
  3. Label
  4. None of the above

100. Which setting you must modify to print a worksheet using letterhead?

  1. Paper
  2. Margin
  3. Layout
  4. Orientation
Tags

MCQ Multiple Choice Questions and Answers on MS EXCEL

MS EXCEL Trivia Questions and Answers PDF Online

MS EXCEL Question and Answer





Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  Netherland  South Africa  Ethiopia  Zambia  Singapore  Malaysia  India  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  and many more....