SMARTSHEET CERTIFICATION EXAM ACTUAL EXAM COMPLETE 100 QUESTIONS WITH DETAILED VERIFIED, Exams of Nursing

Download SMARTSHEET CERTIFICATION EXAM ACTUAL EXAM COMPLETE 100 QUESTIONS WITH DETAILED VERIFIED and more Exams Nursing in PDF only on Docsity! SMARTSHEET CERTIFICATION EXAM ACTUAL EXAM COMPLETE 100 QUESTIONS WITH DETAILED VERIFIED ANSWERS (100% CORRECT ANSWERS) ALREADY GRADED A+ 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 - ....ANSWER >>>>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 - ....ANSWER >>>>Hidden Which function leverages sheet hierarchy to reference the range of rows that are indented below another row? ANCESTORS() CHILDREN() PARENT() INDEX() - ....ANSWER >>>>Children() Juan is currently managing the development of a new product. He has a team of four individuals with whom he assigns various tasks. Juan wants to quickly see tasks assigned to each person and reassign tasks as needed. Which of the options below would be the most efficient way for Juan to accomplish this? Created (Date) System column - ....ANSWER >>>>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 - ....ANSWER >>>>Create an alert to notify you when an attachment is added or changed Which of the following file types can be imported as a new sheet in Smartsheet? (select the four that apply) MS Project JIRA Project Excel Smartsheet Sheet Trello Google Sheets - ....ANSWER >>>>MS Project, Excel, Trello, Google Sheets A sheet can be exported in which of the following formats? Select ALL that apply. MS Project (XML) PDF Google sheet Excel Gantt to image (PNG) Trello - ....ANSWER >>>>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 - ....ANSWER >>>>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 - ....ANSWER >>>>Form, Published dashboard, and Update request Which three of the following file types can be uploaded using the image widget? PDF PNG GIF JPEG - ....ANSWER >>>>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 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 - ....ANSWER >>>>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 - ....ANSWER >>>>Conditional formatting Which of the following can be inserted into a formula to automate the checking of a box, raising of a flag or filling in of a star? 1 "Return" 100% "Yes" - ....ANSWER >>>>1 You've created a form to gather new customer information. When new submissions are made, you must go into the sheet and assign a member of your sales team as the lead, who will then follow-up with the customer. Which of the following workflows best addresses your need to quickly take action after a form submission is made? Use the "Send as Attachment" feature to send yourself a daily email with directions to assign a lead. Create an alert to notify you when anything on the sheet changes. Send yourself the activity log, hourly, so you can adjust the assigned individual. Create an alert to notify yourself when a new row has been added to the sheet. - ....ANSWER >>>>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 - ....ANSWER >>>>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 Use the send row functionality to send a row when the task is marked as at-risk. Create an alert to notify the assignee when a task is marked as at-risk. Send the alert to the assigned to (Contact List column) right away - ....ANSWER >>>>Create an alert to notify the assignee when a task is marked as at-risk. Send the alert to the assigned to (Contact List column) right away Which function will determine the total number of items in a specified range? COUNT() SUM() AVG() CHILDREN() - ....ANSWER >>>>Count() When writing a formula, what symbol do you type to make either a column or row reference absolute? $ dollar sign [ ] square brackets ( ) parenthesis # pound sign - ....ANSWER >>>>$ dollar sign Formulas can trigger a cell value change when a specific value is entered elsewhere on a sheet. If instead of changing the value of a cell, you want to change the visual styling based on an identified trigger, which feature would you use? Format painter Function Conditional formatting Highlighting tool - ....ANSWER >>>>Conditional formatting A dashboard has been shared to me and I can click on a metric widget to open the source sheet. The ability to access a source sheet by clicking on a metric widget means the owner has changed the interaction of the widget. Which additional action has the owner taken? Published the dashboard Granted admin permissions to the dashboard Shared the source sheet Organized the dashboard in a workspace - ....ANSWER >>>>Shared the source sheet When viewing cell history, which three of the following actions are displayed? What attachments were made to the row What information was entered in the cell When the change was made Who made a change - ....ANSWER >>>>What information was entered in the cell, When the change was made, Who made a change To print a sheet or report, you first create a PDF file. Which option would adjust the sheet to fit the width of a page? Scaling Margins Orientation Date range - ....ANSWER >>>>Scaling A report can be published via which one of the following options? sheet(s)? - ....ANSWER >>>>Add the report to a dashboard by using the Report Widget Which file type cannot be uploaded using the image widget? - ....ANSWER >>>>PDF Which two views of a row report can be displayed on a dashboard using the report widget? - ....ANSWER >>>>Grid, Gantt What is the default label for the data in a metric widget? - ....ANSWER >>>>Column name Which dashboard widget type would be best to show a live updating budget number of a project? - ....ANSWER >>>>Metric How is embedding a form on a dashboard via the web content widget effective? - ....ANSWER >>>>It allows an individual to complete a form submission without leaving the dashboard Which widget behavior will allow the user to open the underlying sheet or report? - ....ANSWER >>>>Open the data source What symbol notes the beginning of a formula? - ....ANSWER >>>>= Which formula is the most scalable way to count the indented rows under "Carl Jackson", knowing that you will be adding additional rows within this hierarchy? - ....ANSWER >>>>=COUNT(CHILDREN()) I am adding a field called "Budget Total" in the Sheet summary of a sheet. What is the syntax to reference the "Budget Total" field in a formula? - ....ANSWER >>>>[Budget Total]# When adding a cell link to a sheet, which can be the source of the data? - ....ANSWER >>>>Cell(s) in a sheet 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? - ....ANSWER >>>>Conditional formatting Which is used when writing a formula to automate checking a box, raising a flag, or filling in of a star? - ....ANSWER >>>>1 Which column type would be best for assigning tasks to individual team members? - ....ANSWER >>>>Contact List column What symbols must be placed around a column name in a formula if the name includes a space, special characters, or numbers? - ....ANSWER >>>>[ ] Square brackets Which view must include two date columns in order to be displayed? - ....ANSWER >>>>Gantt What level of hierarchy should the CHILDREN() function should be placed on? - ....ANSWER >>>>Parent row Which Form Submission option allows form users to submit multiple entries one after the other? - ....ANSWER >>>>Reload the same form for another entry What is the lowest permission level you need to edit data from a report? - ....ANSWER >>>>Editor What will happen to the column headers on the sheet when form fields are removed from the form? - ....ANSWER >>>>The column headers will remain on the sheet Forms can be used to collect information from individuals inside or outside your organization. Which two use cases could a form support? - ....ANSWER >>>>Survey Responses & Marketing Requests Which two options enable you to add more columns to your report? - ....ANSWER >>>>1) In the toolbar, click "Columns", then add additional columns 2) Right-click on any column header in the report and select "Add Column" What is the lowest permission level you need to create a form? - ....ANSWER >>>>Admin Which form field option allows you to input a default value so that the form can input sheet data without requiring the form submitter to create it or see the field? - ....ANSWER >>>>Hidden What Forms feature lets you reveal specific fields in a form based on the ANSWERs to other questions? - ....ANSWER >>>>Conditional Logic What is the best approach to providing a collaborator viewer access to only a subset of data that is tracked on a sheet? - ....ANSWER >>>>Publish a report and give them the link What is the reason to create a current user report? - ....ANSWER >>>>The Current User filter allows collaborators to see only the tasks they are assigned to Which of the following is a way to provide access to a form? - ....ANSWER >>>>Email the form directly from Smartsheet Which feature in a sheet allows you to set criteria to only show certain rows while hiding all others? - ....ANSWER >>>>Filters How can a user modify a report to get different results? - ....ANSWER >>>>Change the filter criteria A user has opened a report that you shared to them but does not see any data. Which is a reason why that might occur? - ....ANSWER >>>>The user is not shared to any sheets that the report is pulling data from Which allows you to quickly identify and review the changes that have been made to a sheet? - ....ANSWER >>>>Highlight changes Which is a possible use-case for establishing an alert with a date as the trigger? - ....ANSWER >>>>You want to be sent an email five days before the start of each task so that you can check in with key collaborators 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? - ....ANSWER >>>>The Automation Permissions is not set to unrestricted so external collaborators would not receive the notification 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? - ....ANSWER >>>>Change the frequency by editing the "Run workflow" settings Which option serves as a trigger for an automated workflow? - ....ANSWER >>>>When a date is reached Which Automation Permissions setting only allows the users that are shared to a sheet to receive notifications and requests from the sheet? - ....ANSWER >>>>Restricted To dynamically add cell data in the subject and body of automated request messages, the column name must be wrapped inside which one as a placeholder? - ....ANSWER >>>>{{ }} Double curly brackets When a task becomes at-risk, the project manager wants the individual assigned to the task to be immediately notified. How could the project manager achieve this goal? - ....ANSWER >>>>Create an alert to notify the assignee when a task is marked as at-risk 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". Question: What is an automated way for Joy to ask reps to fill out the "Reason Won/Lost" column if they do not initially do so? - ....ANSWER >>>>Set up a workflow that sends an automated Update Request when the opportunity status changes to "Closed Lost" and the "Reason Won/Lost" column is blank Scenario: You've created a form to gather new customer interest information. When new submissions are made, you need to assign a member of your sales team as the lead, who will follow-up with the customer. Which one of the following workflows would be the most efficient way to quickly take action after a form submission is made? - ....ANSWER >>>>Create 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 - ....ANSWER >>>>Samuel wants to be sent an email five days before the start of each task so he can check in with key collaborators Auto-fill is automatically applied by Smartsheet within every sheet. Which two of the following functions does auto-fill perform? Copy manual update requests to generate recurring updates Continue patterns of formatting Apply formulas and adjust cell references to adjacent rows Generate a numeric value based on conditional formatting rules - ....ANSWER >>>>Continue patterns of formatting Apply formulas and adjust cell references to adjacent rows The ___________ widget uses a URL or embed code to surface interactive content on a dashboard. Title Report Image Web Content - ....ANSWER >>>>Web Content 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 - ....ANSWER >>>>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 - ....ANSWER >>>>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 - ....ANSWER >>>>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