MS EXCEL Questions and Answers in Quiz Form 8 for Practice

106. What happens when dollar signs ($) are entered in a cell address? (ex. $B$2:$B$10)

1. An absolute cell address is created.
2. Cell address will change when it is copied to another cell.
3. The sheet tab is changed.
4. The status bar does not display the cell address.

107. A numeric value can be treated as label value if …… precedes it.

1. Apostrophe (')
2. Exclamation (!)
3. Hash (#)
4. Tilde (~)

108. Concatenation of text can be done using

1. Apostrophe (')
2. Exclamation (!)
3. Hash (#)
4. Ampersand (&)

109. The name box

1. Appears below the status bar
2. Appears to the left of the formula bar
3. Shows the location of the previously active cell
4. None of the above

110. Which Chart can be created in Excel?

1. Area
2. Line
3. Pie
4. All of the above

111. The Greater Than sign is an example of …………………….. operator.

1. Arithmatic
2. Logical
3. Conditional
4. Greater

112. NOT, AND, OR and XOR are

1. Arithmetic operators
2. Relational operators
3. Logical Operators
4. None of the above

113. The process of arrenging the items of a column in some sequence or order is known as

1. Arrengin
2. Autofill
3. Sorting
4. Filtering

114. In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in ……………

1. ascending order
2. descending order
3. alphabetical order
4. random order

115. The ………………………… feature of MS Excel quickly completes a series of data

1. Auto Complete
2. Auto Fill
3. Fill Handle
4. Sorting

116. In Excel, you can sum a large range of data by simply selecting a tool button called

1. Auto sum
2. Auto correct
3. AutoFill
4. None of the above

117. In Excel, which one denoted a range from B1 through E5

1. B1 - E5
2. B1:E5
3. B1 to E5
4. B1$E5

118. What is represented by the small, black square in the lower-right corner of an active cell or range ?

1. Border
2. Copy handle
3. Fill handle
4. None of the above

119. How do you tell one cell from another ?

1. By its address
2. By numbers
3. By letters
4. All of the above

120. How to remove the unwanted action from recorded macro without recording the whole macro again?

1. By using the Find and Edit Action Option
2. By clicking on the Refresh button in the Macro toolbar
3. By edit the macro in the Visual Basic Editor
4. Macro cannot be edited.