For the ____ operation, it is required that the the two tables have a common attribute.

The ________ window provides information about a multitude of topics

Fill in the blank(s) with correct word

Match the following terms to their meanings:

I. COUNTA function II. COUNTIF function III. SUMIF function IV. SUMIFS function V. AVERAGEIF function A. used to count the number of cells in a range that meet one specified criterion B. used to calculate the average for cells that meet one specified criterion C. used to count the number of nonblank cells in a range D. adds the cells in a range that meet one specified criterion E. adds the cells in a range that meet multiple criteria