Smartsheet Core Product Exam questions with answers

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.
|\ |\ |\ |\ |\ |\ |\ |\