Exercise catalogue
Choose a category
Pick a topic, then a function. Each exercise opens a real spreadsheet: type the formula, check your answer, and get a hint if you’re stuck.
99 exercises0 completed
Adds numbers.
How SUM worksSUMSum Hours Worked This WeekDaily work hours logged by an employee from Monday to Friday.BeginnerNot startedSUMSum Weekly Grocery SpendingA simple list of daily grocery expenses for one week.BeginnerNot startedSUMSum Monthly Savings DepositsA record of savings deposits made during the first half of the year.BeginnerNot startedSUMTotal Points in a QuizScores earned by a team across five quiz rounds.BeginnerNot startedSUMTotal Books Read by ClassEach student reported how many books they read this month.BeginnerNot startedSUMBudget Remaining Using SUM and MINUSA department has a fixed budget and several spending categories. Use SUM to total spending, then subtract from the budget to find what remains.IntermediateNot startedSUMConditional Sum Using SUM with IF ArrayA warehouse lists item quantities and whether each is 'Fragile' or 'Standard'. Use SUM combined with IF to total only the fragile quantities.IntermediateNot startedSUMCombining SUM with COUNTA for Average CheckA café records daily sales for a week. Use SUM to get the weekly total, then divide by the count of days using COUNTA to compute the average per day.IntermediateNot startedSUMExpense Report with a Constant FeeA small project has four expense lines plus a fixed administrative fee that is not stored in a cell. SUM can add numbers directly as arguments.IntermediateNot startedSUMTotal Sales Above ThresholdA sales manager wants the combined revenue from all orders that exceed a minimum order value.AdvancedNot startedSUMTotal Sales with Conditional SurchargeA finance analyst needs total sales plus a 5% surcharge on sales above 500.AdvancedNot startedSUMTotal Sales in a Unit RangeA planner needs total sales for orders with units between 20 and 50 inclusive.AdvancedNot startedSUMTotal Sales Excluding Two ProductsA category manager wants total sales excluding two discontinued products.AdvancedNot startedSUMTotal with Bonus for Large OrdersA warehouse supervisor needs total payout including a 10% bonus on orders over 30 units.AdvancedNot started