SMARTSHEET CERTIFICATION EXAM 2 VERSIONS |
ACCURATE AND VERIFIED REAL EXAM CONTAINS 65
QUESTIONS AND ANSWERS RECENTLY TESTED EXAMS |
VERIFIED FOR GUARANTEED PASS | LATEST UPDATE
2023/2024
Changes in cell formatting can be used to capture the attention of a user. Which of the following
features allows collaborators to see updates since they last viewed the sheet?
Conditional formatting
Format painter
Symbol column type
Highlight changes
Highlight changes
What information is tracked in the Attachments Summary? (select the three that apply)
File name
Date attached
Name of the individual who attached the file
Number of downloads
File name
Date attached
Name of the individual who attached the file
When entering formulas in Smartsheet, cell references use the syntax of column name and row
number. What symbol must be placed around a column name when it includes a space, special
character, or number?
{ } Curly brackets
[ ] Square brackets
< > Angle brackets
( ) Parentheses
[ ] Square brackets
When adding a new collaborator to a sheet or workspace, what should be customized to help the
new collaborator understand why they are being added and how they should use the information?
Collaborators
Permissions
Personal message
Default View
,Personal Message
Which view must include two date columns in order to be displayed?
Card
Gantt
Calendar
Grid
Gantt
You are using Smartsheet to plan, track and manage a project. In creating your sheet, you are
assigning tasks to collaborators. You need to make a decision on whether to use multiple single
contact list columns or enable multiple contacts to be assigned within a single cell. You
understand that it best to enable multiple contacts to be assigned within a single cell when
multiple people are working on the same task. In what scenario is it best to use multiple contact
list columns?
When you want to create a filter for each individual
When some individuals are inside your team's account and others are not
When you want to pull a report from a sheet
When the individuals have different roles related to a task
When the individuals have different roles related to a task
Jen has a project sheet that includes a dropdown list column. Her coworker needs to add
additional options to the dropdown list column options in Jen's sheet. What permission level
would her coworker need for Jen's sheet?
Editor- can't share
Viewer
Admin
Editor- can share
Admin
When creating a form, using a ___________ field, allows you to input a default value into a
column on a sheet without requiring the form submitter to create it.
Branded
Hidden
Custom
Required
Hidden
, Which function leverages sheet hierarchy to reference the range of rows that are indented below
another row?
ANCESTORS()
CHILDREN()
PARENT()
INDEX()
Children()
Juan is currently managing the development of a new product. He has a team of four individuals
with whom he assigns various tasks. Juan wants to quickly see tasks assigned to each person and
reassign tasks as needed. Which of the options below would be the most efficient way for Juan to
accomplish this?
Juan needs to create and use a filter for each assignee and then return to the sheet to reassign
tasks.
Juan needs to publish the sheet to his team and allow them to email suggestions on task
reassignment.
Juan needs to utilize card view to view by the assigned to contact column. He could then view
and reassign accordingly.
Juan needs to build a report for each person on his team. From each of the reports, Juan would
reassign tasks.`
Juan needs to utilize card view to view by the assigned to contact column. He could then view
and reassign accordingly.
The report widget allows you to display a report in which two of the following views:
Card
Grid
Calendar
Gantt
Grid and Gantt
You can share a collaborator to which two of the following?
Folder
Workspace
Resource View
Sheet
Workspace and Sheet
Which collaboration feature allows the recipient to make a one time change to your sheet without
sharing them as a collaborator to the sheet?
ACCURATE AND VERIFIED REAL EXAM CONTAINS 65
QUESTIONS AND ANSWERS RECENTLY TESTED EXAMS |
VERIFIED FOR GUARANTEED PASS | LATEST UPDATE
2023/2024
Changes in cell formatting can be used to capture the attention of a user. Which of the following
features allows collaborators to see updates since they last viewed the sheet?
Conditional formatting
Format painter
Symbol column type
Highlight changes
Highlight changes
What information is tracked in the Attachments Summary? (select the three that apply)
File name
Date attached
Name of the individual who attached the file
Number of downloads
File name
Date attached
Name of the individual who attached the file
When entering formulas in Smartsheet, cell references use the syntax of column name and row
number. What symbol must be placed around a column name when it includes a space, special
character, or number?
{ } Curly brackets
[ ] Square brackets
< > Angle brackets
( ) Parentheses
[ ] Square brackets
When adding a new collaborator to a sheet or workspace, what should be customized to help the
new collaborator understand why they are being added and how they should use the information?
Collaborators
Permissions
Personal message
Default View
,Personal Message
Which view must include two date columns in order to be displayed?
Card
Gantt
Calendar
Grid
Gantt
You are using Smartsheet to plan, track and manage a project. In creating your sheet, you are
assigning tasks to collaborators. You need to make a decision on whether to use multiple single
contact list columns or enable multiple contacts to be assigned within a single cell. You
understand that it best to enable multiple contacts to be assigned within a single cell when
multiple people are working on the same task. In what scenario is it best to use multiple contact
list columns?
When you want to create a filter for each individual
When some individuals are inside your team's account and others are not
When you want to pull a report from a sheet
When the individuals have different roles related to a task
When the individuals have different roles related to a task
Jen has a project sheet that includes a dropdown list column. Her coworker needs to add
additional options to the dropdown list column options in Jen's sheet. What permission level
would her coworker need for Jen's sheet?
Editor- can't share
Viewer
Admin
Editor- can share
Admin
When creating a form, using a ___________ field, allows you to input a default value into a
column on a sheet without requiring the form submitter to create it.
Branded
Hidden
Custom
Required
Hidden
, Which function leverages sheet hierarchy to reference the range of rows that are indented below
another row?
ANCESTORS()
CHILDREN()
PARENT()
INDEX()
Children()
Juan is currently managing the development of a new product. He has a team of four individuals
with whom he assigns various tasks. Juan wants to quickly see tasks assigned to each person and
reassign tasks as needed. Which of the options below would be the most efficient way for Juan to
accomplish this?
Juan needs to create and use a filter for each assignee and then return to the sheet to reassign
tasks.
Juan needs to publish the sheet to his team and allow them to email suggestions on task
reassignment.
Juan needs to utilize card view to view by the assigned to contact column. He could then view
and reassign accordingly.
Juan needs to build a report for each person on his team. From each of the reports, Juan would
reassign tasks.`
Juan needs to utilize card view to view by the assigned to contact column. He could then view
and reassign accordingly.
The report widget allows you to display a report in which two of the following views:
Card
Grid
Calendar
Gantt
Grid and Gantt
You can share a collaborator to which two of the following?
Folder
Workspace
Resource View
Sheet
Workspace and Sheet
Which collaboration feature allows the recipient to make a one time change to your sheet without
sharing them as a collaborator to the sheet?
