1 | P a g e SMARTSHEETS PRODUCT CERTIFICATION PART 1 EXAM|| ACTUAL EXAM ALL QUESTIONS AND CORRECT ANSWERS ALREADY GRADED A+|| LATEST AND COMPLETE UPDATE WITH 100% VERIFIED SOLUTIONS|| ASSURED PASS!!! A row report can be displayed on a dashboard using the report widget in which two of the following views? Gantt Calendar Grid Card - ANSWER: 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 - ANSWER: 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 - ANSWER: Highlight changes 2 | P a g e 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 - ANSWER: $ Dollar sign Which column type would be best for assigning tasks to individual team members? Contact List column Created by System column Text/Numbe r column Dropdown List - ANSWER: 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 Date Column Symbol Column - ANSWER: Symbol Column Indenting rows will add hierarchy and create relationships between rows. The hierarchy is applied to the entire row, but will only be visible in what part of the sheet? 3 | P a g e Leftmost column in grid view System column Primary column Row action indicators column - ANSWER: Primary column Which of the following views must include two date columns in order to be displayed? Calendar Gantt Grid Card - ANSWER: Gantt Which one of the following Automation Permissions settings only allows the users that are shared to a sheet to receive notifications and requests from the sheet? Limited Unrestricted Restricted Unlimited - ANSWER: Restricted When adding a cell link to a sheet, which of the following can be the source of the data? Column names Metric widget on a dashboard Cell(s) in a sheet Cell(s) in a report - ANSWER: Cell(s) in a sheet
risk items that could be counted and displayed on a dashboard? System Generated Column Duration Column Date Column Symbol Column - ANSWER: Symbol Column Indenting rows will add hierarchy and create relationships between rows. The hierarchy is applied to the entire row, but will only be visible in what part of the sheet? 3 | P a g e Leftmost column in grid view System column Primary column Row action indicators column - ANSWER: Primary column Which of the following views must include two date columns in order to be displayed? Calendar Gantt Grid Card - ANSWER: Gantt Which one of the following Automation Permissions settings only allows the users that are shared to a sheet to receive notifications and requests from the sheet? Limited Unrestricted Restricted Unlimited - ANSWER: Restricted When adding a cell link to a sheet, which of the following can be the source of the data? Column names Metric widget on a dashboard Cell(s) in a sheet Cell(s) in a report - ANSWER: Cell(s) in a sheet
