Smartsheet Core Product Exam |\ |\ |\ |\
questions with answers |\ |\
What can you customize when you insert a hyperlink in a
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
cell? - CORRECT ANSWERS ✔✔Display text
|\ |\ |\ |\ |\
Which takes priority when a sheet has 2 conditional
|\ |\ |\ |\ |\ |\ |\ |\ |\
formatting rules? - CORRECT ANSWERS ✔✔The rule on |\ |\ |\ |\ |\ |\ |\ |\
the top |\
Which type of user can create or own a sheet in
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
Smartsheet? - CORRECT ANSWERS ✔✔Licensed |\ |\ |\ |\
What permission is required to hide and unhide columns?
|\ |\ |\ |\ |\ |\ |\ |\
- CORRECT ANSWERS ✔✔Admin
|\ |\ |\ |\
Vivian uses a sheet to track the status of a project that
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
she is managing. Several cells are cell linked to a sheet
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
that the IT director uses to track all IT projects. Vivian
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
updates her sheet. |\ |\
When do the linked cells on the director's sheet update? -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔When Vivian's sheet is saved |\ |\ |\ |\ |\ |\
,Which column type tracks when a row was added to a
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
sheet? - CORRECT ANSWERS ✔✔Created (Date) column
|\ |\ |\ |\ |\ |\
Which are the 3 column types that can enable Card View?
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
- CORRECT ANSWERS ✔✔Contact List, Dropdown (Single
|\ |\ |\ |\ |\ |\ |\ |\
Select), Symbol |\
Tyrone created a project plan sheet and is adding 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? -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔Formatting |\ |\
Which view must include 2 date columns in order to be
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
displayed? - CORRECT ANSWERS ✔✔Gantt |\ |\ |\ |\
Which file type can you insert in a cell? - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔.gif |\
Alex is building a sheet to keep track of her tasks on a
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
website project. She must perform the same set of tasks
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
for each webpage. She listed each webpage on 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? - CORRECT ANSWERS ✔✔Copy the |\ |\ |\ |\ |\ |\ |\
rows with tasks, then paste them under each webpage
|\ |\ |\ |\ |\ |\ |\ |\
Which program files can you import into Smartsheet to
|\ |\ |\ |\ |\ |\ |\ |\ |\
create a new sheet? - CORRECT ANSWERS ✔✔Excel
|\ |\ |\ |\ |\ |\ |\
Where can you see the hierarchy in a row? - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔Primary Column |\ |\
You are building a sheet to keep track of opportunities 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? - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\ |\ |\
✔✔Dropdown (Single Select) |\ |\
What is the minimum permission you need to add or edit
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
the options in the column properties of a dropdown list
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
column? - CORRECT ANSWERS ✔✔Admin |\ |\ |\ |\
Sanjay is using a sheet to collect requests for his IT 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 "Complete," he doesn't
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
want them to be able to edit the ticket.
|\ |\ |\ |\ |\ |\ |\ |\
questions with answers |\ |\
What can you customize when you insert a hyperlink in a
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
cell? - CORRECT ANSWERS ✔✔Display text
|\ |\ |\ |\ |\
Which takes priority when a sheet has 2 conditional
|\ |\ |\ |\ |\ |\ |\ |\ |\
formatting rules? - CORRECT ANSWERS ✔✔The rule on |\ |\ |\ |\ |\ |\ |\ |\
the top |\
Which type of user can create or own a sheet in
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
Smartsheet? - CORRECT ANSWERS ✔✔Licensed |\ |\ |\ |\
What permission is required to hide and unhide columns?
|\ |\ |\ |\ |\ |\ |\ |\
- CORRECT ANSWERS ✔✔Admin
|\ |\ |\ |\
Vivian uses a sheet to track the status of a project that
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
she is managing. Several cells are cell linked to a sheet
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
that the IT director uses to track all IT projects. Vivian
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
updates her sheet. |\ |\
When do the linked cells on the director's sheet update? -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔When Vivian's sheet is saved |\ |\ |\ |\ |\ |\
,Which column type tracks when a row was added to a
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
sheet? - CORRECT ANSWERS ✔✔Created (Date) column
|\ |\ |\ |\ |\ |\
Which are the 3 column types that can enable Card View?
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
- CORRECT ANSWERS ✔✔Contact List, Dropdown (Single
|\ |\ |\ |\ |\ |\ |\ |\
Select), Symbol |\
Tyrone created a project plan sheet and is adding 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? -
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
CORRECT ANSWERS ✔✔Formatting |\ |\
Which view must include 2 date columns in order to be
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
displayed? - CORRECT ANSWERS ✔✔Gantt |\ |\ |\ |\
Which file type can you insert in a cell? - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔.gif |\
Alex is building a sheet to keep track of her tasks on a
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
website project. She must perform the same set of tasks
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
for each webpage. She listed each webpage on 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? - CORRECT ANSWERS ✔✔Copy the |\ |\ |\ |\ |\ |\ |\
rows with tasks, then paste them under each webpage
|\ |\ |\ |\ |\ |\ |\ |\
Which program files can you import into Smartsheet to
|\ |\ |\ |\ |\ |\ |\ |\ |\
create a new sheet? - CORRECT ANSWERS ✔✔Excel
|\ |\ |\ |\ |\ |\ |\
Where can you see the hierarchy in a row? - CORRECT
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
ANSWERS ✔✔Primary Column |\ |\
You are building a sheet to keep track of opportunities 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? - CORRECT ANSWERS
|\ |\ |\ |\ |\ |\ |\ |\ |\
✔✔Dropdown (Single Select) |\ |\
What is the minimum permission you need to add or edit
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
the options in the column properties of a dropdown list
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\
column? - CORRECT ANSWERS ✔✔Admin |\ |\ |\ |\
Sanjay is using a sheet to collect requests for his IT 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 "Complete," he doesn't
|\ |\ |\ |\ |\ |\ |\ |\ |\ |\ |\
want them to be able to edit the ticket.
|\ |\ |\ |\ |\ |\ |\ |\
