Whats the effective way to generate report of pass/fail test cases in web testing?

If I have to generate a report of overall pass/fail scenarios in excel then whats the best way to do that ? Lets suppose I have 10 scenarios . Below are cases : 1. If I write my one scenario as one ...