100% tevredenheidsgarantie Direct beschikbaar na je betaling Lees online óf als PDF Geen vaste maandelijkse kosten
logo-home
Eerder door jou gezocht
Eerder door jou gezocht
logo
Smartsheet Core Product Certification Exam (New 2023/ 2024 Update) Questions and Verified Answers| 100% Correct| Graded A €10,29
In winkelwagen
Snel navigeren naar
Voorbeeld
  2.  
  3. Smartsheet Certification
  4.  
  5. Smartsheet Certification

Tentamen (uitwerkingen)

Smartsheet Core Product Certification Exam (New 2023/ 2024 Update) Questions and Verified Answers| 100% Correct| Graded A

3 beoordelingen
 29 keer verkocht
  • Vak
  • Smartsheet Certification
  • Instelling
  • Smartsheet Certification

Smartsheet Core Product Certification Exam (New 2023/ 2024 Update) Questions and Verified Answers| 100% Correct| Graded A QUESTION John wants to have his health column display a red symbol if a task is past its due date. Which formula can he use? Answer: =IF([Due Date]@row < T...

[Meer zien]

Voorbeeld 3 van de 21  pagina's

Document informatie

  • 19 december 2023
  • 21
  • 2023/2024
  • Tentamen (uitwerkingen)
  • Vragen en antwoorden

Onderwerpen

  • smartsheet certification
  • smartsheet core product certification exam new 20
  • yoko created a report to show collaborators on he
  • ohn wants to have his health column display a red

Geschreven voor

  • Smartsheet Certification
  • Smartsheet Certification

3  beoordelingen

review-writer-avatar

Door: lindseymaloo10 • 6 maanden geleden

review-writer-avatar

Door: sherrygrimm • 6 maanden geleden

review-writer-avatar

Door: searcy404 • 6 maanden geleden

Verkoper

avatar-seller
ace_it

Ontvangen beoordelingen

Voorbeeld van de inhoud

Smartsheet Core Product Certification Exam
(New 2023/ 2024 Update) Questions and
Verified Answers| 100% Correct| Graded A

QUESTION
John wants to have his health column display a red symbol if a task is past its due date. Which
formula can he use?


Answer:
=IF([Due Date]@row < TODAY(), "Red")



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


Answer:
Parent row



QUESTION
Jennifer is building a sheet to calculate commissions for her sales team. They earn a fixed
percentage of each sale they make. She has entered the commission rate in a cell on her sheet.
Which formula can Jennifer copy and paste into each row to correctly calculate her team's
commissions?


Answer:
=SUM([Opportunity Value]@row * [Commission Rate]$1)



QUESTION
Which field type is available in a sheet summary?


Answer:
Contact List

,QUESTION
Olga added a field called "Budget Total" in their sheet summary. What is the syntax to reference
the "Budget Total" field in a formula?


Answer:
[Budget Total]#



QUESTION
What symbols must you use when referencing another sheet?


Answer:
{ } Braces



QUESTION
Marcos wrote a formula to check the box in a Complete checkbox column when the %
Complete is 100%. What is the recommended way to apply his formula to the rest of the
column?


Answer:
Convert it to a column formula



QUESTION
Yoko created a report to show collaborators on her project their assigned tasks. They have told
her that many tasks from different areas of the project plan look the same in the report. To solve
the problem, she wants to add the parent name to the row in the report." Which formula should
she use?


Answer:
=JOIN(ANCESTORS())

, QUESTION
What symbols must you place around a column name in a formula if the name includes a space,
special characters, or numbers?


Answer:
[ ] Square brackets



QUESTION
How do you reference the red ball in a symbol column in a formula?


Answer:
"Red"



QUESTION
Kai is building a sheet to track opportunities for his sales team. For each opportunity, the
salesperson enters their Region and the Opportunity Value. Kai wants to know the total value of
all opportunities in the Western region. Which formula should Kai use to add sales opportunities
for the Western region?


Answer:
=SUMIF(Region:Region, "Western", [Opportunity Value]:[Opportunity Value])



QUESTION
Sandra has an alert workflow that notifies a sales manager when an opportunity in their region is
Closed-Won. A manager for a different region learned of this and wants one for their
region.What is the most efficient way for Sandra to start the new workflow?


Answer:
Duplicate the existing workflow



QUESTION
Valentino created an alert to notify a contact in the Assigned To column if their task is past due
and incomplete. He realized that one of his external contractors did not receive the notification

Dit zijn jouw voordelen als je samenvattingen koopt bij Stuvia:

Bewezen kwaliteit door reviews

Bewezen kwaliteit door reviews

Studenten hebben al meer dan 850.000 samenvattingen beoordeeld. Zo weet jij zeker dat je de beste keuze maakt!

In een paar klikken geregeld

In een paar klikken geregeld

Geen gedoe — betaal gewoon eenmalig met iDeal, creditcard of je Stuvia-tegoed en je bent klaar. Geen abonnement nodig.

Direct to-the-point

Direct to-the-point

Studenten maken samenvattingen voor studenten. Dat betekent: actuele inhoud waar jij écht wat aan hebt. Geen overbodige details!

Veelgestelde vragen

Wat krijg ik als ik dit document koop?

Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.

Tevredenheidsgarantie: hoe werkt dat?

Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.

Van wie koop ik deze samenvatting?

Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper ace_it. Stuvia faciliteert de betaling aan de verkoper.

Zit ik meteen vast aan een abonnement?

Nee, je koopt alleen deze samenvatting voor €10,29. Je zit daarna nergens aan vast.

Is Stuvia te vertrouwen?

4,6 sterren op Google & Trustpilot (+1000 reviews)

Afgelopen 30 dagen zijn er 68175 samenvattingen verkocht

Opgericht in 2010, al 15 jaar dé plek om samenvattingen te kopen

Begin nu gratis
€10,29  29x  verkocht
  • (3)
In winkelwagen
Toegevoegd