1. Which of the following Microsoft Excel functions was illustrated in this video? Pivot tables Solver Goal seek Filtering 2. The video suggested using which of the following equations to ascertain the value of uncertain cash flows? Net present value to be offset + Present value factor Net present value to be offset + Present value factor Net present value to be offset x Present value factor Net present value to be offset - Present value factor