Excel Quiz 58

Cell A2 contains the string "Red,Green;Blue".

Which modern array formula correctly splits this text into separate columns using both the comma and semicolon as delimiters?

Cell A2 contains a sentence with words separated by standard spaces.

Using modern dynamic arrays, what is the most concise way to extract exactly the 3rd word from the sentence?

You need to find the latest price of a product in a log where new entries are added to the bottom.

Which XLOOKUP search mode parameter will search from the bottom of the array up to the top?

Column B contains Item Quantities and Column C contains Unit Prices.

Which formula calculates the total revenue without requiring a separate helper column to multiply each row?

Column A contains a list of cities with many duplicates.

Which formula returns a dynamically sorted list of unique cities?

You are merging two tables in Power Query based on a common Customer ID. You want to keep all rows from the first table, and only the matching rows from the second table.

Which Join Kind should you select?

A complex financial model is running slowly due to excessive recalculations.

Which of these functions is "volatile" and triggers a recalculation every time any change is made anywhere in the worksheet?

Column A contains Employee names, and Column B contains their Department.

Which formula returns employees from either the "IT" department OR the "HR" department?

Cell D1 contains the exact text string "Sales!A1:A10".

Which formula correctly sums the range specified by the text in cell D1?

You need to calculate (x+y)*x, where 'x' is the sum of A1:A10 and 'y' is the sum of B1:B10.

Which formula uses LET correctly to define variables and execute the calculation?