Glossary term
What is Exact and approximate match?
In Apex Flow Academy, "Exact and approximate match" means: Exact finds the key as written. Approximate finds the largest lower limit that is not above your number, which suits bands. It is taught in Microsoft Excel: Beginner to Advanced. Related terms include Lookup and key, Criteria, Tidy list and Helper column.
- 1 course teaches it
- plain-word definition
The facts
What is Exact and approximate match?
Exact finds the key as written. Approximate finds the largest lower limit that is not above your number, which suits bands.
Where is Exact and approximate match taught?
Exact and approximate match is defined in Microsoft Excel: Beginner to Advanced.
Which terms are related to Exact and approximate match?
Next to Exact and approximate match in the course glossaries: Lookup and key, Criteria, Tidy list, Helper column, Table, PivotTable, Serial number (dates) and Slicer.
Lookup and keyCriteriaTidy listHelper columnTablePivotTableSerial number (dates)Slicer
The hard questions, answered straight
Bold questions people really ask. Each answer comes from the course data or a settled Academy fact.
Do I need experience before I learn Exact and approximate match?
It depends on the course. Each course that teaches it lists its own prerequisites, and all are listed at beginner level:
- Microsoft Excel: Beginner to Advanced: No earlier spreadsheet experience is needed.