Smartsheet Certification Practice UPDATED ACTUAL Exam Questions and CORRECT Answers

Smartsheet Certification Practice UPDATED
ACTUAL Exam Questions and CORRECT
Answers
Which is used when writing a formula to automate a checking a box, raising a flag, or filling in
of a star?


a. 1
b. 100%
c. Return

d. Yes - CORRECT ANSWER - a. 1


(stats - either 1 or 0)


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?


a. Alerts
b. Format painter
c. Highlight changes

d. Conditional formatting - CORRECT ANSWER - d. conditional formatting


(can set condition that IF x is past due/at risk, THEN set y format to row)


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


a. Card
b. Gantt

, c. Calendar

d. Grid - CORRECT ANSWER - b. Gantt


(Gantt needs the start and finish columns to display the full timeline between those two dates)


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


a. Cell(s) in a report
b. Cell(s) in a sheet
c. Metric widget on a dashboard

d. Column names - CORRECT ANSWER - b. Cell(s) in a sheet


(only item in selection that holds active data that can be linked; reports and widgets are generated
from sheets so cannot link, column names do not contain the data, only its label)


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


a. First child row
b. Last child row
c. All child rows

d. Parent row - CORRECT ANSWER - d. Parent row


(all rows under a parent row are considered children rows)


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


a. IF()
b. CHILDREN()