Multiple Choice
What is the purpose of an Excel What-if scenario?
A) A two-variable goal seek tool
B) Any what-if analysis
C) A tool that changes one variable through several iterations
D) Detailed set of values that represent different possible situations
Correct Answer:

Verified
Correct Answer:
Verified
Q20: Match each of the following terms to
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
Q26: Match the following functions with their categories
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