100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
SMARTSHEET CERTIFICATION EXAM 2 VERSIONS $12.49   Add to cart
Quickly navigate to
Preview
  2.  
  3. SMARTSHEET
  4.  
  5. SMARTSHEET

Exam (elaborations)

SMARTSHEET CERTIFICATION EXAM 2 VERSIONS

1 review
 11 views  0 purchase
  • Course
  • SMARTSHEET
  • Institution
  • SMARTSHEET

SMARTSHEET CERTIFICATION EXAM 2 VERSIONS | ACCURATE AND VERIFIED REAL EXAM CONTAINS 65 QUESTIONS AND ANSWERS RECENTLY TESTED EXAMS | VERIFIED FOR GUARANTEED PASS | LATEST UPDATE 2023/2024

Preview 3 out of 26  pages

Document information

  • July 9, 2024
  • 26
  • 2023/2024
  • Exam (elaborations)
  • Questions & answers

Subjects

  • smartsheet
  • certification exam 2
  • real exam
  • recently tested exams
  • verified

Written for

  • SMARTSHEET
All documents for this subject (250)

1  review

review-writer-avatar

By: RegisteredNurse • 3 months ago

Very Informative, detailed and timely, I passed, thank you very much

Seller

avatar-seller
DrBellaPhD

Reviews received

Content preview

SMARTSHEET CERTIFICATION EXAM 2 VERSIONS |
ACCURATE AND VERIFIED REAL EXAM CONTAINS 65
QUESTIONS AND ANSWERS RECENTLY TESTED EXAMS |
VERIFIED FOR GUARANTEED PASS | LATEST UPDATE
2023/2024
Changes in cell formatting can be used to capture the attention of a user. Which of the following
features allows collaborators to see updates since they last viewed the sheet?

Conditional formatting
Format painter
Symbol column type
Highlight changes
Highlight changes
What information is tracked in the Attachments Summary? (select the three that apply)

File name
Date attached
Name of the individual who attached the file
Number of downloads
File name
Date attached
Name of the individual who attached the file
When entering formulas in Smartsheet, cell references use the syntax of column name and row
number. What symbol must be placed around a column name when it includes a space, special
character, or number?

{ } Curly brackets
[ ] Square brackets
< > Angle brackets
( ) Parentheses
[ ] Square brackets
When adding a new collaborator to a sheet or workspace, what should be customized to help the
new collaborator understand why they are being added and how they should use the information?

Collaborators
Permissions
Personal message
Default View

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

Card
Gantt
Calendar
Grid
Gantt
You are using Smartsheet to plan, track and manage a project. In creating your sheet, you are
assigning tasks to collaborators. You need to make a decision on whether to use multiple single
contact list columns or enable multiple contacts to be assigned within a single cell. You
understand that it best to enable multiple contacts to be assigned within a single cell when
multiple people are working on the same task. In what scenario is it best to use multiple contact
list columns?

When you want to create a filter for each individual
When some individuals are inside your team's account and others are not
When you want to pull a report from a sheet
When the individuals have different roles related to a task
When the individuals have different roles related to a task
Jen has a project sheet that includes a dropdown list column. Her coworker needs to add
additional options to the dropdown list column options in Jen's sheet. What permission level
would her coworker need for Jen's sheet?

Editor- can't share
Viewer
Admin
Editor- can share
Admin
When creating a form, using a ___________ field, allows you to input a default value into a
column on a sheet without requiring the form submitter to create it.

Branded
Hidden
Custom
Required
Hidden

, Which function leverages sheet hierarchy to reference the range of rows that are indented below
another row?

ANCESTORS()
CHILDREN()
PARENT()
INDEX()
Children()
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. Which of the options below would be the most efficient way for Juan to
accomplish this?

Juan needs to create and use a filter for each assignee and then return to the sheet to reassign
tasks.
Juan needs to publish the sheet to his team and allow them to email suggestions on task
reassignment.
Juan needs to utilize card view to view by the assigned to contact column. He could then view
and reassign 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 utilize card view to view by the assigned to contact column. He could then view
and reassign accordingly.
The report widget allows you to display a report in which two of the following views:

Card
Grid
Calendar
Gantt
Grid and Gantt
You can share a collaborator to which two of the following?

Folder
Workspace
Resource View
Sheet
Workspace and Sheet
Which collaboration feature allows the recipient to make a one time change to your sheet without
sharing them as a collaborator to the sheet?

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

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

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

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 DrBellaPhD. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $12.49. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

71184 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$12.49
  • (1)
  Add to cart