1|Page
SMARTSHEET CERTIFICATION EXAM DETAIED COMPLETE
QUESTIONS AND ANSWERS A+ GRADED||JUST OUT!!!
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 can a user modify a report to get different results?
Add/delete rows from the report
Apply conditional formatting to the report
Change the criteria in the Report Builder
Select Edit Report from the File menu - ANSWER-Change the
criteria in the Report Builder
What is a key benefit to embedding a form on a dashboard via
the web content widget?
,2|Page
It provides increased efficiency as an individual can complete a
form submission without leaving the dashboard itself.
Users no longer need to be shared to the form to complete a
form submission.
It automatically captures who completed a form submission in
the dashboard's activity log.
Using an interaction setting, you can provide instant access to
the underlying sheet. - ANSWER-It provides increased efficiency
as an individual can complete a form submission without
leaving the dashboard itself.
Which type of user has the ability to create new items in
Smartsheet?
Free Collaborator
Unlicensed User
Licensed User
System Administrator - ANSWER-Licensed User
When a task becomes at-risk, the project manager wants the
individual assigned to the task to be immediately notified. How
could the project manager achieve this goal?
, 3|Page
Create a conditional formatting rule to notify individuals when a
task is marked at-risk
Send the activity log to all shared users of a sheet
Use the send row functionality to send a row when the task is
marked as at-risk.
Create an alert to notify the assignee when a task is marked as
at-risk. Send the alert to the assigned to ( - ANSWER-Create an
alert to notify the assignee when a task is marked as at-risk.
Send the alert to the assigned to (Contact List column) right
away
Which function will determine the total number of items in a
specified range?
COUNT()
SUM()
AVG()
CHILDREN() - ANSWER-Count()
When writing a formula, what symbol do you type to make
either a column or row reference absolute?
SMARTSHEET CERTIFICATION EXAM DETAIED COMPLETE
QUESTIONS AND ANSWERS A+ GRADED||JUST OUT!!!
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 can a user modify a report to get different results?
Add/delete rows from the report
Apply conditional formatting to the report
Change the criteria in the Report Builder
Select Edit Report from the File menu - ANSWER-Change the
criteria in the Report Builder
What is a key benefit to embedding a form on a dashboard via
the web content widget?
,2|Page
It provides increased efficiency as an individual can complete a
form submission without leaving the dashboard itself.
Users no longer need to be shared to the form to complete a
form submission.
It automatically captures who completed a form submission in
the dashboard's activity log.
Using an interaction setting, you can provide instant access to
the underlying sheet. - ANSWER-It provides increased efficiency
as an individual can complete a form submission without
leaving the dashboard itself.
Which type of user has the ability to create new items in
Smartsheet?
Free Collaborator
Unlicensed User
Licensed User
System Administrator - ANSWER-Licensed User
When a task becomes at-risk, the project manager wants the
individual assigned to the task to be immediately notified. How
could the project manager achieve this goal?
, 3|Page
Create a conditional formatting rule to notify individuals when a
task is marked at-risk
Send the activity log to all shared users of a sheet
Use the send row functionality to send a row when the task is
marked as at-risk.
Create an alert to notify the assignee when a task is marked as
at-risk. Send the alert to the assigned to ( - ANSWER-Create an
alert to notify the assignee when a task is marked as at-risk.
Send the alert to the assigned to (Contact List column) right
away
Which function will determine the total number of items in a
specified range?
COUNT()
SUM()
AVG()
CHILDREN() - ANSWER-Count()
When writing a formula, what symbol do you type to make
either a column or row reference absolute?
