Excel exercises
Excel exercises: Adding things up
This group covers addition in a spreadsheet: one column, several blocks, and totals that include only the rows meeting a condition.
SUM skips text and blanks inside the range it is given. A number stored as text therefore disappears from a total and leaves it short, which is the failure the debugging exercise sets up. SUMIF takes the range to test first and the range to add second. SUMIFS reverses that order, and getting the two the wrong way round is the common mistake.
Later exercises add several blocks in one call, build a running total with a locked starting row, and close with a summary asking which summing function a question needs.
Nine exercises run from level 1 to level 3, so the group starts at the smallest possible formula. Every prompt names the cell the total belongs in, and the answer is checked against the number the grader computed separately.
A stale exercise is one you finished two weeks ago or longer. One that needs practice took a hint, or more than one try.
0 of 9 complete
- SUM: total a column Total a column with one function instead of typing every cell.
- SUMIFS: two conditions at once Total the rows that meet two conditions at once instead of filtering the table first.
- SUMIF: a sum range on another column Paid Total one column while testing a different column for the condition.
- Add only the positives Paid Total the positive and negative rows separately instead of netting a column.
- Debug a total that skips a row Paid Find the row a broken total skips and cover it without double-counting a subtotal.
- SUM across several blocks Paid Add several separate blocks, or one block with gaps, in a single SUM call.
- Running total down a column Paid Build a running total that can be filled down without editing each row.
- Sum functions summary Paid Combine SUM and SUMIF to total a column, a subset of it, and the remainder.
- SUMIF: total one region Total only the rows that match a region.