• Falsches Dokument? Kostenlos tauschen
  • Geschrieben von Student*innen, die bestanden haben
  • Sofort verfügbar nach Zahlung
  • Online lesen oder als PDF
Verkaufen
Wo studierst du
Deine Sprache
Document preview thumbnail
Vorschau 4 aus 33 Seiten
Prüfung

Smartsheet Core Product Certification

Document preview thumbnail
Vorschau 4 aus 33 Seiten

Smartsheet Core Product Certification

Inhaltsvorschau

SMARTSHEET CORE PRODUCT CERTIFICATION EXAM
100% SOLVED




1. Xiao zis ztrying zto zcreate za zmetrics zsheet zthat zwill zcalculate zthe
zhealth zof zall zthe z current z ongoing z campaigns z in z her z marketing

z portfolio. z She z has z a z Health

column zin zeach zcampaign's zsheet zand zis zusing zthe zSymbol zcolumn
ztype zto zindi- zcate zred, zyellow, zor zgreen zfor zthe zhealth zstatus. zWhich

zof zthe zfollowing zformulas zshould zXiao zuse zin zher zmetrics zsheet zto

zcalculate zhow zmany zcampaigns zhave za zhealth z status z of z red?:

z =COUNTIF({Portfolio zSummary zRollup zSheet zRange z1}, z"Red") zis zcorrect. zThis zformula zuses

zthe zCOUNTIF zfunction zto zcount zthe znumber zof zcampaigns zwith za zhealth zstatus zof zred zin za zparticular

zportfolio.

Formulas zthat zare zlooking zat zthe zSymbol zcolumn ztype, zsuch zas zthe zHealth zcolumn zin zthis zscenario,
zrequire zeach zsymbol's zcolor zto zbe zcapitalized.

2. Danielle z would z like z to z have z her z entire z department z review z a
1 z/
z33

,z report z weekly. zAdditionally, z even z though z there z are z a z few
z associates z who z don't z have z access z to zSmartsheet, zDanielle zwants

zto zensure zthat zeveryone zhas zaccess zto zan zup-to-date zversion z of z the

z report z at z any z time. z What z is z the z recommended z action z for

z Danielle zto ztake?: zSend zthe zreport zas zan zattachment zas za zweekly zrecurrence zand zinclude zthe

zpublished zlink zin zthe zbody zof zthe zmessage zis zcorrect. zReports zcan zbe zsent zto zany zemail zaddress zas

zan zattachment zon za zweekly zbasis zwithout zhaving zto zgive zanyone zaccess zto zthe zreport zitself. zPublishing

zthe zreport zand zincluding zthe zlink zin zthe zbody zof zthe zweekly znotification z allows zanyone zto zaccess zthe

zup-to-date-version zof zthe zreport zat zany ztime.

3. Celina zis zlooking zto zlock zin za zcolumn zvalue zin zthe zfollowing
zformula, zso zthat zshe zcould zapply zthe zformula zto zany zrow zand

zit zwould zstill zreference zthe zsame zcolumn:

=IF([%Complete]@row=1, z "Green", z "Yellow")
What zshould zCelina zadd zto zthe zformula?: z=IF($[%Complete]@row=1, z"Green",
z"Yellow") zis zcorrect. zThe z$ zis zan zabsolute zreference. zIn zthis zcase, zthe zabsolute zreference zshould

zappear zbefore zthe zcolumn z%Complete, zwhich zwill ztell zthe zformula zto zalways zreference zthe z

%Complete zcolumn zregardless zof zthe zcell zthe zformula zis zin.
4. Ken zis zbuilding zan zevent zschedule. zHe zwould zlike zeveryone zto
zsimultaneously zsee zthe zwhole zschedule zat zone ztime zbut zalso

zallow zeach zteam zmember zto zfocus zon ztheir zown ztasks

zimmediately.

Which zis zthe zmost zefficient zway zto zaccomplish zthis?: zCreate zconditional
zformatting zto zassign za zcolor zto zeach zteam zmember zis zcorrect. zIf zthe zsheet zhas zan zAssigned

zTo zcolumn zthat zlists zwhich zteam zmember zhas zbeen zassigned zto zeach ztask, zKen zcan zuse zconditional

zformatting zto zassociate zeach zteammate's zname zto za zcolor. zThis zway zeach zteammate zcan zsee zthe

zwhole zschedule zwhile zonly zfocusing zon ztheir zassigned zcolor.




2 z/
z33

,5. Carson z is z creating z a z form z to z collect z requests z for z IT z equipment
z and z software zsupport z from z employees z at z their z organization. z The

z source z sheet z has z the z fol- zlowing z columns: z Request z Type,

z Equipment, z Date z Needed, z Software, z and z Issue. zIf z an z employee

z selects z IT z Equipment z from z the z Request z Type z field, z they z need z to

zsubmit z answers z for z the z Equipment z and z Date z Needed z columns. z If

z they z select z IT zSoftware z Support z from z the z Request z Type z field,

z they z need z to z submit z answers z for z the z Software z and z Issue z fields.

z What z is z the z recommended z way z for z Carson z to zset zup ztheir zform

