Smartsheet Certification UPDATED Exam
Questions and CORRECT Answers
What can be added to a dashboard to help users understand the data on a dashboard? -
CORRECT ANSWER - Text labels
Which option would allow someone to view a report if they are not shared to the underlying
sheet(s)? - CORRECT ANSWER - Add the report to a dashboard by using the Report
Widget
Which file type cannot be uploaded using the image widget? - CORRECT ANSWER -
PDF
Which two views of a row report can be displayed on a dashboard using the report widget? -
CORRECT ANSWER - Grid, Gantt
What is the default label for the data in a metric widget? - CORRECT ANSWER - Column
name
Which dashboard widget type would be best to show a live updating budget number of a project?
- CORRECT ANSWER - Metric
How is embedding a form on a dashboard via the web content widget effective? - CORRECT
ANSWER - It allows an individual to complete a form submission without leaving the
dashboard
Which widget behavior will allow the user to open the underlying sheet or report? - CORRECT
ANSWER - Open the data source
What symbol notes the beginning of a formula? - CORRECT ANSWER -=
, Which formula is the most scalable way to count the indented rows under "Carl Jackson",
knowing that you will be adding additional rows within this hierarchy? - CORRECT
ANSWER - =COUNT(CHILDREN())
I am adding a field called "Budget Total" in the Sheet summary of a sheet. What is the syntax to
reference the "Budget Total" field in a formula? - CORRECT ANSWER - [Budget Total]#
When adding a cell link to a sheet, which can be the source of the data? - CORRECT
ANSWER - Cell(s) in a sheet
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? - CORRECT
ANSWER - Conditional formatting
Which is used when writing a formula to automate checking a box, raising a flag, or filling in of
a star? - CORRECT ANSWER -1
Which column type would be best for assigning tasks to individual team members? - CORRECT
ANSWER - Contact List column
What symbols must be placed around a column name in a formula if the name includes a space,
special characters, or numbers? - CORRECT ANSWER - [ ] Square brackets
Which view must include two date columns in order to be displayed? - CORRECT
ANSWER - Gantt
What level of hierarchy should the CHILDREN() function should be placed on? - CORRECT
ANSWER - Parent row
Which column type would be best for visually representing the status of a row item? -
CORRECT ANSWER - Symbols column
Questions and CORRECT Answers
What can be added to a dashboard to help users understand the data on a dashboard? -
CORRECT ANSWER - Text labels
Which option would allow someone to view a report if they are not shared to the underlying
sheet(s)? - CORRECT ANSWER - Add the report to a dashboard by using the Report
Widget
Which file type cannot be uploaded using the image widget? - CORRECT ANSWER -
Which two views of a row report can be displayed on a dashboard using the report widget? -
CORRECT ANSWER - Grid, Gantt
What is the default label for the data in a metric widget? - CORRECT ANSWER - Column
name
Which dashboard widget type would be best to show a live updating budget number of a project?
- CORRECT ANSWER - Metric
How is embedding a form on a dashboard via the web content widget effective? - CORRECT
ANSWER - It allows an individual to complete a form submission without leaving the
dashboard
Which widget behavior will allow the user to open the underlying sheet or report? - CORRECT
ANSWER - Open the data source
What symbol notes the beginning of a formula? - CORRECT ANSWER -=
, Which formula is the most scalable way to count the indented rows under "Carl Jackson",
knowing that you will be adding additional rows within this hierarchy? - CORRECT
ANSWER - =COUNT(CHILDREN())
I am adding a field called "Budget Total" in the Sheet summary of a sheet. What is the syntax to
reference the "Budget Total" field in a formula? - CORRECT ANSWER - [Budget Total]#
When adding a cell link to a sheet, which can be the source of the data? - CORRECT
ANSWER - Cell(s) in a sheet
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? - CORRECT
ANSWER - Conditional formatting
Which is used when writing a formula to automate checking a box, raising a flag, or filling in of
a star? - CORRECT ANSWER -1
Which column type would be best for assigning tasks to individual team members? - CORRECT
ANSWER - Contact List column
What symbols must be placed around a column name in a formula if the name includes a space,
special characters, or numbers? - CORRECT ANSWER - [ ] Square brackets
Which view must include two date columns in order to be displayed? - CORRECT
ANSWER - Gantt
What level of hierarchy should the CHILDREN() function should be placed on? - CORRECT
ANSWER - Parent row
Which column type would be best for visually representing the status of a row item? -
CORRECT ANSWER - Symbols column
