MS EXCEL Multiple Choice Questions and Answers

91. What is the symbol for dividing?

1. /
2. %
3. &
4. #

92. What should be add before a fraction to avoid entering it as a date ?

1. //
2. Zero
3. Space
4. None of the above

93. Which of the following is correct ?

1. =POWER(2*3)
2. =POWER(2^3)
3. 8
4. None of the above

94. Give me an example of a cell address.

1. 11 25
2. 911
3. 41A
4. A21

95. Selecting the Column G & H then choose Insert->Columns. What will happen?

1. 2 Columns will be inserted after Column F
2. 2 Columns will be inserted after Column G
3. 2 Columns will be inserted after Column H
4. 2 Columns will be inserted after Column I

96. Where a row and a column meet, what do you call that?

1. A cell
2. A block
3. A box
4. None of the above

97. In Excel, a Data Series is defined as what ?

1. A collection of related data
2. A type of chart
3. A cell reference
4. None of the above

98. In Excel, Columns are labelled as

1. A, B, C, etc
2. 1,2,3 etc
3. A1, A2, etc
4. $A$1, $A$2, etc.

99. In Excel, Rows are labelled as

1. A, B, C, etc
2. 1,2,3 etc
3. A1, A2, etc
4. $A$1, $A$2, etc.

100. The cell reference for cell range of A2 to M12 is

1. A2!M12
2. A2.M12
3. A2;M12
4. A2:M12