MS EXCEL MCQ Quiz - Multiple Choice Questions & Answers Page 10

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