Multiple Choice
Match the following five terms to their meanings:
i.SUMIF function
II.COUNTIF function
III.logical function
IV.SUMIFS function
v.syntax
A) A logical function that counts the cells that meet specific criteria in a specified range.
B) A logical function that will add values in multiple ranges that meet multiple criteria.
C) A logical function that will add values in one specified range that meet a certain specific criteria.
D) A function that tests for specific conditions.
E) The arrangement of the arguments in a function.
Correct Answer:

Verified
Correct Answer:
Verified
Q26: A _ is a prediction of the
Q27: Business owners expect that,at some future point,the
Q28: Variable expenses vary depending on the amount
Q29: After a constraint is added to Solver
Q30: The _ of a function specifies the
Q32: The point at which a business begins
Q33: Which of the following would NOT be
Q34: _ is one of Excel's what-if analysis
Q35: Excel has _ codes that enable you
Q36: Match the following five terms to their