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.
386 exercises0 completed
Value at a row and column.
How INDEX worksINDEXSecond Row, Second ColumnUse INDEX with both row_num and column_num on a small two-column table.BeginnerNot startedINDEXProduct Sales LookupUse INDEX to find the sales figure for the third product in a small list.BeginnerNot startedINDEXLookup a Name by PositionUse INDEX to return a text value from the first column of a table.BeginnerNot startedINDEXPick a Score from a GridUse INDEX with row and column numbers to pull a score from a small grid.BeginnerNot startedINDEXLast Item in a ListUse INDEX to retrieve the final value in a short column of numbers.BeginnerNot startedINDEXINDEX with MATCH for a product's salesUse INDEX with MATCH to retrieve the sales figure for a named product from a two-column table.IntermediateNot startedINDEXINDEX with row and column numbersRetrieve a value from a grid by supplying both a row number and a column number to INDEX.IntermediateNot startedINDEXINDEX with COUNTA for the last valueCombine INDEX with COUNTA to fetch the last entry in a list without hard-coding its position.IntermediateNot startedINDEXINDEX with MATCH for a two-way lookupUse INDEX with two MATCH functions to look up a value by both row label and column label.IntermediateNot startedINDEXTop Salesperson Bonus LookupA sales manager needs the name of the top-performing rep to assign a bonus.AdvancedNot startedINDEXProduct Price by Category and RankA buyer wants the price of the 2nd cheapest item within the 'Office' category.AdvancedNot startedINDEXRegion Total via Two-Way INDEXA finance analyst needs the Q3 total for the West region from a cross-tab.AdvancedNot startedINDEXHighest-Paid Employee in DepartmentHR wants the name of the highest-paid person in the Finance department.AdvancedNot startedINDEXTop-Selling Product by RegionA sales manager wants to identify which product generated the highest sales in the North region using INDEX combined with MATCH and MAX.AdvancedNot started