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

Questions 1–5

1. 1application · medium

   An admin wants to create a formula field that displays 'Active' if the account's 'Status__c' field equals 'Active' and the 'Last_Activity_Date__c' is within the last 90 days. Which formula correctly implements this logic?

   • AIF(Status__c = 'Active' && Last_Activity_Date__c >= TODAY() - 90, 'Active', 'Inactive')
   • BIF(AND(Status__c = 'Active', Last_Activity_Date__c >= TODAY() - 90), 'Active', 'Inactive')
   • CIF(Status__c = 'Active' AND Last_Activity_Date__c >= TODAY() - 90, 'Active', 'Inactive')
   • DIF(OR(Status__c = 'Active', Last_Activity_Date__c >= TODAY() - 90), 'Active', 'Inactive')
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   Which formula return type would be most appropriate for a formula that evaluates to true or false?

   • ACheckbox
   • BText
   • CNumber
   • DDate
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which formula converts a numeric field, Quantity__c, to a text value so it can be concatenated with other text?

   • ACONCAT(Quantity__c)
   • BTEXT(Quantity__c)
   • CVALUE(Quantity__c)
   • DSTRING(Quantity__c)
   Reveal Solution Discussion Select an answer first
5. 4application · easy

   An admin needs to create a formula field that displays the year of a custom date field 'Renewal_Date__c' on the Account record. Which formula correctly extracts the year?

   • AYEAR(Renewal_Date__c)
   • BTEXT(Renewal_Date__c)
   • CMONTH(Renewal_Date__c)
   • DDATE(Renewal_Date__c)
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   Which of the following is a limitation of formula fields in Salesforce?

   • AThey cannot reference other fields on the same record.
   • BThey cannot write values to the database.
   • CThey can only be used on standard objects.
   • DThey can only return text values.
   Reveal Solution Discussion Select an answer first