SMARTSHEET CORE PRODUCT
CERTIFICATION EXAM 2025 150 QUESTIONS &
CORRECT DETAILED ANSWERS GRADED A+
Which column type would be best for visually representing (via color) the status of a row
item? This could also be automatically changed using a formula.
a. Symbol column
b. Dropdown List col...
Which column type would be best for visually representing (via color) the status of a row
item? This could also be automatically changed using a formula.
a. Symbol column
b. Dropdown List column
c. Text/Number column
d. System Generated column - ...ANSWER...Symbol column
Which three of the following items can be viewed without a Smartsheet account?
a. Form
b. Published dashboard
c. Report in a workspace shared to you
d. Update request - ...ANSWER...Form, Published dashboard, and Update request
Which three of the following file types can be uploaded using the image widget?
a. PDF
b. PNG
c. GIF
d. JPEG - ...ANSWER...PNG, GIF, JPEG
How can you add more fields to your report beyond what fields are used as criteria?
a. From the File menu select Add More Columns
b. In the Report Builder, click the Columns button and select additional columns
c. Add a column to a source sheet. This new column will automatically be displayed in
the report.
d. In the toolbar, click the Report Tool and select additional criteria - ...ANSWER...In the
Report Builder, click the Columns button and select additional columns
,Cell linking is done at which of the following levels?
a. Row
b. Column
c. Sheet
d. Cell - ...ANSWER...Cell
Forms can be used to collect information from individuals inside or outside your
organization. Which two of the following use cases could a form support?
a. Survey responses
b. Marketing requests
c. Update the status of a task
d. Resource hub - ...ANSWER...Survey responses and Marketing requests
The Notification Center: (select the two options that apply)
a. Displays a red icon when new notifications arrive
b. Allows a user to create new alerts
c. Allows a user to view and fulfill update requests
d. Allows a user to forward a notification to a different user -
...ANSWER...Displays a red icon when new notifications arrive and alloWs a user to
view and fulfill update requests
A snapshot of a sheet or report can be shared via email using the "Send as
Attachment..." action. The sheet can be sent once or on a recurring basis. Select the
two file formats the attachment can be sent as.
a. Excel
b. PDF
c. CSV
d. PNG - ...ANSWER...Excel and PDF
When viewing a sheet, you want to have certain rows grab your attention, if the task is
at risk or past its due date. You can accomplish this by using which feature?
a. Highlight changes
b. Conditional formatting
, c. Alerts
d. Format painter - ...ANSWER...Conditional formatting
The "Send..." action, available from the row menu, allows you to provide a view-only
version of one or more rows to anyone you specify. Which two of the following options
can be customized?
a. File format of the rows (PDF or Excel)
b. Custom message to recipient
c. Delivery recurrence (once, every hour, every day, etc.) d. Columns included -
...ANSWER...Custom message to recipient and columns included
Which feature allows licensed collaborators [with at least Editor permissions] to audit
changes made to the sheet?
a. Conditional formatting
b. Activity log
c. View cell history
d. Highlight changes - ...ANSWER...Activity Log
How is tagging a shared collaborator in a comment, via the use of @mention, an
effective means of collaboration?
a. It shares that collaborator a published view of the sheet so they can view the
comment.
b. It instantly sends the @mentioned individual an alert with the comment.
c. It begins keeping track of the @mentioned individual within activity log.
d. It adds the @mentioned individual to your My Smartsheet Contacts - ...ANSWER...It
instantly sends the @mentioned individual an alert with the comment.
I have a handful of tasks that are falling behind schedule and I want to quickly view
which items are marked "Red" in my project status column. To identify this information
WITHOUT having to leave the sheet, I should:
a. Turn on highlight changes
b. Write a formula
c. Create a filter
d. Send an update request to my collaborators -
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller Lectpearl. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.49. You're not tied to anything after your purchase.
