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.

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

Choose the correct answer.

Nested If-Then-Else

Boolean

Alphanumeric

Print State

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.

DateDiff()

DateSerial()

DateAdd()

DatePart()

CurrentDate()

Q3.

What is the default format for Boolean field?

Choose the correct answer.

Y/N

Yes/No

T/F

True/False

0/1

Q4.

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

There are two correct answers.

All result data types must match

The condition must be a Boolean expression

The Else part of the syntax is mandatory

The result must be Boolean data type