Match the Following Functions with Their Categories of Function

Q21: Advanced filtering will not copy results to

Q22: DSTDEV calculates the standard deviation of a

Q23: Which of the following are not arguments

Q24: The _ function calculates the total future

Q25: What is the purpose of an Excel

Q27: If you need to find the day

Q28: An INDEX function returns the position of

Q29: Which is the Array argument in =INDEX(A2:B5,MATCH(MAX(B2:B5),B2:B5,0),1)?<br>A)MAX(B2:B5)<br>B)MATCH(MAX(B2:B5),B2:B5,0)<br>C)1<br>D)A2:B5

Q30: What is the purpose of the Row_num

Q31: Which financial function calculates the net present