Q251. Which function returns the number of rows in a reference?
Correct Answer: A (ROWS() returns number of rows in a range)
Q252. Which function returns how many columns are in a reference?
Correct Answer: B (COLUMNS(range) returns number of columns)
Q253. Which function transposes rows to columns (and vice versa)?
Correct Answer: C (TRANSPOSE(range) converts rows to columns)
Q254. Which function returns a value from a table based on row and column numbers?
Correct Answer: A (INDEX(array,row_num,[col_num]) returns value)
Q255. Which function returns the position of a lookup value within an array?
Correct Answer: B (MATCH(lookup,range,match_type) returns relative position)
Q256. Which newer Excel function returns unique values from a range?
Correct Answer: A (UNIQUE(range) returns unique values)
Q257. Which function returns an array filtered by a condition?
Correct Answer: B (FILTER(array,include) returns filtered array)
Q258. Which function generates a sequence of numbers in spill range?
Correct Answer: C (SEQUENCE(rows,cols,start,step) creates numbers)
Q259. Which function returns a random decimal between 0 and 1?
Correct Answer: A (RAND() returns random decimal >=0 and <1)
Q260. Which function returns a random integer between two numbers?
Correct Answer: B (RANDBETWEEN(bottom,top) returns integer)
Q261. Which function joins text from range with a delimiter?
Correct Answer: A (TEXTJOIN(delim,ignore_empty,range) joins with delimiter)
Q262. Which function capitalizes the first letter of each word?
Correct Answer: B (PROPER(text) capitalizes each word's first letter)
Q263. Which function returns the leftmost characters from text?
Correct Answer: A (LEFT(text,n) returns leftmost n chars)
Q264. Which function returns the rightmost characters from text?
Correct Answer: B (RIGHT(text,n) returns rightmost n chars)
Q265. Which function extracts characters from the middle of text?
Correct Answer: C (MID(text,start_num,num_chars) extracts substring)
Q266. Which function replaces existing text with new text within a string?
Correct Answer: A (SUBSTITUTE(text,old,new,[instance]) replaces text)
Q267. Which function replaces text by position (start & length)?
Correct Answer: B (REPLACE(old_text,start_num,num_chars,new_text))
Q268. Which function converts a text string that looks like a number into an actual number?
Correct Answer: A (VALUE(text) converts text to number)
Q269. Which function converts text to number using specified decimal and group separators?
Correct Answer: B (NUMBERVALUE(text,decimal_sep,group_sep))
Q270. Which function formats numbers into text using format codes?
Correct Answer: C (TEXT(value,format_text) formats number as text)
Q271. Which function calculates payment for a loan based on constant payments and interest rate?
Correct Answer: A (PMT(rate,nper,pv) returns payment per period)
Q272. Which function computes net present value of an investment based on discount rate and cash flows?
Correct Answer: B (NPV(rate,value1,value2,...))
Q273. Which function returns the internal rate of return for a series of cash flows?
Correct Answer: A (IRR(values,[guess]) returns internal rate)
Q274. Which function calculates IRR for cash flows that are not periodic?
Correct Answer: D (XIRR(values,dates,[guess]) for irregular dates)
Q275. Which argument order is correct for PMT function?
Correct Answer: A (PMT(rate,nper,pv,[fv],[type]))
Q276. Which function returns a date that is a specified number of months before or after a start date?
Correct Answer: C (EDATE(start_date,months) returns offset date)
Q277. Which function returns the last day of the month, n months in the future/past?
Correct Answer: A (EOMONTH(start,months) returns last day of month)
Q278. Which function returns number of whole working days between two dates?
Correct Answer: B (NETWORKDAYS(start,end,holidays) counts working days)
Q279. Which function returns a date after a specified number of working days?
Correct Answer: A (WORKDAY(start,n,holidays) returns date after n working days)
Q280. Which function allows specifying which days are weekend when calculating working days?
Correct Answer: D (WORKDAY.INTL supports custom weekend parameter)
Q281. Which function performs calculations like SUM/AVERAGE only on visible rows (e.g., after filter)?
Correct Answer: A (SUBTOTAL(function_num,range) ignores hidden rows depending on function_num)
Q282. Which function is like SUBTOTAL but supports more operations and options to ignore errors?
Correct Answer: B (AGGREGATE(function_num,options,ref1,[ref2],...) )
Q283. Which function creates a clickable link in a cell?
Correct Answer: C (HYPERLINK(link_location,friendly_name))
Q284. Which function returns the character specified by a number (code)?
Correct Answer: A (CHAR(number) returns character for given code)
Q285. Which function returns numeric code for the first character in a text string?
Correct Answer: B (CODE(text) returns numeric code of first char)
Q286. Which SUBTOTAL function_num ignores manually hidden rows (for SUM use 109)?
Correct Answer: A (Function_num 109 = SUM ignoring manually hidden rows)
Q287. Which newer function splits text into columns using a delimiter?
Correct Answer: C (TEXTTOCOLUMNS feature; TEXTSPLIT is new function in some Excel versions)
Q288. Which Excel tool (not function) splits cell contents into multiple columns based on delimiter?
Correct Answer: B (Data → Text to Columns)
Q289. Where do you change number format (like Currency, Percentage) for a cell?
Correct Answer: A (Right-click → Format Cells → Number tab)
Q290. Which tab contains Conditional Formatting options?
Correct Answer: B (Home → Conditional Formatting)
Q291. Which menu lets you freeze top row or first column?
Correct Answer: A (View → Freeze Panes → Freeze Top Row / First Column)
Q292. Which tab contains the option to protect a worksheet?
Correct Answer: B (Review → Protect Sheet / Protect Workbook)
Q293. Which feature groups rows or columns to create collapsible outlines?
Correct Answer: A (Data → Group/Ungroup creates outlines)
Q294. Which tab do you use to insert a PivotTable?
Correct Answer: B (Insert → PivotTable)
Q295. What feature provides visual filtering controls for PivotTables?
Correct Answer: A (Slicers provide clickable buttons to filter PivotTables)
Q296. Which PivotTable control lets you filter by date ranges visually?
Correct Answer: B (Timeline filters PivotTables by date periods)
Q297. Which feature (also called Power Query) helps import, clean and transform data?
Correct Answer: A (Get & Transform / Power Query)
Q298. Which feature automatically fills values when it detects a pattern as you type?
Correct Answer: B (Flash Fill suggests data based on pattern)
Q299. Which UI element lets you drag to copy cell contents or extend a series?
Correct Answer: A (Fill Handle = small square at bottom-right of cell)
Q300. Which shortcut toggles displaying formulas instead of values in the worksheet?
Correct Answer: B (Ctrl + ` toggles formula view; same key as ~ on some keyboards)
