Learn Excel
EN
Sets how numbers, dates and formulas look, so everything works just like your own Excel.

Home › Learn Excel › Mission

Mission: help the order desk

Customers call with product IDs and names. Look up prices and products from the price list, and catch IDs that don't exist.

  1. Price by ID. The price list is in A:C. The orders come in column E: find the answers in column F. The price of the product ID in E2, in F2
  2. Price by name. The price of the product named in E3, in F3
  3. Most expensive. The name of the most expensive product, in F4
  4. Unknown ID. The price of ID 110 (E5). It doesn't exist: show "Not found" instead of an error

← All lessons