Match the Following Five Terms to Their Meanings

question 31

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.