Logo
Section 1 / 7

基本聚合

通过计算总计、平均值和计数等基本汇总,从数据集中获取关键见解。

导入

基本聚合

通过计算总计、平均值和计数等基本汇总,从数据集中获取关键见解。

...
计算总销售额
1.

Can I add numbers from multiple ranges or include specific values in one SUM() formula?

0/500

值得思考的问题

...
确定平均客户评分
1.

Why might knowing the average be more insightful than just the total sum in some business scenarios?

0/500

值得思考的问题

...
查找最低和最高销售额
...
统计数值、非空和空白单元格
1.

If you have a column that contains a mix of text descriptions, numerical ratings, and some empty cells, how would you combine COUNT() and COUNTBLANK() to quickly determine the number of non-numerical descriptions?

0/500

值得思考的问题

数据准备基础

条件聚合