Tell us what you think

We want to create the best possible experience for our learners. Your feedback helps us to improve the experience for everyone.

Knowledge quiz

It’s time to put what you’ve learned to the test, get 3 questions right to pass this unit.

Q1.

What should you remember when using If-Then-Else logic in formulas?

There are two correct answers.

The condition must be a Boolean expression

The result must be Boolean data type

All result data types must match

The Else part of the syntax is mandatory

Q2.

Which functions do you use in a formula to calculate an employee’s years of service from their hire date?

There are two correct answers.

CurrentDate()

DateDiff()

DateSerial()

DatePart()

DateAdd()

Q3.

Which type of formula do you use with on/off formatting attributes?

Choose the correct answer.

Boolean

Print State

Alphanumeric

Nested If-Then-Else

Q4.

What is the default format for Boolean field?

Choose the correct answer.

Yes/No

Y/N

0/1

T/F

True/False