你可能感兴趣的试题
等差数列的公差是2,等比数列的公比是3 数列的公差或公比不是填充“序列”对话框中的“步长值” 操作时可单击“开始”选项卡→“编辑”组→“填充”→“系列” 进行等差或等比数列填充时,既可选择行或列,也可选择填充序列对话框中的“终值”
=2*$A$1 =2*A1 =2+$A$1 =2+A1
=2*SA$1 =2*$A1 =2*A$1 =2*A1
=2*$A$1 =2*$A1 =2*A$1 =2*A1
=2*$A$1 =2*$A1 =2*A$l =2*A1
=2*$A$1 =2*$A1 =2*A$1 =2*A1
=2*SA$1 =2*$A1 =2*A$1 =2*A1
“插入”菜单命令 填充柄 “工具”菜单命令 填充序列对话框
=2$A$1 =2$A1 =2+$A$1 =2+A1
=2*$A$1 =2*A1 #VALUE! REF!
以等差数列填充 以等比数列填充 用左单元格数值填充 用右单元格数值填充
前一单元格数值 前二单元格数值 等比数列 等差数列
=2*$A$1 =2*A1 =2+$A$1 =2+A1
=2*$A$1 =2*$A1 =2*A$1 =2*A1
=2*$A$1 =2*A1 =2+$A$1 =2+A1
=2*$A$1 =2*A1 =2+$A$1 =2+A1
=2*$A$1 =2*A1 =2+$A$1 =2+A1