| Subject | English | Chinese simplified |
| comp., MS | array formula | 数组公式 (A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results) |
| comp., MS | Bollinger Bands formula | 布林线公式 (A formula that calculates the standard deviation above and below a simple moving average of the data. Since standard deviation is a measure of volatility, a large standard deviation indicates a volatile market, and a smaller standard deviation indicates a calmer market) |
| comp., MS | calculation formula | 计算公式 (A Multidimensional Expressions (MDX) expression used to supply a value for cells in a calculation subcube, subject to the application of a calculation condition) |
| comp., MS | commodity channel index formula | 商品通道指数公式 (A formula that calculates the mean deviation of the daily average price of a commodity from the moving average. A value above 100 indicates that the commodity is overbought, and a value below -100 indicates that the commodity is oversold) |
| comp., MS | detrended price oscillator formula | 趋势价格振荡线公式 (A formula that calculates the difference between the daily price and the moving average. This is useful for identifying cycles and overbought and oversold price levels) |
| comp., MS | envelopes formula | 包络线公式 (" A financial formula that calculates "envelopes" above and below a moving average using a specified percentage as the shift. The envelopes indicator is used to create signals for buying and selling. You can specify the percentage the formula uses to calculate the envelopes.") |
| comp., MS | formula bar | 编辑栏 (A bar at the top of the Excel window that you use to enter or edit values or formulas in cells or charts. Displays the constant value or formula stored in the active cell) |
| comp., MS | formula item | 配方物料 (An output of a batch process controlled by a formula) |
| comp., MS | local formula | 局部公式 (A formula that is stored in a cell of a shape instead of being inherited from a master or a style. A local formula overrides changes to the corresponding cell in the master of which the shape is an instance) |
| comp., MS | mathematical formula | 数学公式 (A mathematical statement in a formal language that can be given a semantic meaning) |
| comp., MS | MDX formula | MDX 公式 (The online analytical processing (OLAP) equivalent of an SQL query) |
| comp., MS | median price formula | 平均价公式 (A formula that calculates the average of the high and low prices) |
| comp., MS | time formula | 时间公式 (An expression that is created following the Simple Time Period Syntax. It takes the form of a time unit plus or minus a whole number, such as Year-1 or Month-6. It is the formula that is applied when you are using time intelligence on a dashboard) |
| comp., MS | validation formula | 验证公式 (Checks the data in a field as it is entered. It sets limits or conditions on what can be entered) |
| comp., MS | weighted close formula | 加权收盘价公式 (A formula that calculates the average of the high, low, and close prices, while giving extra weight to the close price) |