Sheets AcademySheets Academy
Premium
Task #71

Budget vs. actual by department

The CFO asks for a budget vs. actual report on department spending.

  1. In D2:D9, calculate what percentage of the budget was used.
  2. In E2:E9, calculate the variance in dollars: actual minus budget.
  3. Highlight in red the departments that used less than 90% of their budget.
Task #71
Budget vs. actual by department

The CFO asks for a budget vs. actual report on department spending.

  1. In D2:D9, calculate what percentage of the budget was used.
  2. In E2:E9, calculate the variance in dollars: actual minus budget.
  3. Highlight in red the departments that used less than 90% of their budget.