Exam (elaborations)
Smartsheet Formulas Basics Questions with correct answers
Rating
Sold
-
Pages
3
Grade
A+
Uploaded on
16-07-2023
Written in
2022/2023
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 and paste into each row to correctly calculate her team's commissions? Answer =SUM([Opportunity Value]@row * [Commission Rate]$1) What symbols must you use when referencing another sheet? Answer {} Braces
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
- July 16, 2023
- Number of pages
- 3
- Written in
- 2022/2023
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
smartsheet formulas basics questions with correct
$11.49
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 Certification Bundle Set
5
2023
$ 71.45
More info
