Smartsheet Formulas Basics Questions with correct answers
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
Geschreven voor
- Instelling
- Smartsheet
- Vak
- Smartsheet
Documentinformatie
- Geüpload op
- 16 juli 2023
- Aantal pagina's
- 3
- Geschreven in
- 2022/2023
- Type
- Tentamen (uitwerkingen)
- Bevat
- Vragen en antwoorden
Onderwerpen
-
smartsheet formulas basics questions with correct
Ook beschikbaar in voordeelbundel