CertificationAnswers

 

What is the default aggregation method for the third parameter of GROUPBY() function?

 

• A) Sum

 

• B) Average

 

• C) Count  

 

• D) Join

 

• E) None of the above

 

 

How do you define a variable in the second parameter of a MAP/MAPFLAT function?

 

• A) “variable_name”

 

• B) $variable_name

 

• C) &variable_name

 

• D) {props.variable_name}

 

 

Josephine from accounting is writing a formula using the SELECT( ) function. She wants to select payroll data to match the following conditions: the paydates must fall within the current year and the employee type must be equal to full time. However, it is only possible to have one condition in the SELECT( ) function.

 

• A) True

 

• B) False

 

 

You can pass the timezone as a parameter to the NOW( ) function.

 

• A) True

 

• B) False

 

 

The DATERANGE function can be used to populate an X-axis with all the dates between a given start and an end date.

 

• A) True

 

• B) False

 

 

You have a datasource whose column A contains date/time in unix format. You wish to display the date in the calendar format of MMM dd, yyyy but you also wish to include the hour and minute information (with a separator of :). How do you specify the time to match the requirement above?

 

• HH:MM

 

• hh:MM

 

• hh:mm

 

• HH:mm

 

• c and d

 

• None of the above