- Study guides, Class notes & Summaries

Smartsheet Formulas Basics exam 2024 Which function can you use to add up numerical values? - correct answer =SUM() Tricia has a task sheet where she is tracking both % Complete and Status. Which function can she use to change the symbol in the Status column based on the value in the % Complete column? - correct answer =IF() 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 rat...

-

3 pages

Written in 2023/2024

Grade A+

RapidPassAcademy

Smartsheet Formulas Basics Exam UPDATED ACTUAL QUESTIONS AND CORRECT ANSWERS

-

3 pages

Written in 2024/2025

Grade A+

STANFORDTOPGRADES

Which function can you use to add up numerical values? - ANSWERS=SUM() Tricia has a task sheet where she is tracking both % Complete and Status. Which function can she use to change the symbol in the Status column based on the value in the % Complete column? - ANSWERS=IF() 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 a...

-

2 pages

Written in 2025/2026

Grade A

Brilliantscores1

=SUM() – ANSWERS Which function can you use to add up numerical values? =IF() – ANSWERS Tricia has a task sheet where she is tracking both % Complete and Status. Which function can she use to change the symbol in the Status column based on the value in the % Complete column? =SUM([Opportunity Value]@row * [Commission Rate]$1) - ANSWERSJennifer 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 c...

-

4 pages

Written in 2025/2026

Grade A

Brilliantscores1

Smartsheet Formulas Basics Package Bundle

-

5 items

Registerednurse

Smartsheet Formulas exam with complete solutions

-

8 pages

Written in 2025/2026

Grade A+

Registerednurse

Smartsheet Formulas Basics Quiz With Correct Answers

-

3 pages

Written in 2025/2026

Grade A+

Registerednurse

Smartsheet Formulas Basics Quiz With Complete Solutions

-

5 pages

Written in 2025/2026

Grade A+

Registerednurse

Smartsheet Practice Exam With Full Pack Solutions

-

6 pages

Written in 2025/2026

Grade A+

Registerednurse

PM Smartsheets exam with verified answers

-

10 pages

Written in 2025/2026

Grade A+

Registerednurse

Quiz 4 Writing Formulas in Smartsheet exam graded A+

-

8 pages

Written in 2025/2026

Grade A+

Registerednurse

Smartsheet Core Product Certification

-

33 pages

Written in 2025/2026

Grade A+

Registerednurse

Writing Formulas In Smartsheet Quiz With Accurate Solutions

-

4 pages

Written in 2025/2026

Grade A+

Registerednurse

Smartsheet Formulas Basics Exam UPDATED Study Guide ACTUAL QUESTIONS AND CORRECT ANSWERS =SUM() - CORRECT ANSWER values? =IF() - CORRECT ANSWER Which function can you use to add up numerical Tricia has a task sheet where she is tracking both % Complete and Status. Which function can she use to change the symbol in the Status column based on the value in the % Complete column? =SUM([Opportunity Value]@row * [Commission Rate]$1) - CORRECT ANSWER Jennifer is buildin...

-

6 pages

Written in 2024/2025

Grade A+

STANFORDTOPGRADES

Smartsheet Formulas Basics Questions And Answers Latest Top Score. Which function can you use to add up numerical values? - correct answer. =SUM() Tricia has a task sheet where she is tracking both % Complete and Status. Which function can she use to change the symbol in the Status column based on the value in the % Complete column? - correct answer. =IF() Jennifer is building a sheet to calculate commissions for her sales team. They earn a fixed percentage of each...

-

3 pages

Written in 2024/2025

Grade A+

Lectsadh

Smartsheet Formulas Basics Quiz with Verified Answers Guillermo owns a project tracking sheet. His sheet uses a hierarchy with all tasks being children of a phase. He created a filter to help his team see only their tasks. They are reporting that it is difficult to understand the phase as there are tasks with the same name in multiple phases. To help them understand the phase, he has added a column titled "Phase." What function can he combine with JOIN() to show this information? =AN...

-

4 pages

Written in 2023/2024

Grade A+

BrilliantScores

Smartsheet Formulas Basics Quiz with Complete Solutions (1) Which function can you use to add up numerical values? - Answer-=SUM() Tricia has a task sheet where she is tracking both % Complete and Status. Which function can she use to change the symbol in the Status column based on the value in the % Complete column? - Answer-=IF() 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...

-

2 pages

Written in 2023/2024

Grade A+

wisdompoint

Smartsheet Formulas Basics Quiz with Complete Solutions Which function can you use to add up numerical values? - Answer-=SUM() Tricia has a task sheet where she is tracking both % Complete and Status. Which function can she use to change the symbol in the Status column based on the value in the % Complete column? - Answer-=IF() 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 rat...

-

2 pages

Written in 2023/2024

Grade A+

shiifridoc

Smartsheet Formulas Basics Quiz with Complete Solutions Which function can you use to add up numerical values? - Answer-=SUM() Tricia has a task sheet where she is tracking both % Complete and Status. Which function can she use to change the symbol in the Status column based on the value in the % Complete column? - Answer-=IF() 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 ra...

-

2 pages

Written in 2023/2024

Grade A+

Scholarsstudyguide

=SUM() - Answer- Which function can you use to add up numerical values? =IF() - Answer- Tricia has a task sheet where she is tracking both % Complete and Status. Which function can she use to change the symbol in the Status column based on the value in the % Complete column? =SUM([Opportunity Value]@row * [Commission Rate]$1) - Answer- 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 commissio...

-

4 pages

Written in 2023/2024

Grade A+

FLYINGCOLORS