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 |\ |\
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 |\ |\
