Jet Report Quiz
Authored by Kenny Lua
Professional Development
Professional Development
Used 3+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
8 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
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.
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
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.
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
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.
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
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.
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
To avoid Empty Filter Not Allowed error message, what symbol we should put?
##
@@
**
%%
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which Jet Report Function can only extract data from the same table?
Browser
Report Wizard
Table Builder
None
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which Jet Report Function cannot group report?
Browser
Report Wizard
Table Builder
None
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
