Search Header Logo

Jet Report Quiz

Authored by Kenny Lua

Professional Development

Professional Development

Used 3+ times

Jet Report Quiz
AI

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

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?