An unhandled error has occurred.
Reload
X
UIZFORGE
Exams
Pricing
Career Paths
Resources
EN
Login
Sign Up
1
/ 5
Intermediate
A formula should return a two-column sorted table of unique customers and their total sales from a transaction table. Which design is most appropriate in Microsoft 365?
Use VLOOKUP to return the first sale for each customer
Use UNIQUE to get customers, MAP or SUMIFS to calculate totals by customer, then SORTBY the result by total
Use Remove Duplicates on the transaction table and sort by Amount
Use IFERROR around a single XLOOKUP
AI Tutor
Stuck? Get a hint
