# Answer check: Excel calculation practice

The downloaded workbook has one sheet, `Orders`, with three fictional product rows. Initial formula results are cached in the file. The workbook's calculation mode is **Manual**. Check Formulas > Calculation Options before changing an input; Excel may show a different setting if your desktop session already has other workbooks open.

| Cell | Formula or input | Initial expected result | After changing B5 to 3 and recalculating |
| --- | --- | ---: | ---: |
| B5 | KIT-101 quantity | 2 | 3 |
| C5 | KIT-101 unit price | $25.00 | $25.00 |
| D5 | `=B5*C5` | $50.00 | $75.00 |
| D6 | `=B6*C6` = 4 × $12 | $48.00 | $48.00 |
| D7 | `=B7*C7` = 1 × $40 | $40.00 | $40.00 |
| D8 | `=SUM(D5:D7)` | $138.00 | $163.00 |

Independent arithmetic: `2 × 25 + 4 × 12 + 1 × 40 = 138`; after the edit, `3 × 25 + 4 × 12 + 1 × 40 = 163`. The difference is $25.00. A formula displaying `$50.00` immediately after the B5 edit is **stale**, not a valid recalculated result. After calculation, D5 and D8 must both match the last column. If Automatic is enabled, a further quantity edit should update dependent results without clicking Calculate Workbook.

These answers were also checked in a private Excel for the web copy. The first edit after import recalculated despite Manual being shown; a later edit under Manual displayed stale values, and Calculate Workbook produced $75/$163. The account UI was localized, so the English video uses illustrative diagrams.
