Skip to content

Business Excel & Job Interview Challenges · Exercise 2 of 10 · Finance · Intermediate · 25 min · Premium

Department Budget Variance

Report budget against actual for eight departments: variance in dollars, a status with an on-track band, total variance and the biggest overspend.

What you will practise: Calculate variances with a consistent sign convention, classify them with a tolerance band, and find the largest overspend.

Premium

This is a Premium exercise

Premium members can open this exercise and practise it in the spreadsheet.

Upgrade to PremiumAlready a member? Open exercise

Open exercise