100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
SMARTSHEET CORE PRODUCT CERTIFICATION YEAR 2024/2025 ACCURATE CURRENTLY TESTING EXAM VERSIONS WITH ACTUAL QUESTIONS AND DETAILED ANSWERS EITH A STUDY GUIDE / EXPORT VERIFIED FOR GURANTEED PASS/ LATEST UPDATE . $24.49   Add to cart

Exam (elaborations)

SMARTSHEET CORE PRODUCT CERTIFICATION YEAR 2024/2025 ACCURATE CURRENTLY TESTING EXAM VERSIONS WITH ACTUAL QUESTIONS AND DETAILED ANSWERS EITH A STUDY GUIDE / EXPORT VERIFIED FOR GURANTEED PASS/ LATEST UPDATE .

 7 views  0 purchase
  • Course
  • SMARTSHEET CORE PRODUCT CERTIFICATION
  • Institution
  • SMARTSHEET CORE PRODUCT CERTIFICATION

SMARTSHEET CORE PRODUCT CERTIFICATION YEAR 2024/2025 ACCURATE CURRENTLY TESTING EXAM VERSIONS WITH ACTUAL QUESTIONS AND DETAILED ANSWERS EITH A STUDY GUIDE / EXPORT VERIFIED FOR GURANTEED PASS/ LATEST UPDATE .

Preview 4 out of 34  pages

  • September 6, 2024
  • 34
  • 2024/2025
  • Exam (elaborations)
  • Questions & answers
  • SMARTSHEET CORE PRODUCT CERTIFICATION
  • SMARTSHEET CORE PRODUCT CERTIFICATION
avatar-seller
DrMedinaReed
SMARTSHEET CORE PRODUCT CERTIFICATION YEAR 2024/2025 /
ACCURATE CURRENTLY TESTING EXAM VERSIONS WITH ACTUAL
QUESTIONS AND DETAILED ANSWERS EITH A STUDY GUIDE / EXPORT
VERIFIED FOR GURANTEED PASS/ LATEST UPDATE .

The sponsor of a project that you are managing wants an emailed update on the status of the
project before their weekly meeting.
How can you ensure they have an up-to-date view of the project sheet in their inbox each week?
- CORRECT ANSWER Schedule the sheet to send weekly as an attachment


How can you provide access to a form? - CORRECT ANSWER Email the form directly from
Smartsheet


What is the lowest permission you need to create a form? - CORRECT ANSWER Admin


Which can you customize with a color of your choice? - CORRECT ANSWER Background


Pamela is creating a form to collect requests for her marketing creative services team. In order to
complete any request, she needs to know which cost center to bill for the work. How can she
ensure that each request will contain the cost center? - CORRECT ANSWER Make the field
required


Which column records when a form was submitted? - CORRECT ANSWER Created (Date)


What information is tracked in the Attachments Summary? - CORRECT ANSWER File name
Date Attached
Name of the individual who attached the files


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
characters or number?

,{ } Curly brackets
[ ] Square brackets
< > Angle brackets
( ) Parentheses - CORRECT ANSWER [ ] 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 - CORRECT ANSWER personal message


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


Card
Gantt
Calendar
Grid - CORRECT ANSWER 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 with a single cell. You understand
that it is 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? - CORRECT 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 drop down list column options in Jen's sheet. What permission level
would her coworker need for Jen's sheet? - CORRECT ANSWER Admin

,When creating a form, using a _____ field, allows you to input a default. Slur into a column on a
sheet without requiring the form submitter to create it. - CORRECT ANSWER Hidden


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


ANCESTORS()
CHILDREN()
PARENT()
INDEX() - CORRECT ANSWER CHILDREN()


Juan is currently managing the development of a new project. 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? - CORRECT ANSWER 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 - CORRECT ANSWER Grid and Gantt


You can share a collaborator to which two of the following?


Folder
Workspace
Resource View

, Sheet - CORRECT ANSWER Workplace and Sheet


Which collaboration feature allows the receipt to make a one time change to your sheet without
sharing them as a collaborator to the sheet? - CORRECT ANSWER Create proofs ??


Jason is managing a new project and created a sheet to track its status. The project charter was
just approved by his stakeholders. It is a PDF document.
What is the recommended way to include it in Smartsheet? - CORRECT ANSWER Attach the
file to the sheet


How can you make sure that a specific collaborator receives a notification about a comment that
you make? - CORRECT ANSWER Mention them with the @ symbol in the comment


Shawn is managing a project that includes a subcontractor. His sheet contains sensitive budget
data that he does not want the subcontractor to view.
How can Shawn have the subcontractor make updates to his project sheet? - CORRECT
ANSWER Send an update request


Maria manages requests for a marketing shared services team. She has separate sheets to track
new requests, projects that are in progress, and archived requests.
What is the recommended way to share these assets with her team? - CORRECT ANSWER Put
them in a workspace


You created a workspace to organize a program you manage. Inez told you that she has a few
sheets to add to the workspace.
What permission does she need for her to be able to move these sheets into your workspace? -
CORRECT ANSWER Admin


After returning from a week of vacation, you want to see what changes have been made to your
sheet.
How can you see all the cells that have changed? - CORRECT ANSWER Highlight changes

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

Will I be stuck with a subscription?

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

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

72841 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
$24.49
  • (0)
  Add to cart