Analyze groups of numbers to measure totals, averages, highs, lows, and overall performance.
Calculate The Total Operating Expenses (Jan–Jun)
This sheet displays each department's spending for each month from January to June. Write a formula to calculate the total operating expenses for the entire company over this six-month period, summing all departments and months.
Total your three stores
You manage three of the company’s five stores: Downtown, Harbor, and Midtown. The sheet lists monthly sales for all stores. Write a formula that adds up the total sales for just your three stores.
Are we fast enough?
The support team aims to reply to each email in under 60 minutes. The table shows today’s log for 7 emails. There are several numerical columns, but only one answers the question: What was the average reply time?
What Is the Average Shop Profit?
A company owns four shops. The table lists each shop’s profit for every month from January to April. (A negative number means the shop lost money that month.) Calculate the average monthly profit across all shops and all months.
What's the Highest Daily Output?
A factory operates two machines, A and B. The table lists the number of units produced by each machine every day, along with the number of breakdowns. What is the largest number of units made by one machine in a single day?
What's the Shortest Distance Driven?
A delivery van drives a route every day. The table shows how far the van traveled and how much fuel it used each day. What is the smallest distance the van drove in one day?
Find the Company's Net Profit
This sheet shows a company's first six months. Rows 1 and 2 display income (product sales and service revenue). Rows 3 to 6 show costs (salaries, rent, marketing, and supplies). Calculate the company's net profit for this period. (Net profit = total income − total costs.)
Did Training Boost Daily Sales?
A clothing shop sent its staff to a sales training course. The table shows daily sales for each day of the week before and after the training. How much did the average daily sales increase after the training?
How Much Did All VIP Tickets Sell For?
A company sells two types of conference tickets: Standard and VIP. The table lists each attendee, their ticket type, payment status, and price. What is the total value of all VIP tickets, whether paid or pending?
How Much Has Been Paid for VIP Tickets?
You have a table showing all conference tickets sold. The organizer needs to know the total amount received from VIP tickets that have already been paid for (money in the bank). Only include tickets where both conditions are met: the ticket type is VIP and the payment status is Paid. What is the total amount?
What Is the Average Delivery Time for Riverside?
A delivery company delivers packages in three cities. The table shows each delivery and the time it took in minutes. The manager is concerned about Riverside due to frequent customer complaints. Calculate the average delivery time for Riverside only.
How Much Do London Sales Employees Earn on Average?
A company employs staff in various cities and departments. The table lists each person's monthly pay. What is the average monthly pay for employees who are both based in London and work in the Sales department? Only include people who meet both conditions.
What's the Warehouse Charge?
A company stores extra stock in a rented warehouse. The warehouse charges $4 per box each week. However, the minimum cost to use the warehouse is $50 per week even if you store just a few boxes. If the total box charge is less than $50, you pay $50. If it’s more than $50, you pay the higher amount. This week, the company stored 8 boxes. What is the total warehouse charge? Use the MAX function to resolve this problem.
How Much Will the Worker Be Reimbursed for the Trip?
A worker went on a business trip and wants to be reimbursed for their expenses. The company will pay back the total of all receipts for the trip, but the maximum reimbursement for one trip is $500. The table lists all the receipts. How much will the worker be reimbursed?
What Does One Customer Spend on Average?
Your company owns 8 clothing shops. The table shows, for each shop, the number of sales last month, the total revenue, and the average sale value. Across all 8 shops, what is the overall average sale amount?
How Far Below Average Is the Lowest Seller?
A shop has 8 salespeople. The table shows each person’s sales for this month. The manager wants to see how the lowest seller compares to the team average to prepare his coaching session. What is the difference between the lowest sales amount and the team average?