Smartsheet Certification Final Exam Complete Questions And Detailed Solutions Latest Update Just Released

SMARTSHEET CERTIFICATION FINAL EXAM

COMPLETE QUESTIONS AND DETAILED SOLUTIONS
LATEST UPDATE JUST RELEASED



Question 1: When entering formulas in Smartsheet, cell references
use the syntax of column name and row number. What symbols
must be placed around a column name when it includes a space,
special characters, or numbers? { } Curly brackets [ ] Square
brackets ( ) Parentheses < > Angle brackets
Answer:

[ ] Square brackets Scenario: You have a handful of tasks that are falling
behind schedule and you want to quickly view which items are marked "Red"
in your project status column. Question: To identify this information WITHOUT
having to leave your sheet, you should: Create a filter Send an Update
Request to your collaborators Turn on Highlight Changes



Question 2: Write a formula
Answer:

Create a filter



Question 3: How is embedding a form on a dashboard via the web
content widget effective? It allows an individual to complete a form
submission without leaving the dashboard Users no longer need to
be shared to the form to complete a form submission Using an
interaction setting, you can provide instant access to the
underlying sheet It automatically captures who completed a form

,submission in the dashboard's activity log
Answer:

It allows an individual to complete a form submission without leaving the
dashboard



Question 4: When viewing a sheet, you want to have certain rows
grab your attention, visually, if the task is at risk or past its due
date. You can accomplish this by using which feature? Highlight
changes Conditional formatting Format painter Alerts
Answer:

Conditional formatting



Question 5: You want to use automated Alerts to alert someone
external to your organization who doesn't use Smartsheet. Because
the alert is for external collaborators you want to safeguard the
data on the sheet. Which option is the most secure way to send an
alert without providing access to your data? A C B
Answer:

C



Question 6: Which feature would you use to change the visual
styling of a sheet based on an identified trigger? Highlighting tool
Function Conditional Formatting Format Painter
Answer:

Conditional Formatting

, Question 7: When viewing cell history, which three of the following
actions are displayed? Who made a change What information was
entered in the cell What attachments were made to the row When
the change was made
Answer:

Who made a change What information was entered in the cell When the
change was made



Question 8: Which one of these functions can be used in
conjunction with another function such as COUNT() to reference all
the cells directly indented under a parent row? ANCESTORS()
INDEX() CHILDREN() PARENT()
Answer:

CHILDREN()



Question 9: Which one of the following statements is untrue about
Conditional Logic in forms? Editing the Column Type or Values of
fields used in your conditional logic may affect existing rules.
Target fields will only submit data to the sheet if they are displayed
when the form is submitted. In order to submit the form, all
required target fields must be filled in, even if they aren't displayed
due to logic on the form. Target fields will not be displayed by
default, and they are displayed when at least one of the source
conditions are met.
Answer:

In order to submit the form, all required target fields must be filled in, even if
they aren't displayed due to logic on the form.