This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Choose the best response for each of the questions below.
Which of the following aggregate functions can't be applied to a column with a string data type?
Count
Count distinct
Sum
To uncover the revenue of the New York store in your dataset, what approach would you use?
Group the dataset by the Store field, and summarize the Revenue field.
Count the number of rows where the Store value is equal to New York.
Delete all rows where the store isn't equal to New York and then summarize the Revenue field.
Which of the following columns in a dataset would be an appropriate use of a color scale indicator?
Temperature
Day
LastName
You must answer all questions before checking your work.
Was this page helpful?