|
|
| 第 37 行： |
第 37 行： |
|
| |
|
| ===== Microsoft Excel ===== | | ===== Microsoft Excel ===== |
| * Supports up to 1,048,576 rows and 16,384 columns (XFD) in a single worksheet, with 32,767 characters in a single cell (17,179,869,184 cells in a worksheet, 562,932,773,552,128 characters in a worksheet). | | * 在单个工作表中最多支持 1 048 576 行和 16 384 列（XFD），单个单元格中有 32 767 个字符（工作表中有 17 179 869 184 个单元格，工作表中有 562 932 773 552 128 个字符）。 |
| * Conditional Formatting introduces support for three new features — Color Scales, Icon Sets, and Data Bars Color Scales, which automatically color the background of a group of cells with different colors according to the values. | | * 条件格式引入了对三个新功能的支持 — 色阶、图标集和数据栏色阶，它们会根据值自动为一组单元格的背景设置不同颜色的颜色。 |
| * Icon sets, which precede the text in a cell with an icon that represents some aspect of the value of the cell with respect to other values in a group of cells, can also be applied. Icons can be conditionally applied to show up only when certain criteria are met, such as a cross showing up on an invalid value, where the condition for invalidity can be specified by the user. | | * 还可以应用图标集，这些图标位于单元格中的文本之前，图标表示单元格值相对于一组单元格中其他值的某个方面。图标可以有条件地应用，使其仅在满足某些条件时显示，例如在无效值上显示叉号（×），其中无效条件可由用户指定。 |
| * Data Bars show as a gradient bar in the background of a cell the contribution of the cell value in the group. | | * 数据栏在单元格的背景中以渐变条的形式显示单元格值在组中的贡献。 |
| * Column titles can optionally show options to control the layout of the column. | | * 列标题可以选择显示用于控制列布局的选项。 |
| * Multithreaded calculation of formulae, to speed up large calculations, especially on multi-core/multi-processor systems. | | * 公式的多线程计算，以加快大型计算的速度，尤其是在多核/多处理器系统上。 |
| * User Defined Functions (UDF), which are custom functions written to supplement Excel's set of built-in functions, supports the increased number of cells and columns. UDFs now can also be multithreaded. Server-side UDFs are based on the .NET Managed code. | | * 用户定义函数（UDF）是为补充 Excel 的内置函数集而编写的自定义函数，支持增加单元格和列的数量。UDF 现在也可以是多线程的。服务器端 UDF 基于 .NET 托管代码。 |
| * Importing data from external sources, such as a database, has been upgraded. Data can also be imported from formatted tables and reports, which do not have a regular grid structure. | | * 从外部源（如数据库）导入数据的功能已升级。还可以从没有常规网格结构的格式化表和报表中导入数据。 |
| * Formula AutoComplete, which automatically suggests function names, arguments and named ranges, and automatically completing them if desired, based on the characters entered. Formulae can refer to a table as well. | | * 公式自动完成，它会自动建议函数名称、参数和命名范围，并在需要时根据输入的字符自动完成它们。公式也可以引用表。 |
| * CUBE functions which allow importing data, including set aggregated data, from data analysis services, such as SQL Server Analysis Services. | | * 允许从数据分析服务（如 SQL Server Analysis Services）导入数据（包括设置聚合数据）的 CUBE 函数。 |
| * Page Layout view, to author spreadsheets in a way that mirrors the formatting that will be applied when printed. | | * 页面布局视图，以反映打印时将应用的格式的方式编写电子表格。 |
| * PivotTables, which are used to create analysis reports out of sets of data, can now support hierarchical data by displaying a row in the table with a "+" icon, which, when clicked, shows more rows regarding it, which can also be hierarchical. | | * 数据透视表用于从数据集中创建分析报告，现在可以通过在表中显示带有“+”图标的行来支持分层数据，单击此图标时，会显示有关此图标的更多行，此行也可以是分层的。 |
| * PivotTables can also be sorted and filtered independently, and conditional formatting used to highlight trends in the data. | | * 数据透视表也可以独立排序和筛选，并使用条件格式来突出显示数据中的趋势。 |
| * Filters now includes a Quick filter option allowing the selection of multiple items from a drop-down list of items in the column. The option to filter based on color has been added to the choices available. | | * 过滤器现在包括一个“快速过滤器”选项，允许从列中的项目下拉列表中选择多个项目。根据颜色进行筛选的选项已添加到可用选项中。 |
| * Excel features a new charting engine, which supports advanced formatting, including 3D rendering, transparencies, and shadows. Chart layouts can also be customized to highlight various trends in the data. | | * Excel 使用新的图表引擎，此引擎支持高级格式设置，包括 3D 渲染、透明度和阴影。还可以自定义图表布局以突出显示数据中的各种趋势。 |
|
| |
|
| ===== Microsoft PowerPoint ===== | | ===== Microsoft PowerPoint ===== |