Excel ROUND Practice Question: Actual sales are in B2:B6 and budget in C2:C6. Show the variance as a decimal…
The question
Actual sales are in B2:B6 and budget in C2:C6. Show the variance as a decimal ((actual - budget) / budget), rounded to 3 decimals, in E2:E6.
The data
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Actual | Budget | Variance % | |
| 2 | North | 118000 | 110000 | ? | |
| 3 | South | 92500 | 95000 | ? | |
| 4 | East | 101200 | 100000 | ? | |
| 5 | West | 87400 | 90000 | ? | |
| 6 | Central | 64300 | 60000 | ? |
The yellow cells are where your answer goes.
Show answer
Expected results:
- E2 = 0.073
- E3 = -0.026
- E4 = 0.012
- E5 = -0.029
- E6 = 0.072
How it works
Explanation: Variance percent shows how far actual is from budget, as a share of the budget. A negative number means the region is below budget.
Syntax: =ROUND((B2-C2)/C2,3)
North is +0.073 (7.3% above budget) and South is -0.026 (2.6% below).
Try it yourself in the live sheet
Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.
Try this question in the live sheet →ROUND syntax
Rounds a number to a set number of decimal places. ROUND is used in financial models and engineering-style calculations where precise numeric work is needed. Full ROUND guide.
More ROUND practice questions
- Using ROUND, round the amount in B2 to 2 decimal places and put it in C2.
- Round each weight to the nearest whole kg and put the results in C2 to C4.
- Using ROUND, round each price to the nearest 10 and put the results in C2 to C4.
- Find the GST on each invoice at the rate in E2, rounded to 2 decimals, and put it in C2…
- Round each price to the nearest 5 and put the results in C2 to C4.
- Find the average mark rounded to 1 decimal and put it in D2.
- The price after the discount in E2 must be a whole rupee amount. Find the final price…
- Round each line total (Qty x Price) to a whole number first, then add the rounded lines…
All practice questions · Excel exercises · Interview prep · Cheat sheet