$1.$Select the most appropriate item for each description from the answer list below. Enter your answers on Canvas.

$1)$A way to display aggregate data when a query is run.

$2)$A method of summarizing data by the values of a field.

$3)$An Access tool that enables you to create more complicated expressions.

$4)$A calculation performed on an entire column of data that returns a single value. Includes functions such as Sum, Avg, and Count.

$5)$The function that returns the position number of a specified text.

$6)$It remembers what you just did on Excel to perform the same on every cell on the same column.

$7)$It finds the average value over the cells that match the condition given in the second parameter.

$8)$Extracts a subtext at the specified start position of a text data such as $$Pitt$$ in $$Brad Pitt$.$