- Study guides, Class notes & Summaries

Smartsheet Formulas 2023 Exam Questions with Correct Answers New Update (Verified A+ Pass)

-

12 pages

Written in 2025/2026

Grade A+

KeithAndrews

Formulas: What is absolute cell referencing? - ANSWERSAdd a $ in front of the column name, row number, or both and it will not change when moved, copied, or filled Formulas: What is relative cell referencing? - ANSWERSAs you copy, the formula will automatically change its respective field references 1. How do you calculate the sum of a range of cells in Smartsheet? - ANSWERS1. To calculate the sum of a range of cells in Smartsheet, you can use the SUM function. For example, if you want to ...

-

7 pages

Written in 2025/2026

Grade A

Brilliantscores1

Smartsheet Formulas Basics Quiz Questions with Correct Answers New Update (Verified A+ Pass)

-

7 pages

Written in 2025/2026

Grade A+

KeithAndrews

Smartsheet Formulas Basics Quiz Questions with Correct Answers New Update (Verified A+ Pass)

-

3 pages

Written in 2025/2026

Grade A+

KeithAndrews

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 rate in a cell on her sheet. Which formula can Jennifer copy ...

-

2 pages

Written in 2023/2024

Grade A+

ACADEMICMATERIALS

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 rate in a cell on her sheet. Which formula can...

-

3 pages

Written in 2023/2024

Grade A+

GRADEUNITS