Calculating NPV

In class we used four different formulas for calculating NPV$.$ For the example below show $4$ different formulas, each using different Excel functions, to calculate NPV$.$ Enter each formula in the yellow$-$fill cells. Do not enter data into cells other than the $4$ answer cells!

$\backslash$table$[[$Opportunity Cost of Capital $=,10\mathrm{.}0\%,,],[$Year$,$NCF$,\backslash$table$[[$Discount$],[$factor$]],PV(NCF)$