Excel

Question 1

Index Match

Answer 1

Index(answer column, match(c1, cc1) )

Question 2

Sumif

Answer 2

Sumif(cc1, c1, answer column)

Question 3

Sumifs

Answer 3

=sumifs (answer column, cc1, c1, cc2, c2)

Question 4

Countifs

Answer 4

=countifs (cc1,c1, cc2,c2)

Question 5

NPV (e.g. 5 year NPV)

Discounted net cash flow

Answer 5

Cashflow / ( ( 1 + discount factor / 12 ) ^month )