MS EXCEL MCQ Multiple Choice Questions Answers - Page 4 for Practice
91. What is the AutoComplete feature of Excel?
Correct Answer is: It completes text entries that match an existing entry in the same column
92. What does the NOW() function return?
Correct Answer is: None of the above
93. Long text can be broken down into many lines within a cell. You can do this through
Correct Answer is: Wrap Text
94. In Excel, by default Numeric Values appears in.
Correct Answer is: Right aligned
95. What are the tabs that appear at the bottom of each workbook called ?
Correct Answer is: Sheet tabs
96. To record a sequence of keystrokes and mouse actions to play back later we use
Correct Answer is: Macro Recorder
97. A function inside another function is called
Correct Answer is: Nested function
98. Which functionin Excel tells how many numeric entries are there ?
Correct Answer is: COUNT
99. Which of the following is not a valid data type in Excel ?
Correct Answer is: Character
100. Which setting you must modify to print a worksheet using letterhead?
Correct Answer is: Margin
101. What type of chart is useful for comparing parts of a whole ?
Correct Answer is: Pie Chart
102. What type of chart is useful for comparing vaues over categories ?
Correct Answer is: Column Chart
103. What type of chart is useful for showing trends or changes over time ?
Correct Answer is: Line Chart
104. What do you use to create a chart?
Correct Answer is: Chart Wizard
105. Which function is not available in the Consolidate dialog box?
Correct Answer is: Pmt
106. Which of the following methods will not enter data in a cell?
Correct Answer is: Pressing the Esc key
107. Getting data from a cell located in a different sheet is called
Correct Answer is: Referencing
108. If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?
Correct Answer is: Insert a row
109. Text formula:
Correct Answer is: Concatenate and manipulate text
110. To return the remainder after a number is divided by a divisor in EXCEL we use the function ?
Correct Answer is: MOD ( )
111. Which of the following function will return a value of 8?
Correct Answer is: Only B and C
112. You are editing a worksheet that you had previously saved. If you want to save the edited sheet without losing the original one, which command should you use ?
Correct Answer is: Save
113. What is the correct way to refer the cell A10 on sheet3 from sheet1?
Correct Answer is: sheet3!A10
114. The Software which contains rows and columns is called
Correct Answer is: Spreadsheet
115. It is a collection of data that is stored electronically as a series of records in a table.
Correct Answer is: database
116. Which area in an Excel window allows entering values and formulas ?
Correct Answer is: Formula Bar
117. Excel displays the current cell address in the
Correct Answer is: Name Box
118. Which one is not a Function in MS Excel ?
Correct Answer is: AVG
119. Hyperlinks can be
Correct Answer is: All of the above
120. In Excel ……………………………….may not contain in Formula
