開始使用免費開始

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.

動手互動練習

將理論付諸實踐,立即體驗我們的互動練習

開始練習