$(1)$ What is the value at the end of Year $3$ of the following cash flow stream if the quoted interest rate is $10\%,$ compounded semiannually? $-$ how to do it in excel

$0-$ $$0,1-$ $$100,2-$ $$100,3-$ $$100$

$(2)$ What is the PV of the same stream?