Smartsheets Product Certification Part 1 Quiz with correct answers

Smartsheets Product Certification Part 1 |\ |\ |\ |\ |\




Quiz with correct answers |\ |\ |\




A row report can be displayed on a dashboard using the
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\



report widget in which two of the following views?
|\ |\ |\ |\ |\ |\ |\ |\




Gantt
Calendar
Grid
Card - CORRECT ANSWERS ✔✔Gantt
|\ |\ |\ |\




Card


What Forms feature lets you reveal specific fields in a
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\



form based on the answers to other questions?
|\ |\ |\ |\ |\ |\ |\




Form Elements |\




Conditional Logic |\




Fields
Settings - CORRECT ANSWERS ✔✔Conditional Logic
|\ |\ |\ |\ |\




To quickly identify and review the changes that have been
|\ |\ |\ |\ |\ |\ |\ |\ |\



made to a sheet, use _________
|\ |\ |\ |\ |\ |\




Symbols column type |\ |\




Highlight changes |\

,Conditional formatting |\




Format painter - CORRECT ANSWERS ✔✔Highlight
|\ |\ |\ |\ |\ |\



changes


When writing a formula, what symbol do you type to
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\



make either a column or row reference absolute?
|\ |\ |\ |\ |\ |\ |\




( ) Parentheses
|\ |\




$ Dollar sign
|\ |\




# Pound sign
|\ |\




[ ] Square brackets - CORRECT ANSWERS ✔✔$ Dollar sign
|\ |\ |\ |\ |\ |\ |\ |\ |\




Which column type would be best for assigning tasks to
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\



individual team members? |\ |\




Contact List column |\ |\




Created by System column |\ |\ |\




Text/Number column |\




Dropdown List - CORRECT ANSWERS ✔✔Contact List |\ |\ |\ |\ |\ |\ |\



column


Scenario: You want to surface a count of at-risk tasks on a
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\



dashboard. You determine one option for doing so would
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\



be to use a drop-down column to mark a task at-risk.
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\

,Question: Which one of the following column types can
|\ |\ |\ |\ |\ |\ |\ |\ |\



also be utilized to mark at-risk items that could be
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\



counted and displayed on a dashboard?
|\ |\ |\ |\ |\




System Generated Column |\ |\




Duration Column |\




Date Column |\




Symbol Column - CORRECT ANSWERS ✔✔Symbol Column
|\ |\ |\ |\ |\ |\




Indenting rows will add hierarchy and create relationships
|\ |\ |\ |\ |\ |\ |\



between rows. The hierarchy is applied to the entire row,
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\



but will only be visible in what part of the sheet?
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\




Leftmost column in grid view |\ |\ |\ |\




System column |\




Primary column |\




Row action indicators column - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\



✔✔Primary column |\




Which of the following views must include two date
|\ |\ |\ |\ |\ |\ |\ |\ |\



columns in order to be displayed? |\ |\ |\ |\ |\




Calendar
Gantt
Grid
Card - CORRECT ANSWERS ✔✔Gantt
|\ |\ |\ |\

, Which one of the following Automation Permissions
|\ |\ |\ |\ |\ |\ |\



settings only allows the users that are shared to a sheet
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\



to receive notifications and requests from the sheet?
|\ |\ |\ |\ |\ |\ |\




Limited
Unrestricted
Restricted
Unlimited - CORRECT ANSWERS ✔✔Restricted |\ |\ |\ |\




When adding a cell link to a sheet, which of the following
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\



can be the source of the data?
|\ |\ |\ |\ |\ |\




Column names |\




Metric widget on a dashboard
|\ |\ |\ |\




Cell(s) in a sheet |\ |\ |\




Cell(s) in a report - CORRECT ANSWERS ✔✔Cell(s) in a
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\



sheet


In order to enable Card View, your sheet must have at
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\



least one of three specific column types. Two of those
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\



columns types are Dropdown List and Symbol. What is the
|\ |\ |\ |\ |\ |\ |\ |\ |\



third column type?
|\ |\ |\




System Generated column |\ |\




Text/Number column |\




Contact List column |\ |\