SMARTSHEET CORE PRODUCT
CERTIFICATION EXAM | 150 QUESTIONS
AND ANSWERS (VERIFIED ANSWERS) |
ALREADY 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.
Symbol column
Dropdown List column
Text/Number column
System Generated column - ...ANSWER...Symbol column
Which three of the following items can be viewed without a
Smartsheet account?
Form
Published dashboard
Report in a workspace shared to you
Update request - ...ANSWER...Form, Published dashboard,
and Update request
,Which three of the following file types can be uploaded
using the image widget?
PDF
PNG
GIF
JPEG - ...ANSWER...PNG, GIF, JPEG
How can you add more fields to your report beyond what
fields are used as criteria?
From the File menu select Add More Columns
In the Report Builder, click the Columns button and select
additional columns
Add a column to a source sheet. This new column will
automatically be displayed in the report.
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?
Row
Column
Sheet
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?
Survey responses
,Marketing requests
Update the status of a task
Resource hub - ...ANSWER...Survey responses and
Marketing requests
The Notification Center: (select the two options that apply)
Displays a red icon when new notifications arrive
Allows a user to create new alerts
Allows a user to view and fulfill update requests
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.
Excel
PDF
CSV
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?
Highlight changes
Conditional formatting
Alerts
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?
File format of the rows (PDF or Excel)
Custom message to recipient
Delivery recurrence (once, every hour, every day, etc.)
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?
Conditional formatting
Activity log
View cell history
Highlight changes - ...ANSWER...Activity Log
How is tagging a shared collaborator in a comment, via the
use of @mention, an effective means of collaboration?
It shares that collaborator a published view of the sheet so
they can view the comment.
It instantly sends the @mentioned individual an alert with
the comment.
It begins keeping track of the @mentioned individual within
activity log.
CERTIFICATION EXAM | 150 QUESTIONS
AND ANSWERS (VERIFIED ANSWERS) |
ALREADY 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.
Symbol column
Dropdown List column
Text/Number column
System Generated column - ...ANSWER...Symbol column
Which three of the following items can be viewed without a
Smartsheet account?
Form
Published dashboard
Report in a workspace shared to you
Update request - ...ANSWER...Form, Published dashboard,
and Update request
,Which three of the following file types can be uploaded
using the image widget?
PNG
GIF
JPEG - ...ANSWER...PNG, GIF, JPEG
How can you add more fields to your report beyond what
fields are used as criteria?
From the File menu select Add More Columns
In the Report Builder, click the Columns button and select
additional columns
Add a column to a source sheet. This new column will
automatically be displayed in the report.
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?
Row
Column
Sheet
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?
Survey responses
,Marketing requests
Update the status of a task
Resource hub - ...ANSWER...Survey responses and
Marketing requests
The Notification Center: (select the two options that apply)
Displays a red icon when new notifications arrive
Allows a user to create new alerts
Allows a user to view and fulfill update requests
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.
Excel
CSV
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?
Highlight changes
Conditional formatting
Alerts
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?
File format of the rows (PDF or Excel)
Custom message to recipient
Delivery recurrence (once, every hour, every day, etc.)
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?
Conditional formatting
Activity log
View cell history
Highlight changes - ...ANSWER...Activity Log
How is tagging a shared collaborator in a comment, via the
use of @mention, an effective means of collaboration?
It shares that collaborator a published view of the sheet so
they can view the comment.
It instantly sends the @mentioned individual an alert with
the comment.
It begins keeping track of the @mentioned individual within
activity log.
