Course outline / Job and interview practice

Lesson 74 of 75 · Intermediate · 5 exercises

Interview practice: summaries

Totals, counts and averages by group, as asked in job tests.

Start this lesson free

What you'll practise

  1. Total salary for a department
  2. Headcount for a department
  3. Average salary for a department
  4. Count high earners in a department
  5. Count who joined before a date

Total salary for a department

In cell H2, add up the salaries (D2:D6) of the Sales department (C2:C6).

Headcount for a department

In cell H2, count the employees in IT.

Average salary for a department

In cell H2, find the average salary in IT.

Count high earners in a department

In cell H2, count the IT employees earning more than 56,000.

Count who joined before a date

In cell H2, count the employees whose start date (E2:E6) is before 1 January 2020. Use "<"&DATE(2020,1,1) as the criteria.

Try it in a real spreadsheet

Every step checks your answer instantly and tells you exactly what to fix.

Start the lesson

Function guides

← Interview practice: lookupsInterview practice: logic and text →