MS EXCEL Questions and Answers in Quiz Form 7 for Practice

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

101. The first cell in EXCEL worksheet is labeled as

1. AA
2. A1
3. Aa
4. A0

102. Statistical calculations and preparation of tables and graphs can be done using

1. Adobe Photoshop
2. Excel
3. Notepad
4. Power Point

103. What is the shortcut key to insert new sheet in current workbook ?

1. Alt + F11
2. Ctrl + F11
3. Shift + F11
4. None of the above

104. What is the shortcut key to insert a new comment in a cell ?

1. Alt + F2
2. Ctrl + F2
3. Shift + F2
4. None of the above

105. Functions in MS Excel must begin with

1. An () sign
2. An Equal Sign
3. A Plus Sign
4. A > Sign