Download Smartsheet Features and Functionality and more Exams Nursing in PDF only on Docsity!
SMART SHEETS PRODUCT CERTIFICATION EXAM
Questions With 100% Verified Answers Latest
Updates 2024 GRADE A+
- A row report can be displayed on a dashboard using the report widget in which two of the following views? Gantt Calendar Grid Card: Gantt Card
- What Forms feature lets you reveal specific fields in a form based on the answers to other questions? Form Elements Conditional Logic Fields Settings: Conditional Logic
- To quickly identify and review the changes that have been made to a sheet, use Symbols column type Highlight changes Conditional formatting
Format painter: Highlight changes
- When writing a formula, what symbol do you type to make either a column or row reference absolute? ( ) Parentheses $ Dollar sign
Pound sign
[ ] Square brackets: $ Dollar sign
- Which column type would be best for assigning tasks to individual team members? Contact List column Created by System column Text/Number column Dropdown List: Contact List column
- Scenario: You want to surface a count of at-risk tasks on a dashboard. You determine one option for doing so would be to use a drop-down column to mark a task at-risk. Question: Which one of the following column types can also be utilized to mark at-risk items that could be counted and displayed on a dashboard? System Generated Column Duration Column
Metric widget on a dashboard Cell(s) in a sheet Cell(s) in a report: Cell(s) in a sheet
- In order to enable Card View, your sheet must have at least one of three specific column types. Two of those columns types are Dropdown List and Symbol. What is the third column type? System Generated column Text/Number column Contact List column Date column: Contact List column
- Which feature allows licensed collaborators [with at least Editor permis- sions] to audit and export changes made to the sheet? Conditional formatting Activity log
Highlight changes View cell history: Activity log
- Based on the settings shown above, what permission level would Don Miller have on the sheet? Owner Editor Admin Viewer: Editor
- Scenario: Valentino created an alert to notify a contact in the "assigned to" column if their task is past due and incomplete. Valentino realized that one of his external contractors did not receive the notification when this occurred. Question: What is a likely reason an external collaborator does not receive an automated notification? The user must first be in your personal My Smartsheet Contacts list in order to receive the notification The Automation Permissions is not set to unrestricted so external collabora- tors would not receive the notification Valentino needed to create an approval request rather than an alert Alerts can only be sent to people in your account. You must send a request, to your System Administrator, that the collaborator be added to the account contact list: The Automation Permissions is not set to unrestricted so external collaborators would not receive the notification
- Scenario: Joy is the director of a sales team that manages its pipeline in Smartsheet. Every time an opportunity status is marked as "Closed Lost", reps should provide detail in a column called "Reason Won/Lost".
Return Yes: 1
- When you create a new form for a sheet in Smartsheet, the form is auto- matically populated with fields based on which sheet element? Primary column Drop-down list Columns Rows: Columns
- The Notification Center: (select the two options that apply) Allows a user to forward a notification to a different user 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 view and fulfill update requests Displays a red icon when new notifications arrive
- Which type of cell link gets its value from a cell in another sheet? Source Destination Outbound Inbound: Inbound
- You can share a collaborator to which two of the following? Workspace Folder
Resource View Sheet: Workspace Sheet
- Scenario: Shauna, a sheet level Admin, is receiving too many notifications from an established workflow. Shauna still wants to receive notifications from this workflow, but not as often. Question: Which one of the following options would reduce the number of notifications sent for a given workflow without changing the triggers? Add a conditional formatting rule to the alert Lock the row after the first notification is sent Change the frequency by editing the "Run workflow" settings Replace the rule with an update request: Change the frequency by editing the "Run workflow" settings
On the sheet summary Within your Personal Settings Within the column properties for a contact list column: Within the column properties for a contact list column
- How is tagging a shared collaborator, in a comment via an @mention, an effective means of collaboration? It shares that collaborator a published view of the sheet so they can view the comment It adds the @mentioned individual to your My Smartsheet Contacts It instantly sends the @mentioned individual a notification with the comment It begins keeping track of the @mentioned individual within activity log: It instantly sends the @mentioned individual a notification with the comment
- A is helpful when you need to share a number of items with the same group of people.: Workspace
- Auto-fill is automatically applied by Smartsheet within every sheet. Which two of the following functions does auto-fill perform? Apply formulas and adjust cell references to adjacent rows Continue patterns of formatting Copy manual update requests to generate recurring updates Generate a numeric value based on conditional formatting rules: Apply formu- las and adjust cell references to adjacent rows Continue patterns of formatting
- Which column type would be best for visually representing the status of a row item? Emoji column Symbols column Text/Number column Drop-down List column: Symbols column
- When entering formulas in Smartsheet, cell references use the syntax of column name and row number. What symbols must be placed around a column name when it includes a space, special characters, or numbers? { } Curly brackets [ ] Square brackets ( ) Parentheses < > Angle brackets: [ ] Square brackets
- Scenario: You have a handful of tasks that are falling behind schedule and you want to quickly view which items are marked "Red" in your project status column. Question: To identify this information WITHOUT having to leave your sheet,
board's activity log: It allows an individual to complete a form submission without leaving the dashboard
- When viewing a sheet, you want to have certain rows grab your attention, visually, if the task is at risk or past its due date. You can accomplish this by using which feature? Highlight changes Conditional formatting Format painter Alerts: Conditional formatting
- You want to use automated Alerts to alert someone external to your organization who doesn't use Smartsheet. Because the alert is for external collaborators you want to safeguard the data on the sheet. Which option is the most secure way to send an alert without providing access to your data? A C B: C
- Which feature would you use to change the visual styling of a sheet based on an identified trigger? Highlighting tool Function Conditional Formatting Format Painter: Conditional Formatting
- When viewing cell history, which three of the following actions are dis- played?
Who made a change What information was entered in the cell What attachments were made to the row When the change was made: Who made a change What information was entered in the cell When the change was made
- Which one of these functions can be used in conjunction with another function such as COUNT() to reference all the cells directly indented under a parent row? ANCESTORS() INDEX() CHILDREN() PARENT(): CHILDREN()
Juan needs to utilize Card View to view tasks by the "assigned to" contact column. He could then reassign tasks 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 publish the sheet to his team and allow them to email ideas on how the tasks should be reassigned.: Juan needs to utilize Card View to view tasks by the "assigned to" contact column. He could then reassign tasks accordingly.
- Select which one of the following formats is not applicable for exporting a sheet in Smartsheet. Trello PDF Google Sheet Excel
MS Project (XML) Gantt to image (PNG): Trello
- You want to know when new attachments are added to your sheet without opening the 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: Create an alert to notify you when an attachment is added or changed
- 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. CSV PNG Excel PDF: Excel PDF
- Scenario: 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 several single Contact List columns or enable multiple contacts to be assigned within a single cell. Question: In which one of the following scenarios is it best to use several Contact List columns? When the individuals have different roles related to a task.
- Both sharing and publishing are features that can be used to give view only access to a sheet. What is the difference between sharing a sheet as a viewer and sending a published link? There is no difference between viewing a published sheet and a shared sheet Viewing a shared sheet grants access to see attachments and comments, published sheets do not Viewing a shared sheet requires a collaborator to log-in, viewing a published sheet does not Shared sheets reflect changes in real-time, published sheets do not: Viewing a shared sheet requires a collaborator to log-in, viewing a published sheet does not
- Which one of the following options does not serve as a trigger for an automated workflow? When columns are added or changed When a date is reached When rows are changed When rows are added: When columns are added or changed
- When a task becomes at-risk, the project manager wants the individual as- signed to the task to be immediately notified. How could the project manager achieve this goal? Send the activity log to all shared users of a sheet Create an alert to notify the assignee when a task is marked as at-risk Use the send row functionality to send a row when the task is marked as at-risk Create a conditional formatting rule to notify individuals when a task is marked at-risk: Create an alert to notify the assignee when a task is marked as at-risk
- Dashboards provide real-time visibility into the status of the business,
providing critical KPIs through metric, chart and graph, and report widgets that help users make better decisions, faster. Which one of the following options has the same functionality of a dashboard, but caters to a different use case? Metrics sheet Published report Portal Sheet Summary: Portal
- Which conditional formatting rule takes priority in this situation? The one on the top Both The one at the bottom None: The one on the top
