Office Scripts and Power Automate: practice exercises
Office Scripts and Power Automate move Excel automation to the cloud. These exercises show how a TypeScript script reads and writes cells, how to record an action and tidy the result, and how a Power Automate flow runs the script on a schedule or when a file changes. The set is short and practical, a good fit if your company uses Excel for the web and macros are not available.
6 exercises · level: Expert
Start with the first task Study the course: Office Scripts and Power Automate →
Showing 6 of 6
ExcelScript API
In D2:D7, get what the script writes to row[3]: price × quantity, with a 10% discount when the quantity is 10 or more.
In D8, enter the formula that the setFormula line puts there: the sum of D2:D7.
Power Automate
In F1, enter the value of the threshold parameter that the flow passes to the script.
In F2, enter the value of the label parameter.
In C2:C7, get what the script writes to marks: the label from F2 when revenue is at least F1, otherwise "-". Lock the references to the parameters.
In F3, get the number the script returns to the flow (return count).
No exercises match these filters.