Exam (elaborations)
SMARTSHEET PRACTICE EXAM QUESTIONS AND ANSWERS 100 % PASS SOLUTION A+ GRADE
- Course
- Institution
SMARTSHEET PRACTICE EXAM QUESTIONS AND ANSWERS 100 % PASS SOLUTION A+ GRADE
[Show more]
Content preview
SMARTSHEET PRACTICE EXAM 2024-2025 QUESTIONS ANDANSWERS 100 % PASS SOLUTION A+ GRADE
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 - ANSWER- 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 - ANSWER-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 - ANSWER-Hidden
Which function leverages sheet hierarchy to reference the range of rows that are indented
below another row?
ANCESTORS() CHILDREN() PARENT()
INDEX() - ANSWER-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.` - ANSWER-Juan needs to utilize card view to view by the assigned to
contact column. He could then view and reassign accordingly.
What can be added to a dashboard to help users understand the data on a dashboard? -
ANSWER-Text labels
Which option would allow someone to view a report if they are not shared to the underlying
sheet(s)? - ANSWER-Add the report to a dashboard by using the Report Widget
Which file type cannot be uploaded using the image widget? - ANSWER- PDF
Which two views of a row report can be displayed on a dashboard using the report widget? -
ANSWER-Grid, Gantt
, What is the default label for the data in a metric widget? - ANSWER- Column name
Which dashboard widget type would be best to show a live updating budget number of a
project? - ANSWER-Metric
How is embedding a form on a dashboard via the web content widget effective? - ANSWER-It
allows an individual to complete a form submission without leaving the dashboard
Which widget behavior will allow the user to open the underlying sheet or report? -
ANSWER-Open the data sou
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? - ANSWER-
=COUNT(CHILDREN())
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? - ANSWER-[Budget Total]#
When adding a cell link to a sheet, which can be the source of the data? - ANSWER-Cell(s) in a
sheet
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? - ANSWER-
Conditional formatting
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 dennohz2000. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
79373 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now