フリー問題

問題文

A calculation classifies orders by searching for several keywords inside a long comment field, and it is the slowest part of the workbook. Which change reduces the cost most?

選択肢

1. Compute the classification in a group and store it as a label, so the workbook reads a value instead of scanning text.
2. Compute the classification in a parameter and store it as a choice, so the workbook reads a value instead of scanning text.
3. Compute the classification in a set and store it as a member, so the workbook reads a value instead of scanning.
4. Compute the classification upstream and store it as a column, so the workbook reads a value instead of scanning text.