HOSMERIT
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 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 -
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 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 -
