例1：If the input for B7 is 「=C2」, and B7 is copied and pasted to C8, what is the return value for C8? (Ans: 2048)
例2：If the input of B7 is 「=A3&B4」, then what is the return value of B7? (Ans: 256TRUE)
例3：Select range B7:C8 and input 「{=LARGE(A1:A4, {1,2})}」 with array formula, then select B9:C10 and input 「{=LARGE(A1:A4, {1;2})}」 with array formula. Please use the array format of {x1,x2,...} to represent the return values of range B7:C10 in a single array. The answer should start and end with { }, and do not include any spaces. (Ans: {256,16;256,16;256,256;16,16})
- Advanced Level
→ 老師提供一份Excel，使用上課所教學的方式將該Excel完善
→ 相較於Basic，Advanced比較注重實作部分 (但是考試不考實作)
→ 難度比Basic難上不少，但有趣的多。題目通常認真上課都可以解答得出來 (ChatGPT不一定管用...)
→ 老師會很認真讀你的函式，所以不可能蒙混過關。題目舉例：
