Matching
Match the function categories to their descriptions:
Premises:
Lookup & Reference
Logical
Statistical
Date & Time
Financial
Responses:
looks up values in cells and creates links to cells
provides methods for manipulating date and time values
performs test with AND,OR,and NOT
averages and standard deviations,for example
performs financial calculations such as payments rates,and present value.
Correct Answer:
Premises:
Responses:
Lookup & Reference
Logical
Statistical
Date & Time
Financial
Premises:
Lookup & Reference
Logical
Statistical
Date & Time
Financial
Responses:
Related Questions
Q14: Because the SUM function is a rarely
Q22: Match the terms to their descriptions:
Q23: What does the MEDIAN function do?<br>A)Identifies the
Q24: The IF function only evaluates a condition
Q26: The _ function category performs calculations such
Q28: While lookup tables are typically designed vertically,they
Q29: Match the math and statistical functions to
Q30: The IF function in Excel 2013 has
Q31: What is the F4 key used for
Q80: A mixed cell reference<br>A) occurs when a