01 Sheet Basics Quiz - bsharphd/Smartsheet_Core_App_Path GitHub Wiki

Question 1: Correct answer

What symbol notes the beginning of a formula?

  • =
  • [
  • (

Question 2: Correct answer

Which is used when writing a formula to automate checking a box, raising a flag, or filling in of a star?

  • 100%
  • Yes
  • Return
  • 1

Question 3: Correct answer

Which is one of the three column types that are required to enable Card View?

  • System Generated column
  • Contact List column
  • Text/Number column
  • Date column

Question 4: Correct answer

When adding a cell link to a sheet, which can be the source of the data?

  • Cell(s) in a sheet
  • Metric widget on a dashboard
  • Coulmn names
  • Cell(s) in a report

Question 5: Correct answer

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
  • Alerts
  • Format painter
  • Conditional formatting

Question 6: Correct 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?

Screenshot of Smartsheet. Four columns are included: Opportunity, Rep, Sales Stage, and Product. The first row reads "Sales Pipeline- West". The next row indented under that reads "Carl Jackson". Under that is indented six rows.

  • =COUNT(Product:Product)
  • =COUNT(Product5:Product10)
  • =COUNT(Product5,Product6,Product7,Product8,Product9,Product10)
  • =COUNT(CHILDREN())

Question 7: Correct answer

Which function can be used in conjunction with another function such as COUNT() to reference all the cells directly indented under a parent row?

  • PARENT()
  • CHILDREN()
  • IF()
  • RANGE()

Question 8: Correct answer

Scenario: 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.

Question: Which one of the options below would be the most efficient way for Juan to accomplish this?

  • 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.
  • Juan needs to build a report for each person on his team. From each of the reports, Juan would reassign tasks.
  • Juan needs to create and use a filter for each assignee and then return to the sheet to reassign tasks.

Question 9: Correct answer

Which column type would be best for visually representing the status of a row item?

  • Symbols column
  • Dropdown List column
  • Text/Number column
  • Emoji column

Question 10: Correct answer

What level of hierarchy should the CHILDREN() function should be placed on?

  • All child rows
  • Last child row
  • First child row
  • Parent row

Question 11: Correct answer

Which column type would be best for tracking when a row was added to a sheet?

  • Date column
  • Auto-Number column
  • Created by System column
  • Created (Date) System column

Question 12: Correct answer

Which feature would you use to change the visual styling of a sheet based on an identified trigger?

  • Format painter
  • Highlighting tool
  • Function
  • Conditional formatting

Question 13: Correct answer

Which conditional formatting rule takes priority in this situation?

  • Conditional formatting menu depicting two conditional formatting rules
  • The one at the bottom
  • The one on the top
  • Both
  • None

Question 14: Correct answer

Which formula would you use to add up sales opportunities for the Western region?

  • =COUNTIF(Region:Region, "Western", [Opportunity Value]:[Opportunity Value])
  • =SUMIF(Region:Region, "Western", [Opportunity Value]:[Opportunity Value])
  • =COUNTIF( [Opportunity Value]:[Opportunity Value], Region:Region, "Western")
  • =SUMIF([Opportunity Value]:[Opportunity Value], Region:Region, "Western")

Question 15: Correct answer

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?

  • #Budget Total
  • [Budget Total]#
  • Budget Total#
  • #[Budget Total]

Question 16: Correct answer

What symbols must be placed around a column name in a formula if the name includes a space, special characters, or numbers?

  • { } Curly brackets
  • ( ) Parentheses
  • < > Angle brackets
  • [ ] Square brackets

Question 17: Correct answer

When hierarchy is applied to a row, where will it be visible?

  • Row action indicators column
  • Primary column
  • Leftmost column in grid view
  • System column

Question 18: Correct answer

Which column type would be best for assigning tasks to individual team members?

  • Dropdown List column
  • Created by System column
  • Contact List column
  • Text/Number column

Question 19: Correct answer

Which view must include two date columns in order to be displayed?

  • Calendar
  • Card
  • Gantt
  • Grid