SMARTSHEET CERTIFICATION EXAM
NEWEST EXAM | QUESTIONS AND
CORRECT ANSWERS WITH
EXPLANATIONS | LATEST VERSION |
GRADED A+ | VERIFIED ANSWERS
Which column type would be best for tracking when a row was added to a
sheet?
a. Date column
b. Created (Date) System column
c. Created by System column
d. Auto-Number ---------CORRECT ANSWER-----------------b. Created (Date)
System column
(standard date column may be used to refer to the date of the data for
that row, not necessarily when the row was created)
When hierarchy is applied to a row, where will it be visible?
a. Row action indicators column
b. Primary column
c. Leftmost column in grid view
d. System column ---------CORRECT ANSWER-----------------b. Primary
column
(Indents are displayed only in a sheet's Primary Column; however, the
relationship is applied to the entire row)
Which column type would be best for visually representing the status of a
row item?
a. Symbol column
,b. Dropdown List column
c. Text/Number column
d. System Generated column ---------CORRECT ANSWER-----------------a.
Symbol column
(dropdown list and text/number only provides values for a status, not
determining the status itself)
Scenario: Juan is currently managing the development of a new product.
He has a team of four individuals with whom he assigned 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?
a. Juan needs to *utilize Card View* to view tasks by the "assigned to"
contact column. He could then reassign tasks accordingly.
b. Juan needs to *build a report* for each person on his team. From each of
the reports, Juan would reassign tasks
c. Juan needs to *create and use a filter* for each assignee and then return
to the sheet to reassign tasks
d. Juan needs to publish the sheet to his team and allow them to email
ideas on how tasks should be reassigned. ---------CORRECT ANSWER-----
------------a. utilize Card View
(every other option involved multiple steps to update any
information/reassign tasks; Card View developed to see assignees at
a glance and to move data accordingly).
Which is one of the three column types that are required to enable Card
View?
a. Contact List column
,b. Text/Number column
c. Date column
d. System Generated column ---------CORRECT ANSWER-----------------a.
Contact List column
(Card View is driven by the *drop-down list, symbol, and contact list*
column types that offer multiple selections. These different selection
options create the lanes in which to drop your cards)
What symbols must be placed around a column name in a formula if the
name includes a space, special characters, or numbers?
a. () Parenthesis
b. [] Square brackets
c. <> Angle brackets
d. {} Curly brackets ---------CORRECT ANSWER-----------------b. [] Square
brackets
(helps formula recognize full column name with spaces/special
characters/numbers as one full name to keep formula parseable)
Which column type would be best for assigning tasks to individual team
members?
a. Created by System column
b. Dropdown List column
c. Contact List column
d. Text/Number column ---------CORRECT ANSWER-----------------c.
Contact List column
(Contact List enables Resource Views to also capture the tasks
assigned using this column type)
, Which feature would you use to change the visual styling of a sheet on an
identified trigger?
a. Highlighting tool
b. Function
c. Format painter
d. Conditional formatting ---------CORRECT ANSWER-----------------d.
Conditional formatting
(identified trigger = condition prescribed to format/styling)
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?
a. Budget Total#
b. #[Budget Total]
c. #Budget Total
d. [Budget Total}# ---------CORRECT ANSWER-----------------d. [Budget
Total]#
(helps formula recognize full column name with spaces/special
characters/numbers as one full name to keep formula parseable)
What symbol notes the beginning of a formula?
a. [
b. =
c. (
d. * ---------CORRECT ANSWER-----------------b. =
(=COUNTIF, =SUM, etc.)
Which formula would you use to add up sales opportunities for the Western
region?
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller nevilletadayo. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $22.99. You're not tied to anything after your purchase.
