Q101. Which function returns the average of a set of numbers?
A) COUNT() B) SUM() C) AVERAGE() D) MEDIAN()
Answer: C) AVERAGE()
Q102. Shortcut to insert a new worksheet?
A) Shift + F11 B) Ctrl + N C) Alt + N D) Ctrl + W
Answer: A) Shift + F11
Q103. Which function counts only empty cells?
A) COUNT() B) COUNTA() C) COUNTBLANK() D) ISBLANK()
Answer: C) COUNTBLANK()
Q104. Which shortcut opens the Format Cells dialog?
A) Ctrl + 1 B) Ctrl + F1 C) Alt + 1 D) Shift + F1
Answer: A) Ctrl + 1
Q105. Which feature lets you keep headings visible while scrolling?
A) Freeze Panes B) Split C) Zoom D) Full Screen
Answer: A) Freeze Panes
Q106. Default file extension for modern Excel workbooks is?
A) .xls B) .xlsx C) .csv D) .xlsm
Answer: B) .xlsx
Q107. Which key lets you edit the active cell?
A) F2 B) F3 C) F4 D) Esc
Answer: A) F2
Q108. Which chart is best for showing trends over time?
A) Line Chart B) Pie Chart C) Radar Chart D) Donut Chart
Answer: A) Line Chart
Q109. Which function returns current date and time?
A) DATE() B) TODAY() C) NOW() D) TIME()
Answer: C) NOW()
Q110. VLOOKUP is used for?
A) Horizontal lookup B) Vertical lookup C) Array lookup D) Exact match only
Answer: B) Vertical lookup
Q111. Which function returns number of characters in text?
A) LEN() B) COUNT() C) CHAR() D) LENGTH()
Answer: A) LEN()
Q112. Which function removes leading and trailing spaces?
A) TRIM() B) CLEAN() C) SUBSTITUTE() D) REPLACE()
Answer: A) TRIM()
Q113. Which function gives the position of a value in a range?
A) INDEX() B) MATCH() C) FIND() D) SEARCH()
Answer: B) MATCH()
Q114. Which function can return a value from a table using row & column numbers?
A) VLOOKUP() B) HLOOKUP() C) INDEX() D) MATCH()
Answer: C) INDEX()
Q115. Which feature quickly formats a range as a table?
A) Format Painter B) Insert → Table C) Home → Format as Table D) Both B and C
Answer: D) Both B and C
Q116. Which function returns TRUE if all conditions are TRUE?
A) OR() B) AND() C) ALL() D) EVERY()
Answer: B) AND()
Q117. Which function returns the nth largest value?
A) LARGE() B) MAX() C) TOP() D) RANK()
Answer: A) LARGE()
Q118. Which feature imports and transforms external data?
A) Power Pivot B) Power Query C) Solver D) Flash Fill
Answer: B) Power Query
Q119. Which function finds and replaces text?
A) FIND() B) REPLACE() C) SUBSTITUTE() D) SEARCH()
Answer: C) SUBSTITUTE()
Q120. Which function returns a random number between 0 and 1?
A) RAND() B) RANDBETWEEN() C) RANDOM() D) RANDINT()
Answer: A) RAND()
Q121. What does the TRIM() function do?
A) Removes all spaces B) Removes leading & trailing spaces C) Converts text to uppercase D) Removes punctuation
Answer: B) Removes leading & trailing spaces
Q122. Which function converts text to uppercase?
A) UPPER() B) LOWER() C) PROPER() D) TITLE()
Answer: A) UPPER()
Q123. Which function converts text to lowercase?
A) LOWER() B) UPPER() C) PROPER() D) SMALL()
Answer: A) LOWER()
Q124. Which shortcut inserts current date?
A) Ctrl + ; B) Ctrl + : C) Ctrl + D D) Alt + D
Answer: A) Ctrl + ;
Q125. What is the maximum number of rows in Excel (modern versions)?
A) 65,536 B) 1,048,576 C) 10,48,576 D) 2,097,152
Answer: B) 1,048,576
Q126. Which feature removes duplicate rows?
A) Data → Remove Duplicates B) Conditional Formatting C) Data Validation D) Flash Fill
Answer: A) Data → Remove Duplicates
Q127. Which function returns TRUE if a cell is blank?
A) ISNUMBER() B) ISBLANK() C) IFBLANK() D) EMPTY()
Answer: B) ISBLANK()
Q128. Which function returns the column number of a reference?
A) ROW() B) COL() C) COLUMN() D) ADDRESS()
Answer: C) COLUMN()
Q129. Which function returns the row number of a reference?
A) ROW() B) ROWNUM() C) ROWNUM() D) ROWN()
Answer: A) ROW()
Q130. Which function returns the integer part of a number?
A) ROUND() B) INT() C) TRUNC() D) FLOOR()
Answer: B) INT()
Q131. Which feature shows formulas instead of results?
A) Show Formulas (Ctrl + `) B) Formula Auditing C) Evaluate Formula D) Watch Window
Answer: A) Show Formulas (Ctrl + `)
Q132. Which function returns the position of a text within text (case-sensitive)?
A) SEARCH() B) FIND() C) INSTR() D) LOCATE()
Answer: B) FIND()
Q133. Which combo auto-fills formulas when double-clicking fill handle?
A) Double-click fill handle B) Ctrl + D C) Shift + Enter D) Alt + Enter
Answer: A) Double-click fill handle
Q134. Which function returns the remainder after division?
A) QUOTIENT() B) MOD() C) REM() D) DIV()
Answer: B) MOD()
Q135. Which function returns the current workbook filename?
A) INFO() B) CELL("filename") C) FILENAME() D) WORKBOOK()
Answer: B) CELL("filename")
Q136. Which function returns the smallest value in a range?
A) SMALL() B) MIN() C) LEAST() D) BOTTOM()
Answer: B) MIN()
Q137. Which function joins text with a delimiter (modern Excel)?
A) CONCATENATE() B) TEXTJOIN() C) CONCAT() D) JOIN()
Answer: B) TEXTJOIN()
Q138. Which tool performs what-if analysis with scenarios?
A) Solver B) Scenario Manager C) Goal Seek D) Data Table
Answer: B) Scenario Manager
Q139. Which function returns true if any condition is true?
A) OR() B) AND() C) ANY() D) SOME()
Answer: A) OR()
Q140. Which function converts number to text with format?
A) TEXT() B) FORMAT() C) TO_TEXT() D) VALUE()
Answer: A) TEXT()
Q141. Which feature allows conditional color formatting?
A) Data Validation B) Conditional Formatting C) Format as Table D) Cell Styles
Answer: B) Conditional Formatting
Q142. Which function returns the nth smallest value?
A) SMALL() B) MIN() C) LEAST() D) RANK()
Answer: A) SMALL()
Q143. What does Paste Special → Values do?
A) Pastes formulas B) Pastes only values C) Pastes formatting only D) Pastes links
Answer: B) Pastes only values
Q144. Which function finds an exact match and returns relative position?
A) MATCH() B) INDEX() C) VLOOKUP() D) HLOOKUP()
Answer: A) MATCH()
Q145. Which function returns TRUE if a value is a number?
A) ISNUMBER() B) ISN() C) ISNUM() D) ISDIGIT()
Answer: A) ISNUMBER()
Q146. Which shortcut inserts a chart of the selected data on the current sheet?
A) Alt + F1 B) F11 C) Ctrl + Alt + C D) Shift + F11
Answer: A) Alt + F1
Q147. Which function returns the current worksheet name?
A) SHEETNAME() B) CELL("filename") C) INFO() D) WORKSHEET()
Answer: B) CELL("filename") (contains sheet name)
Q148. Which function returns TRUE if a value is text?
A) ISTEXT() B) ISSTRING() C) ISCHAR() D) ISEXCEL()
Answer: A) ISTEXT()
Q149. Which function returns a value based on row and column match using MATCH with INDEX?
A) INDEX(MATCH()) B) VLOOKUP() C) HLOOKUP() D) LOOKUP()
Answer: A) INDEX(MATCH())
Q150. Which function returns a random integer between two values?
A) RAND() B) RANDBETWEEN() C) RANDOM() D) RANDINT()
Answer: B) RANDBETWEEN()
