Which scenario is an appropriate use case for a formula field?

Calculating the number of days between an order date and the current date.

Tracking the history of changes to a field over time.

Capturing a user's signature on a contract.

Storing a large attachment file for a record.

An admin needs to create a formula field on the Account object that displays 'Yes' if the account has a non-empty billing country and 'No' otherwise. Which formula correctly accomplishes this?

IF(ISBLANK(BillingCountry), 'No', 'Yes')

IF(BillingCountry != '', 'No', 'Yes')

IF(BillingCountry = NULL, 'Yes', 'No')

IF(BillingCountry = '', 'Yes', 'No')

A support manager wants to display a priority indicator on the Case record. The formula should show 'High' if the case priority is 'High' or 'Critical', and 'Normal' otherwise. Which formula correctly implements this logic?

IF(Priority = 'High' || Priority = 'Critical', 'High', 'Normal')

IF(Priority = 'High' OR Priority = 'Critical', 'High', 'Normal')

IF(AND(Priority = 'High', Priority = 'Critical'), 'High', 'Normal')

IF(OR(Priority = 'High', Priority = 'Critical'), 'High', 'Normal')

A company wants to show the number of open opportunities on an Account record. The admin considers using a formula field. What is the best approach to achieve this requirement?

Create a workflow rule that updates a number field on Account with the count.

Create a formula field on Opportunity that references the Account and sums the amounts.

Create a formula field on Account that uses COUNT(Opportunities__r).

Create a roll-up summary field on Account that counts Opportunities where IsClosed = false.

SalesforceCertified Platform App Builder

Domain 4Objective 2

Describe the Capabilities of and Use Cases for Formula Fields. PLATFORM-APP-BUILDER Practice Questions (Page 2)

Part of the BUSINESS LOGIC AND PROCESS AUTOMATION domain, which accounts for 27% of the PLATFORM-APP-BUILDER exam.

17questions here

4free pages

6concepts

27%of the exam

Questions 6–10

6foundation · easy
Which scenario is an appropriate use case for a formula field?
Select an answer first
7application · medium
An admin needs to create a formula field on the Account object that displays 'Yes' if the account has a non-empty billing country and 'No' otherwise. Which formula correctly accomplishes this?
Select an answer first
8application · medium
A support manager wants to display a priority indicator on the Case record. The formula should show 'High' if the case priority is 'High' or 'Critical', and 'Normal' otherwise. Which formula correctly implements this logic?
Select an answer first
9expert · hard
A company wants to show the number of open opportunities on an Account record. The admin considers using a formula field. What is the best approach to achieve this requirement?
Select an answer first
10foundation · easy
Which formula return type should be selected for a formula that displays a value like "$1,250.00"?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PLATFORM-APP-BUILDER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Salesforce. “PLATFORM-APP-BUILDER” is a trademark of its owner, used for identification only.