Matching
Match the terms to their descriptions:
Premises:
Lookup table
Quick Analysis
Logical test
Nested function
Breakpoint
Responses:
range containing values or text that can be retrieved
lowest value for a category or in a series
set of analytical tools in Excel 2013
when one function is embedded as an argument within another function
formula that contains either a value or an expression that evaluates to true or false
Correct Answer:
Premises:
Responses:
Lookup table
Quick Analysis
Logical test
Nested function
Breakpoint
Premises:
Lookup table
Quick Analysis
Logical test
Nested function
Breakpoint
Responses:
Related Questions
Q14: Because the SUM function is a rarely
Q17: When might you want to use an
Q18: An argument is an operator such as
Q19: What is syntax and why is it
Q20: How many arguments are required for the
Q21: Syntax:<br>A)displays a list of functions and defined
Q23: What does the MEDIAN function do?<br>A)Identifies the
Q26: The _ function category performs calculations such
Q27: Match the function categories to their descriptions:
Q80: A mixed cell reference<br>A) occurs when a