Excel's query tool reshapes messy imports into 1NF, so AVERAGEIFS replaces hacks and your summaries run faster.
If Excel is showing formulas instead of results on your Windows PC, check the cell format, turn off the 'Show Formulas' ...