Excel Analysis: Conditional Totals and Weighted Measures

Excel Analysis: Conditional Totals and Weighted Measures

Choose one best answer. Each attempt draws 10 of 20 questions; the practice pass mark is 8/10. SUMIFS, COUNTIFS, weighted averages and dynamic arrays. Use English Excel 365 functions and comma separators. Original topic practice, not an official exam or score prediction.
1 из 10
A store sells 2 units at $10 and 8 units at $20. What is the average price per unit across all units sold?