You need to perform an aggregate function in a crosstab query. Your functions needs to calculate the number of the nonnull field values in your spreadsheet. Which aggregate function will you use?
A)Count
B)StDev
C)Var
D)Avg

Question

Quizplus · Accepted Answer

The Count function is the best choice for calculating the number of nonnull field values in a crosstab query. The StDev, Var, and Avg functions are used to calculate statistical values based on numeric field values.

You Need to Perform an Aggregate Function in a Crosstab