12 questions. Score 70% or more to pass this rank's quiz.
XLOOKUP does an exact match by default, and with no if_not_found value a missing key returns #N/A.
Excel's ROUND rounds halves away from zero, so 2.5 becomes 3 (not banker's rounding).
TRIM removes leading/trailing spaces and collapses inner runs to one space, leaving "Sunshine Grocers" (16 characters).
COUNTIFS accepts multiple range/criteria pairs and counts rows that meet all of them.
The relative reference B2 shifts one row to B3, while the absolute reference $F$1 stays locked.
1/0 produces #DIV/0!, and IFERROR replaces any error with the value you supply.
Dynamic array formulas never overwrite cells; if anything is in the spill range, the formula returns #SPILL! until you clear it.
range_lookup defaults to TRUE (approximate match), a classic source of wrong results; pass FALSE or use XLOOKUP for exact matches.
EOMONTH moves 1 month forward and returns that month's last day; 2024 is a leap year, so it is Feb 29.
The optional if_empty argument is returned when no rows meet the condition; without it FILTER returns #CALC!.
Unpivot turns column headers into row values, producing one row per item per month, which is what PivotTables and Power BI expect.
The comparison yields TRUE/FALSE, which multiplying converts to 1/0, so only 10 and 30 are summed.
DashCoreHub