Exam (elaborations)
Smartsheet Formulas Basics UPDATED Exam Questions and CORRECT Answers
Rating
Sold
-
Pages
6
Grade
A+
Uploaded on
07-06-2024
Written in
2023/2024
=SUM() - ANS Which function can you use to add up numerical values? =IF() - ANS 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) - ANS 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? {} Braces - ANS What symbols must you use when referencing another sheet?
Show more
Read less
Institution
Smartsheet
Course
Smartsheet
Whoops! We can’t load your doc right now. Try again or contact support.
Written for
- Institution
- Smartsheet
- Course
- Smartsheet
Document information
- Uploaded on
- June 7, 2024
- Number of pages
- 6
- Written in
- 2023/2024
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
- smartsheet formulas
- smartsheet
-
smartsheet formulas basics
$7.99
Get access to the full document:
100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached
Also available in package deal
Package deal
Smartsheet Bundled Exam Package with Correct Answers
6
2024
$ 48.94
More info
