The _____ function adds the values in a range that match criteria you specify.Select one:a.ADDIFb.ADDASc.SUMIFd.SUMAS

The _________ function takes all of the values in each of the specified cells and totals their values?Select one:A.SumB.AvgC.Total

The SUM function in SQL is used for:Finding the unique values in a column.Calculating the total of all values in a numeric column or within a group.Returning the first value in a column.Removing duplicate rows from a table.

Correct format for a SUMIF statement isSelect one:A.=SUMIF(range, critera,sum_range)B.=SUMIF(range,sum_range,critera)C.=SUMIF(sum_range,critera,range)

However, in SQL you can only perform arithmetic across columns on values in a given row. To clarify, you can only add values in multiple columns from the same row together using +—if you want to add values across multiple rows, you'll need to use aggregate functions, which are covered in the Intermediate SQL section of this tutorial.

_______ will perform summary operations on a set of values to result an single value.Select one:a.Date functionsb.Single row functionsc.Aggregate functionsd.Numeric functions