BRG All quiz

What is missing for this formula of attendance Rate?

sum(Totalpresent)/ case when sum() <> 0 then sum() end

(a)  

Runs a Google Visualization API Query Language query across data.

• =filter()

• =importrange()

• =query()

• None of the above

What is the name of the google account where you should share your file so it can be uploaded in PLX?

Clue: popular in 7/11

(a)  

In PLX Dashboard what should you pick if you want to Insert a TEXT in you DB with a specific design, font size, font color, font style ,etc.

• { } Data source

• Image

• < > HTML

• Embedded Content

Google app script formula to get the email of the current user of the Web App.

• Session()getActiveUser.getEmail();

• Session().getActiveUser().getEmail();

• Session.getActiveUser().getEmail();

• Session.getActiveUser.getEmail();

What is missing in this formula?

( ___ DATE_TRUNC(( ____ date1 AS DATE), month) AS STRING) AS Monthly,

(a)  

What formula should be used in taking a specific part of a whole word.

Sample:

you want to extract only the Ldap jsosmena in [e-mail]

• =query()

• =REGEXEXTRACT()

• =importrange()

• =filter()

Enables the display of values returned from an array formula into multiple rows and/or columns and the use of non-array functions with arrays.

• =query()

• =arrayformula()

• =formulaarray()

• None of the above

Google app script Formula to link a specific Google sheet file to your web app.

• SpreadsheetApp.openByUrl();

• SpreadsheetApp.openByUrl{};

• spreadsheetapp.openByUrl();

• SpreadsheetApp.openBy.Url();

Google app script formula for getting a specific Tab/sheet name inside a google sheet

• GetSheetByName();

• get.Sheet.By.Name();

• getSheetByName();

• getSheetByName[];