Download Smartsheet Certification Practice Test Questions and more Exams Engineering in PDF only on Docsity!
SMARTSHEET CERTIFICATION PRACTICE TEST Questions
With 100% Verified Answers Latest Updates 2024
GRADE A+
How is tagging a shared collaborator in a comment, via the use of at mention, an effective means of collaboration? It shares that collaborator a published view of the sheet so they can view the comment. It instantly sends the @mentioned individual an alert with the comment. It begins keeping track of the @mentioned individual within activity log. It adds the @mentioned individual to your My Smartsheet Contacts - ans It instantly sends the @mentioned individual an alert with the comment. I have a handful of tasks that are falling behind schedule and I want to quickly view which items are marked "Red" in my project status column. To identify this information WITHOUT having to leave the sheet, I should:
Turn on highlight changes Write a formula Create a filter Send an update request to my collaborators - ans Create a filter Date based alerts help keep collaborators aware of key project dates. Date based alerts can be triggered on a specific date or based off a date in any date column. Which of the following is a possible use case for establishing a date based alert? Samuel wants to automatically inform his boss when the status of a task becomes at-risk Samuel wants to notify all collaborators when a task is over budget Samuel wants to be sent an email five days before the start of each task so he can check in with key collaborators Samuel wants to automatically let external vendors know when a task is not complete - ans Samuel wants to be sent an email five days before the start of each task so he can check in with key collaborators
In order to enable Card View, your sheet must have a least one of three specific column types. Two of those columns are dropdown list and symbol. What is the third column type? Date column Text/Number column System Generated column Contact List column - ans Text/Number column 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 - ans 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 - ans 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 - ans [ ] Square brackets
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 - ans 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 - ans 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 - ans Hidden Which function leverages sheet hierarchy to reference the range of rows that are indented below another row? ANCESTORS() CHILDREN() PARENT() INDEX() - ans Children()
Grid Calendar Gantt - ans Grid and Gantt You can share a collaborator to which two of the following? Folder Workspace Resource View Sheet - ans 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? Share a sheet An update request Publish Send a row - ans An update request
Which column type would be best for tracking when a row was added to a sheet? Date column Created by System column Auto-Number column Created (Date) System column - ans Auto-Number column You want to keep track of new attachments as they are added to a sheet. Which of the following is the best way to achieve this goal? Create a conditional formatting rule to highlight rows with new attachments Audit Activity Log daily Create an alert to notify you when an attachment is added or changed Instruct collaborators to @mention you in the comments after an attachment has been uploaded - ans Create an alert to notify you when an attachment is added or changed
Trello - ans MS Project (XML), PDF, Google Sheet, Excel, Gantt to image (PNG) Which column type would be best for visually representing (via color) the status of a row item? This could also be automatically changed using a formula. Symbol column Dropdown List column Text/Number column System Generated column - ans Symbol column Which three of the following items can be viewed without a Smartsheet account? Form Published dashboard Report in a workspace shared to you Update request - ans Form, Published dashboard, and Update request
Which three of the following file types can be uploaded using the image widget? PDF PNG GIF JPEG - ans PNG, GIF, JPEG How can you add more fields to your report beyond what fields are used as criteria? From the File menu select Add More Columns In the Report Builder, click the Columns button and select additional columns Add a column to a source sheet. This new column will automatically be displayed in the report. In the toolbar, click the Report Tool and select additional criteria - ans In the Report Builder, click the Columns button and select additional columns
Forms can be used to collect information from individuals inside or outside your organization. Which two of the following use cases could a form support? Survey responses Marketing requests Update the status of a task Resource hub - ans Survey responses and Marketing requests The Notification Center: (select the two options that apply) Displays a red icon when new notifications arrive Allows a user to create new alerts Allows a user to view and fulfill update requests Allows a user to forward a notification to a different user - ans Displays a red icon when new notifications arrive and allos a user to view and fulfill update requests
A snapshot of a sheet or report can be shared via email using the "Send as Attachment..." action. The sheet can be sent once or on a recurring basis. Select the two file formats the attachment can be sent as. Excel PDF CSV PNG - ans Excel and PDF When viewing a sheet, you want to have certain rows grab your attention, if the task is at risk or past its due date. You can accomplish this by using which feature? Highlight changes Conditional formatting Alerts Format painter - ans Conditional formatting
Create an alert to notify yourself when a new row has been added to the sheet. - ans Create an alert to notify yourself when a new row has been added to the sheet. The "Send..." action, available from the row menu, allows you to provide a view-only version of one or more rows to anyone you specify. Which two of the following options can be customized? File format of the rows (PDF or Excel) Custom message to recipient Delivery recurrence (once, every hour, every day, etc.) Columns included - ans Custom message to recipient and columns included 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 - ans 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 - ans Change the criteria in the Report Builder What is a key benefit to embedding a form on a dashboard via the web content widget? 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.