zto zensure zthey zcollect zthe zresponses zthey zneed?: zAdd zform zlogic zto zthe

zRequest zType zfield zis zcorrect. zCarson zshould zadd ztwo zrules zto zthe zlogic zfor zthe zRequest zType zfield:

6. Mary zis zsetting zup za zproject zschedule zwith zpredecessors zand
zhas zcreated zan zOverdue zcolumn zwith za zformula zthat zcalculates

zhow zmany zdays za ztask zis zoverdue. zNow zshe zwants zto zvisualize

zthe zseverity zof zthe zdelay, zdepending zon

how z many z days z a z task z is z overdue. z What z is z the z most z efficient
z way z to z accomplish zthis?: zCreate zconditional zformatting zrules zthat zassign za zcolor zto za zrow

zbased zon zhow zmany zdays za ztask zis zoverdue zis zcorrect. zCreating zconditional zformatting zrules zallows

zMary zto zassign za zditterent zcolor zfor zditterent zranges zof zdays zthat zeach ztask zis zoverdue.

7. Benjy z wants z his z associates z to z be z able z to z update z the z status z of
z their z tasks z on z a zreport z he z has z built. z He z also z wants z this

z updated z information z to z appear z on z the z underlying z sheets. z What

z does z Benjy z need z to z do z to z ensure z his z associates z can zupdate zboth

zthe zreport zand zthe zunderlying zsheets?: zGrant zall zassociates zEditor zor

zhigher zpermissions zon zthe zreport zand zthe zunderlying zsheets zis zcorrect. zUsers zmust zhave zat zleast

zEditor zpermissions zon zboth zthe zreport zand zthe zsource zsheet(s) zto zedit zinfo zin za zreport, zwhich zwill

zthen zpopulate zback zto zthe zsource zsheets.

8. Juan z is z looking z to z automate z the z symbols z that z are z produced z in
z his z Health zcolumn. z He z applies z a z nested z IF z formula, z but z the

z formula z is z returning z an z #UN- zPARSEABLE zresponse. zWhat zis zmost

zlikely zthe zcause zof zthe zerror zmessage?: zThe zformula zcontains za zmisspelling,

zuses zthe zwrong zcase zfor zcolumn znames, zor zmisapplies zquotation zmarks. zis zcorrect.

3 z/
z33

, An z#UNPARSEABLE zerror zis zdisplayed zwhen zthe zformula zhas za zproblem zwhich zprevents zit zfrom
zbeing zparsed zand zinterpreted. zThis zcan zhappen zfor zmany zreasons, zsuch zas zmisspelling, zincomplete

zoperators, zusing zthe zwrong zcase zfor za zcolumn zname, zor zusing zsingle zquotes zinstead zof zdouble

zquotes.

9. Benjamin z is z creating z an z IF z formula z to z display z specific z Health
z symbols z based zon z conditions z in z his z sheet. z When z a z task z has z a

z value z of z 100% z in z the z % z Complete zcolumn, z he z wants z to z show z the

z green z symbol. z He z is z sure z he z typed z in z the z correct




4 z/
z33

Dokument Information

Hochgeladen auf
20. september 2025
Anzahl der Seiten
33
geschrieben in
2025/2026
Typ
Prüfung
Enthält
Fragen & antworten
14,03 €

Falsches Dokument? Kostenlos tauschen Innerhalb von 14 Tagen nach dem Kauf und vor dem Herunterladen kannst du ein anderes Dokument wählen. Du kannst den Betrag einfach neu ausgeben.
Geschrieben von Student*innen, die bestanden haben
Sofort verfügbar nach Zahlung
Online lesen oder als PDF

Seller avatar
Bewertungen des Ansehens basieren auf der Anzahl der Dokumente, die ein Verkäufer gegen eine Gebühr verkauft hat, und den Bewertungen, die er für diese Dokumente erhalten hat. Es gibt drei Stufen: Bronze, Silber und Gold. Je besser das Ansehen eines Verkäufers ist, desto mehr kannst du dich auf die Qualität der Arbeiten verlassen.
Registerednurse
2,0
(4)
Verkauft
39
Anhänger
3
Sachen
6083
Zuletzt verkauft
1 Jahren vor




Warum sich Studierende für Stuvia entscheiden

on Mitstudent*innen erstellt, durch Bewertungen verifiziert

Geschrieben von Student*innen, die bestanden haben und bewertet von anderen, die diese Studiendokumente verwendet haben.

Nicht zufrieden? Wähle ein anderes Dokument

Kein Problem! Du kannst direkt ein anderes Dokument wählen, das besser zu dem passt, was du suchst.

Bezahle wie du möchtest, fange sofort an zu lernen

Kein Abonnement, keine Verpflichtungen. Bezahle wie gewohnt per Kreditkarte oder Sofort und lade dein PDF-Dokument sofort herunter.

Student with book image

“Gekauft, heruntergeladen und bestanden. So einfach kann es sein.”

Alisha Student

Arbeitest du an deiner Quellenangabe?

Erstelle korrekte Quellenangaben in APA, MLA und Harvard mit unserem kostenlosen Zitiergenerator.

Arbeitest du an deiner Quellenangabe?

Häufig gestellte Fragen