What is the purpose of using a by clause with the stats command?
A. To group the results by one or more fields.
B. To compute numerical statistics on each field.
C. To specify how the values in a list are delimited.
D. To partition the input data based on the split-by fields.
Answer: A. To group the results by one or more fields.
You might also like to view...
Which of the following is NOT true about PivotTables?
A) PivotTables can arrange data in columns or rows. B) PivotTables can summarize data. C) PivotTables can Auto Refresh data. D) PivotTables are dynamic.
If you didn't use the New Comment command on the Review tab, how would you insert a comment?
A) Click comment in the status bar. B) Use the New Comment command on the Home tab. C) Right-click on the cell and then select Insert Comment. D) Right-click and select commenting options.