Excel Core Functions and Formula Mastery Questions

Strong proficiency with essential Excel functions: VLOOKUP and INDEX-MATCH for data lookups, IF and nested IF statements for logic, SUM/SUMIF/SUMIFS for conditional aggregation, PivotTables for data summarization, TEXT functions for formatting, IFERROR for error handling, COUNTIF/COUNTA for counting. Build efficient, understandable formulas that other people can audit and modify. Understand formula best practices and when to use each function type.