Question

Which formula would you enter into D3, and then AutoFill into D4 to D6, to calculate the winning percentage (Pct.) for the teams?

Answer 1

Answer:
Formula to calculate percentage are=
Winning match/total match *100
And copy paste formula of VLOOKUP in to desire cell formula bar.
Example in spreadsheet :
Winning match=A5
Total match=A6
Write formula in cell D3:
=(A5/A6)*100
And write formula of VLOOKUP into cell D4-D6 to retrieve data from desire cell.