Home › Learn Excel › Test
No tips this time. Answer the questions and see your score: 70% or more and you've passed.
XLOOKUP looks for a value in one column and returns the value from the same row in another column. Find the price of product P-104 in F2HLOOKUP is VLOOKUP turned on its side: it looks along the top row and returns a value from a row below. Look up the sales for the month in A6, in B6MATCH finds the row of a value, and INDEX returns what's in that row of another column. Together they look up anything. Find the department of Dina in F2UNIQUE removes the duplicates from a list. The answer spills into the cells below by itself. List every region once, starting in C2FILTER returns every row that meets a condition. The answer spills into the cells below by itself. List everyone who works in Sales, starting in D2