SF-Admin Object Manager and Lightning App Builder Practice Question
An administrator needs to create a field that calculates a value based on other fields on the same object. Which field type should be selected?
⚠ Common exam trap
Candidates often confuse 'Formula' fields with 'Roll-Up Summary' fields. While both are read-only, Roll-Up Summaries only work in master-detail relationships, whereas Formulas work on the same record.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Formula
Formula fields are the standard way to perform calculations across fields within a record. They are read-only and update dynamically whenever the underlying data changes. This is a foundational skill for administrators, as it allows for the creation of derived data points without writing code, enabling business logic to be embedded directly into the schema for reporting and display purposes.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Roll-up Summary
Why it's wrong here
Roll-up summary fields calculate values from related child records, not from fields on the same record. They require a master-detail relationship to function, making them unsuitable for calculations involving fields contained entirely within the current record's own definition.
- ✗
Text (Encrypted)
Why it's wrong here
Encrypted text fields are used for storing sensitive information that needs to be masked for most users. They do not support mathematical or logical calculations and cannot be used in formula expressions, making them the wrong choice for a field that needs to perform a computation.
- ✓
Formula
Why this is correct
Formula fields are designed specifically to evaluate expressions based on other fields. They provide a robust syntax for arithmetic, date, and logical operations, allowing the administrator to derive information automatically. They are the correct choice for any requirement that involves field-to-field calculation.
- ✗
Auto-Number
Why it's wrong here
Auto-number fields are strictly for generating unique, sequential identifiers for records. They do not support any calculation logic and cannot be used as the output for an expression involving other record fields. They are intended for record identification rather than data manipulation.
About these practice questions
One of 202 original SF-Admin practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Salesforce exam blueprint
This SF-Admin practice question is part of Courseiva's free Salesforce certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the SF-Admin exam.