SMARTSHEET CORE PRODUCT CERTIFICATION EXAM NEWEST 202
Smartsheet Core Product Exam
COMPLETE QUESTIONS AND CORRECT DETAILED ANSWERS
Study online at https://quizlet.com/_hbfqhq
(VERIFIED ANSWERS) |ALREADY GRADED A+
1. What can you customize when you insert a hyperlink in Display text
a cell?
2. Which takes priority when a sheet has 2 conditional The rule on the top
formatting rules?
3. Which type of user can create or own a sheet in Licensed
Smartsheet?
4. What permission is required to hide and unhide Admin
columns?
5. Vivian uses a sheet to track the status of a project that When Vivian's sheet is
she is managing. Several cells are cell linked to a sheet saved
that the IT director uses to track all IT projects. Vivian
updates her sheet.
When do the linked cells on the director's sheet up-
date?
6. Which column type tracks when a row was added to a Created (Date) column
sheet?
7. Which are the 3 column types that can enable Card Contact List, Dropdown
View? (Single Select), Symbol
8. Tyrone created a project plan sheet and is adding Formatting
tasks. He added the first task, then moved to the next
row to add his second task.
What will automatically be copied down to the new
row?
9. Which view must include 2 date columns in order to be Gantt
displayed?
, Smartsheet Core Product Exam
Study online at https://quizlet.com/_hbfqhq
10. Which file type can you insert in a cell? .gif
11. Alex is building a sheet to keep track of her tasks on Copy the rows with tasks,
a website project. She must perform the same set of then paste them under
tasks for each webpage. She listed each webpage on each webpage
her sheet and has written out the tasks for the first
one.
What is the fastest way for her to add the tasks to the
remaining webpages?
12. Which program files can you import into Smartsheet Excel
to create a new sheet?
13. Where can you see the hierarchy in a row? Primary Column
14. You are building a sheet to keep track of opportunities Dropdown (Single Select)
for your sales team. You want a column to show which
of the 4 regions each opportunity is assigned to.
Which column type would be best?
15. What is the minimum permission you need to add or Admin
edit the options in the column properties of a drop-
down list column?
16. Sanjay is using a sheet to collect requests for his IT Lock the rows
team. He has shared the sheet, giving them Editor
permissions so they can update the status of tickets
they are assigned to. When a ticket is marked as "Com-
plete," he doesn't want them to be able to edit the
ticket.
How can Sanjay do this?
17. Publish the sheet
Smartsheet Core Product Exam
COMPLETE QUESTIONS AND CORRECT DETAILED ANSWERS
Study online at https://quizlet.com/_hbfqhq
(VERIFIED ANSWERS) |ALREADY GRADED A+
1. What can you customize when you insert a hyperlink in Display text
a cell?
2. Which takes priority when a sheet has 2 conditional The rule on the top
formatting rules?
3. Which type of user can create or own a sheet in Licensed
Smartsheet?
4. What permission is required to hide and unhide Admin
columns?
5. Vivian uses a sheet to track the status of a project that When Vivian's sheet is
she is managing. Several cells are cell linked to a sheet saved
that the IT director uses to track all IT projects. Vivian
updates her sheet.
When do the linked cells on the director's sheet up-
date?
6. Which column type tracks when a row was added to a Created (Date) column
sheet?
7. Which are the 3 column types that can enable Card Contact List, Dropdown
View? (Single Select), Symbol
8. Tyrone created a project plan sheet and is adding Formatting
tasks. He added the first task, then moved to the next
row to add his second task.
What will automatically be copied down to the new
row?
9. Which view must include 2 date columns in order to be Gantt
displayed?
, Smartsheet Core Product Exam
Study online at https://quizlet.com/_hbfqhq
10. Which file type can you insert in a cell? .gif
11. Alex is building a sheet to keep track of her tasks on Copy the rows with tasks,
a website project. She must perform the same set of then paste them under
tasks for each webpage. She listed each webpage on each webpage
her sheet and has written out the tasks for the first
one.
What is the fastest way for her to add the tasks to the
remaining webpages?
12. Which program files can you import into Smartsheet Excel
to create a new sheet?
13. Where can you see the hierarchy in a row? Primary Column
14. You are building a sheet to keep track of opportunities Dropdown (Single Select)
for your sales team. You want a column to show which
of the 4 regions each opportunity is assigned to.
Which column type would be best?
15. What is the minimum permission you need to add or Admin
edit the options in the column properties of a drop-
down list column?
16. Sanjay is using a sheet to collect requests for his IT Lock the rows
team. He has shared the sheet, giving them Editor
permissions so they can update the status of tickets
they are assigned to. When a ticket is marked as "Com-
plete," he doesn't want them to be able to edit the
ticket.
How can Sanjay do this?
17. Publish the sheet
