Task from Suresh Sharma, Owner, Sharma Distributors
My nephew made this sheet and left the important cells empty. Fill them with proper FORMULAS, not typed numbers, I will change the data next month and the sheet must still work. Column E needs the line total for every order row. Then the three summary cells at the bottom.
- E1 to E10: line total, quantity times unit price, as a formula in every row.
- E12: total revenue across all ten orders, one SUM formula.
- E13: average line total, one AVERAGE formula.
- E14: highest single line total, one MAX formula.
Formulas evaluate live in the grid. Typed numbers fail the check even when the value is right. Pass all four checks to unlock the AI review.