Exam (elaborations)
Smartsheet Core Product Certification Exam Latest Updated 2024
- Course
- Institution
Smartsheet Core Product Certification Exam Latest Updated 2024
[Show more]
Content preview
Smartsheet Core Product Certification Exam Latest Updated 2024A 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.
,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:
Turn on highlight changes Write a formula
Create a filter
Send an update request to my collaborators -
...ANSWER...Create a filter
Date based alerts help keep collaborators aware of key project dates. Date based alerts
can be triggered on a specific date or based off a date in any date column. Which of the
following is a possible use case for establishing a date based alert?
Samuel wants to automatically inform his boss when the status of a task becomes at-risk
Samuel wants to notify all collaborators when a task is over budget
Samuel wants to be sent an email five days before the start of each task so he can check in
with key collaborators Samuel wants to automatically let external vendors know when a
task is not complete - ...ANSWER...Samuel wants to be sent an email five days before the
start of each task so he can check in with key collaborators
Auto-fill is automatically applied by Smartsheet within every sheet. Which two of the
following functions does auto-fill perform?
Copy manual update requests to generate recurring updates Continue patterns of
formatting
Apply formulas and adjust cell references to adjacent rows Generate a numeric value
based on conditional formatting rules - ...ANSWER...Continue patterns of formatting Apply
formulas and adjust cell references to adjacent rows
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
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 BESTEXAMINER1. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $21.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
78637 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now