All of the following statements are TRUE about conditional aggregate functions EXCEPT:
A) Elements such as named ranges and cell references should go inside quotes.
B) With an aggregate function, a range would still be provided, but the aggregation would only use cells that meet a given criteria.
C) Conditional aggregate functions are functions that consolidate or summarize a subset of data that has been filtered based upon one or more criteria.
D) The criteria can be on the data that is being aggregated or on associated data.
A
You might also like to view...
The __________ object represents the properties of a speech synthesizer.
a) SynthesizerProperties b) Central c) SynthesizerModeDesc d) None of the above.
Match each item with the correct statement below.
A. The way a paragraph is spread out between the left and right sides of a text box B. A set of characters based on a typeface using a specific size and style C. A design created for a set of characters including the alphabet, numbers, and some symbols D. The amount of space between the baselines of two lines of type E. The process of placing text so that it runs from one text box to another F.
Subdivided areas on a ribbon are called ________
Fill in the blank(s) with correct word
A(n) ________ tab is a tab that is added to a ribbon automatically when a specific object is selected and contains commands relevant to the selected object
Fill in the blank(s) with correct word