Change the Calculation Mode and input formulas to see the calculation behavior.

Check the different calculate scopes with different calculation types in different calculation modes.