Solutions: Exercise 2 (Formulas & Lookups)
Task 2: SUMIFS
EXCEL
=SUMIFS(Sales[Total], Sales[Product], "Laptop", Sales[Region], "East")
Task 3: XLOOKUP with Fallback
EXCEL
=XLOOKUP(A2, BonusTable[EmpID], BonusTable[BonusPct], 0.0)
Task 4: Text Cleansing
EXCEL
=PROPER(TRIM(A2))
Task 5: Date Tenure
EXCEL
=DATEDIF(B2, TODAY(), "Y")