Computer Science > EXAM > Smartsheet Formulas Basics Quiz (Latest 2023 / 2024) Questions and Answers Included (All)
Smartsheet Formulas Basics Quiz (Latest 2023 / 2024) Questions and Answers Included
Document Content and Description Below
1. Which function can you use to add up numerical values? ANS: =SUM() 2. 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? ANS: =IF() 3. 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? ANS: - =SUM([Opportunity Value]@row * [Commission Rate]$1) 4. What symbols must you use when referencing another sheet? ANS: {} Braces 5. How do you reference the red ball in a symbol column in a formula? ANS: "Red" 6. Reginald is managing requests for his IT team using a sheet with a form. Employees can request the completion date in the "Date Need By" column.The team member assigned to the work enters a date in the "Estimated Completion [Show More]
Last updated: 1 year ago
Preview 1 out of 8 pages
Buy this document to get the full access instantly
Instant Download Access after purchase
Buy NowInstant download
We Accept:
Reviews( 0 )
$9.00
Can't find what you want? Try our AI powered Search
Document information
Connected school, study & course
About the document
Uploaded On
Apr 21, 2024
Number of pages
8
Written in
All
Additional information
This document has been written for:
Uploaded
Apr 21, 2024
Downloads
0
Views
39
