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.
301 exercises0 completed
Average of numbers.
How AVERAGE worksAVERAGEAverage Monthly RainfallAverage the rainfall over six months.BeginnerNot startedAVERAGEAverage Weekly StepsAverage the step counts recorded over seven days.BeginnerNot startedAVERAGEAverage Product PriceCalculate the average price of five products.BeginnerNot startedAVERAGEAverage Daily TemperatureCompute the average of five daily temperature readings.BeginnerNot startedAVERAGEAverage Quiz ScoresFind the average score of four students on a quiz.BeginnerNot startedAVERAGEAverage of Top Three PricesCombine AVERAGE with LARGE to average only the three highest prices.IntermediateNot startedAVERAGEAverage with Rounded ValuesUse AVERAGE inside ROUND to average measurements and round the result to one decimal.IntermediateNot startedAVERAGEAverage Sales with a Minimum ThresholdCompute the average of monthly sales values that meet a minimum threshold using AVERAGE with a conditional array.IntermediateNot startedAVERAGEAverage Excluding Zero EntriesUse AVERAGE with a condition to ignore zero values in a score list.IntermediateNot startedAVERAGEAverage Sales Above a ThresholdPractice using AVERAGE with a conditional IF array to average only the sales values that exceed a given threshold.IntermediateNot startedAVERAGEAverage of Above-Average SalesA sales analyst wants the average of only those sales figures that exceed the overall average, to highlight strong performers.AdvancedNot startedAVERAGEAverage Score for Passing StudentsA teacher wants the average exam score among students who scored at least 60.AdvancedNot startedAVERAGEAverage Unit Price of In-Stock ProductsA purchasing officer wants the average unit price of products that currently have stock.AdvancedNot startedAVERAGEAverage Order Value for High-Value OrdersA sales manager wants the average order amount among orders that exceeded a 500 threshold.AdvancedNot startedAVERAGEAverage Salary of the Sales DepartmentAn HR analyst needs the average salary for employees in the Sales department only.AdvancedNot started