MS EXCEL Multiple Choice Questions and Answers

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

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

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

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

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

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

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

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

95. A function inside another function is called……………………………

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

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

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

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

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

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

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

99. What type of chart is useful for comparing parts of a whole ?

1. Column Chart
2. Line Chart
3. Dot Graph
4. 1

100. What type of chart is useful for comparing vaues over categories ?

1. Column Chart
2. Line Chart
3. Dot Graph
4. 2