开始使用免费开始使用

Number of reports by person and type

Your previous work found the number of reports, total expenditure, and average expenditure for each person, but being able to see a breakdown by person and type of expenditure would reveal even greater insights.

In this exercise, you'll calculate the total number of reports for each person and expense type, which are stored in the grid, G8:K11.

本练习是课程的一部分

Google Sheets 数据分析

查看课程

练习说明

  • In H9:K11, count the number of expense reports for each person/expense type pair.

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习