Practice Excel formulas until they stick

The free Excel formulas and functions set covers lookup formulas like VLOOKUP and INDEX MATCH, logical functions like IF and IFS, conditional aggregation like SUMIF and COUNTIF, plus text and date functions - the topics most Excel assessments test.

Yes. You can study every quiz and flashcard in the Excel formulas set for free on Gradiuz, and copy them to your own library with a free account to track your progress.

VLOOKUP only searches the first column of a range and returns a value from a column to its right, and it defaults to approximate match. XLOOKUP replaces both VLOOKUP and HLOOKUP: it can look in any direction, defaults to exact match, takes a return range instead of a column index number, and has a built-in if-not-found argument. XLOOKUP is available in Excel 2021, Excel 365 and Excel for the web.

Use INDEX MATCH when the value you want to return is to the left of the lookup column, or when columns may be inserted or deleted - VLOOKUP breaks because it counts columns by number, while INDEX MATCH references the return column directly. On very wide tables it can also be faster because it only scans two columns.

A #N/A error means the lookup value was not found: most often the value genuinely is not in the first column, there are trailing spaces, or a number is stored as text on one side of the comparison. It also happens when the last argument is TRUE (approximate match) on unsorted data. Wrap the formula in IFNA or IFERROR to show a friendly fallback.

SUMIF handles a single condition and takes the criteria range first: SUMIF(range, criteria, sum_range). SUMIFS handles one or more conditions and reverses the order - the sum range comes first: SUMIFS(sum_range, criteria_range1, criteria1, ...). The same pattern applies to COUNTIF vs COUNTIFS and AVERAGEIF vs AVERAGEIFS.

Yes. Employer Excel assessments focus heavily on formulas: lookups, conditionals, and aggregation. Drilling them as quiz questions and flashcards trains the recall those tests reward. Always check what version and topics your specific assessment covers.

Yes. Upload your Excel notes, a training manual chapter, or a formulas cheat sheet and Gradiuz generates tailored practice questions, flashcards, and summaries from your material.

Yes. Gradiuz flashcards use an SM-2 based spaced repetition schedule, so the formulas you find hardest - like nested IFs or INDEX MATCH syntax - come back more often until you know them.

Yes. Your first AI generations are free and no credit card is required to get started.