excel20xx常用函数完全手册完善版内容摘要:
............................................…................... 9 .....................................................................................................................…....... ................. 9 .....................................................................................................................…....... ................. 9 .....................................................................................................................................……................... 9 ....................................................................................................................................…….................... 9 Excel 2020 函数应用完全手册 第 3 页 共 67 页 ...............................................................................................................................……......................... 9 ......................................................................................................................................…….................... 9 ............................................................................................................................……...................... 10 ..............................................................................................................................……...................... 10 ...............................................................................................................................…….................. 10 .........................................................................................................................…... ................... 10 ......................................................................................................................................….............. 10 ..........................................................................................................................................……........... 10 ......................................................................................................................................…............... 10 ..........................................................................................................................................….…......... 10 ..............................................................................................................................................…........ 10 ...........................................................................................................................................…........ 10 ........................................................................................................................................….......... 10 ........................................................................................................................................… .......... 10 (五 )财务函数 ................................................................................................................................................... 10 .................................................................................................................................…................... 10 .......................................................................................................................…..... ..................... 11 ..................................................................................................................….......................... 11 .......................................................................................................................….......................... 11 ................................................................................................................................................. 11 ........................................................................................................................….... ..................... 11 ............................................................................................................................................... 11 .........................................................................................................................….... ...................... 11 .........................................................................................................................…... ........................ 11 ......................................................................................................................…............................ 11 ...................................................................................................................…............................ 12 ...................................................................................................................................……........................ 12 ....................................................................................................................................……..................... 12 ..........................................................................................................................................…….............. 12 ............................................................................................................................…................... 12 ............................................................................................................................… ................... 12 .............................................................................................................................…................... 12 ....................................................................................................................................……............... 12 ..........................................................................。excel20xx常用函数完全手册完善版
相关推荐
.................................................................................. 78 Now 函数 ..........................................................................................................
works‖ 及 ――File and Printer Sharing for Microsoft Networks‖两项,如图 4所示。 此外,还可以选择取消 ―QoS Packet Scheduler‖和 ―Inter Protocol Version 6 (TCP/IPv6)‖。 图 4:复制界面属性页 接下来,打开 ―Inter Protocol Version 4
1所示。 表 11 命令模式和功能特性 命令模式 功能 提 示 符 进入命令 退出命令 普通用户 模式 查看设备的简单运行状态和统计信息 Fengine 与设备建立连接即进入 Exit 断开与设备连接 特权用户 模式 查看设备的全部运行状态和统计信息,并可以进行文件管理和系统管理 Fengine 在普通模式下键入enable Disable 返回普通模式, exit 断开与设备的连接 全局配置
返回作为概率和自由度函数的学生氏 t 分布的 t 值。 取值 . 返回一条线性回归拟合线的一组纵坐标值 (y值 )。 取值 返回所选区域内一定范围数据的平均值。 取值 返回与学生氏 t检验相关的概率。 取值 估算样本方差。 取值 用来估算给定样本的方差。 文本与逻辑值参与计算。 取值 计算样本总体的方差。 取值 计算样本总体的方差。 文本与逻辑值参与计算。 取值 返回韦伯分布。 用于可靠性分析。
定条件的单元格中的最小数字。 语法: DMIN(database, field, criteria) 参数: Database 构成列表或数据库的单元格区域。 Field 指定函数所使用的数据列。 Criteria 为一组包含给定条件的 单元格区域。 用途:返回数据清单或数据库的指定列中,满足给定条件单元格中数值乘积。 语法: DPRODUCT(database, field,
19 19 19 19 19 20 20 20 20 20 20 20 20 21 (六 )信息函数 21 21 21 21 类函数 21 22 22 22 22 23 (七 )逻辑运算符 23 23 23 23 23 24 24 (八 )查找和引用函数 24 24 24 24 25 25 25 25 25 26 26 26 27 5 27 27 27 27 28 (九 )数学和三角函数 28