The SCAN and REDUCE functions in MS Excel allow us to iterate over an array to produce a dynamic array results. While it is often used...