Smartsheet Certification Exam 2024-2025. Real Questions & Correct Answers. Graded A+, Exams of Web Design and Development

Download Smartsheet Certification Exam 2024-2025. Real Questions & Correct Answers. Graded A+ and more Exams Web Design and Development in PDF only on Docsity! Smartsheet Certification Exam 2024- 2025. Real Questions & Correct Answers. Graded A+ 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 - ANSShared the source sheet A report can be published via which one of the following options? Read Only HTML (light web link) iCal (calendar) Read Only Full (rich web link) Edit by Anyone - ANSiCal (calendar) 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 - ANSMS Project (XML), PDF, Google Sheet, Excel, Gantt to image (PNG) 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 - ANSExcel and PDF 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 - ANSContinue patterns of formatting Apply formulas and adjust cell references to adjacent rows Cell linking is done at which of the following levels? Row Column Sheet Cell - ANSCell 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 - ANSHighlight changes 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 - ANSSamuel wants to be sent an email five days before the start of each task so he can check in with key collaborators 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 - ANSSurvey responses and Marketing requests 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? Juan needs to build a report for each person on his team. From each of the reports, Juan would reassign tasks.` - ANSJuan needs to utilize card view to view by the assigned to contact column. He could then view and reassign accordingly. The ___________ widget uses a URL or embed code to surface interactive content on a dashboard. Title Report Image Web Content - ANSWeb Content 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 - ANSCustom message to recipient and columns included 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 - ANSDisplays a red icon when new notifications arrive and allos a user to view and fulfill update requests The report widget allows you to display a report in which two of the following views: Card Grid Calendar Gantt - ANSGrid and Gantt 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 - ANSScaling 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 - ANSFile name Date attached Name of the individual who attached the file 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. It automatically captures who completed a form submission in the dashboard's activity log. Using an interaction setting, you can provide instant access to the underlying sheet. - ANSIt provides increased efficiency as an individual can complete a form submission without leaving the dashboard itself. What is the name for the type of link that contains data linked from another sheet? (Note: This is designated with a blue arrow on the right side of the cell). Destination Outbound Inbound Source - ANSInbound 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? Create a conditional formatting rule to notify individuals when a task is marked at-risk Send the activity log to all shared users of a sheet 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 - ANSCreate 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 When adding a new collaborator to a sheet or workspace, what should be customized to help the new collaborator understand why they are being added and how they should use the information? Collaborators Permissions Personal message Default View - ANSPersonal Message 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 - ANSHidden 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 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 - ANSConditional formatting 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 - ANSWhat information was entered in the cell, When the change was made, Who made a change 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 - ANS$ dollar sign 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