Sheets AcademySheets Academy
Premium
Task #90

Family trip budget

A family is back from a trip to San Diego and is checking their spending against the budget in column F.

  1. In G2:G5, calculate how much was spent in each category.
  2. In H2:H5, show each category's share of all spending.
  3. In I2:I5, write “Over budget” if they spent more than the budget, otherwise “Within budget”.
Task #90
Family trip budget

A family is back from a trip to San Diego and is checking their spending against the budget in column F.

  1. In G2:G5, calculate how much was spent in each category.
  2. In H2:H5, show each category's share of all spending.
  3. In I2:I5, write “Over budget” if they spent more than the budget, otherwise “Within budget”.