Knowledge check

Choose the best response for each of the questions below. Then select Check your answers.

Check your knowledge

The dcount() function will do which of the following?

Return a day count on the expression difference provided to the function.

Return a difference count on the expression provided to the function.

Return a distinct count on the expression provided to the function.

The arg_max() function will do which of the following?

Returns the maximum value for each column passed to the function.

Returns a JSON Array of maximum values for each column passed to the function.

Returns a row selected based on the row having the max value for an expression.

The bin() function provides the most value to which type of chart?

scatterchart

timechart

barchart

You must answer all questions before checking your work.