Uncategorized
All of Klipfolio’s Date/Time functions return the results in dd/MM/yyyy format by default.
True False
0 Comments
November 10, 2020
Menu
Uncategorized
Which of the following is true of the LOOKUP function?
It is similar to vLOOKUP in Excel Duplicate values in the 2nd parameter (“keys”) are not a problem. The 1st and 2nd paramters need to evaluate to the same number…
November 10, 2020
Uncategorized
Adam has an Excel datasource set up in his Klipfolio account. Column 1 of the datasource contains the names of new customers in the past month and Adam suspects that the entries of this column have leading and trailing blanks. What is the best function that Adam should use to remove the leading and trailing blanks?
CONCAT SUBSTITUTE URLDECODE URLENCODE None of the above
November 10, 2020
Uncategorized
True or False: Dashboards published privately require a password?
True False
November 10, 2020
Uncategorized
True or False? User input controls can control data in more than one Klip.
True False
November 10, 2020
Uncategorized
True or False? A User can be assigned to more than one role.
True False
November 10, 2020
Uncategorized
Which of the following formulas is the best option for SUM’ing a set of values held in Column A of multiple Dynamic Data Source instances? NOTE: The possible values for the Dynamic property is in Column B of a 2nd data source.
SUM(MAP(A:A)) SUM(B:B) SUM(MAP(B:B)) SUM(A:A) SUM(ARRAY(JOIN(MAP(B:B))) JOIN(A:A)
November 10, 2020
Uncategorized
You can schedule a specific time a datasource refreshes using the Klipfolio API.
True False
November 10, 2020
Uncategorized
Replacing “view” with “debug_info” in the data source url will help you do which of the following? Select ALL that apply.
Manage/list dynamic data source instances Change dynamic data source configuration Add dynamic data source instances Delete dynamic data source instances Refresh dynamic data source instances View data for a dynamic…
November 10, 2020
