02 Gather Data and Report Quiz - bsharphd/Smartsheet_Core_App_Path GitHub Wiki

Question 1: Correct answer

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?

  • You did not publish the report as "Read-Only Full"
  • Grouping was not set up on the report
  • They were not added to the Report Summary
  • The user is not shared to any sheets that the report is pulling data from

Question 2: Correct answer

What will happen to the column headers on the sheet when form fields are removed from the form?

  • The form fields are locked and cannot be deleted
  • The column headers will remain on the sheet
  • The data on the sheet will be removed
  • The column headers will be removed from the sheet

Question 3: Correct answer

What is the lowest permission level you need to create a form?

  • Admin
  • Owner
  • Viewer
  • Editor

Question 4: Correct answer

What Forms feature lets you reveal specific fields in a form based on the answers to other questions?

  • Form Elements
  • Conditional Logic
  • Fields
  • Settings

Question 5: Correct answer

What is the lowest permission level needed to modify the criteria of the report?

  • Editor
  • Owner
  • Viewer
  • Admin

Question 6: Correct answer

Which two options enable you to add more columns to your report?

  • In the toolbar, click the Report Tool and select additional criteria
  • In the toolbar, click "Columns", then add additional columns
  • Right-click on any column header in the report and select "Add Column"
  • From the file menu select Add More Columns
  • Add a column to a source sheet. This new column will automatically be displayed in the report

Question 7: Correct answer

Which Form Submission option allows form users to submit multiple entries one after the other?

  • Display this message on the confirmation page
  • Send the user to a URL
  • Reload the same form for another entry
  • Enable a confirmation email

Question 8: Correct answer

Forms can be used to collect information from individuals inside or outside your organization. Which two use cases could a form support?

  • Survey responses
  • Resource hub
  • Marketing requests
  • Update the status of a task

Question 9: Correct answer

What is the reason to create a current user report?

  • The Current User filter shows which users are logged in
  • The Current User filter allows collaborators to see only the tasks they are assigned to
  • The Current User filter prevents anybody but the current user from editing it
  • The Current User filter allows them to see only the sheets they are shared to

Question 10: Correct answer

How can a user modify a report to get different results?

  • Apply conditional formatting to the report
  • Change the filter criteria
  • Add/delete rows from the report
  • Select Edit Report from the file menu

Question 11: Correct answer

Which of the following is a way to provide access to a form?

  • Email the form directly from Smartsheet
  • Share the Form with Editor - can share permission
  • Add the form to a workspace and share the workspace
  • Publish the Form as Read-Only Full

Question 12: Correct answer

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?

  • Hidden
  • Custom
  • Required
  • Branded

Question 13: Correct answer

What is the lowest permission level you need to edit data from a report?

  • Owner
  • Admin
  • Editor
  • Viewer

Question 14: Correct answer

Which feature in a sheet allows you to set criteria to only show certain rows while hiding all others?

  • Reports
  • Filters
  • Hide column
  • Conditional formatting

Question 15: Correct answer

What is the best approach to providing a collaborator viewer access to only a subset of data that is tracked on a sheet?

  • Publish a report and give them the link
  • Share them to both the report and the sheet
  • Share them to the report but not the sheet
  • Share them to a summary report

Question 16: Correct answer

When you create a new form for a sheet in Smartsheet, the form is automatically populated with fields based on which sheet element?

  • Primary column
  • Columns
  • Dropdown list
  • Rows