Yoko created a report - Study guides, Class notes & Summaries

=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...

=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...

Which takes priority when a sheet has 2 conditional formatting rules? - Answer- The rule on the top Which program files can you import into Smartsheet to create a new sheet? - Answer- Excel What permission is required to hide and unhide columns? - Answer- Admin You are building a sheet to keep track of opportunities for your sales team. You want a column to show which of the 4 regions each opportunity is assigned to. Which column type would be best? - Answer- Dropdown (Single Select) ...

Which function can you use to add up numerical values? =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? =IF() Brainpower Read More 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 ca...

=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...

=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...

Smartsheet Formulas Basics Quiz Questions with correct Answers 2023 Which function can you use to add up numerical values? =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? =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 r...

Smartsheet Practice Questions with correct Answers 2023 Which takes priority when a sheet has 2 conditional formatting rules? The rule on the top Which program files can you import into Smartsheet to create a new sheet? Excel What permission is required to hide and unhide columns? Admin You are building a sheet to keep track of opportunities for your sales team. You want a column to show which of the 4 regions each opportunity is assigned to. Which column type would be b...

Smartsheet Formulas Basics Quiz 100% verified

Smartsheet Formulas Basics Quiz (From the Course) Answered Correctly!! Which function can you use to add up numerical values? =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? =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 ...