Excel Functions Quiz: CONTAINS, ContainsString, ISBLANK

The CONTAINS function returns a statistics table for each column in each table in the model

The ISNUMBER function determines if a value is blank

The HASONEFILTER function returns true if there are exactly one directly filtered values on ColumnName

The ISEMPTY function verifies whether a column is empty

The CONTAINSSTRING function is case-sensitive

The ISERROR function returns true if the value is logical

The ISNONTEXT function returns true if a value is blank

The ISINSCOPE function returns true when a column is being filtered

The CUSTOMDATA function returns the information found in the connection string’s CustomData property

The ISCROSSFILTERED function returns true when a column is being directly filtered

The ISFILTERED function returns true when a table is empty

The ISSUBTOTAL function creates a new column in a SUMMARIZE expression that returns True if the row has values for the subtotal column specified as an argument

DAX functions can only take in a single argument.

The ISERROR function returns FALSE if the referenced value contains an error.

DAX information functions examine the entire dataset to determine compatibility with the expected type.

The Contains function returns TRUE if the values for any of the referred columns exist.

DAX formulas can only be used with numerical data.

DAX functions are limited to mathematical and trigonometric operations.

The DAX function DATEVALUE returns the number of boundaries between two dates.

The DAX function DATEDIFF can use 'Second' as a valid Interval value.

The DAY function in DAX can accept dates in any string format.

The DAX function NOW returns the current date and time as a string value.

In DAX, the DAY function can accept an expression that yields a date as an argument.

DATEDIFF can calculate the difference between dates at a minute level precision.

The DAX Calendar function can generate a table with multiple columns.

The DATE function in DAX requires four parameters to create a date.

The DATEVALUE function in DAX ignores the client computer's locale and date/time settings during conversion.

The CALENDAR function in DAX can generate a table with a non-continuous range of dates.

The DAX Date function returns a date in a format that can be used as a text string.

The DATEVALUE function in DAX can only convert dates in a specific format.