Jet Report Quiz

What is NL Function?

• Return a specified field value of a record key returned by the NL function.

• Return balances, budgets, and other common accounting values by specific filters, such as G/L account and company.

• Return Fields or record keys from a table based on filters. These can be replicated in rows, columns, or sheets.

• Perform utility operations on data to be used in other Jet functions.

What is NF Function?

• Return a specified field value of a record key returned by the NL function.

• Return balances, budgets, and other common accounting values by specific filters, such as G/L account and company.

• Return Fields or record keys from a table based on filters. These can be replicated in rows, columns, or sheets.

• Perform utility operations on data to be used in other Jet functions.

What is NP Function?

• Return a specified field value of a record key returned by the NL function.

• Return balances, budgets, and other common accounting values by specific filters, such as G/L account and company.

• Return Fields or record keys from a table based on filters. These can be replicated in rows, columns, or sheets.

• Perform utility operations on data to be used in other Jet functions.

What is GL Function?

• Return a specified field value of a record key returned by the NL function.

• Return balances, budgets, and other common accounting values by specific filters, such as G/L account and company.

• Return Fields or record keys from a table based on filters. These can be replicated in rows, columns, or sheets.

• Perform utility operations on data to be used in other Jet functions.

To avoid Empty Filter Not Allowed error message, what symbol we should put?

• ##

• @@

• **

• %%

Which Jet Report Function can only extract data from the same table?

• Browser

• Report Wizard

• Table Builder

• None

Which Jet Report Function cannot group report?

• Browser

• Report Wizard

• Table Builder

• None

Which Jet Report Function cannot do pivot table?

• Browser

• Report Wizard

• Table Builder

• None