MS EXCEL MCQ Multiple Choice Questions Answers - Page 4 for Practice
91. What is the symbol for dividing?
Correct Answer is: /
92. What should be add before a fraction to avoid entering it as a date ?
Correct Answer is: Space
93. Which of the following is correct ?
Correct Answer is: 8
94. Give me an example of a cell address.
Correct Answer is: A21
95. Selecting the Column G & H then choose Insert->Columns. What will happen?
Correct Answer is: 2 Columns will be inserted after Column F
96. Where a row and a column meet, what do you call that?
Correct Answer is: A cell
97. In Excel, a Data Series is defined as what ?
Correct Answer is: A collection of related data
98. In Excel, Columns are labelled as
Correct Answer is: A, B, C, etc
99. In Excel, Rows are labelled as
Correct Answer is: 1,2,3 etc
100. The cell reference for cell range of A2 to M12 is
Correct Answer is: A2:M12
101. The first cell in EXCEL worksheet is labeled as
Correct Answer is: A1
102. Statistical calculations and preparation of tables and graphs can be done using
Correct Answer is: Excel
103. What is the shortcut key to insert new sheet in current workbook ?
Correct Answer is: Shift + F11
104. What is the shortcut key to insert a new comment in a cell ?
Correct Answer is: Shift + F2
105. Functions in MS Excel must begin with
Correct Answer is: An Equal Sign
106. What happens when dollar signs ($) are entered in a cell address? (ex. $B$2:$B$10)
Correct Answer is: An absolute cell address is created.
107. A numeric value can be treated as label value if …… precedes it.
Correct Answer is: Apostrophe (')
108. Concatenation of text can be done using
Correct Answer is: Ampersand (&)
109. The name box
Correct Answer is: Appears to the left of the formula bar
110. Which Chart can be created in Excel?
Correct Answer is: All of the above
111. The Greater Than sign is an example of …………………….. operator.
Correct Answer is: Logical
112. NOT, AND, OR and XOR are
Correct Answer is: Logical Operators
113. The process of arrenging the items of a column in some sequence or order is known as
Correct Answer is: Sorting
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 ……………
Correct Answer is: descending order
115. The ………………………… feature of MS Excel quickly completes a series of data
Correct Answer is: Auto Fill
116. In Excel, you can sum a large range of data by simply selecting a tool button called
Correct Answer is: Auto sum
117. In Excel, which one denoted a range from B1 through E5
Correct Answer is: B1:E5
118. What is represented by the small, black square in the lower-right corner of an active cell or range ?
Correct Answer is: Fill handle
119. How do you tell one cell from another ?
Correct Answer is: By its address
120. How to remove the unwanted action from recorded macro without recording the whole macro again?
Correct Answer is: By edit the macro in the Visual Basic Editor
