MS Excel MCQs – 50 Important Questions for Exam | Part 5 (Q201–Q250)
Q201. Which symbol starts a formula in Excel?
Correct Answer: B (=) (Formula always starts with equal sign)
Q202. Shortcut to insert a new worksheet?
Correct Answer: B (Shift + F11) (Inserts a new worksheet)
Q203. What does CONCAT function do?
Correct Answer: B (Joins text strings) (CONCAT / CONCATENATE combine texts)
Q204. Which function counts non-empty cells?
Correct Answer: C (COUNTA()) (Counts non-empty cells)
Q205. Which function adds a range of cells?
Correct Answer: A (SUM() — Adds numbers in a range)
Q206. Which key edits the active cell?
Correct Answer: C (F2) (F2 allows editing in the cell)
Q207. Which chart type shows proportions of a whole?
Correct Answer: B (Pie Chart) (Good for part-to-whole)
Q208. Which function returns current date & time?
Correct Answer: C (NOW() returns date & time)
Q209. Shortcut to save workbook?
Correct Answer: B (Ctrl + S) (Save shortcut)
Q210. Which function counts blank cells?
Correct Answer: C (COUNTBLANK() — counts empty cells)
Q211. Which function removes extra spaces from text?
Correct Answer: B (TRIM() removes leading/trailing extra spaces)
Q212. A reference like A$1 is called?
Correct Answer: C (Mixed — column relative, row absolute)
Q213. What is the maximum number of columns in Excel 2019?
Correct Answer: B (16,384 columns — A to XFD)
Q214. Which function combines text from multiple cells?
Correct Answer: B (CONCATENATE/CONCAT joins text)
Q215. In newer Excel versions, old-style comments are called?
Correct Answer: A (Notes — legacy comments now called Notes)
Q216. Shortcut to open Format Cells dialog?
Correct Answer: A (Ctrl + 1 opens Format Cells)
Q217. Which function returns the average of numbers?
Correct Answer: B (AVERAGE() — computes mean)
Q218. Shortcut for AutoSum is?
Correct Answer: B (Alt + = activates AutoSum)
Q219. Which function counts cells based on a condition?
Correct Answer: A (COUNTIF() counts cells meeting a condition)
Q220. Which function returns text length (number of characters)?
Correct Answer: C (LEN() returns number of characters)
Q221. Which function converts number to formatted text?
Correct Answer: A (TEXT(value, format_text) converts numbers to formatted text)
Q222. Which function returns current date only?
Correct Answer: C (TODAY() returns current date)
Q223. Which function returns current time only?
Correct Answer: A (TIME() can return a time value; NOW() returns date+time)
Q224. Which function returns maximum value from range?
Correct Answer: B (MAX() returns largest number)
Q225. Which function converts text to uppercase?
Correct Answer: B (UPPER() converts text to uppercase)
Q226. Which function converts text to lowercase?
Correct Answer: A (LOWER() converts text to lowercase)
Q227. Which function capitalizes first letter of each word?
Correct Answer: A (PROPER() capitalizes first letter of each word)
Q228. Which chart Excel often uses as default for many data sets?
Correct Answer: B (Column chart is a common default)
Q229. Shortcut to open Save As dialog?
Correct Answer: A (F12 opens Save As)
Q230. Shortcut to select entire worksheet?
Correct Answer: A (Ctrl + A selects whole sheet / region)
Q231. Shortcut to insert a new column?
Correct Answer: A (Ctrl + Shift + + inserts row/column)
Q232. Shortcut to delete selected column?
Correct Answer: A (Ctrl + - deletes selected row/column)
Q233. Which function returns integer part of a number?
Correct Answer: B (INT() returns integer part; TRUNC can too)
Q234. Which function rounds number down?
Correct Answer: B (ROUNDDOWN() forces rounding down)
Q235. Which function rounds number up?
Correct Answer: A (ROUNDUP() rounds up)
Q236. Which function counts based on multiple conditions?
Correct Answer: B (COUNTIFS allows multiple criteria)
Q237. Shortcut to insert new worksheet?
Correct Answer: A (Shift + F11 inserts a new worksheet)
Q238. Which function finds difference between two dates?
Correct Answer: A (DATEDIF(start,end,unit) returns difference)
Q239. Which function returns weekday number from a date?
Correct Answer: B (WEEKDAY(date) returns day number 1–7)
Q240. Which function extracts month from a date?
Correct Answer: B (MONTH(date) returns month number)
Q241. Which function extracts year from a date?
Correct Answer: A (YEAR(date) returns the year)
Q242. Shortcut to bold selected text?
Correct Answer: A (Ctrl + B applies bold)
Q243. Shortcut to italicize text?
Correct Answer: A (Ctrl + I italics)
Q244. Shortcut to underline text?
Correct Answer: A (Ctrl + U underlines)
Q245. Which function returns the nth largest value?
Correct Answer: B (LARGE(range,n) returns nth largest)
Q246. Which function returns the nth smallest value?
Correct Answer: B (SMALL(range,n) returns nth smallest)
Q247. Which function calculates future value (financial)?
Correct Answer: A (FV() returns future value)
Q248. Which function returns the future value for an investment?
Correct Answer: A (FV() calculates future value)
Q249. Which function returns present value?
Correct Answer: A (PV() returns present value)
Q250. Which function returns payment per period for a loan?
Correct Answer: A (PMT() calculates payment per period)
