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 of 10
A1:A3 contains numeric 0, numeric 10, and a genuinely empty cell. What does =AVERAGE(A1:A3) return?