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 Li...
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?
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.
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 STUDYROOM2024. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $15.49. You're not tied to anything after your purchase.
