Advanced Excel — Practice Quiz — Quiz in Progress

Q1. In VLOOKUP, the fourth argument FALSE means: AReturn an error always BExact match required CSearch bottom-up DIgnore the first row

Q2. A key advantage of XLOOKUP over VLOOKUP is: AIt only works on Mac BIt can look left and doesn't break when columns are inserted CIt requires sorted data DIt is slower

Q3. To total sales for product 'Tea' in region 'East', use: ASUM BSUMIFS CLEN DTRIM

Q4. IFERROR(VLOOKUP(...),"Not found") does what? AHides all results BShows 'Not found' instead of an error when lookup fails CDeletes missing rows DFixes the source data