Smartsheet Training
Presentation
•
Mathematics
•
Professional Development
•
Easy
Abigail Eval
Used 13+ times
FREE Resource
4 Slides • 17 Questions
1
2
Multiple Choice
Formula in "Remarks" column:
=IF(Status3 = "red", "at risk", "on-time")
What will be the result?
3
Multiple Choice
Formula in "Delivery Charge" column:
=IF([Delivered?]5 = true, "paid", "pending")
What will be the result?
4
Multiple Choice
Formula in "Status" column:
=IF([Order Date]2 < TODAY(), "Red", IF([Order Date]2 > TODAY(), "Yellow", IF([Order Date]2 = TODAY(), "Green")))
Note: "Date today" is Nov 29. What will be the result?
5
Open Ended
Faulty row: [Approval Status]82
The task is approved but the approval status column shows that is for revision. How to fix it?
6
Open Ended
Faulty row: [Submission Status]82
The task has been submitted but "NA" is shown in the Submission Status column. The result should be "On-time". How to fix it?
7
Open Ended
Faulty row: [AC (PHP)]2
The UO task has been submitted and approved but no AC is reflected. How to fix it?
8
Open Ended
Faulty row: [AC (PHP)]3
The TGSA task has been submitted and rated but no AC is reflected. How to fix it?
9
10
Open Ended
Bank name is incorrect even if the bank's name is included in the cross-sheet reference. How to fix it?
11
Open Ended
The account number of FRL-0329 is not reflected. How to fix it?
12
Open Ended
TIN is incorrect even if the TIN number is included in the cross-sheet reference. How to fix it?
13
Open Ended
The address of FRL-0329 cannot be found. How to fix it?
14
15
Open Ended
Formula:
=INDEX([Learning Competencies]1:[Lesson Code UO]10, 1, 2)
What value will the smartsheet return?
16
Open Ended
Formula:
=INDEX([Learning Competencies]1:[Lesson Code UO]10, 11, 2)
What value will the smartsheet return?
17
Open Ended
Formula:
=INDEX([Learning Competencies]1:[Learning Competencies]14, 1, 3)
What value will the smartsheet return?
18
19
Open Ended
20
Open Ended
21
Open Ended
Show answer
Auto Play
Slide 1 / 21
SLIDE
