Return Of Excel

As my title suggests, The Beaver is back with a new Excel mini lesson again. These time I had to make a table. Here are the formulas that I used:

=average(b2,b3,b4,b5)
=average(c2,c3,c4,c5)
=average(d2,d3,d4,d5)
=average(e2,e3,e4,e5)
to calculate the interpose I used the same formula only with changed data:
=average(b6,c6,d6,e6)
in order to calculate if the student passed or failed use:
F5-> =IF(AVERAGE(B5,E5)<5, "failed", "passed").
That's all for today. Look at the image above.