In Excel, how to generate 100 instances of the variable x = (x1 + x2)/2, where each xi is distributed as bin(5, 0.2) and n=2?

a) Using VLOOKUP function
b) Using COUNTIF function
c) Using RAND function
d) Using AVERAGE function