Challenge 2: Confirming XLOOKUP via the Function Wizard — Solution Walkthrough

Steps:
  1. Insert > Function (or click the fx icon on the formula bar).
  2. Browse or search for XLOOKUP.
  3. Compare its listed argument order — lookup_value, lookup_array,
     return_array, and the optional if_not_found and match_mode
     arguments — against Excel Fundamentals Chapter 5's own coverage.

Expected result: the argument order matches exactly — Calc's XLOOKUP
takes the same lookup value, lookup range, return range, and optional
fallback/match-mode arguments in the same positions Excel Fundamentals
Chapter 5 taught.

Why checking the Function Wizard is a better habit than relying on memory, even for a function you're confident about:

Memory is reconstructive, not a perfect record — a small mistake in
argument order or an assumption carried over incorrectly from a
similar but different function (easy to happen with a large function
library) can silently produce a working-looking but wrong formula,
since Calc won't necessarily error just because arguments are
logically misapplied within valid syntax. The Function Wizard costs
one extra click and removes that uncertainty entirely by showing the
function's actual current definition directly, rather than trusting
recall — a small, cheap habit that removes a real, if infrequent,
source of quiet formula bugs.

WHY THIS WORKS AS AN ANSWER
------------------------------
This directly reinforces this chapter's own warning box: the risk
isn't that function names differ often (they mostly don't) — it's the
habit of assuming without checking, which is precisely what the
Function Wizard exists to make unnecessary.